OCSE Office of Audit - Data Submission Requirements for the Fiscal Year 2008 Data Reliability Audits
      DATA RELIABILITY AUDIT SPECIFICATIONS
Audit TrailFormatMediaDatabase FileTable NameRequired FieldsDataData TypeFormat
(*) Case ID must be the same format for all lines.  Likewise, Child ID must be the same format for all lines.
Child Support System UniverseAccessCDCSAuditTrails.mdbIVDUniverseCase ID (*)One record per caseText 
Status DateOne record per caseDate
Case StatusOne record per caseText
CP NameOne record per caseText
CP SSN (last four digits)One record per caseText
NCP NameOne record per caseText
NCP SSN (last four digits)One record per caseText
Line 1AccessCDCSAuditTrails.mdbLine01Case ID (*)One record per caseText 
Line 2AccessCDCSAuditTrails.mdbLine02Case ID (*)One record per caseText 
Line 2eAccessCDCSAuditTrails.mdbLine02eCase ID (*)One record per caseText 
Line 5AccessCDCSAuditTrails.mdbLine05Case ID (*)One record per childText 
Child ID (*)One record per childText
Child SSN (last four digits)One record per childText
Child Birth DateOne record per childDate
Line 6AccessCDCSAuditTrails.mdbLine06Case ID (*)One record per childText 
Child ID (*)One record per childText
Child SSN (last four digits)One record per childText
Paternity Establishment DateOne record per childDate
Line 8AccessCDCSAuditTrails.mdbLine08Child ID (*)One record per childText 
Child SSN (last four digits)One record per childText
Child NameOne record per childText
Child Birth DateOne record per childDate
Line 9AccessCDCSAuditTrails.mdbLine09Child ID (*)One record per childText 
Child SSN (last four digits)One record per childText
Child NameOne record per childText
Paternity Establishment DateOne record per childDate
Line 21AccessCDCSAuditTrails.mdbLine21Case ID (*)One record per caseText 
Line 21aAccessCDCSAuditTrails.mdbLine21aCase ID (*)One record per caseText 
Line 24AccessCDCSAuditTrails.mdbLine24Case ID (*)One record per caseTextFixed
Amount DueOne amount per case:  Total Amount of Current Support Due for the Fiscal YearNumber
Line 25AccessCDCSAuditTrails.mdbLine25Case ID (*)One record per caseTextFixed
Amount DistributedOne amount per case:  Total Amount Distributed as Current Support during the Fiscal YearNumber
Line 28AccessCDCSAuditTrails.mdbLine28Case ID (*)One record per caseText 
Line 29AccessCDCSAuditTrails.mdbLine29Case ID (*)One record per caseText