generator name, the shipped date, waste code, quantity shipped, who received the waste, and how it was handled. (PA_OHW_OTS_WSS.ERR_FLG != ‘N’) Columns Table Field Description 1 2 Always representing the summary code for waste – ‘S1’ shipments 3 7 OTS Request ID. The generator be registered with – the IHW program area or unregistered. The value this field will be determined by the following: 8 57 COMPANY NAME – PR_PRINCIPAL.PRINC_NAME 58 69 Manifest tracking number – 70 74 Receiver’s Texas registration number or ID – 75 86 Receiver’s EPA ID should be present when the receiver is – – from out of state. 87 94 PA_IHW_OTS_WSS.TWC_CD Waste code of waste that is being reported – 95 95 classification. The value in this field is determined by – the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 96 98 Waste form code. The value in this field is determined by – the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 99 112 PA_IHW_OTS_WSS.WSS_QTY Quantity shipped (nnnnnnnnn.nnnn) – 113 113 Unit of measurement of quantity shipped –
generator name, the shipped date, waste code, quantity shipped, who received the waste, and how it was handled. (PA_OHW_OTS_WSS.ERR_FLG != ‘N’) Columns Table Field Description 1 – 2 Always ‘S1’ representing the summary code for waste shipments 3 – 7 OTS Request ID. The generator be registered with the IHW program area or unregistered. The value this field will be determined by the following: 8 – 57 PR_PRINCIPAL.PRINC_NAME COMPANY NAME 58 – 69 Manifest tracking number 70 – 74 Receiver’s Texas registration number or ID 75 – 86 Receiver’s EPA ID – should be present when the receiver is from out of state. 87 – 94 PA_IHW_OTS_WSS.TWC_CD Waste code of waste that is being reported 95 – 95 classification. The value in this field is determined by the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 96 – 98 Waste form code. The value in this field is determined by the following: PA_IHW_OTS_REQ.TWC_ID = PA_IHW_WST_STREAM.TWC_ID 99 – 112 PA_IHW_OTS_WSS.WSS_QTY Quantity shipped (nnnnnnnnn.nnnn) 113 – 113 Unit of measurement of quantity shipped
17_Texas_Solid_Waste_System_Activity_File.docx