Business Application Services - Technical

Interface File Layouts

Agency Information File Layout (.pdf, 1 pp, 72.86 KB - Revised: July 15, 2003)
AllTrans File Layout for General Ledger (.pdf, 5 pp, 117 KB - Revised: March 3, 2015)
AllTrans File Layout for Accounts Payable - Warrants (.pdf, 4 pp, 115.86 KB - Revised: May 20, 2004)
AllTrans File Layout for Accounts Payable - Funding (.pdf, 6 pp, 91 KB - Revised: March 3, 2015)
AllTrans File Layout for Accounts Receivable (.pdf, 3 pp, 93 KB - New: March 3, 2015)
Cash and Allotment Balances File Layout (.pdf, 1 pp, 58.56 KB - Revised: May 6, 2003)
File Layout for General Ledger Accounts (.pdf, 1 pp, 81.27 KB - Revised: April 30, 2003)
Miscellaneous Claims Record Layout (.pdf, 12 pp, 162.49 KB - Revised: April 29, 2003)
Outstanding Orders File Layout (.pdf, 2 pp, 105 KB) - Revised: March 3, 2015
Vouchers From Remote Agencies (.pdf, 12 pp, 97.64 KB - Revised: April 10, 2003)
Proposed 747 Layouts (.xls, 54 KB - created March 11, 2015)

Commodity Code Interface Layout (.pdf, 2 pp, 96.72 KB - Revised: Aug. 11, 2003)
Commodity Codes by Vendor (.pdf, 1 pp, 85.12 KB - Revised: March 31, 2003)
Statewide Contract Layout (.pdf, 3 pp, 101.03 KB - Revised: July 15, 2003)
Statewide Contract Line Item (.pdf, 3 pp, 101.31 KB - Revised: July 15, 2003)
Statewide Contract Line Ship (.pdf, 1 pp, 87.95 KB - Revised: July 15, 2003)
Statewide Contract Comments (.pdf, 1 pp, 92.98 KB - Revised: July 15, 2003)
Vendor File Interface Layout (.pdf, 4 pp, 112 KB - Revised: April 2, 2012
- Due to the PeopleSoft requirement that the valid unit of measures (UOMs) are specified for each commodity code, and only those UOMs may be used for that commodity code, the valid UOMs for each item be added to the extract file.

HCM Layouts - Overview (.pdf, 5 pp, 19.57 KB - Revised: Feb. 22, 2008)
Agency Extract File Change for PeopleSoft HCM 9.0 (.doc, 1 p, 27.5 KB - Revised: Nov. 14, 2008)
Agency Setup Tables (.xls, 207 KB - Revised: Sept. 17, 2010)
Employee Paycheck Summary (.pdf, 4 pp, 110.43 KB - Revised: May 17, 2004)
Employee Record Structure (.xls, 99KB - Revised: Nov. 14, 2008)
Employee Setup Tables (.xls, 528.5 KB - Revised: Sept. 17, 2010)
Leave (.pdf, 3 pp, 11.31 KB - Revised: April 27, 2005)
MDC Allocations (.xls, 44 KB - Revised: Sept. 17, 2010)
Paycheck Data (.xls, 311 KB - Revised: April 21, 2009)
Personal Data (.xls, 119 KB - Revised: June 25, 2010)
Setup Tables (pdf, 20 pp, 46.46 KB - Revised: Feb. 22, 2008)
Year to Date Information
(.xls, 94 KB - Revised: Oct. 24, 2006)