Skip to content

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.

Click on any column heading to sort by that column
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