def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'party_contact_guid',
         'ownership_block_guid',
         'ownership_block_contact_type',
     ]
     self.query = 'select {0} from party_cont_own_blks{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.party_contact_guid = ''
     self.ownership_block_guid = ''
     self.ownership_block_contact_type = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.party_contact_guid = module_pfmm_helpers.passNull(
                 row[1], self.party_contact_guid)
             self.ownership_block_guid = module_pfmm_helpers.passNull(
                 row[2], self.ownership_block_guid)
             self.ownership_block_contact_type = module_pfmm_helpers.passNull(
                 row[3], self.ownership_block_contact_type)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'coun',
         'acres_deed',
         'acres_gis',
         'town',
         'range',
         'sect',
         'fort',
         'legal_desc',
         'orig_id',
         'rdir',
     ]
     self.query = 'select {0} from ownership_blocks{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.coun = 0
     self.acres_deed = 0
     self.acres_gis = 0
     self.town = 0
     self.range = 0
     self.sect = 0
     self.fort = 0
     self.legal_desc = ''
     self.orig_id = ''
     self.rdir = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.coun = module_pfmm_helpers.passNull(row[1], self.coun)
             self.acres_deed = module_pfmm_helpers.decimalToFloat(
                 row[2], self.acres_deed)
             self.acres_gis = module_pfmm_helpers.decimalToFloat(
                 row[3], self.acres_gis)
             self.town = module_pfmm_helpers.passNull(row[4], self.town)
             self.range = module_pfmm_helpers.passNull(row[5], self.range)
             self.sect = module_pfmm_helpers.passNull(row[6], self.sect)
             self.fort = module_pfmm_helpers.passNull(row[7], self.fort)
             self.legal_desc = module_pfmm_helpers.passNull(
                 row[8], self.legal_desc)
             self.orig_id = module_pfmm_helpers.passNull(
                 row[9], self.orig_id)
             self.rdir = module_pfmm_helpers.passNull(row[10], self.rdir)
     conn.close()
 def __init__(self, coun=''):
     self.recordExists = False
     self.fieldList = [
         'coun',
         'cty_name',
     ]
     self.query = 'select {0} from county_coun where coun = %s'.format(
         ', '.join(self.fieldList))
     self.coun = 0
     self.cty_name = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [coun])
         for row in curs:
             self.globalIdExists = True
             self.coun = module_pfmm_helpers.passNull(row[0], self.coun)
             self.cty_name = module_pfmm_helpers.passNull(
                 row[1], self.cty_name)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'party_contact_guid',
         'ownership_parcel_guid',
         'purchase_date',
         'sale_date',
         'current_owner',
         'ownership_block_contct_type',
         'comments',
     ]
     self.query = 'select {0} from party_cont_own_prcl{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.party_contact_guid = ''
     self.ownership_parcel_guid = ''
     self.purchase_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.sale_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.current_owner = 0
     self.ownership_block_contct_type = ''
     self.comments = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.party_contact_guid = module_pfmm_helpers.passNull(
                 row[1], self.party_contact_guid)
             self.ownership_parcel_guid = module_pfmm_helpers.passNull(
                 row[2], self.ownership_parcel_guid)
             self.purchase_date = module_pfmm_helpers.passNull(
                 row[3], self.purchase_date)
             self.sale_date = module_pfmm_helpers.passNull(
                 row[4], self.sale_date)
             self.current_owner = module_pfmm_helpers.passNull(
                 row[5], self.current_owner)
             self.ownership_block_contct_type = module_pfmm_helpers.passNull(
                 row[6], self.ownership_block_contct_type)
             self.comments = module_pfmm_helpers.passNull(
                 row[7], self.comments)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'person_first_name',
         'person_middle_name',
         'person_last_name',
         'preferred_name',
         'person_name_prefix',
         'person_name_suffix',
         'business_name',
         'business_type',
         'business_unit',
         'business_title',
         'business_role',
         'address_attention_line',
         'address_line_1',
         'address_line_2',
         'city',
         'state_provice_short_name_code',
         'country_short_name_code',
         'postal_code',
         'fire_number',
         'po_box',
         'rural_route_nbr',
         'phone_line_1',
         'phone_type_1',
         'phone_line_2',
         'phone_type_2',
         'phone_line_3',
         'phone_type_3',
         'email_address_1',
         'email_type_1',
         'email_address_2',
         'email_type_2',
         'sys_username',
         'plan_writer_id',
         'spouse_name',
         'plchldr',
         'comments',
         'orig_id',
         'plan_writer_certified',
         'do_not_mail',
         'email_address_1_unsubscribe',
         'email_address_2_unsubscribe',
         'vendor_number',
     ]
     self.query = 'select {0} from party_contacts{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.person_first_name = ''
     self.person_middle_name = ''
     self.person_last_name = ''
     self.preferred_name = ''
     self.person_name_prefix = ''
     self.person_name_suffix = ''
     self.business_name = ''
     self.business_type = ''
     self.business_unit = ''
     self.business_title = ''
     self.business_role = ''
     self.address_attention_line = ''
     self.address_line_1 = ''
     self.address_line_2 = ''
     self.city = ''
     self.state_provice_short_name_code = ''
     self.country_short_name_code = ''
     self.postal_code = ''
     self.fire_number = ''
     self.po_box = ''
     self.rural_route_nbr = ''
     self.phone_line_1 = ''
     self.phone_type_1 = ''
     self.phone_line_2 = ''
     self.phone_type_2 = ''
     self.phone_line_3 = ''
     self.phone_type_3 = ''
     self.email_address_1 = ''
     self.email_type_1 = ''
     self.email_address_2 = ''
     self.email_type_2 = ''
     self.sys_username = ''
     self.plan_writer_id = ''
     self.spouse_name = ''
     self.plchldr = ''
     self.comments = ''
     self.orig_id = ''
     self.plan_writer_certified = ''
     self.do_not_mail = ''
     self.email_address_1_unsubscribe = ''
     self.email_address_2_unsubscribe = ''
     self.vendor_number = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.person_first_name = module_pfmm_helpers.passNull(
                 row[1], self.person_first_name)
             self.person_middle_name = module_pfmm_helpers.passNull(
                 row[2], self.person_middle_name)
             self.person_last_name = module_pfmm_helpers.passNull(
                 row[3], self.person_last_name)
             self.preferred_name = module_pfmm_helpers.passNull(
                 row[4], self.preferred_name)
             self.person_name_prefix = module_pfmm_helpers.passNull(
                 row[5], self.person_name_prefix)
             self.person_name_suffix = module_pfmm_helpers.passNull(
                 row[6], self.person_name_suffix)
             self.business_name = module_pfmm_helpers.passNull(
                 row[7], self.business_name)
             self.business_type = module_pfmm_helpers.passNull(
                 row[8], self.business_type)
             self.business_unit = module_pfmm_helpers.passNull(
                 row[9], self.business_unit)
             self.business_title = module_pfmm_helpers.passNull(
                 row[10], self.business_title)
             self.business_role = module_pfmm_helpers.passNull(
                 row[11], self.business_role)
             self.address_attention_line = module_pfmm_helpers.passNull(
                 row[12], self.address_attention_line)
             self.address_line_1 = module_pfmm_helpers.passNull(
                 row[13], self.address_line_1)
             self.address_line_2 = module_pfmm_helpers.passNull(
                 row[14], self.address_line_2)
             self.city = module_pfmm_helpers.passNull(row[15], self.city)
             self.state_provice_short_name_code = module_pfmm_helpers.passNull(
                 row[16], self.state_provice_short_name_code)
             self.country_short_name_code = module_pfmm_helpers.passNull(
                 row[17], self.country_short_name_code)
             self.postal_code = module_pfmm_helpers.passNull(
                 row[18], self.postal_code)
             self.fire_number = module_pfmm_helpers.passNull(
                 row[19], self.fire_number)
             self.po_box = module_pfmm_helpers.passNull(
                 row[20], self.po_box)
             self.rural_route_nbr = module_pfmm_helpers.passNull(
                 row[21], self.rural_route_nbr)
             self.phone_line_1 = module_pfmm_helpers.passNull(
                 row[22], self.phone_line_1)
             self.phone_type_1 = module_pfmm_helpers.passNull(
                 row[23], self.phone_type_1)
             self.phone_line_2 = module_pfmm_helpers.passNull(
                 row[24], self.phone_line_2)
             self.phone_type_2 = module_pfmm_helpers.passNull(
                 row[25], self.phone_type_2)
             self.phone_line_3 = module_pfmm_helpers.passNull(
                 row[26], self.phone_line_3)
             self.phone_type_3 = module_pfmm_helpers.passNull(
                 row[27], self.phone_type_3)
             self.email_address_1 = module_pfmm_helpers.passNull(
                 row[28], self.email_address_1)
             self.email_type_1 = module_pfmm_helpers.passNull(
                 row[29], self.email_type_1)
             self.email_address_2 = module_pfmm_helpers.passNull(
                 row[30], self.email_address_2)
             self.email_type_2 = module_pfmm_helpers.passNull(
                 row[31], self.email_type_2)
             self.sys_username = module_pfmm_helpers.passNull(
                 row[32], self.sys_username)
             self.plan_writer_id = module_pfmm_helpers.passNull(
                 row[33], self.plan_writer_id)
             self.spouse_name = module_pfmm_helpers.passNull(
                 row[34], self.spouse_name)
             self.plchldr = module_pfmm_helpers.passNull(
                 row[35], self.plchldr)
             self.comments = module_pfmm_helpers.passNull(
                 row[36], self.comments)
             self.orig_id = module_pfmm_helpers.passNull(
                 row[37], self.orig_id)
             self.plan_writer_certified = module_pfmm_helpers.passNull(
                 row[38], self.plan_writer_certified)
             self.do_not_mail = module_pfmm_helpers.passNull(
                 row[39], self.do_not_mail)
             self.email_address_1_unsubscribe = module_pfmm_helpers.passNull(
                 row[40], self.email_address_1_unsubscribe)
             self.email_address_2_unsubscribe = module_pfmm_helpers.passNull(
                 row[41], self.email_address_2_unsubscribe)
             self.vendor_number = module_pfmm_helpers.passNull(
                 row[42], self.vendor_number)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'map_label',
         'anticipated_practice_start_date',
         'practice',
         'component',
         'task',
         'subtask',
         'component_unit',
         'cost_per_unit',
         'cost_share_rate',
         'acres_gis',
         'proposed_component_amount',
         'estimated_total_cost',
         'completion_date',
         'completed_component_amount',
         'requesting_cost_share',
         'cost_shares_recommended',
         'cost_shares_earned',
         'comments',
         'project_area_guid',
     ]
     self.query = 'select {0} from project_practices{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.map_label = ''
     self.anticipated_practice_start_date = datetime.datetime(
         1900, 1, 1, 0, 0, 0)
     self.practice = ''
     self.component = ''
     self.task = ''
     self.subtask = ''
     self.component_unit = ''
     self.cost_per_unit = 0
     self.cost_share_rate = 0
     self.acres_gis = 0
     self.proposed_component_amount = 0
     self.estimated_total_cost = 0
     self.completion_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.completed_component_amount = 0
     self.requesting_cost_share = ''
     self.cost_shares_recommended = 0
     self.cost_shares_earned = 0
     self.comments = ''
     self.project_area_guid = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.map_label = module_pfmm_helpers.passNull(
                 row[1], self.map_label)
             self.anticipated_practice_start_date = module_pfmm_helpers.passNull(
                 row[2], self.anticipated_practice_start_date)
             self.practice = module_pfmm_helpers.passNull(
                 row[3], self.practice)
             self.component = module_pfmm_helpers.passNull(
                 row[4], self.component)
             self.task = module_pfmm_helpers.passNull(row[5], self.task)
             self.subtask = module_pfmm_helpers.passNull(
                 row[6], self.subtask)
             self.component_unit = module_pfmm_helpers.passNull(
                 row[7], self.component_unit)
             self.cost_per_unit = module_pfmm_helpers.decimalToFloat(
                 row[8], self.cost_per_unit)
             self.cost_share_rate = module_pfmm_helpers.decimalToFloat(
                 row[9], self.cost_share_rate)
             self.acres_gis = module_pfmm_helpers.decimalToFloat(
                 row[10], self.acres_gis)
             self.proposed_component_amount = module_pfmm_helpers.decimalToFloat(
                 row[11], self.proposed_component_amount)
             self.estimated_total_cost = module_pfmm_helpers.decimalToFloat(
                 row[12], self.estimated_total_cost)
             self.completion_date = module_pfmm_helpers.passNull(
                 row[13], self.completion_date)
             self.completed_component_amount = module_pfmm_helpers.decimalToFloat(
                 row[14], self.completed_component_amount)
             self.requesting_cost_share = module_pfmm_helpers.passNull(
                 row[15], self.requesting_cost_share)
             self.cost_shares_recommended = module_pfmm_helpers.decimalToFloat(
                 row[16], self.cost_shares_recommended)
             self.cost_shares_earned = module_pfmm_helpers.decimalToFloat(
                 row[17], self.cost_shares_earned)
             self.comments = module_pfmm_helpers.passNull(
                 row[18], self.comments)
             self.project_area_guid = module_pfmm_helpers.passNull(
                 row[19], self.project_area_guid)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'party_contact_applicant_guid',
         'acres_gis',
         'assigned_date',
         'party_contact_writer_guid',
         'project_plan_delivered_date',
         'anticipated_project_start_date',
         'anticipated_project_end_date',
         'completion_date',
         'canceled_date',
         'reason_for_canceling',
         'comments',
         'entered_date',
         'party_contact_entered_guid',
         'request_approved_date',
         'party_contact_approver_guid',
         'total_cost_share_approved',
         'da_signed_date',
         'po_number',
         'po_encumbered_date',
         'completion_deadline_date',
         'practices_certified_date',
         'party_contact_certifier_guid',
         'total_cost_share_to_be_paid',
         'reconciled_date',
         'ownership_block_guid',
         'pa_cultural_heritage',
         'invoice_number',
     ]
     self.query = 'select {0} from project_areas{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.party_contact_applicant_guid = ''
     self.acres_gis = 0
     self.assigned_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.party_contact_writer_guid = ''
     self.project_plan_delivered_date = datetime.datetime(
         1900, 1, 1, 0, 0, 0)
     self.anticipated_project_start_date = datetime.datetime(
         1900, 1, 1, 0, 0, 0)
     self.anticipated_project_end_date = datetime.datetime(
         1900, 1, 1, 0, 0, 0)
     self.completion_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.canceled_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.reason_for_canceling = ''
     self.comments = ''
     self.entered_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.party_contact_entered_guid = ''
     self.request_approved_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.party_contact_approver_guid = ''
     self.total_cost_share_approved = 0
     self.da_signed_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.po_number = ''
     self.po_encumbered_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.completion_deadline_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.practices_certified_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.party_contact_certifier_guid = ''
     self.total_cost_share_to_be_paid = 0
     self.reconciled_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.ownership_block_guid = ''
     self.pa_cultural_heritage = ''
     self.invoice_number = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.party_contact_applicant_guid = module_pfmm_helpers.passNull(
                 row[1], self.party_contact_applicant_guid)
             self.acres_gis = module_pfmm_helpers.decimalToFloat(
                 row[2], self.acres_gis)
             self.assigned_date = module_pfmm_helpers.passNull(
                 row[3], self.assigned_date)
             self.party_contact_writer_guid = module_pfmm_helpers.passNull(
                 row[4], self.party_contact_writer_guid)
             self.project_plan_delivered_date = module_pfmm_helpers.passNull(
                 row[5], self.project_plan_delivered_date)
             self.anticipated_project_start_date = module_pfmm_helpers.passNull(
                 row[6], self.anticipated_project_start_date)
             self.anticipated_project_end_date = module_pfmm_helpers.passNull(
                 row[7], self.anticipated_project_end_date)
             self.completion_date = module_pfmm_helpers.passNull(
                 row[8], self.completion_date)
             self.canceled_date = module_pfmm_helpers.passNull(
                 row[9], self.canceled_date)
             self.reason_for_canceling = module_pfmm_helpers.passNull(
                 row[10], self.reason_for_canceling)
             self.comments = module_pfmm_helpers.passNull(
                 row[11], self.comments)
             self.entered_date = module_pfmm_helpers.passNull(
                 row[12], self.entered_date)
             self.party_contact_entered_guid = module_pfmm_helpers.passNull(
                 row[13], self.party_contact_entered_guid)
             self.request_approved_date = module_pfmm_helpers.passNull(
                 row[14], self.request_approved_date)
             self.party_contact_approver_guid = module_pfmm_helpers.passNull(
                 row[15], self.party_contact_approver_guid)
             self.total_cost_share_approved = module_pfmm_helpers.decimalToFloat(
                 row[16], self.total_cost_share_approved)
             self.da_signed_date = module_pfmm_helpers.passNull(
                 row[17], self.da_signed_date)
             self.po_number = module_pfmm_helpers.passNull(
                 row[18], self.po_number)
             self.po_encumbered_date = module_pfmm_helpers.passNull(
                 row[19], self.po_encumbered_date)
             self.completion_deadline_date = module_pfmm_helpers.passNull(
                 row[20], self.completion_deadline_date)
             self.practices_certified_date = module_pfmm_helpers.passNull(
                 row[21], self.practices_certified_date)
             self.party_contact_certifier_guid = module_pfmm_helpers.passNull(
                 row[22], self.party_contact_certifier_guid)
             self.total_cost_share_to_be_paid = module_pfmm_helpers.decimalToFloat(
                 row[23], self.total_cost_share_to_be_paid)
             self.reconciled_date = module_pfmm_helpers.passNull(
                 row[24], self.reconciled_date)
             self.ownership_block_guid = module_pfmm_helpers.passNull(
                 row[25], self.ownership_block_guid)
             self.pa_cultural_heritage = module_pfmm_helpers.passNull(
                 row[26], self.pa_cultural_heritage)
             self.invoice_number = module_pfmm_helpers.passNull(
                 row[27], self.invoice_number)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'party_contact_1_guid',
         'party_contact_2_guid',
         'ownership_block_guid',
         'management_plan_guid',
         'subject',
         'contact_event_type',
         'summary',
         'notes',
         'contact_date',
         'party_contact_3_guid',
     ]
     self.query = 'select {0} from contact_events{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.party_contact_1_guid = ''
     self.party_contact_2_guid = ''
     self.ownership_block_guid = ''
     self.management_plan_guid = ''
     self.subject = ''
     self.contact_event_type = ''
     self.summary = ''
     self.notes = ''
     self.contact_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.party_contact_3_guid = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.party_contact_1_guid = module_pfmm_helpers.passNull(
                 row[1], self.party_contact_1_guid)
             self.party_contact_2_guid = module_pfmm_helpers.passNull(
                 row[2], self.party_contact_2_guid)
             self.ownership_block_guid = module_pfmm_helpers.passNull(
                 row[3], self.ownership_block_guid)
             self.management_plan_guid = module_pfmm_helpers.passNull(
                 row[4], self.management_plan_guid)
             self.subject = module_pfmm_helpers.passNull(
                 row[5], self.subject)
             self.contact_event_type = module_pfmm_helpers.passNull(
                 row[6], self.contact_event_type)
             self.summary = module_pfmm_helpers.passNull(
                 row[7], self.summary)
             self.notes = module_pfmm_helpers.passNull(row[8], self.notes)
             self.contact_date = module_pfmm_helpers.passNull(
                 row[9], self.contact_date)
             self.party_contact_3_guid = module_pfmm_helpers.passNull(
                 row[10], self.party_contact_3_guid)
     conn.close()
 def __init__(self, globalId='', guid=''):
     self.globalIdExists = False
     self.fieldList = [
         'globalid',
         'ownership_block_guid',
         'status',
         'plan_type',
         'plan_date',
         'acres_plan',
         'acres_gis',
         'tree_farm_status',
         'conservation_easement',
         'request_date',
         'assigned_date',
         'registered_date',
         'incentives_date',
         'completion_date',
         'priority',
         'donation',
         'comments',
         'orig_id',
         'completion_status',
         'party_contact_guid',
         'ecs_subsection_guid',
         'cultural_heritage',
         'grant_id',
         'planname',
         'planid',
         'fedfy',
         'reg_fee',
         'cust_num',
         'invc_num',
         'invc_date',
         'reg_num',
         'ran',
         'registering',
         'party_contact_2_guid',
         'party_contact_3_guid',
         'approved_date',
         'dnr_plan_writing_fee',
         'cost_share_to_be_paid',
         'po_number',
         'reconciled_date',
         'cs_invoice_number',
         'reg_letter_grant',
     ]
     self.query = 'select {0} from management_plans{1} where globalid = %s'.format(
         ', '.join(self.fieldList), view)
     self.globalid = ''
     self.ownership_block_guid = ''
     self.status = ''
     self.plan_type = ''
     self.plan_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.acres_plan = 0
     self.acres_gis = 0
     self.tree_farm_status = ''
     self.conservation_easement = ''
     self.request_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.assigned_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.registered_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.incentives_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.completion_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.priority = 0
     self.donation = ''
     self.comments = ''
     self.orig_id = ''
     self.completion_status = ''
     self.party_contact_guid = ''
     self.ecs_subsection_guid = ''
     self.cultural_heritage = ''
     self.grant_id = ''
     self.planname = ''
     self.planid = ''
     self.fedfy = ''
     self.reg_fee = 0
     self.cust_num = ''
     self.invc_num = ''
     self.invc_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.reg_num = ''
     self.ran = ''
     self.registering = ''
     self.party_contact_2_guid = ''
     self.party_contact_3_guid = ''
     self.approved_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.dnr_plan_writing_fee = 0
     self.cost_share_to_be_paid = 0
     self.po_number = ''
     self.reconciled_date = datetime.datetime(1900, 1, 1, 0, 0, 0)
     self.cs_invoice_number = ''
     self.reg_letter_grant = ''
     conn = psycopg2.connect(dsn)
     with conn.cursor() as curs:
         curs.execute(self.query, [globalId])
         for row in curs:
             self.globalIdExists = True
             self.globalid = module_pfmm_helpers.passNull(
                 row[0], self.globalid)
             self.ownership_block_guid = module_pfmm_helpers.passNull(
                 row[1], self.ownership_block_guid)
             self.status = module_pfmm_helpers.passNull(row[2], self.status)
             self.plan_type = module_pfmm_helpers.passNull(
                 row[3], self.plan_type)
             self.plan_date = module_pfmm_helpers.passNull(
                 row[4], self.plan_date)
             self.acres_plan = module_pfmm_helpers.decimalToFloat(
                 row[5], self.acres_plan)
             self.acres_gis = module_pfmm_helpers.decimalToFloat(
                 row[6], self.acres_gis)
             self.tree_farm_status = module_pfmm_helpers.passNull(
                 row[7], self.tree_farm_status)
             self.conservation_easement = module_pfmm_helpers.passNull(
                 row[8], self.conservation_easement)
             self.request_date = module_pfmm_helpers.passNull(
                 row[9], self.request_date)
             self.assigned_date = module_pfmm_helpers.passNull(
                 row[10], self.assigned_date)
             self.registered_date = module_pfmm_helpers.passNull(
                 row[11], self.registered_date)
             self.incentives_date = module_pfmm_helpers.passNull(
                 row[12], self.incentives_date)
             self.completion_date = module_pfmm_helpers.passNull(
                 row[13], self.completion_date)
             self.priority = module_pfmm_helpers.passNull(
                 row[14], self.priority)
             self.donation = module_pfmm_helpers.passNull(
                 row[15], self.donation)
             self.comments = module_pfmm_helpers.passNull(
                 row[16], self.comments)
             self.orig_id = module_pfmm_helpers.passNull(
                 row[17], self.orig_id)
             self.completion_status = module_pfmm_helpers.passNull(
                 row[18], self.completion_status)
             self.party_contact_guid = module_pfmm_helpers.passNull(
                 row[19], self.party_contact_guid)
             self.ecs_subsection_guid = module_pfmm_helpers.passNull(
                 row[20], self.ecs_subsection_guid)
             self.cultural_heritage = module_pfmm_helpers.passNull(
                 row[21], self.cultural_heritage)
             self.grant_id = module_pfmm_helpers.passNull(
                 row[22], self.grant_id)
             self.planname = module_pfmm_helpers.passNull(
                 row[23], self.planname)
             self.planid = module_pfmm_helpers.passNull(
                 row[24], self.planid)
             self.fedfy = module_pfmm_helpers.passNull(row[25], self.fedfy)
             self.reg_fee = module_pfmm_helpers.decimalToFloat(
                 row[26], self.reg_fee)
             self.cust_num = module_pfmm_helpers.passNull(
                 row[27], self.cust_num)
             self.invc_num = module_pfmm_helpers.passNull(
                 row[28], self.invc_num)
             self.invc_date = module_pfmm_helpers.passNull(
                 row[29], self.invc_date)
             self.reg_num = module_pfmm_helpers.passNull(
                 row[30], self.reg_num)
             self.ran = module_pfmm_helpers.passNull(row[31], self.ran)
             self.registering = module_pfmm_helpers.passNull(
                 row[32], self.registering)
             self.party_contact_2_guid = module_pfmm_helpers.passNull(
                 row[33], self.party_contact_2_guid)
             self.party_contact_3_guid = module_pfmm_helpers.passNull(
                 row[34], self.party_contact_3_guid)
             self.approved_date = module_pfmm_helpers.passNull(
                 row[35], self.approved_date)
             self.dnr_plan_writing_fee = module_pfmm_helpers.decimalToFloat(
                 row[36], self.dnr_plan_writing_fee)
             self.cost_share_to_be_paid = module_pfmm_helpers.decimalToFloat(
                 row[37], self.cost_share_to_be_paid)
             self.po_number = module_pfmm_helpers.passNull(
                 row[38], self.po_number)
             self.reconciled_date = module_pfmm_helpers.passNull(
                 row[39], self.reconciled_date)
             self.cs_invoice_number = module_pfmm_helpers.passNull(
                 row[40], self.cs_invoice_number)
             self.reg_letter_grant = module_pfmm_helpers.passNull(
                 row[41], self.reg_letter_grant)
     conn.close()