OCSE Office of Audit - Data Submission Requirements for the Fiscal Year 2008 Data Reliability Audits

����� DATA RELIABILITY AUDIT SPECIFICATIONS
Audit Trail	Format	Media	Database File	Table Name	Required Fields	Data	Data Type	Format
(*) Case ID must be the same format for all lines.� Likewise, Child ID must be the same format for all lines.
Child Support System Universe	Access	CD	CSAuditTrails.mdb	IVDUniverse	Case ID (*)	One record per case	Text
					Status Date	One record per case	Date
					Case Status	One record per case	Text
					CP Name	One record per case	Text
					CP SSN (last four digits)	One record per case	Text
					NCP Name	One record per case	Text
					NCP SSN (last four digits)	One record per case	Text
Line 1	Access	CD	CSAuditTrails.mdb	Line01	Case ID (*)	One record per case	Text
Line 2	Access	CD	CSAuditTrails.mdb	Line02	Case ID (*)	One record per case	Text
Line 2e	Access	CD	CSAuditTrails.mdb	Line02e	Case ID (*)	One record per case	Text
Line 5	Access	CD	CSAuditTrails.mdb	Line05	Case ID (*)	One record per child	Text
					Child ID (*)	One record per child	Text
					Child SSN (last four digits)	One record per child	Text
					Child Birth Date	One record per child	Date
Line 6	Access	CD	CSAuditTrails.mdb	Line06	Case ID (*)	One record per child	Text
					Child ID (*)	One record per child	Text
					Child SSN (last four digits)	One record per child	Text
					Paternity Establishment Date	One record per child	Date
Line 8	Access	CD	CSAuditTrails.mdb	Line08	Child ID (*)	One record per child	Text
					Child SSN (last four digits)	One record per child	Text
					Child Name	One record per child	Text
					Child Birth Date	One record per child	Date
Line 9	Access	CD	CSAuditTrails.mdb	Line09	Child ID (*)	One record per child	Text
					Child SSN (last four digits)	One record per child	Text
					Child Name	One record per child	Text
					Paternity Establishment Date	One record per child	Date
Line 21	Access	CD	CSAuditTrails.mdb	Line21	Case ID (*)	One record per case	Text
Line 21a	Access	CD	CSAuditTrails.mdb	Line21a	Case ID (*)	One record per case	Text
Line 24	Access	CD	CSAuditTrails.mdb	Line24	Case ID (*)	One record per case	Text	Fixed
					Amount Due	One amount per case:� Total Amount of Current Support Due for the Fiscal Year	Number
Line 25	Access	CD	CSAuditTrails.mdb	Line25	Case ID (*)	One record per case	Text	Fixed
					Amount Distributed	One amount per case:� Total Amount Distributed as Current Support during the Fiscal Year	Number
Line 28	Access	CD	CSAuditTrails.mdb	Line28	Case ID (*)	One record per case	Text
Line 29	Access	CD	CSAuditTrails.mdb	Line29	Case ID (*)	One record per case	Text