743302226R0044 Attachment 3 Payroll ITS File Specifications.pdf
PDF 47 KB Posted
- Attached to
- ABMC Human Resources Information System
- Solicitation number
- 74330226R0044
- Issued by
- Not on record
About this file
This is a file format specification document for Foreign Wire Payment Advanced Rate Payments submitted to a federal agency. The document provides detailed technical requirements for structuring payment files, including mandatory field definitions, data types, field lengths, and validation rules.
The file structure comprises three main record types: a File Header Record that identifies the submission with a filename format (XXMMDDYY.001), current date, batch sequence number, and descriptive title; a Wire Payment Detail Record containing payment specifics such as agency ALC code, schedule number, value date in YYMMDD format (must be two business days from file submission), base amount in USD, foreign exchange amount with currency code, and banking information including SWIFT addresses, beneficiary account details, and payment instructions; and a Trailer Record that concludes the file with record count and file total. The specification requires validation of critical fields including file name, current date, ALC code, value date, base amount, and foreign exchange amount, with file rejection mandated for invalid or missing required data. The document accommodates up to 100 repetitions of Treasury Account Symbol (TAS) and Business Event Type Code (BETC) entries per payment to fulfill agency requirements, and specifies that all banking detail fields support variable requirements for foreign currency transactions, including bank contact information for certain currencies.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 74330226R0044-45 Vendor Questions.xlsx | XLSX spreadsheet | |
| 74330226R0044 RFP Instructions.pdf | ||
| 74330226R0044 Attachment 2 Questions Matrix.xlsx | XLSX spreadsheet | |
| 74330226R0044 Attachment 1 HRIS PWS.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
File Header Record
EXAMPLE: XXMMDDYY.001 MMDDYY 01 VENDOR PAYMENTS
*ENDMSG*
# Field Name Type Length Start
Position End
Position KFC Validation Rules Notes
1 File Name AN 12 1 12 If invalid or missing, reject the file
Should be XXMMDDYY.001, where MMDDYY is current business month, day and year. The file extension".001" can be incremented if multiple file are processed on same day, for example ".002". The 2-character alpha beginning is agency specific. Recommend using 2 characters that represent the customer Agency's name - this would need to be confirmed with ITS.gov prior to use
2 Current Date AN 6 14 19 If invalid or missing, reject the file Date should match date in file name 3 Batch Sequence Number N 2 21 22 4 Descriptive File Title AN 19 24 43 Type of payments 5 *ENDMSG* AN 8 1 8 Concludes header record
Wire Payment Detail Record
# Field Name Type Length Start
Position End
Position KFC Validation Rules Notes
6 [FXR] A Required for wire payments. Start of payment record 7 :ALC: N 8 1 8 If invalid or missing, reject the file Should be Agency's ALC
8 :SCHEDULE: AN 10 1 10 Manually validated against SPS certification Schedule Number, no minimum
9 :30 VALUE DATE: AN 6 1 6
Must be two business days from date in file name
In YYMMDD format. US holidays should be taken into consideration
10 :BASE AMT: AN 21 1 21 If missing, reject the file "USD" space USD amount indicated, including decimals 11 :FX AMT: AN 21 1 21 If missing, reject the file 3 digit currency code space FX total including decimal 12 :57D PAY THRU: AN 8/11 1 11 If missing, reject the file SWIFT Address should be 8 or 11 alphanumeric characters 13 BANK NAME AN 35 1 35 Not all foreign wires / countries require full bank name 14 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address 15 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address 16 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address
17 :59 BENEFICIARY: AN 34 1 34
Beneficiary Account Number can be up to 34 alphanumeric characters
18 BENEFICIARY NAME AN 35 1 35
Not all foreign wires / countries require full beneficiary address
19 BENEFICIARY ADDRESS AN 35 1 35
Not all foreign wires / countries require full beneficiary address
20 BENEFICIARY ADDRESS AN 35 1 35
Not all foreign wires / countries require full beneficiary address
21 BENEFICIARY ADDRESS AN 35 1 35
22 :70 BENEF INFO:
23 PAYMENT INFORMATION AN 35 1 35
24 PAYMENT INFORMATION AN 35 1 35
25 PAYMENT INFORMATION AN 35 1 35
FOREIGN WIRE PAYMENT
ADVANCED RATE PAYMENT
26 PAYMENT INFORMATION AN 35 1 35
27 :72 RECEIVER INFO:
28 BANK DETAILS AN 35 1 35
Some foreign currencies require additional bank details (i.e.
bank contact phone number, in country vendor codes). These requirements should be populated in this field
29 BANK DETAILS AN 35 1 35
Some foreign currencies require additional bank details (i.e.
bank contact phone number, in country vendor codes). These requirements should be populated in this field
30 BANK DETAILS AN 35 1 35
Some foreign currencies require additional bank details (i.e.
bank contact phone number, in country vendor codes). These requirements should be populated in this field
31 BANK DETAILS AN 35 1 35
Some foreign currencies require additional bank details (i.e.
bank contact phone number, in country vendor codes). These requirements should be populated in this field
*32 :TAS: N 2 1 2 TAS Sub-level Prefix Code *33 N 3 3 5 TAS Allocation Transfer Agency Identifier *34 N 3 6 8 TAS Agency Identifier *35 N 4 9 12 TAS Beginning Period of Availability *36 N 4 13 16 TAS Ending Period of Availability *37 AN 1 17 17 TAS Availability Code *38 N 4 18 21 TAS Main Account Code *39 N 3 22 24 TAS Sub-Account Code *40 :BETC: AN 8 1 8 Businss Event Type Code *41 :AMT: N 17 1 17 USD amount including decimals *42 *ENDMSG* A Constitutes end of payment record
Trailer Record
EXAMPLE: *ENDFILE* 000001 00000000000000000
# Field Name Type Length Start
Position End
Position KFC Validation Rules Notes
43 *ENDFILE* A 9 1 9
44 Record Count N 6 11 16 Front fill with zeroes; total number of payments in file 45 File Total AN 16 18 33 Total USD found in file for all payments, no punctuation
Footnotes
* Lines 32, 33, 34, 35, 36, 37, 38, 39, 40, 41 can repeat up to 100 per payment to fulfill agency requirements for TAS / BETC
File details come from the government source that posted it. Updated .