3.6.2 Systems Interfaces
Example systems interface requirements:
A. System1-to-System2 Interface
The will create and send a fixed length text file as an email attachment to System2mail@u.washington.edu to be imported into the System2 system for payroll calculation. This file must be received on EDIT day by 4:00 PM in order to be processed in the EDIT night run. The requirements below document the file specifications, data transfer process, and specific schedule. This file is referred to as "FileName" in this document.
File Structure and Format
A1. The FileName file is a fixed length text file.
A2. The FileName file is an unformatted ASCII file (text-only).
A3. The FileName file contains a batch totals record and several detail records.
File Description: Batch Totals Record
A4. The batch totals record can be placed at the beginning, in the middle, or at the end of the file.
A5. The batch totals record contains the following:
• Record Type (value: XA)
• Process Type (value: A)
• Batch Number (3 digit number assigned by Payroll Dept)
• Origin Code (AIG)
• Total number of detail records
• Total deduction amount
File Description: Detail Records
A6. The FileName file contains a row for each record meeting xxx criteria.
A7. Each row in the FileName file contains the following fields, comma-delimited and encased in double-quotes where the data includes commas or spaces:
• Employee Id
• Record Type
• Process Date (MMDDYY)
• XYG Number
• Element Code
• Amount
• Amount Sign
• Year Flag
• Total Amount
• Total Amt Sign