281 310 AD_ELECTR_COMMU.CNTRY_CD fax number – and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM 311 350 AD_ELECTR_COMMU. Owner’s email address – EMAIL_ADDR_TXT 351 380 RF_GEN_CD.NAME_TXT Business Type Convert the value in CR according to the – – following: PR_PRINCIPAL.OWN_TYPE_TXT = RF_GEN_CD.GEN_CD_TXT and RF_GEN_CD.GEN_CD_TYP_ID = RF_GEN_CD_TYP.GEN_CD_TYP_ID and RF_GEN_CD_TYP.NAME_TXT = ‘OWNERSHIPT_TYPE’ If the PR_PRINCPAL.OWN_TYPE_TXT is not found in the RF_GEN_CD table, then use the RF_GEN_CD.NAME_TXT value for the RF_GEN_CD.GEN_CD_TXT = ‘OT’. 381 391 PR_PRINCIPLE. Tax Id – STATE_FRAN_TAX_ID_TXT or FED_TAX_ID_NUM 392 392 = 1, if the following conditions are met: – PY_ADM.DBTACCTTABLE.DB_MAST_ACCT = <AR number for the owner> PY_ADM.DBTACCTTABLE. DB_ACTIV_IND = and ‘y’ PY_ADM.DBTACCTTABLE. DB_ANAL_COD3 in (‘BKRT,CH11,CH12,CH13,CH 7,CH 9’) Otherwise = 0
281 – 310 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM fax number 311 – 350 AD_ELECTR_COMMU. EMAIL_ADDR_TXT Owner’s email address 351 – 380 RF_GEN_CD.NAME_TXT Business Type – Convert the value in CR according to the following: PR_PRINCIPAL.OWN_TYPE_TXT = RF_GEN_CD.GEN_CD_TXT and RF_GEN_CD.GEN_CD_TYP_ID = RF_GEN_CD_TYP.GEN_CD_TYP_ID and RF_GEN_CD_TYP.NAME_TXT = ‘OWNERSHIPT_TYPE’ If the PR_PRINCPAL.OWN_TYPE_TXT is not found in the RF_GEN_CD table, then use the RF_GEN_CD.NAME_TXT value for the RF_GEN_CD.GEN_CD_TXT = ‘OT’. 381 – 391 PR_PRINCIPLE. STATE_FRAN_TAX_ID_TXT or FED_TAX_ID_NUM Tax Id 392 – 392 = 1, if the following conditions are met: PY_ADM.DBTACCTTABLE.DB_MAST_ACCT = <AR number for the owner> PY_ADM.DBTACCTTABLE. DB_ACTIV_IND = ‘y’ and PY_ADM.DBTACCTTABLE. DB_ANAL_COD3 in (‘BKRT,CH11,CH12,CH13,CH 7,CH 9’) Otherwise = 0
17_Texas_Solid_Waste_System_Activity_File.docx