___________________________________
Department of Treasury
Bureau of the Fiscal Service
Secure Payment System (SPS) Schedule Upload 440 File Format
For Government-wide Accounting (GWA) Reporter Only
Version 1.6 Updated on May 2014
2 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Table of Contents
I GENERAL SPECIFICATIONS ................................................................................................................................................................................................. 4
A. INTRODUCTION ......................................................................................................................................................................................................................... 4B. CHANGES FOR GWA REPORTER ALCS .................................................................................................................................................................................... 5C. SCHEDULE TYPES/PAYMENT TYPES ......................................................................................................................................................................................... 8D. DATA ELEMENT FIELD VALUES.............................................................................................................................................................................................. 11E. FMS XML SCHEMA ............................................................................................................................................................................................................... 11
II CHECK PAYMENT SCHEDULE FILE FORMAT ........................................................................................................................................................... 12
A. RECORD “01” - CHECK HEADER RECORD (REQUIRED)........................................................................................................................................................... 12B. RECORD “04” - CHECK PAYMENT RECORD (REQUIRED)......................................................................................................................................................... 13C. RECORD “05” - CHECK STUB ENCLOSURE RECORD (REQUIRED IF PAYMENT ID LINES > 2, OTHERWISE OPTIONAL)............................................................. 16D. RECORD “06” - CHECK STUB ENCLOSURE (CONTINUED) RECORD (REQUIRED IF PAYMENT ID LINES > 8, OTHERWISE OPTIONAL) ...................................... 17E. RECORD “07” - CHECK PAYMENT LEVEL TAS/BETCS RECORD (REQUIRED) ........................................................................................................................ 18F. RECORD “08” - CHECK PAYMENT LEVEL PAYMENT INFORMATION REPOSITORY RECORD (OPTIONAL FOR VENDOR, OTHERWISE DISALLOWED) ................ 34G. RECORD “10” - CHECK PAYMENT PAYEE ADDRESS INFORMATION RECORD (REQUIRED WHEN ENCLOSURE CODE IS NON-ZERO, OTHERWISE OPTIONAL) . 35
III ACH PAYMENT SCHEDULE FILE FORMAT................................................................................................................................................................. 38
A. RECORD “01” - ACH HEADER RECORD (REQUIRED).............................................................................................................................................................. 38B. RECORD “04” - ACH PAYMENT RECORD (REQUIRED) ........................................................................................................................................................... 40C. RECORD “07” - ACH PAYMENT LEVEL TAS/BETCS FOR NON-PRENOTES RECORD (REQUIRED).......................................................................................... 42D. RECORD “08” - ACH PAYMENT LEVEL PAYMENT INFORMATION REPOSITORY RECORD (OPTIONAL FOR VENDOR ONLY, OTHERWISE DISALLOWED)......... 59E. RECORD “10” - ACH PAYMENT PAYEE ADDRESS RECORD (REQUIRED FOR NON-DOMESTIC, OTHERWISE OPTIONAL) ......................................................... 60
IV SAME DAY PAYMENT (SDP) SCHEDULE FILE FORMAT ......................................................................................................................................... 62
A. RECORD “01”- SDP HEADER RECORD (REQUIRED)................................................................................................................................................................ 63B. RECORD “04” - SDP SCHEDULE HEADER RECORD (REQUIRED) ............................................................................................................................................. 63C. RECORD “05” – SDP PAYMENT RECORD (REQUIRED) ............................................................................................................................................................ 65D. RECORD “07” - SDP PAYMENT LEVEL TAS/BETCS RECORD (REQUIRED) ............................................................................................................................ 68E. RECORD “08” – SDP PAYMENT LEVEL PAYMENT INFORMATION REPOSITORY RECORD (OPTIONAL) .................................................................................... 84
V SUMMARY TOTALS SCHEDULE FILE FORMAT ........................................................................................................................................................ 86
A. RECORD “01” - SUMMARY TOTALS HEADER RECORD (REQUIRED) ........................................................................................................................................ 86B. RECORD “04” - SUMMARY TOTALS RECORD (REQUIRED) ...................................................................................................................................................... 88C. RECORD “05” – SUMMARY TOTALS COMMENTS RECORD (REMARKS) (OPTIONAL) ............................................................................................................... 90D. RECORD “06” – SUMMARY TOTALS COMMENTS (CONTINUED) RECORD (REMARKS - CONTINUED) (OPTIONAL)................................................................... 91E. RECORD “07” – SUMMARY TOTALS TAS/BETCS FOR NON-PRENOTES RECORD (REQUIRED) ............................................................................................... 92
VI ACRONYMS ......................................................................................................................................................................................................................... 103
3 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
VII STATE CODES.................................................................................................................................................................................................................. 104
APPENDIX 1 .................................................................................................................................................................................................................................. 107
A. FORMAT REQUIREMENTS...................................................................................................................................................................................................... 107B. FILE STRUCTURE .................................................................................................................................................................................................................. 107
FIGURE 1 - SCHEDULE TYPES/PAYMENT TYPES/SEC/AMOUNT RESTRICTIONS CHART 11 FIGURE 2 - VALID CHARACTERS FOR DATA FIELDS 11
4 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
I General Specifications
A. Introduction On October 7, 2012 the Financial Management Service and Bureau of the Public Debt were consolidated and re-designated as the new Bureau of the Fiscal Service. References and logos have been changed to reflect this consolidation. For Same Day Pay schedules the Account Number is always required. To provide information deemed necessary to process Same Day Pay / Wire Schedules through the Federal Reserve Bank and U.S Treasury Department’s Office of Foreign Assets Control’s (OFAC) Specially Designated Nationals and Blocked Persons (SDN) List, the following changes have been incorporated: Party Name is always required, Account Number is required if Product Code is "CTR/", Beneficiary Bank Remarks maximum length is 68 positions instead of 72, and Bank Name maximum length is 35 positions instead of 51. Regular Check schedule payment amounts must be less than $10 million; therefore, the first position of the field shall be 0.
This document represents the data specification for uploading schedules for GWA Reporter Agency Location Codes (ALCs) only. This specification is not to be used for non-GWA Reporter ALC schedules. There is a separate specification for Non-GWA Reporters. See the SPS Website at www.fms.treas.gov/sps. Guidance on GWA Reporting can be found on the Central Accounting and Reporting System (CARS) website (https://fms.treas.gov/cars/ref_guidance.html). GWA Reporter ALCs (i.e., CARS Reporters) for Payments shall provide Treasury Account Symbol/Business Event Type Code(s) (TAS/BETCs) on ACH, Check, Manual Check, Same Day Payment and Summary schedules in order to classify transactions when they are initiated and thereby streamline central accounting reporting. TAS/BETCs shall include the Debit/Credit Type indicator. The Shared Accounting Module (SAM) shall provide a list of Payment TAS/BETCs as GWA Reference Data on the SAM Public Website (https://www.sam.fms.treas.gov/sampublic/). For GWA Reporter ALCs that enter Summary Schedules certifications in SPS, the corresponding bulk payment file shall use the Payment Application Modernization (PAM) Standard Request Format when transmitting the bulk payment files to Bureau of the Fiscal Service. PAM information is available on the PAM Website www.fms.treas.gov/pam. In addition, other changes have been incorporated for ACH Payee Address for International ACH Transactions (IAT) or domestic letters, ACH garnishment indicator, additional check address fields, standardized amount size to a maximum of 10 digits at the payment level for ACH, and various changes listed in the change section.
5 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
B. Changes for GWA Reporter ALCs 1. The File Format Version “GWA001” shall be required. (Record “01”, positions 3-8). 2. All Schedule Numbers can be a maximum of 14 positions. (Record “01”, positions 9-22) 3. Fields that do not apply shall be listed as filler. 4. Certain records and fields that were required, but empty, are now optional. 5. “AFC” is not valid for Regional Financial Center (RFC). Only “KFC”, “PFC” and “SFC” are valid RFCs. (Record 01, positions 43-45
for Manual Check and Summary) 6. A schedule can have a maximum of 1,000 TAS/BETCs per schedule. The Schedule Upload 440 File Format for GWA Reporter
ALCs does not have Total Schedule Amount field or Total Count field for Type A schedules for ACH, ACH Prenote, Check, Manual Check, and Same Day Payment (SDP). The Schedule Upload 440 File Format for GWA Reporter does not have summarization of TAS/BETC at the schedule level for Type A schedules for ACH, ACH Prenote, Check, Manual Check, and Same Day Payment (SDP). SPS computes this based on payment information.
7. Specific changes for GWA Reporters by Check, ACH, Same Day Payment (SDP) and Summary are below. a. Check
i. New optional procurement fields for Vendor schedules at the payment level: Procurement Instrument Identifier, Procurement Agency Identifier, Contracting Office Procurement Agency Identifier, Indefinite Delivery Vehicle Procurement Instrument Identifier, and Indefinite Delivery Vehicle Procurement Agency Identifier. (Record “08”)
ii. Check Payment Payee Address Information has been moved to a separate Record “10” and fields have been added. (1) Changes to Payee Address - Domestic
(a) New Is Non Domestic (International Address Indicator) value = “0” for Domestic, (b) New Optional City Name, (c) New Optional State Code Text, (d) New Optional Postal Code, and (e) New Optional Postal Code Extension.
(2) Changes to Payee Address - International/Foreign (a) New Is Non Domestic (International Address Indicator) value = “1” for International/Foreign, (b) Payee Address Line 4 not allowed for International/Foreign Addresses, (c) New Optional City Name, (d) New Optional State Name, (e) New Required Country Name, (f) New Optional Postal Code, (g) New Optional Postal Code Extension, and (h) New Optional Consular Code (It is a three position code to indicate the code for mailing bulk check
shipments to foreign countries via the consulate. These Consular Codes, also known as GEO Codes, can be obtained from the servicing RFC.).
6 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
b. Automated Clearing House (ACH) i. Added Schedule Level Garnishment Indicator for ACH schedules. (Record “01”, position 422) ii. Removed “P” Preauthorized Debit PPD and “Q” Preauthorized Debit CCD as ACH Payment Type Codes. (Record
“01”, position 418) iii. Removed value “F” for “Miscellaneous PPD” Payment Type Code. Use value “M” for “Miscellaneous” and specify
Standard Entry Class Code (SEC) of “IAT”, “PPD” or “CCD”. (Record “01”, position 418) iv. SEC was formerly called Addendum Code. SEC will be at the schedule level. All payments on the schedule must be
the same SEC. The SEC values are “PPD”, “CCD” and the new “IAT” for International ACH Transactions. IAT is available for all ACH schedule payment types. (Record “01”, positions 419-421)
v. New optional procurement fields for Vendor schedules at the payment level: Procurement Instrument Identifier, Procurement Agency Identifier, Contracting Office Procurement Agency Identifier, Indefinite Delivery Vehicle Procurement Instrument Identifier, and Indefinite Delivery Vehicle Procurement Agency Identifier. (Record “08”)
vi. ACH with SEC = “IAT” allows two optional Payment Related Information fields for IAT Addenda Record for Remittance Information. (Record “04”, 113-192 and 284-363)
vii. New ACH Payee Address (Record “10”): (1) International Address (SEC = “IAT”)
(a) New Is Non Domestic (International/Foreign Payee Address Indicator) field = “1” if SEC = “IAT”, (b) New Required Payee Address Line 1, (c) New Required City Name, (d) New Optional State Name, (e) New Optional Postal Code, (f) New Optional Postal Code Extension, and (g) New Required Country Code Text.
(2) Domestic Address (SEC = “PPD” or “CCD”) (a) New Is Non Domestic (International/Foreign Payee Address Indicator) field = “0” if SEC = “PPD” or “CCD”, (b) New Optional Payee Address Line 1, (c) New Optional Payee Address Line 2, (d) New Optional City Name, (e) New Optional State Code Text, (f) New Optional Postal Code, and (g) New Optional Postal Code Extension.
7 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
c. Same Day Payment i. New optional procurement fields at the payment level: Procurement Instrument Identifier, Procurement Agency
Identifier, Contracting Office Procurement Agency Identifier, Indefinite Delivery Vehicle Procurement Instrument Identifier, and Indefinite Delivery Vehicle Procurement Agency Identifier. (Record “08”)
d. Summary i. Removed Summary Payment Type B Codes: “P” Preauthorized Debits (PADs) and “R” RedrawSchedulesTOP.
(Record “04”, position 35) ii. Removed Mixed Check and ACH (“M”) from Summary and Summary Prenote payment method. (Record “04”,
position 36)
8 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
8. TAS/BETC Changes for GWA Reporters a. There must be at least 1 TAS/BETC with debit type per payment for non-Prenotes. (Record “07”) b. TAS must be in the CGAC format. (Record “07”) c. Each TAS/BETC must have an Is Credit Indicator (debit/credit type) where “0” is Debit and “1” is Credit. The Is Credit Indicator
corresponds to the BETC Type. The TAS/BETC and Is Credit Indicator must be valid. (Record “07”) d. There can be a maximum of 100 unique TAS/BETCs per non-Prenote payment for ACH, Check and Same Day Payment
Schedules. (Record “07”) e. Each TAS/BETC must have an amount. TAS/BETC amounts must follow current amount requirements to be right justified, zero
padded, and valid characters are “0-9”. The last two digits are cents. (Record “07”) f. TAS/BETC Amounts cannot be $0.00. ACH Prenotes and Summary Prenotes do not have TAS/BETCs. (Record “07”) g. For ACH, Check and Same Day Payment, the Total TAS/BETC Amount (Debit minus Credit) for a payment must equal the
Payment Amount. (Check and ACH Total TAS/BETC amount for a payment can be from $0.01 to $99,999,999.99. Same Day Payment Total TAS/BETC amount for a payment can be from $0.01 to $9,999,999,999.99.) (Record “07”s and Record “04”)
h. For ACH, Check and Same Day Payment, each TAS/BETC Amount has the same length restrictions as the Payment Amount. (Each Check and ACH TAS/BETC can be from $0.01 to $99,999,999.99. Each Same Day Payment TAS/BETC can be from $0.01 to $9,999,999,999.99.) (Record “07”)
i. For Summary schedules, the Total TAS/BETC Amount (Debit minus Credit) must be the schedule Total Amount from $0.01 to $9,999,999,999,999.99. (Record “07”)
j. Individual Summary Schedule TAS/BETC Amounts can be from $0.01 to $99,999,999,999.99 (Record “07”) k. There can be a maximum of 1,000 unique TAS/BETCs at the schedule level per non-Prenote schedule. (Record “07”) l. On a Record “07”, after the first TAS/BETC Amount combination, all other TAS/BETC Amount combinations are optional and
only entered if needed. m. On a Record “07”, the TAS/BETC Amount combinations must be contiguous and sequential. Do not have blank TAS/BETC-
Amount combinations between actual TAS/BETC Amount combinations. (Do not skip.)
C. Schedule Types/Payment Types 1. The Schedule Types/Payment Types/SEC/Amount Restrictions Chart defines schedule types and payment types for all
schedules, as well as, the valid SEC (formerly called addendum code) for ACH schedules and payment amount restrictions. There are seven main schedule types: Regular Check, Manual Check, ACH, ACH Prenotes, Same Day Payment, Summary, and Summary Prenotes.
9 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Payment Schedule
Type Payment Type
Standard Entry Class Code (SEC)
Amount per Payment and/or TAS/BETC
Check Vendor C V N/A $0.01-$9,999.999.99Check Miscellaneous C M N/A $0.01-$9,999.999.99Check Tax C X N/A $0.01-$9,999.999.99Check OPM Benefit C O N/A $0.01-$9,999.999.99Check RRB Benefit C R N/A $0.01-$9,999.999.99Check SSA Benefit C B N/A $0.01-$9,999.999.99Check SSI Benefit C D N/A $0.01-$9,999.999.99Check VA Benefit C C N/A $0.01-$9,999.999.99Manual Check Vendor N V N/A $0.01-$99,999,999.99Manual Check Miscellaneous N M N/A $0.01-$99,999,999.99Manual Check Tax N X N/A $0.01-$99,999,999.99ACH Vendor A V CCD/IAT $0.01-$99,999,999.99ACH Salary A S PPD/IAT $0.01-$99,999,999.99ACH Travel A T PPD/IAT $0.01-$99,999,999.99ACH Miscellaneous A M PPD/CCD/IAT $0.01-$99,999,999.99ACH Tax A X PPD/IAT $0.01-$99,999,999.99ACH OPM Benefit A O PPD/IAT $0.01-$99,999,999.99ACH RRB Benefit A R PPD/IAT $0.01-$99,999,999.99ACH SSA Benefit A B PPD/IAT $0.01-$99,999,999.99ACH SSI Benefit A D PPD/IAT $0.01-$99,999,999.99ACH VA Benefit A C PPD/IAT $0.01-$99,999,999.99ACH Prenotes Vendor P V CCD/IAT $0ACH Prenotes Salary P S PPD/IAT $0ACH Prenotes Travel P T PPD/IAT $0ACH Prenotes Miscellaneous P M PPD/CCD/IAT $0ACH Prenotes Tax P X PPD/IAT $0ACH Prenotes OPM Benefit P O PPD/IAT $0ACH Prenote RRB Benefit P R PPD/IAT $0ACH Prenotes SSA Benefit P B PPD/IAT $0
10 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Payment Schedule Type
Payment Type
Standard Entry Class Code (SEC)
Amount per Payment and/or TAS/BETC
ACH Prenotes SSI Benefit P D PPD/IAT $0ACH Prenotes VA Benefit P C PPD/IAT $0SDP D Blank N/A $0.01-$9,999,999,999.99 Summary Allotments M A N/A $0.01-$99,999,999,999.99 Summary Benefit (Monthly: SSA, SSI, VA, OPM and RRB)
M B N/A $0.01-$99,999,999,999.99
Summary Daily Benefit (such as PMA) M D N/A $0.01-$99,999,999,999.99Summary Foreign Mailing M F N/A $0.01-$99,999,999,999.99Summary International Direct Deposit (IDD) M H N/A $0.01-$99,999,999,999.99Summary IDRS Daily Tax M I N/A $0.01-$99,999,999,999.99Summary Miscellaneous M M N/A $0.01-$99,999,999,999.99Summary VAINS (VA Insurance) M N N/A $0.01-$99,999,999,999.99Summary Salary M S N/A $0.01-$99,999,999,999.99Summary Travel M T N/A $0.01-$99,999,999,999.99Summary Vendor M V N/A $0.01-$99,999,999,999.99Summary Tax Refunds (IMF, BMF) M X N/A $0.01-$99,999,999,999.99Summary EDI/EFT/CTX Files M Z N/A $0.01-$99,999,999,999.99Summary Prenote Allotments Y A N/A $0.00 Summary Prenote Benefit (Monthly: VA, OPM and RRB)
Y B N/A $0.00
Summary Prenote Daily Benefit (PMA) Y D N/A $0.00 Summary Prenote Foreign Mailing Y F N/A $0.00 Summary Prenote International Direct Deposit (IDD) Y H N/A $0.00 Summary Prenote IDRS Daily Tax Y I N/A $0.00 Summary Prenote Miscellaneous Y M N/A $0.00 Summary Prenote VAINS (VA Insurance) Y N N/A $0.00 Summary Prenote Salary Y S N/A $0.00 Summary Prenote Travel Y T N/A $0.00 Summary Prenote Vendor Y V N/A $0.00 Summary Prenote Tax Refunds (IMF, BMF) Y X N/A $0.00
11 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Payment Schedule Type
Payment Type
Standard Entry Class Code (SEC)
Amount per Payment and/or TAS/BETC
Summary Prenote EDI/EFT/CTX Files Y Z N/A $0.00 Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
D. Data Element Field Values 1. In the file formats “A/N” means alpha-numeric and “N” means numeric. 2. Legal field values will consist of characters from the “Keyboard ASCII Character Set” as defined by the following regular
expression: [A-Z0-9&'><!#$%\(\)\+\*,\./:;=?@\[\]\\\^_`{}\|~\-] All alphabetical characters in the character set are upper case. This character set is printed in the table below. Additional field restrictions are defined in the validation criteria for each field.
Figure 2 - Valid Characters for Data Fields
3. Unless otherwise specified, alpha-numeric fields are to be left justified with trailing blanks. 4. Unless otherwise specified, numeric fields are right justified with leading zeros. 5. Filler fields are currently not validated for content. Implementers are expected to blank fill (0x20) fields so that the current fields
are compatible with future format changes if any. 6. Amount fields do not have decimal points, commas, dollar signs or positive/negative sign. The last two digits are cents. For
example: Check Payment Amount of $50.00 would be “0000005000”.
E. XML Schema Fiscal Service is moving towards allowing agencies to transmit file messages using XML. Fiscal Service publishes the Business Data Exchanges XML Schema on their website, www.fms.treas.gov/eda under Transmission Message. SPS changed some field naming conventions in the "Field" column of this document to be similar to the Fiscal Service XML Schema v4.5.1 convention which is reference in the "XML Schema Transmission" column. Although the XML Schema will provide basic format, additional more specific field requirements will be contained in SPS documentation for certain fields. As of February 2011, the Transmission Message XML Schema is version 4.5.1 using urn:us:gov:treas:fms:BusinessTransaction:v4.5.1 at http://fms.treas.gov/eda/xml/FMSv451/Transmission/index.html.
12 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
II Check Payment Schedule File Format Check Record Order Notation: 01, (04, [05, [06]], 07{1, 12}, [08], [10]) {1, 60} Description: 01 record followed by one to sixty "Payment record(s)". Each Payment record(s) has a 04 record followed by "Payment ID record(s)", followed by one to twelve 07 records, followed by an optional 08 record, and followed by an optional 10 record. Payment ID record(s) can be just a single 05 record, or, 05 record followed by 06 record. Manual Check Record Order Notation: 01, (04, 07{1, 12}, [08], [10]) {1, 60} (Manual Check is the same as Check except no 05 and 06 Records.)
A. Record “01” - Check Header Record (Required) Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission (1)
1 2 1-2 N Record Type Value = “01”. 2 6 3-8 A/N File Format Version Required. Value = “GWA001”.
(Formerly Transmission Number X(6) 3-8)
3 14 9-22 A/N Schedule Number Required. Valid characters are “0-9”, “A-Z”, or dash (-). Cannot be all zeroes. Shall not be reused by ALC for one fiscal year. Right justify and zero pad.
/Transmission/Schedule/@ScheduleNumber
4 20 23-42 Filler No validation. (Formerly Date/Time X(12) positions 23-34) (Formerly FPAID X(4) positions 35-38) (Formerly FPA PC# X(2) positions 39-40) (Formerly Filler X(2) positions 41-42)
5 3 43-45 A/N Regional Financial Center Code (RFC) (Formerly RFC Identifier)
Required for Manual Check only. If it is a Manual Check Schedule, this field must have a valid RFC, otherwise blank fill no validation. Values = “KFC”, “PFC”, or “SFC”
/Transmission/Schedule/@RegionalFinancialCenterCode
6 8 46-53 N Agency Location Code (ALC)
Required. Must be valid 8-digit Treasury Disbursed ALC.
/Transmission/Schedule/OriginatingAgency/@AgencyLocationCode
7 363 54-416 Filler No validation. (Formerly DOS File Name x(12) 54-65) (Formerly Filler X(351) 66-416)
13 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
8 1 417-417 A/N Schedule Type (formerly Payment Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
/Transmission/Schedule/TypeA_Details/CheckPayments/@IsManualCheck
9 1 418-418 A/N Payment Type Code (formerly Payment Sub-Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
/Transmission/Schedule/TypeA_Details/CheckPayments/@PaymentTypeCode
10 22 419-440 Filler No validation. (1) See Section IE, XML Schema
B. Record “04” - Check Payment Record (Required)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “04”.
2 20 3-22
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)
3 1 23-23 N Check Payment Enclosure Code (formerly Check Enclosure Code)
Required. Values are: “0” – Name Only, “1” – Direct Mail, “2” - Stub, or “5” – Foreign Mail. If Schedule Type in “01” record equals “N” for Manual Check or Payment Type Code equals “X” Tax, “O” OPM Benefit, “R” RRB Benefit , “B” SSA Benefit, “D” SSI Benefit or “C” VA Benefit; the Check Payment Enclosure Code must be “1”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@CheckPaymentEnclosureCode
4 8 24-31 Filler No validation. (Formerly Filler X(7) positions 24-30) (Formerly Zero Constant 9(1) positions 31-31)
5 10 32-41 N Payment Amount Required. Valid characters are “0-9”. Right justify and zero pad. The last two digits are cents. If Schedule Type is "C" for Check, the first position must always be zero (i.e., less than $10 million)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/Payment/@Amount
14 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
6 10 42-51 A/N Agency Check Text (formerly Agency ID)
Optional. Blank fill if not used. Valid characters are “0-9”, “A-Z”, dash (-), or blanks.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@AgencyCheckText
7 1 52-52 Filler No validation. (Formerly Record Code “B” X(1) positions 52-52)
8 35 53-87 A/N Party Name (formerly Payee Name)
Required. First position cannot be a space. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@PartyName
9 130 88-217 Filler No validation. Address moved to record “10”. (Formerly Address 1 X(35) positions 88-122) (Formerly Address 2 X(35) positions 123-157) (Formerly Address 3 X(30) positions 158-187) (Formerly Address 4 X(30) positions 188-217)
10 1 218-218 A/N Agency Payment Type Code (formerly Type of Payment)
Optional. For agency use to further classify payment type. Blank fill if not used. If used, valid characters are “0-9” or “A-Z”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@AgencyPaymentTypeCode
11 16 219-234 Filler No validation. (Formerly Account Symbol X(16) positions 219-234)
12 9 235-243 A/N Payee Identifier (formerly Payee ID/TIN)
Required. Shall be valid Payee’s Taxpayer Identification Number, Vendor ID, SSN or other valid Payee ID. This field is required for Treasury Debt Offset. First position shall be = “0-9”, “A-Z”, or “-“. For positions 2-9, valid characters are “0-9”, “A-Z”, dash (-) or blanks.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@PayeeIdentifier
13 40 244-283 Filler No validation.
14 2 284-285 N Number of Payment Identification Lines
Required. Value = “00”-“14”, representing the number of
15 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Payment ID Lines in the file. If Value > “02” record “05” is required, otherwise optional. If Value > “08” record “06” is required, otherwise optional. Enclosure Code = “0”, “1”, or “5” can have from 0 to 2 Payment ID Lines. Enclosure Code = “2” can have from 1 to 14 Payment ID Lines.
15 55 286-340 A/N Payment Identification Line 1 (formerly Payment ID Line 1)
Optional and limited to first 40 characters if Check Payment Enclosure Code = “0”, “1” or “5”. Required and shall be up to 55 characters if Check Payment Enclosure Code = “2”. Blank fill if not used.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
16 55 341-395 A/N Payment Identification Line 2 (formerly Payment ID Line 2)
Optional and limited to first 40 characters if Check Payment Enclosure Code = “0”, “1”, or “5”. Optional and can be up to 55 characters if Check Payment Enclosure Code = “2”. Blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 2.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
17 19 396-414 Filler No validation. (Formerly Filler X(18) positions 396-413) (Formerly 1099 Reporting Eligibility X(1) 414-414)
18 1 415-415 A/N Is TOP Offset (formerly TOP Offset Eligibility)
Required. Values are “Y” (payment is eligible for Treasury Offset) or “N” (not eligible for offset).
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@IsTOPOffset
19 25 416-440 Filler No validation. (Formerly ASAID length 8 positions 416-423) (Formerly ACOID length 8 positions 424-431) (Formerly MAC length 9 positions 432-440)
16 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
C. Record “05” - Check Stub Enclosure Record (Required if Payment ID Lines > 2, Otherwise Optional)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “05”. This record is provided for Check Payment Enclosure Code 2.
2 20 3-22
Filler No validation. (Formerly Payment Number length 6 positions 3-8) (Formerly Schedule Number length 14 positions 9-22)
3 55 23-77 A/N Payment Identification Line 3 (formerly Payment ID Line 3)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 3.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
4 55 78-132 A/N Payment Identification Line 4 (formerly Payment ID Line 4)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 4.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
5 55 133-187 A/N Payment Identification Line 5 (formerly Payment ID Line 5)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 5.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
6 55 188-242 A/N Payment Identification Line 6 (formerly Payment ID Line 6)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 6.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
7 55 243-297 A/N Payment Identification Line 7 (formerly
Optional, blank fill if not used. Must be blank filled if the number of Payment ID
/Transmission/Schedule/TypeA_Details/CheckPaymen
17 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
D. Record “06” - Check Stub Enclosure (Continued) Record (Required if Payment ID Lines > 8, Otherwise Optional)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “06”. This record is provided for Check Payment Enclosure Code 2.
2 20 3-22
Filler No validation. (Formerly Payment Number length 6 positions 3-8) (Formerly Schedule Number length 14 positions 9-22)
3 55 23-77 A/N Payment Identification Line 9 (formerly Payment ID Line 9)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 9.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
4 55 78-132 A/N Payment Identification Line 10 (formerly Payment ID Line 10)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 10.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentI
Payment ID Line 7) Lines are less than 7. ts/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
8 55 298-352 A/N Payment Identification Line 8 (formerly Payment ID Line 8)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 8.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
9 88 353-440 Filler No validation. (Formerly Filler length 63 positions 353-415) (Formerly ASAID length 8 positions 416-423) (Formerly ACOID length 8 positions 424-431) (Formerly MAC length 9 positions 432-440)
18 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
dentificationLine
5 55 133-187 A/N Payment Identification Line 11 (formerly Payment ID Line 11)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 11.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
6 55 188-242 A/N Payment Identification Line 12 (formerly Payment ID Line 12)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 12.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
7 55 243-297 A/N Payment Identification Line 13 (formerly Payment ID Line 13)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 13.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
8 55 298-352 A/N Payment Identification Line 14 (formerly Payment ID Line 14)
Optional, blank fill if not used. Must be blank filled if the number of Payment ID Lines are less than 14.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PaymentIdentificationLines/PaymentIdentificationLine
9 88 353-440 Filler No validation. (Formerly Filler length 63 positions 353-415) (Formerly ASAID length 8 positions 416-423) (Formerly ACOID length 8 positions 424-431) (Formerly MAC length 9 positions 432-440)
E. Record “07” - Check Payment Level TAS/BETCs Record (Required)
The first TAS/BETC-TYPE is required. Every entered TAS/BETC-TYPE must be valid per SAM. There cannot be non-blank TAS/BETC-TYPEs after a blank TAS/BETC-TYPE. Unused TAS/BETC-TYPE entries must be blank filled. Cannot be more than 12 consecutive “07” records for Check.
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
19 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
1 2 1-2 N Record Type Value = “07”.
2 2 3-4 N TAS (a) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
3 3 5-7 N TAS (a) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
4 3 8-10 N TAS (a) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
5 4 11-14 N TAS (a) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
6 4 15-18 N TAS (a) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
7 1 19-19 A TAS (a) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTy
20 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
peCode
8 4 20-23 N TAS (a) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
9 3 24-26 N TAS (a) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
10 8 27-34 A/N BETC (a) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
11 1 35-35 N Is Credit (DEBIT/CREDIT TYPE) (a)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
12 15 36-50 N TAS/BETC-Amount (a) Must be a valid amount. See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
13 2 51-52 N TAS (b) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
14 3 53-55 N TAS (b) Allocation Must be a valid value for this field per GWA. /Transmission/Schedule/Ty
21 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Transfer Agency Identifier (ATA)
peA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
15 3 56-58 N TAS (b) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
16 4 59-62 N TAS (b) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
17 4 63-66 N TAS (b) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
18 1 67-67 A TAS (b) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
19 4 68-71 N TAS (b) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
20 3 72-74 N TAS (b) Sub-Account Must be a valid value for this field per GWA. /Transmission/Schedule/Ty
22 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Code (SUB) peA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
21 8 75-82 A/N BETC (b) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
22 1 83-83 N Is Credit (DEBIT/CREDIT TYPE) (b)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
23 15 84-98 N TAS/BETC-Amount (b) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
24 2 99-100 N TAS (c) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
25 3 101-103 N TAS (c) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
26 3 104-106 N TAS (c) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAcco
23 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
untSymbol/@AgencyIdentifier
27 4 107-110 N TAS (c) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
28 4 111-114 N TAS (c) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
29 1 115-115 A TAS (c) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
30 4 116-119 N TAS (c) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
31 3 120-122 N TAS (c) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
32 8 123-130 A/N BETC (c) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEve
24 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ntType/@BusinessEventTypeCode
33 1 131-131 N Is Credit (DEBIT/CREDIT TYPE) (c)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
34 15 132-146 N TAS/BETC-Amount (c) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
35 2 147-148 N TAS (d) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
36 3 149-151 N TAS (d) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
37 3 152-154 N TAS (d) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
38 4 155-158 N TAS (d) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
25 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
39 4 159-162 N TAS (d) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
40 1 163-163 A TAS (d) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
41 4 164-167 N TAS (d) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
42 3 168-170 N TAS (d) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
43 8 171-178 A/N BETC (d) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
44 1 179-179 N Is Credit (DEBIT/CREDIT TYPE) (d)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
45 15 180-194 N TAS/BETC-Amount (d) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount
/Transmission/Schedule/TypeA_Details/CheckPaymen
26 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Restrictions Chart) ts/CheckPayment/AccountClassification/Classification/@Amount
46 2 195-196 N TAS (e) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
47 3 197-199 N TAS (e) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
48 3 200-202 N TAS (e) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
49 4 203-206 N TAS (e) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
50 4 207-210 N TAS (e) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
51 1 211-211 A TAS (e) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/Account
27 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Classification/TreasuryAccountSymbol/@AvailabilityTypeCode
52 4 212-215 N TAS (e) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
53 3 216-218 N TAS (e) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
54 8 219-226 A/N BETC (e) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
55 1 227-227 N Is Credit (DEBIT/CREDIT TYPE) (e)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
56 15 228-242 N TAS/BETC-Amount (e) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
57 2 243-244 N TAS (f) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
28 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
58 3 245-247 N TAS (f) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
59 3 248-250 N TAS (f) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
60 4 251-254 N TAS (f) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
61 4 255-258 N TAS (f) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
62 1 259-259 A TAS (f) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
63 4 260-263 N TAS (f) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
29 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
64 3 264-266 N TAS (f) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
65 8 267-274 A/N BETC (f) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
66 1 275-275 N Is Credit (DEBIT/CREDIT TYPE) (f)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
67 15 276-290 N TAS/BETC-Amount (f) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
68 2 291-292 N TAS (g) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
69 3 293-295 N TAS (g) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
70 3 296-298 N TAS (g) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/Account
30 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Classification/TreasuryAccountSymbol/@AgencyIdentifier
71 4 299-302 N TAS (g) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
72 4 303-306 N TAS (g) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
73 1 307-307 A TAS (g) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
74 4 308-311 N TAS (g) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
75 3 312-314 N TAS (g) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
76 8 315-322 A/N BETC (g) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/Account
31 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Classification/BusinessEventType/@BusinessEventTypeCode
77 1 323-323 N Is Credit (DEBIT/CREDIT TYPE) (g)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
78 15 324-338 N TAS/BETC-Amount (g) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
79 2 339-340 N TAS (h) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
80 3 341-343 N TAS (h) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
81 3 344-346 N TAS (h) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
82 4 347-350 N TAS (h) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
32 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
83 4 351-354 N TAS (h) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
84 1 355-355 A TAS (h) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
85 4 356-359 N TAS (h) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
86 3 360-362 N TAS (h) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
87 8 363-370 A/N BETC (h) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
88 1 371-371 N Is Credit (DEBIT/CREDIT TYPE) (h)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
89 15 372-386 N TAS/BETC-Amount (h) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount
/Transmission/Schedule/TypeA_Details/CheckPaymen
33 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Restrictions Chart) ts/CheckPayment/AccountClassification/Classification/@Amount
90 2 387-388 N TAS (i) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
91 3 389-391 N TAS (i) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
92 3 392-394 N TAS (i) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
93 4 395-398 N TAS (i) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
94 4 399-402 N TAS (i) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
95 1 403-403 A TAS (i) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/Account
34 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Classification/TreasuryAccountSymbol/@AvailabilityTypeCode
96 4 404-407 N TAS (i) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
97 3 408-410 N TAS (i) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
98 8 411-418 A/N BETC (i) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
99 1 419-419 N Is Credit (DEBIT/CREDIT TYPE) (i)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/@IsCredit
100 15 420-434 N TAS/BETC-Amount (i) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/AccountClassification/Classification/@Amount
101 6 435-440 Filler No validation.
F. Record “08” - Check Payment Level Payment Information Repository Record (Optional for Vendor, Otherwise Disallowed)
Field Length Positions Type Field Validations/Notes XML Schema Transmission
35 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
G. Record “10” - Check Payment Payee Address Information Record (Required When Enclosure Code is Non-Zero, Otherwise Optional)
No A/N
1 2 1-2 N Record Type Value = “08”.
2 50 3-52 A/N Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/ProcurementDetail/@ProcurementInstrumentIdentifier
3 4 53-56 A/N Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/ProcurementDetail/@ProcurementAgencyIdentifier
4 4 57-60 A/N Contracting Office Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/ProcurementDetail/@ContractingOfficeProcurementAgencyIdentifier
5 50 61-110 A/N Indefinite Delivery Vehicle Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@ProcurementInstrumentIdentifier
6 4 111-114 A/N Indefinite Delivery Vehicle Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@ProcurementAgencyIdentifier
7 326 115-440 Filler No validation.
36 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “10”.
2 1 3-3 N Is Non Domestic (International/Foreign Address Indicator)
Values = “1” (International/Foreign) or “0” (Domestic). For Check Payment Enclosure Code = Foreign Mail (5), Is Non Domestic value = “1”. For Check Payment Enclosure Code = Name Only (0), Is Non Domestic value = “0”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@IsNonDomestic
3 35 4-38 A/N Payee Address Line 1 Optional if Check Payment Enclosure Code = “0”. Blank fill if not used. Required if Check Payment Enclosure Code = “1”, “2” or “5”, and cannot be all blanks.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PayeeAddress/PayeeAddressLine
4 35 39-73 A/N Payee Address Line 2 Optional if Check Payment Enclosure Code = “1”, “2” or “5”. Blank fill if not used. Shall be blank if Check Payment Enclosure Code = “0”
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PayeeAddress/PayeeAddressLine
5 30 74-103 A/N Payee Address Line 3 Optional if Check Payment Enclosure Code = “1”, “2” or “5”. Blank fill if not used. Shall be blank if Check Payment Enclosure Code = “0”.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PayeeAddress/PayeeAddressLine
6 30 104-133 A/N Payee Address Line 4 Optional if Check Payment Enclosure Code = “1”, “2” or “5”. Blank fill if not used. Shall be blank if Check Payment Enclosure Code = “0”. If Is Non Domestic = “1”, Payee Address Line 4 shall be blank.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/PayeeAddress/PayeeAddressLine
7 27 134-160 A/N City Name Optional. /Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@CityName
8 2 161-162 A State Code Text Optional if Is Non Domestic = “0”, otherwise not allowed. See Section VII State Codes. Blank fill if
/Transmission/Schedule/TypeA_Details/Check_Payme
37 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
not used. nts/Check_Payment/CheckPayeeAddress/@StateCodeText
9 50 163-212 A/N State Name Optional if Is Non Domestic = “1”, otherwise not allowed. Blank fill if not used. Only first 10 positions allowed for State Name.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@StateName
10 5 213-217 A/N Postal Code Optional. If entered for Is Non Domestic = “0”, must be 5 digits. (zip code) If entered for Is Non Domestic = “1”, can be up to 5 characters. (universal postal code)
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@PostalCode
11 5 218-222 A/N Postal Code Extension Optional. If entered for Is Non Domestic = “0”,
must be 4 numeric and left justified. If entered for Is Non Domestic = “1” can be up to 5 characters. (remainder of universal postal code) Must have Postal Code if there is a Postal Code Extension.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@PostalCodeExtension
12 40 223-262 A/N Country Name For Is Non Domestic = “1”, Country Name is required. For Is Non Domestic = “0”, Country Name is not allowed.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/CheckPayeeAddress/@CountryName
13 3 263-265 A/N Consular Code Optional. Contact your servicing RFC for a list of consular/geo codes.
/Transmission/Schedule/TypeA_Details/CheckPayments/CheckPayment/@ConsularCode
14 175 266-440 Filler No validation.
38 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
III ACH Payment Schedule File Format ACH Record Order Notation: 01, (04, 07{1, 12}, [08], [10]) {1, 60} Description: 01 record followed by one to sixty "Payment record(s)". Each Payment record(s) has a 04 record followed by one to twelve 07 records, followed by an optional 08 record, and followed by an optional 10 record. ACH Prenote Record Order Notation: 01, (04, [08], [10]) {1, 60} (ACH Prenote is the same as ACH except no 07 Records.)
A. Record “01” - ACH Header Record (Required) Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission (1)
1 2 1-2 N Record Type Value = “01”. 2 6 3-8 A/N File Format Version Required. Value = “GWA001”.
(Formerly Transmission Number X(6) 3-8)
3 14 9-22 A/N Schedule Number Required. Valid characters are “0-9”, “A-Z”, or dash (-). Cannot be all zeroes. Shall not be reused by ALC for one fiscal year. Right justify and zero pad.
/Transmission/Schedule/@ScheduleNumber
4 23 23-45 Filler No validation. (Formerly Date/Time X(12) positions 23-34) (Formerly FPAID X(4) positions 35-38) (Formerly FPA PC# X(2) positions 39-40) (Formerly Filler X(2) positions 41-42) (Formerly RFC Identifier X(8) positions 43-45)
5 8 46-53 N Agency Location Code (ALC)
Required. Must be valid 8-digit Treasury Disbursed ALC.
/Transmission/Schedule/OriginatingAgency/@AgencyLocationCode
6 363 54-416 Filler No validation. (Formerly DOS File Name x(12) 54-65) (Formerly Filler X(351) 66-416)
7 1 417-417 A/N Schedule Type (formerly Payment Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart.
/Transmission/Schedule/TypeA_Details/ACH_Payments
39 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Prenote is determined by schedule amount, with $0 schedule being interpreted as a prenote.
8 1 418-418 A/N Payment Type Code (formerly Payment Sub-Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
/Transmission/Schedule/TypeA_Details/ACH_Payments/@PaymentTypeCode
9 3 419-421 A Standard Entry Class Code (SEC) (formerly Filler)
Required. Values = “PPD”, “CCD” or “IAT”. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
/Transmission/Schedule/TypeA_Details/ACH_Payments/@StandardEntryClassCode
10 1 422-422 N Garnishment Indicator (formerly Filler)
Values = “1” eligible for garnishment and “0” not eligible for garnishment.
/Transmission/Schedule/TypeA_Details/ACH_Payments/@GarnishmentIndicator
11 18 423-440 Filler No validation. (1) See Section IE, XML Schema.
40 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
B. Record “04” - ACH Payment Record (Required)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “04”.
2 20 3-22
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)
3 1 23-23 A/N Bank Account Type (formerly Account Type)
Required. Value = “C” (Checking Account), “S” (Savings Account), “G” (General Ledger), or “L” (Loan Account).
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeBankInfo/@BankAccountType
4 9 24-32 A/N Payee Identifier (formerly Payee ID/TIN)
Required. Payee’s Taxpayer Identification Number, Vendor ID, SSN, or other valid Payee ID. This field is required for Treasury Debt Offset. If Payment Type Code in “01” record equals “S” or “T”, all 9 positions shall be numeric (“0-9”). Otherwise, first position shall be equal to “0-9”, “A-Z”, or dash (-) and for positions 2-9, valid characters are “0-9”, “A-Z”, dash (-), or blanks.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/@PayeeIdentifier
5 14 33-46 Filler No validation. (Formerly Filler X(3) positions 33-35) (Formerly Zero Constant 9(11) positions 36-46)
6 10 47-56 N Payment Amount Required. Valid characters are “0-9”. Right justify and zero pad. The last two digits are cents. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/Payment/@Amount
7 1 57-57 Filler No validation. (Formerly Record Code “B” X(1) positions 57-57)
41 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
8 22 58-79 A/N Party Name (formerly Payee Name)
Required. First position shall not be a space. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/@PartyName
9 1 80-80 A/N Is Salary Allotment (formerly Allotment Code)
Required if Payment Type Code in “01” record = “S”. Values are “Y” (Salary Allotment Payment) or “N” (Regular Salary Payment). Shall be blank if Payment Type Code is not equal to “S”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/@IsSalaryAllotment
10 6 81-86 Filler No validation.
11 9 87-95 N Routing Number (formerly Routing Transit Number)
Required. Valid characters are “0-9”. Shall be a valid Routing Number for ACH transactions.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeBankInfo/@RoutingNumber
12 17 96-112 A/N Account Number (formerly Depositor Account Number)
Required. Payee’s account number at Financial Institution. Valid characters are “A-Z”, “0-9”, or dash (-). Trailing blanks are valid. Leading or embedded blanks are not valid. Left justify.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeBankInfo/@AccountNumber
13 80 113-192 A/N Payment Related Information (1) (formerly filler)
Optional. Used for providing addendum information for payment. If SEC = “PPD” or “CCD” this is for the one and only optional addendum record. If used, then the field shall meet format requirements of the Federal Reserve Bank NACHA rules. If SEC = “IAT” this is optional Payment Related Information for addendum 1. There are no validations on this field for IAT. (Note: The optional second Payment Related Information for addendum 2 is in positions 284-363) Blank fill if not used.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/PaymentAddendum/PaymentRelatedInformation
14 91 193-283 Filler No validation.
42 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
(Formerly Filler X(91) positions 193-216) (Formerly Payment Type X(1) positions 217-217) (Formerly Account Symbol X(16) positions 218-233) (Formerly Filler X(50) positions 234-282)
15 80 284-363 A/N Payment Related Information (2) (formerly Payment ID Line)
Optional. Can only be used if SEC = “IAT”. Blank fill if not used. There are no validations on this field.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/PaymentAddendum/PaymentRelatedInformation
16 51 364-414 Filler No validation. (Formerly Filler X(47) positions 364-410) (Formerly Addendum Code X(3) positions 411-413) (Formerly 1099 Reporting Eligibility X(1) 414-414)
17 1 415-415 A/N Is TOP Offset (formerly TOP Offset Eligibility)
Required. Values are “Y” (payment is eligible for Treasury Offset) or “N” (not eligible for Treasury offset).
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/@IsTOP_Offset
18 25 416-440 Filler No validation. (Formerly ASAID length 8 positions 416-423) (Formerly ACOID length 8 positions 424-431) (Formerly MAC length 9 positions 432-440)
C. Record “07” - ACH Payment Level TAS/BETCs for Non-Prenotes Record (Required)
The first TAS/BETC-TYPE is required. Every entered TAS/BETC-TYPE must be valid per SAM. There cannot be non-blank TAS/BETC-TYPEs after a blank TAS/BETC-TYPE. Unused TAS/BETC-TYPE entries must be blank filled. Cannot be more than 12 consecutive “07” records for ACH.
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “07”.
2 2 3-4 N TAS (a) Sub-level Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payment
43 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Prefix Code (SP) s/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
3 3 5-7 N TAS (a) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
4 3 8-10 N TAS (a) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
5 4 11-14 N TAS (a) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
6 4 15-18 N TAS (a) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
7 1 19-19 A TAS (a) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
8 4 20-23 N TAS (a) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payment
44 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
s/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
9 3 24-26 N TAS (a) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
10 8 27-34 A/N BETC (a) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
11 1 35-35 N Is Credit (DEBIT/CREDIT TYPE) (a)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
12 15 36-50 N TAS/BETC-Amount (a) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
13 2 51-52 N TAS (b) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
14 3 53-55 N TAS (b) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTran
45 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
sferAgencyIdentifier
15 3 56-58 N TAS (b) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
16 4 59-62 N TAS (b) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
17 4 63-66 N TAS (b) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
18 1 67-67 A TAS (b) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
19 4 68-71 N TAS (b) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
20 3 72-74 N TAS (b) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-
46 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
accountCode
21 8 75-82 A/N BETC (b) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
22 1 83-83 N Is Credit (DEBIT/CREDIT TYPE) (b)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
23 15 84-98 N TAS/BETC-Amount (b) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
24 2 99-100 N TAS (c) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
25 3 101-103 N TAS (c) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
26 3 104-106 N TAS (c) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
27 4 107-110 N TAS (c) Beginning Must be a valid value for this field per GWA. /Transmission/Schedule/Ty
47 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Period of Availability (BPOA)
peA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
28 4 111-114 N TAS (c) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
29 1 115-115 A TAS (c) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
30 4 116-119 N TAS (c) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
31 3 120-122 N TAS (c) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
32 8 123-130 A/N BETC (c) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
33 1 131-131 N Is Credit Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/Ty
48 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
(DEBIT/CREDIT TYPE) (c)
peA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
34 15 132-146 N TAS/BETC-Amount (c) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
35 2 147-148 N TAS (d) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
36 3 149-151 N TAS (d) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
37 3 152-154 N TAS (d) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
38 4 155-158 N TAS (d) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
39 4 159-162 N TAS (d) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccou
49 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ntSymbol/@EndingPeriodOfAvailability
40 1 163-163 A TAS (d) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
41 4 164-167 N TAS (d) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
42 3 168-170 N TAS (d) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
43 8 171-178 A/N BETC (d) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
44 1 179-179 N Is Credit (DEBIT/CREDIT TYPE) (d)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
45 15 180-194 N TAS/BETC-Amount (d) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/
50 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
@Amount
46 2 195-196 N TAS (e) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
47 3 197-199 N TAS (e) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
48 3 200-202 N TAS (e) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
49 4 203-206 N TAS (e) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
50 4 207-210 N TAS (e) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
51 1 211-211 A TAS (e) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTyp
51 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
eCode
52 4 212-215 N TAS (e) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
53 3 216-218 N TAS (e) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
54 8 219-226 A/N BETC (e) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
55 1 227-227 N Is Credit (DEBIT/CREDIT TYPE) (e)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
56 15 228-242 N TAS/BETC-Amount (e) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
57 2 243-244 N TAS (f) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
58 3 245-247 N TAS (f) Allocation Must be a valid value for this field per GWA. /Transmission/Schedule/Ty
52 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Transfer Agency Identifier (ATA)
peA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
59 3 248-250 N TAS (f) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
60 4 251-254 N TAS (f) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
61 4 255-258 N TAS (f) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
62 1 259-259 A TAS (f) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
63 4 260-263 N TAS (f) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
64 3 264-266 N TAS (f) Sub-Account Must be a valid value for this field per GWA. /Transmission/Schedule/Ty
53 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Code (SUB) peA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
65 8 267-274 A/N BETC (f) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
66 1 275-275 N Is Credit (DEBIT/CREDIT TYPE) (f)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
67 15 276-290 N TAS/BETC-Amount (f) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
68 2 291-292 N TAS (g) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
69 3 293-295 N TAS (g) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
70 3 296-298 N TAS (g) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccou
54 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ntSymbol/@AgencyIdentifier
71 4 299-302 N TAS (g) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
72 4 303-306 N TAS (g) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
73 1 307-307 A TAS (g) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
74 4 308-311 N TAS (g) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
75 3 312-314 N TAS (g) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
76 8 315-322 A/N BETC (g) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEvent
55 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Type/@BusinessEventTypeCode
77 1 323-323 N Is Credit (DEBIT/CREDIT TYPE) (g)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
78 15 324-338 N TAS/BETC-Amount (g) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
79 2 339-340 N TAS (h) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
80 3 341-343 N TAS (h) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
81 3 344-346 N TAS (h) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
82 4 347-350 N TAS (h) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
56 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
83 4 351-354 N TAS (h) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
84 1 355-355 A TAS (h) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
85 4 356-359 N TAS (h) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
86 3 360-362 N TAS (h) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
87 8 363-370 A/N BETC (h) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
88 1 371-371 N Is Credit (DEBIT/CREDIT TYPE) (h)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
89 15 372-386 N TAS/BETC-Amount (h) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount
/Transmission/Schedule/TypeA_Details/ACH_Payment
57 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Restrictions Chart) s/ACH_Payment/AccountClassification/Classification/@Amount
90 2 387-388 N TAS (i) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
91 3 389-391 N TAS (i) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
92 3 392-394 N TAS (i) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
93 4 395-398 N TAS (i) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
94 4 399-402 N TAS (i) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
95 1 403-403 A TAS (i) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountCl
58 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
assification/TreasuryAccountSymbol/@AvailabilityTypeCode
96 4 404-407 N TAS (i) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
97 3 408-410 N TAS (i) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
98 8 411-418 A/N BETC (i) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
99 1 419-419 N Is Credit (DEBIT/CREDIT TYPE) (i)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/@IsCredit
100 15 420-434 N TAS/BETC-Amount (i) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/AccountClassification/Classification/@Amount
101 6 435-440 Filler No validation.
59 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
D. Record “08” - ACH Payment Level Payment Information Repository Record (Optional for Vendor Only, Otherwise Disallowed)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “08”
2 50 3-52 A/N Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ProcurementDetail/@ProcurementInstrumentIdentifier
3 4 53-56 A/N Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ProcurementDetail/@ProcurementAgencyIdentifier
4 4 57-60 A/N Contracting Office Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ProcurementDetail/@ContractingOfficeProcurementAgencyIdentifier
5 50 61-110 A/N Indefinite Delivery Vehicle Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@ProcurementInstrumentIdentifier
6 4 111-114 A/N Indefinite Delivery Vehicle Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@Procure
60 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
E. Record “10” - ACH Payment Payee Address Record (Required for Non-Domestic, Otherwise Optional)
mentAgencyIdentifier
7 326 115-440 Filler No validation.
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “10”.
3 1 3-3 N Is Non Domestic (International/Foreign Address Indicator)
Values = “1” or “0”. If SEC = “IAT”, this field must equal “1”. If SEC = “PPD” or “CCD”, this field must equal “0”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@IsNonDomestic
4 35 4-38 A/N Payee Address Line 1 Required if Is Non Domestic = “1” and cannot be blank, otherwise optional.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/PayeeAddressLine
5 35 39-73 A/N Payee Address Line 2 Optional. Must be blank if Is Non Domestic = “1”.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/PayeeAddressLine
6 27 74-100 A/N City Name Required if Is Non Domestic = “1” and cannot be blank, otherwise optional.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@CityName
7 2 101-102 A/N State Code Text Optional. Must be blank if Is Non Domestic = “1”. See Section VII State Codes.
/Transmission/Schedule/TypeA_Details/ACH_Payment
61 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
s/ACH_Payment/ACH_PayeeAddress/@StateCodeText
8 50 103-152 A/N State Name Optional if Is Non Domestic = “1”, otherwise must blank fill. Last 40 characters must be blanks.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@StateName
9 5 153-157 A/N Postal Code Optional. If entered for Is Non Domestic = “0”, must be 5 digits. (zip code) If entered for Is Non Domestic = “1”, can be up to 5 characters. (universal postal code)
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@PostalCode
10 5 158-162 A/N Postal Code Extension Optional. If entered for Is Non Domestic = “0”, must be 4 numeric and left justified. If entered for Is Non Domestic = “1” can be up to 5 characters. (remainder of universal postal code) Must have Postal Code if there is a Postal Code Extension.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@PostalCodeExtension
11 2 163-164 A/N Country Code Text Required if Is Non Domestic = “1”, must have two alpha characters. (See the ISO3166-1 Alpha 2 Country Codes. Example: http://www.iso.org/iso/english_country_names_and_code_elements). If Is Non Domestic = “0”, must be blank filled.
/Transmission/Schedule/TypeA_Details/ACH_Payments/ACH_Payment/ACH_PayeeAddress/@CountryCodeText
12 276 165-440 Filler Filler
62 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
IV Same Day Payment (SDP) Schedule File Format
Record Order Notation: 01, 04, (05, 07{1, 12}, [08]) {1, 60} Description: 01 record followed by 04, followed by one to sixty "Payment record(s)". Each Payment record(s) has a 05 record followed by one to twelve 07 records, followed by an optional 08 record. See DEO User Manual for foreign payment requirements (SWIFT codes).
63 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
A. Record “01”- SDP Header Record (Required)
(1) See Section IE, XML Schema.
B. Record “04” - SDP Schedule Header Record (Required)
Field Length Positions Type Field Validations/Notes XML Schema
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission (1)
1 2 1-2 N Record Type Required. Value = “01”. 2 6 3-8 A/N File Format Version Required. Value = “GWA001”.
(Formerly Transmission Number X(6) 3-8)
3 14 9-22 A/N Schedule Number Required. Valid characters are “0-9”, “A-Z”, or dash (-). Cannot be all zeroes. Shall not be reused by ALC for one fiscal year. Right justify and zero pad.
/Transmission/Schedule/@ScheduleNumber
4 23 23-45 Filler No validation. (Formerly Date/Time X(12) positions 23-34) (Formerly FPAID X(4) positions 35-38) (Formerly FPA PC# X(2) positions 39-40) (Formerly Filler X(2) positions 41-42) (Formerly RFC Identifier X(3) positions 43-45)
5 8 46-53 N Agency Location Code (ALC)
Required. Must be valid 8-digit Treasury Disbursed ALC.
/Transmission/Schedule/OriginatingAgency/@AgencyLocationCode
6 363 54-416 Filler No validation. (Formerly DOS File Name x(12) 54-65) (Formerly Filler X(351) 66-416)
7 1 417-417 A/N Schedule Type (formerly Payment Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
8 23 418-440 Filler No validation. (Formerly Payment Sub-Type X(1) positions 418-418) (Formerly Filler X(22) positions 419-440)
64 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
No A/N Transmission
1 2 1-2 N Record Type Value = “04”.
2 20 3-22
Filler No validation. (Formerly Sequence Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)
3 8 23-30 N Requested Payment Date (formerly Same Day Payment Date)
Required. Valid format is MMDDYYYY. Shall be a valid date.
/Transmission/Schedule/TypeA_Details/SameDayPayments/@RequestedPaymentDate
4 58 31-88 Filler No validation. (Formerly ALC 9(8) positions 31-38) (Formerly CO Phone NO. X(10) positions 64-73) (Formerly Grand Total 9(13) positions 74-86) (Formerly Number of Payments 9(2) positions 87-88)
5 40 89-128 A/N Appropriation Payment Remark 1 (formerly Appropriation Remarks Line 1)
Optional. Blank fill if not used. /Transmission/Schedule/TypeA_Details/SameDayPayments/AppropriationPaymentRemarks/AppropriationPaymentRemark
6 40 129-168 A/N Appropriation Payment Remark 2 (formerly Appropriation Remarks Line 2)
Optional. Blank fill if not used. /Transmission/Schedule/TypeA_Details/SameDayPayments/AppropriationPaymentRemarks/AppropriationPaymentRemark
7 40 169-208 A/N Appropriation Payment Remark 3 (formerly Appropriation Remarks Line 3)
Optional. Blank fill if not used. /Transmission/Schedule/TypeA_Details/SameDayPayments/AppropriationPaymentRemarks/AppropriationPaymentRemark
8 40 209-248 A/N Appropriation Payment Remark 4 (formerly Appropriation Remarks Line 4)
Optional. Blank fill if not used. /Transmission/Schedule/TypeA_Details/SameDayPayments/AppropriationPaymentRemarks/AppropriationPaymentRemark
65 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
10 192 249-440 Filler No validation (Formerly Filler X(166) positions 250-415) (Formerly Record Code “B” X(1) positions 249-249) (Formerly ASAID X(8) positions 416-423) (Formerly ACOID X(8) positions 424-431) (Formerly MAC X(9) positions 432-440)
C. Record “05” – SDP Payment Record (Required)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “05”
2 20 3-22
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)
3 9 23-31 N Routing Number (formerly Receiving ABA Number)
Required. Shall be valid Fedwire Routing Number (ABA /RTN) of receiving financial institution. Valid characters are “0-9”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/SameDayPaymentPayeeBankInfo/@RoutingNumber
4 35 32-66 Filler No validation. (Formerly Receiving ABA Name X(18) positions 32-49) (Formerly Receiving ABA City X(15) positions 50-64) (Formerly Receiving ABA State X(2) positions 65-66)
5 2 67-68 N Fedwire Type Code (formerly Type Code)
Required. Funds Transfer type. Valid values are: “10” – Standard Funds Transfer “15” – Foreign Funds Transfer
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/@FedwireTypeCode
6 4 69-72 A/N Fedwire Product Code (Formerly Product
Required. Identifies payment recipient as customer or bank.
/Transmission/Schedule/TypeA_Details/SameDayPay
66 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Code) Valid values are: “CTR/” – Recipient is a customer “BTR/” – Recipient is a bank
ments/SameDayPayment/@FedwireProductCode
7 35 73-107 A/N Bank Name (formerly Beneficiary Bank (BBK))
Name of Beneficiary Bank. Required if Product Code equals “BTR/”. Optional if Product Code equals “CTR/”. Valid characters are “A-Z”, “0-9”, “&”, “=”, “,”,”.”, ”?”, ”-“, ”$”, ”(“, “)” or space. First position shall not be a space. Blank fill if not used.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/SameDayPaymentPayeeBankInfo/@BankName
7a 16 108-123 Filler No validation (Formerly continuation of Bank Name 108-123)
8 9 124-132 Filler No validation (Formerly BBK ABA Number 9(9) positions 124-132)
9 47 133-179 A/N Party Name (formerly BNF)
Name of Customer or Bank recipient. Required. Blank fill if not used. Valid characters are “A-Z”, “0-9”, “&”, “=”, “,”, “.”, “?”, “-“,”$”, or space. First position shall not be a space.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/@PartyName
10 17 180-196 A/N Account Number (formerly Depositor Account Number)
Required. Valid characters are “A-Z”, “0-9”, or dash “-“. Trailing blanks are valid. Leading or embedded blanks are not valid.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/SameDayPaymentPayee/SameDayPaymentPayeeBankInfo/@AccountNumber
11 68 197-264 A/N Beneficiary Bank Remarks (BBK Remarks)
Remarks field used to convey payment information to receiving customer or bank. Optional. Blank fill if not used. If used and Product Code equals “BTR/”, then first four characters shall be “BBI=”. If used and Product Code equals “CTR/”, then
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/BeneficiaryBankRemarks
67 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
first four characters shall be “OBI=”. Valid characters for positions 5-68 are: “A-Z”, “0-9”, “&”, “=”, “,”,”.”, “?”, “-“, “$”, “(“, “)”, or space.
11a 4 265-268 Filler No validation (Formerlycontinuation of Beneficiary Bank Remarks 265-268)
12 16 269-284 A/N Payment Reference (formerly RFB)
Reference for payment information. Optional. Blank fill if not used. Valid characters are “A-Z”, “0-9”, “-“, or space.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/@PaymentReference
13 50 285-334 A/N Payment Remark 1 Additional field used to convey payment information to receiving customer or bank. Optional. Blank fill if not used. Valid characters are: “A-Z”, “0-9”, “&”, “=”, “,”,”.”, “?”, “-“, “$”, “(“, “)”, or space.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/PaymentRemarks/PaymentRemark
14 50 335-384 A/N Payment Remark 2 Additional field used to convey payment information to receiving customer or bank. Optional. Blank fill if not used. Valid characters are: “A-Z”, “0-9”, “&”, “=”, “,”,”.”, “?”, “-“, “$”, “(“, “)”, or space. Payment Remarks 2 shall be blank if no data exists in Payment Remarks 1.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/PaymentRemarks/PaymentRemark
15 12 385-396 N Payment Amount Required. Valid characters are “0-9”. Right justify, zero pad. The last two digits are cents. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/Payment@Amount
16 8 397-404 Filler No validation.
17 9 405-413 A/N Payee Identifier (formerly Payee ID/TIN)
Required. Payee’s Taxpayer Identification Number, Vendor ID, SSN, or other valid Payee ID. This field is required for Treasury Debt Offset.First position shall be equal to “0-9”, “A-Z”, or dash “-" and for positions 2 thru 9, valid characters are “0-9”, “A-Z”, dash (-), or blanks.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/@PayeeIdentifier
68 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
18 1 414-414 Filler No validation.
19 1 415-415 A/N Is TOP Offset (formerly TOP Offset Eligibility)
Required. Values are “Y” (payment is eligible for Treasury Offset) or “N” (not eligible for offset).
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/@IsTOP_Offset
20 25 416-440 Filler No validation. (Formerly ASAID X(8) positions 416-423) (Formerly ACOID X(8) positions 424-431) (Formerly MAC X(9) positions 432-440)
D. Record “07” - SDP Payment Level TAS/BETCs Record (Required)
The first TAS/BETC-TYPE is required. Every entered TAS/BETC-TYPE must be valid per SAM. There cannot be non-blank TAS/BETC-TYPEs after a blank TAS/BETC-TYPE. Unused TAS/BETC-TYPE entries must be blank filled. Cannot be more than 12 consecutive “07” records for Same Day Payment.
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “07”.
2 2 3-4 N TAS (a) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
3 3 5-7 N TAS (a) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
4 3 8-10 N TAS (a) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Treasu
69 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ryAccountSymbol/@AgencyIdentifier
5 4 11-14 N TAS (a) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
6 4 15-18 N TAS (a) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
7 1 19-19 A TAS (a) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
8 4 20-23 N TAS (a) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
9 3 24-26 N TAS (a) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
10 8 27-34 A/N BETC (a) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Busine
70 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ssEventType/@BusinessEventTypeCode
11 1 35-35 N Is Credit (DEBIT/CREDIT TYPE) (a)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
12 15 36-50 N TAS/BETC-Amount (a) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
13 2 51-52 N TAS (b) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
14 3 53-55 N TAS (b) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
15 3 56-58 N TAS (b) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
16 4 59-62 N TAS (b) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
71 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
17 4 63-66 N TAS (b) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
18 1 67-67 A TAS (b) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
19 4 68-71 N TAS (b) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
20 3 72-74 N TAS (b) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
21 8 75-82 A/N BETC (b) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
22 1 83-83 N Is Credit (DEBIT/CREDIT TYPE) (b)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
72 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
23 15 84-98 N TAS/BETC-Amount (b) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
24 2 99-100 N TAS (c) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
25 3 101-103 N TAS (c) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
26 3 104-106 N TAS (c) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
27 4 107-110 N TAS (c) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
28 4 111-114 N TAS (c) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
73 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
29 1 115-115 A TAS (c) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
30 4 116-119 N TAS (c) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
31 3 120-122 N TAS (c) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
32 8 123-130 A/N BETC (c) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
33 1 131-131 N Is Credit (DEBIT/CREDIT TYPE) (c)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
34 15 132-146 N TAS/BETC-Amount (c) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
35 2 147-148 N TAS (d) Sub-level Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPay
74 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Prefix Code (SP) ments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
36 3 149-151 N TAS (d) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
37 3 152-154 N TAS (d) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
38 4 155-158 N TAS (d) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
39 4 159-162 N TAS (d) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
40 1 163-163 A TAS (d) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
41 4 164-167 N TAS (d) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPay
75 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
42 3 168-170 N TAS (d) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
43 8 171-178 A/N BETC (d) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
44 1 179-179 N Is Credit (DEBIT/CREDIT TYPE) (d)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
45 15 180-194 N TAS/BETC-Amount (d) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
46 2 195-196 N TAS (e) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
47 3 197-199 N TAS (e) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Treasu
76 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ryAccountSymbol/@AllocationTransferAgencyIdentifier
48 3 200-202 N TAS (e) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
49 4 203-206 N TAS (e) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
50 4 207-210 N TAS (e) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
51 1 211-211 A TAS (e) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
52 4 212-215 N TAS (e) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
53 3 216-218 N TAS (e) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Treasu
77 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ryAccountSymbol/@Sub-accountCode
54 8 219-226 A/N BETC (e) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
55 1 227-227 N Is Credit (DEBIT/CREDIT TYPE) (e)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
56 15 228-242 N TAS/BETC-Amount (e) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
57 2 243-244 N TAS (f) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
58 3 245-247 N TAS (f) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
59 3 248-250 N TAS (f) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
78 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
60 4 251-254 N TAS (f) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
61 4 255-258 N TAS (f) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
62 1 259-259 A TAS (f) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
63 4 260-263 N TAS (f) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
64 3 264-266 N TAS (f) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
65 8 267-274 A/N BETC (f) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
79 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
66 1 275-275 N Is Credit (DEBIT/CREDIT TYPE) (f)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
67 15 276-290 N TAS/BETC-Amount (f) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
68 2 291-292 N TAS (g) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
69 3 293-295 N TAS (g) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
70 3 296-298 N TAS (g) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
71 4 299-302 N TAS (g) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
72 4 303-306 N TAS (g) Ending Period Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPay
80 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
of Availability (EPOA) ments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
73 1 307-307 A TAS (g) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
74 4 308-311 N TAS (g) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
75 3 312-314 N TAS (g) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
76 8 315-322 A/N BETC (g) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
77 1 323-323 N Is Credit (DEBIT/CREDIT TYPE) (g)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
78 15 324-338 N TAS/BETC-Amount (g) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/A
81 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ccountClassification/Classification/@Amount
79 2 339-340 N TAS (h) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
80 3 341-343 N TAS (h) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
81 3 344-346 N TAS (h) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
82 4 347-350 N TAS (h) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
83 4 351-354 N TAS (h) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
84 1 355-355 A TAS (h) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Treasu
82 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ryAccountSymbol/@AvailabilityTypeCode
85 4 356-359 N TAS (h) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
86 3 360-362 N TAS (h) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
87 8 363-370 A/N BETC (h) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
88 1 371-371 N Is Credit (DEBIT/CREDIT TYPE) (h)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
89 15 372-386 N TAS/BETC-Amount (h) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
90 2 387-388 N TAS (i) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
83 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
91 3 389-391 N TAS (i) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
92 3 392-394 N TAS (i) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
93 4 395-398 N TAS (i) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
94 4 399-402 N TAS (i) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
95 1 403-403 A TAS (i) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
96 4 404-407 N TAS (i) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
84 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
97 3 408-410 N TAS (i) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
98 8 411-418 A/N BETC (i) Must be a valid value for this field per GWA. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/BusinessEventType/@BusinessEventTypeCode
99 1 419-419 N Is Credit (DEBIT/CREDIT TYPE) (i)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayement/AccountClassification/@IsCredit
100 15 420-434 N TAS/BETC-Amount (i) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/AccountClassification/Classification/@Amount
101 6 435-440 Filler No validation.
E. Record “08” – SDP Payment Level Payment Information Repository Record (Optional)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “08”.
2 50 3-52 A/N Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/ProcurementDetail/@Procur
85 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ementInstrumentIdentifier
3 4 53-56 A/N Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/ProcurementDetail/@ProcurementAgencyIdentifier
4 4 57-60 A/N Contracting Office Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/ProcurementDetail/@ContractingOfficeProcurementAgencyIdentifier
5 50 61-110 A/N Indefinite Delivery Vehicle Procurement Instrument Identifier
Optional. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@ProcurementInstrumentIdentifier
6 4 111-114 A/N Indefinite Delivery Vehicle Procurement Agency Identifier
Optional. /Transmission/Schedule/TypeA_Details/SameDayPayments/SameDayPayment/ProcurementDetail/IndefiniteDeliveryVehicleDetail/@ProcurementAgencyIdentifier
7 326 115-440 Filler No validation.
86 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
V Summary Totals Schedule File Format Summary Record Order Notation: 01, 04, [05, [06]], 07{1,112} Description: 01 record followed by 04, followed by optional "Remark record(s)", followed by one to one hundred and twelve 07 records. Remark record(s) can be just a single 05 record, or, 05 record followed by 06 record. Summary Prenote Record Order Notation: 01, 04, [05, [06]] (Summary Prenote is the same as Summary except no 07 Records.)
A. Record “01” - Summary Totals Header Record (Required)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission (1)
1 2 1-2 N Record Type Value = “01”. 2 6 3-8 A/N File Format Version Required. Value = “GWA001”. (Formerly
Transmission Number X(6) 3-8)
3 14 9-22 A/N Schedule Number Required. Valid characters are “0-9”, “A-Z”, or dash (-). Cannot be all zeroes. Shall not be reused by ALC for one fiscal year. Right justify and zero pad.
/Transmission/Schedule/@ScheduleNumber
4 20 23-42 Filler No validation. (Formerly Date/Time X(12) positions 23-34) (Formerly FPAID X(4) positions 35-38) (Formerly FPA PC# X(2) positions 39-40) (Formerly Filler X(2) positions 41-42)
5 3 43-45 A/N Regional Financial Center Code (RFC) (Formerly RFC Identifier)
Required. Values = “KFC”, “PFC”, or “SFC”
/Transmission/Schedule/@RegionalFinancialCenterCode
6 8 46-53 N Agency Location Code (ALC)
Required. Must be valid 8-digit Treasury Disbursed ALC.
/Transmission/Schedule/OriginatingAgency/@AgencyLocationCode
7 363 54-416 Filler No validation. (Formerly DOS File Name x(12) 54-65)
87 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
(Formerly Filler X(351) 66-416) 8 1 417-417 A/N Schedule Type
(formerly Payment Type)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart
9 23 418-440 Filler No validation. (Formerly Payment Sub-Type X(1) positions 418-418) (Formerly Filler X(22) positions 419-440)
(1) See Section IE, XML Schema.
88 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
B. Record “04” - Summary Totals Record (Required)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “04”.
2 24 3-26
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22) (Formerly Filler X(4) positions 23-26)
3 8 27-34 N Requested Payment Date
Required. Valid format is MMDDYYYY. Shall be valid date. Requested Payment Date shall be between the current date and up to 25 days in the future.
/Transmission/Schedule/TypeB_Details/@RequestedPaymentDate
4 1 35-35 A/N Payment Type B Code (formerly Summary Payment Codes)
Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart.
/Transmission/Schedule/TypeB_Details/@PaymentTypeB_Code
5 1 36-36 A/N Payment Method Required. See Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart Required Value = “C” for check or “E” for EFT/ACH For Payment Type B Code of “F” for Foreign Mail, the Payment Method must equal “C” for check. For Payment Type B Code of “H” for International Direct Deposit must be “E” for EFT/ACH.
5 10 37-46 Filler No validation.
6 7 47-53 A/N Control Number Required. Position 1 shall be characters “A-Z”. Position 2 – 7 shall be numeric “0-9”. Note: The Control Number field is assigned by
/Transmission/Schedule/TypeB_Details/@ControlNumber
89 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
the processing RFC and is sent to the agency upon successful pre-validation editing of the corresponding bulk payment file.
7 79 54-132 Filler No validation. (Formerly Reel Number 2 X(7) positions 54-60) (Formerly Reel Number 3 X(7) positions 61-67) (Formerly Reel Number 4 X(7) positions 68-74) (Formerly Reel Number 5 X(7) positions 75-81) (Formerly Filler X(35) positions 82-116) (Formerly MAC for Payment Data X(8) positions 117-124) (Formerly ALC X(8) positions 125-132)
8 8 133-140 N Total Count (formerly Total Number of Payments)
Required. Total number of payments on corresponding Bulk Payment Standard Request File. Right justified, zero padded and shall be greater than zero. Valid characters are “0-9”.
/Transmission/Schedule/@TotalCount
/Transmission/Schedule/TypeB_Details/TypeB_ACH_
Schedule/@TotalCount
9 15 141-155 N Total Schedule Amount
Required. Total dollar amount of payments on corresponding Bulk Payment Standard Request File. Valid characters are “0-9”. Right justify and zero pad. The last two digits are cents. If Schedule Type in “01” record = “Y”, then amount shall equal zero. Shall equal Total TAS/BETC Amount (Debits-Credits) for non-Prenotes.
/Transmission/Schedule/@TotalAmount /Transmission/Schedule/TypeB_Details/TypeB_ACH_Schedule/@TotalAmount /Transmission/Schedule/TypeB_Details/TypeB_CheckSchedule/@TotalAmount
10 285 156-440 Filler No validation. (Formerly Filler X(5) positions 156-160) (Formerly Account Symbol 1 X(16) positions 161-176) (Formerly Total Amt Sym 1 9(13) positions 177-189) (Formerly Account Symbol 2 X(16) positions
90 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
190-205) (Formerly Total Amt Sym 2 9(13) positions 206-218) (Formerly Account Symbol 3 X(16) positions 190-205) (Formerly Total Amt Sym 3 9(13) positions 206-218) (Formerly Account Symbol 4 X(16) positions 190-205) (Formerly Total Amt Sym 4 9(13) positions 206-218) (Formerly Account Symbol 5 X(16) positions 190-205) (Formerly Total Amt Sym 5 9(13) positions 206-218) (Formerly Account Symbol 6 X(16) positions 190-205) (Formerly Total Amt Sym 6 9(13) positions 206-218) (Formerly Account Symbol 7 X(16) positions 190-205) (Formerly Total Amt Sym 7 9(13) positions 206-218) (Formerly Account Symbol 8 X(16) positions 190-205) (Formerly Total Amt Sym 8 9(13) positions 206-218) (Formerly Filler X(23) positions 393-415) (Formerly ASAID X(8) positions 416-423) (Formerly ACOID X(8) positions 424-431) (Formerly MAC X(9) positions 423-440)
C. Record “05” – Summary Totals Comments Record (Remarks) (Optional)
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “05”.
91 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
D. Record “06” – Summary Totals Comments (Continued) Record (Remarks - Continued) (Optional)
2 101 3-103
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)(Formerly Account Symbol 9 X(16) positions 23-38) (Formerly Total Amt Sym 9 9(13) positions 39-51) (Formerly Account Symbol 10 X(16) positions 52-67) (Formerly Total Amt Sym 10 9(13) positions 68-80) (Formerly Non-Check Total 9(13) positions 81-93) (Formerly Filler X(10) positions 94-103)
3 72 104-175 A/N Comment 1 (formerly Remarks 1)
Optional. Blank fill if not used.
/Transmission/Schedule/TypeB_Details/Comment
4 72 176-247 A/N Comment 2 (formerly Remarks 2)
Optional. Blank fill if not used.
/Transmission/Schedule/TypeB_Details/Comment
5 72 248-319 A/N Comment 3 (formerly Remarks 3)
Optional. Blank fill if not used.
/Transmission/Schedule/TypeB_Details/Comment
6 121 320-440 Filler No validation. (Formerly Filler X(96) positions 320-415) (Formerly ASAID X(8) positions 416-423) (Formerly ACOID X(8) positions 424-431) (Formerly MAC X(9) positions 423-440).
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “06”.
2 20 3-22
Filler No validation. (Formerly Payment Number 9(6) positions 3-8) (Formerly Schedule Number 9(14) positions 9-22)
3 72 23-94 A/N Comment 4 (formerly Optional. Blank fill if not used. /Transmission/Schedule/Ty
92 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
E. Record “07” – Summary Totals TAS/BETCs for Non-Prenotes Record (Required)
The first TAS/BETC-TYPE is required. Every entered TAS/BETC-TYPE must be valid per SAM. There cannot be non-blank TAS/BETC-TYPEs after a blank TAS/BETC-TYPE. Unused TAS/BETC-TYPE entries must be blank filled. Cannot be more than 112 consecutive “07” records for Summary.
Field No
Length Positions Type A/N
Field Validations/Notes XML Schema Transmission
1 2 1-2 N Record Type Value = “07”.
2 2 3-4 N TAS (a) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
3 3 5-7 N TAS (a) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
4 3 8-10 N TAS (a) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Agency
Remarks 4) peB_Details/Comment
4 72 95-166 A/N Comment 5(formerly Remarks 5
Optional. Blank fill if not used. /Transmission/Schedule/TypeB_Details/Comment
5 72 167-238 A/N Comment 6(formerly Remarks 6
Optional. Blank fill if not used. /Transmission/Schedule/TypeB_Details/Comment
6 72 239-310 A/N Comment 7(formerly Remarks 7)
Optional. Blank fill if not used. /Transmission/Schedule/TypeB_Details/Comment
7 130 311-440
Filler No validation. (Formerly CO Name X(16) positions 311-326) (Formerly Filler X(89) positions 327-415) (Formerly ASAID X(8) positions 416-423) (Formerly ACOID X(8) positions 424-431) (Formerly MAC X(9) positions 432-440)
93 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Identifier
5 4 11-14 N TAS (a) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
6 4 15-18 N TAS (a) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
7 1 19-19 A TAS (a) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
8 4 20-23 N TAS (a) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
9 3 24-26 N TAS (a) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
10 8 27-34 A/N BETC (a) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
11 1 35-35 N Is Credit (DEBIT/CREDIT TYPE) (a)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
12 15 36-50 N TAS/BETC-Amount (a) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
13 2 51-52 N TAS (b) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-
94 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
levelPrefixCode
14 3 53-55 N TAS (b) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
15 3 56-58 N TAS (b) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
16 4 59-62 N TAS (b) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
17 4 63-66 N TAS (b) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
18 1 67-67 A TAS (b) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
19 4 68-71 N TAS (b) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
20 3 72-74 N TAS (b) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
21 8 75-82 A/N BETC (b) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
22 1 83-83 N Is Credit Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/Ac
95 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
(DEBIT/CREDIT TYPE) (b)
countClassification/@IsCredit
23 15 84-98 N TAS/BETC-Amount (b) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
24 2 99-100 N TAS (c) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
25 3 101-103 N TAS (c) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
26 3 104-106 N TAS (c) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
27 4 107-110 N TAS (c) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
28 4 111-114 N TAS (c) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
29 1 115-115 A TAS (c) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
30 4 116-119 N TAS (c) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
31 3 120-122 N TAS (c) Sub-Account Must be a valid value for this field per GWA. /Transmission/Schedule/Ac
96 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Code (SUB) countClassification/TreasuryAccountSymbol/@Sub-accountCode
32 8 123-130 A/N BETC (c) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
33 1 131-131 N Is Credit (DEBIT/CREDIT TYPE) (c)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
34 15 132-146 N TAS/BETC-Amount (c) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
35 2 147-148 N TAS (d) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
36 3 149-151 N TAS (d) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
37 3 152-154 N TAS (d) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
38 4 155-158 N TAS (d) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
39 4 159-162 N TAS (d) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
40 1 163-163 A TAS (d) Availability Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/Ac
97 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Type Code (A) countClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
41 4 164-167 N TAS (d) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
42 3 168-170 N TAS (d) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
43 8 171-178 A/N BETC (d) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
44 1 179-179 N Is Credit (DEBIT/CREDIT TYPE) (d)
Must be “1” for Credit and “0” for Debit /Transmission/Schedule/AccountClassification/@IsCredit
45 15 180-194 N TAS/BETC-Amount (d) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
46 2 195-196 N TAS (e) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
47 3 197-199 N TAS (e) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
48 3 200-202 N TAS (e) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
49 4 203-206 N TAS (e) Beginning Must be a valid value for this field per GWA. /Transmission/Schedule/Ac
98 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Period of Availability (BPOA)
countClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
50 4 207-210 N TAS (e) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
51 1 211-211 A TAS (e) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
52 4 212-215 N TAS (e) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
53 3 216-218 N TAS (e) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
54 8 219-226 A/N BETC (e) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
55 1 227-227 N Is Credit (DEBIT/CREDIT TYPE) (e)
Must be “1” for Credit and “0” for Debit /Transmission/Schedule/AccountClassification/@IsCredit
56 15 228-242 N TAS/BETC-Amount (e) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
57 2 243-244 N TAS (f) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
58 3 245-247 N TAS (f) Allocation Must be a valid value for this field per GWA. /Transmission/Schedule/Ac
99 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Transfer Agency Identifier (ATA)
countClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
59 3 248-250 N TAS (f) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
60 4 251-254 N TAS (f) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
61 4 255-258 N TAS (f) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
62 1 259-259 A TAS (f) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
63 4 260-263 N TAS (f) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
64 3 264-266 N TAS (f) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
65 8 267-274 A/N BETC (f) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
66 1 275-275 N Is Credit (DEBIT/CREDIT TYPE) (f)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
100 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
67 15 276-290 N TAS/BETC-Amount (f) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
68 2 291-292 N TAS (g) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
69 3 293-295 N TAS (g) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
70 3 296-298 N TAS (g) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
71 4 299-302 N TAS (g) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
72 4 303-306 N TAS (g) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
73 1 307-307 A TAS (g) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
74 4 308-311 N TAS (g) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
75 3 312-314 N TAS (g) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-
101 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
accountCode
76 8 315-322 A/N BETC (g) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
77 1 323-323 N Is Credit (DEBIT/CREDIT TYPE) (g)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
78 15 324-338 N TAS/BETC-Amount (g) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
79 2 339-340 N TAS (h) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
80 3 341-343 N TAS (h) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
81 3 344-346 N TAS (h) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
82 4 347-350 N TAS (h) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@BeginningPeriodOfAvailability
83 4 351-354 N TAS (h) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
84 1 355-355 A TAS (h) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Availabi
102 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
lityTypeCode
85 4 356-359 N TAS (h) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
86 3 360-362 N TAS (h) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
87 8 363-370 A/N BETC (h) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
88 1 371-371 N Is Credit (DEBIT/CREDIT TYPE) (h)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
89 15 372-386 N TAS/BETC-Amount (h) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
90 2 387-388 N TAS (i) Sub-level Prefix Code (SP)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-levelPrefixCode
91 3 389-391 N TAS (i) Allocation Transfer Agency Identifier (ATA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AllocationTransferAgencyIdentifier
92 3 392-394 N TAS (i) Agency Identifier (AID)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AgencyIdentifier
93 4 395-398 N TAS (i) Beginning Period of Availability (BPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Beginni
103 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
ngPeriodOfAvailability
94 4 399-402 N TAS (i) Ending Period of Availability (EPOA)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@EndingPeriodOfAvailability
95 1 403-403 A TAS (i) Availability Type Code (A)
Must be a valid value for this field per GWA. If used, must be “A”, “X”, “F” or “M”.
/Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@AvailabilityTypeCode
96 4 404-407 N TAS (i) Main Account Code (MAIN)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@MainAccountCode
97 3 408-410 N TAS (i) Sub-Account Code (SUB)
Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/TreasuryAccountSymbol/@Sub-accountCode
98 8 411-418 A/N BETC (i) Must be a valid value for this field per GWA. /Transmission/Schedule/AccountClassification/BusinessEventType/@BusinessEventTypeCode
99 1 419-419 N Is Credit (DEBIT/CREDIT TYPE) (i)
Must be “1” for Credit and “0” for Debit. /Transmission/Schedule/AccountClassification/@IsCredit
100 15 420-434 N TAS/BETC-Amount (i) Must be a valid amount. (See IB.8 and Figure 1 - Schedule Types/Payment Types/SEC/Amount Restrictions Chart)
/Transmission/Schedule/AccountClassification/Classification/@Amount
101 6 435-440 Filler No validation.
VI Acronyms A/N – Alpha-numeric ACH – Automated Clearing House (or EFT – Electronic funds Transfer) AFC – Austin Financial Center ALC – Agency Location Code
104 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
BETC – Business Event Type Code CCD – Cash Concentration or Disbursem*nt for Standard Entry Class Code CGAC – Common Government-wide Accounting Classification Structure EFT – Electronic Funds Transfer (see ACH) Fiscal Service – Bureau of the Fiscal Service (formerly FMS – United States Treasury Financial Management Service) FPA – Federal Program Agency GWA – Government-wide Accounting GWAMP – Government-wide Accounting and Modernization Project IAT – International ACH Transactions for Standard Entry Class Code KFC – Kansas City Financial Center (RFC) N – Numeric NACHA – National Automated Clearing House – The Electronic Payments Association PAM – Payment Application Modernization PFC – Philadelphia Financial Center PM – Payment Management (formerly FMS Regional Operations) PPD – Prearranged Payment and Deposit Entry for Standard Entry Class Code RFC – Regional Financial Center RO – Regional Operations part of Payment Management as of 10/01/2007 RTN – Routing Transit Number/Routing Number/American Bankers Association Number SAM – Shared Accounting Module/ Financial Reference Data SDP – Same Day Payment (SDP) (Fedwire) SEC – Standard Entry Class Code (formerly addendum code) SPS – Secure Payment System TAS – Treasury Account Symbol SP – Sub-level Prefix Code ATA – Allocation Transfer Agency Identifier AID – Agency Identifier BPOA – Beginning Period of Availability EPOA – Ending Period of Availability A - Availability Type Code MAIN – Main Account Code SUB – Sub-Account Code TDO – Treasury Disbursing Office TIN – Tax Identification Number
VII State Codes State Codes per /www.usps.com/ncsc/lookups/usps_abbreviations.html
105 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
State Abbreviations
State/Possession Abbreviation ALABAMA AL ALASKA AK AMERICAN SAMOA AS ARIZONA AZ ARKANSAS AR CALIFORNIA CA COLORADO CO CONNECTICUT CT DELAWARE DE DISTRICT OF COLUMBIA DC FEDERATED STATES OF MICRONESIA FM FLORIDA FL GEORGIA GA GUAM GU HAWAII HI IDAHO ID ILLINOIS IL INDIANA IN IOWA IA KANSAS KS KENTUCKY KY LOUISIANA LA MAINE ME MARSHALL ISLANDS MH MARYLAND MD MASSACHUSETTS MA MICHIGAN MI MINNESOTA MN MISSISSIPPI MS MISSOURI MO MONTANA MT NEBRASKA NE NEVADA NV NEW HAMPSHIRE NH
106 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
NEW JERSEY NJ NEW MEXICO NM NEW YORK NY NORTH CAROLINA NC NORTH DAKOTA ND NORTHERN MARIANA ISLANDS MP OHIO OH OKLAHOMA OK OREGON OR PALAU PW PENNSYLVANIA PA PUERTO RICO PR RHODE ISLAND RI SOUTH CAROLINA SC SOUTH DAKOTA SD TENNESSEE TN TEXAS TX UTAH UT VERMONT VT VIRGIN ISLANDS VI VIRGINIA VA WASHINGTON WA WEST VIRGINIA WV WISCONSIN WI WYOMING WY
Military "State" Abbreviation Armed Forces Africa AE Armed Forces Americas (except Canada)
AA
Armed Forces Canada AE Armed Forces Europe AE Armed Forces Middle East AE Armed Forces Pacific AP
107 of 107 SPS Schedule Upload 440 File Format for GWA Reporter Only Version 1.6, Updated on May 2014
Appendix 1
A. Format Requirements 1. The basic format requirements are stated below.
a. File must have first record starting with Record Type “01”. b. File must have valid File Format Version “GWA001” in record “01” positions (3-8). c. Legacy 440 File must not have “GWA001” in record “01” positions (3-8). d. File must have records in record number order specified. e. File must have required records.
2. If a file meets basic format requirements, but does not meet field level validations as defined in this document, the file will be rejected.
B. File Structure 1. Each schedule to be certified in SPS shall be a separate file. 2. Type A Schedules of Regular Check, Manual Check, ACH, ACH Prenotes and SDP schedules are still limited to 60 payments per
schedule. 3. Type B Schedules of Summary and Summary Prenote schedules have only the summary totals information on the certified
schedule and the individual payment information is transmitted to FMS in a Bulk Standard Payment Request File processed by PAM.
4. Individual records shall be in 440 byte contiguous segments.