Appendices Appendix A elements to Sampling user guide –CSV Staging Table Column Header Definition Domain Optionality Business Rules # Laboratory –issued 1 B_LAB_SAMPLE_NUMBER unique 20 Mandatory Lab unique identifier Numeric sample number 2 B_STATE_SAMPLE_NUMBER unique 20 N/A Open field Numeric sample number assigned Water 3 B_PWS_NUMBER 9 Mandatory PWS ID all TX#######” System Numeric Number Public Water 4 S_PWS_NAME 40 Optional PWS Name System Numeric name
Appendices Appendix A –CSV elements to Sampling user guide # Staging Table Column Header Definition Domain Optionality Business Rules 1 B_LAB_SAMPLE_NUMBER Laboratory –issued unique sample number 20 Mandatory Lab unique identifier 2 B_STATE_SAMPLE_NUMBER unique sample number 20 N/A Open field 3 B_PWS_NUMBER assigned Water System Number 9 Mandatory PWS ID all TX#######” 4 S_PWS_NAME Public Water System name 40 Optional PWS Name Numeric Numeric Numeric Numeric