USAS Extract Files
USAS extracts can be divided into financial activity extracts and profile title extracts. Profile title extracts provide the control key and title information for each record set up on the profile requested.
Users must submit an extract request to the Comptroller’s System Input/Output (SIO) group to receive any extract. See the USAS Interface Manual (FPP Q.011) (login required) for information on requesting financial activity and profile title extracts.
Some extracts also allow the user to customize the extract by setting up a request on the Report Request Profile (91). The options available for these extracts are detailed on the Report Control Profile (D64).
Financial Activity Extracts
Extract ID | Extract Title |
---|---|
APX | Appropriation Balance Extract |
HX | History Extract |
TX | Transaction Extract |
DAFXTGLX | General Ledger Extract * |
* USAS report request (91) required |
Profile Extracts
A USAS report request (91) is required for all profile extracts.
Extract ID | Extract Title |
---|---|
DAFXTD02 | Agency |
DAFXTD03 | Organizational Code |
DAFXTD04 | Program Code |
DAFXTD08 | GAAP Source/Object |
DAFXTD10 | Comptroller Object |
DAFXTD11 | Agency Object |
DAFXTD13 | GAAP General Ledger Account Category |
DAFXTD14 | GAAP General Ledger Account Class |
DAFXTD16 | GAAP Category |
DAFXTD20 | GAAP Fund Group |
DAFXTD21 | GAAP Fund Type |
DAFXTD22 | Appropriated Fund |
DAFXTD23 | Fund |
DAFXTD24 | GAAP Fund |
DAFXTD25 | Agency Object Group |
DAFXTD28 | Grantor |
DAFXTD31 | Comptroller General Ledger Account |
DAFXTD38 | NACUBO Subfund |
DAFXTD40 | Grant Category |
DAFXTD42 | Project Number |
DAFXTD47 | Grant Number |
DAFXTD48 | Grant Object |
DAFXTD54 | NACUBO Function Code |
DAFXT020 | Appropriation Number |
DAFXT026 | Program Cost Account |
DAFXT027 | Project Control |
DAFXT28A | Transaction Code Decision |
DAFXT029 | Grant Control Profile Maintenance/Inquiry |
DAFXT033 | Document Control |