USAS User’s Manual –
Chapter 9 – Financial Inquiry (continued)
Reports
Tables Used
The lower right hand section of the Report Control Profile (D64) screen provides information as to which financial tables are being accessed to generate the specific requestable report.
What Tables Reports Come From
In the example below, the DAFR7500 is shown to be generated from the Accounting Event Table and the Appropriation Table.
A picture of the USAS Report Control Profile screen
TEXAS SD64 UNIFORM STATEWIDE ACCOUNTING SYSTEM 02/07/95 09:28 AM LINK TO: REPORT CONTROL PROFILE PROD ACTION: R (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL) REPORT ID: DAFR7500 APPROPRIATION ACTIVITY ANALYSIS REPORT REQUESTABLE IND: 2 (0=NOT, 1=CENTRALLY, 2=REQUESTABLE BY ALL) CONF: N PRINT REMOTE IND: Y (Y=YES, N=NO) PRINTER TYPE: H (L=LOW, M=MEDIUM, H=HIGH) INTERVAL OPTIONS (R=REQUIRED, O=OPTIONAL, N=NOT ALLOWED)- TIMEFRAME - AP YEAR: O PERIOD: R FREQUENCY - MMDDYY: N DAILY: N WEEKLY: N MONTHLY: O QUARTERLY: N ANNUALLY: N LEVEL OPTIONS (N=NOT ALLOWED OR LOW AND HIGH VALUE ALLOWED)- LO - ORG: N PGM: N OBJ: N FUND: N NACUBO FUND: N GL ACCT: N GRANT: N PROJ: N HI - ORG: N PGM: N OBJ: N FUND: N NACUBO FUND: N GL ACCT: N GRANT: N PROJ: N SPECIAL SELECTS (R=REQUIRED, O=OPTIONAL, N=NOT ALLOWED)- AGENCY: R ORG CODE: N AE: Y DF: N PJ: N PROGRAM CODE: N NACUBO FUND: N AF: N GL: N APPROP FUND: O FUND: N AB: N GP: N COMP OBJECT: N AGENCY OBJECT: N AP: Y IV: N GL ACCT: N AGENCY GL ACCT: N CC: N CF: N GRANT: N PROJECT: N SPECIAL SELECT 1: R EDIT: A1 SPECIAL SELECT 2: N EDIT: STATUS CODE: A EFF START DATE: 08131990 EFF END DATE: LAST PROC DATE: 07141994 Tables include: AE Accounting Event DF Document AF Agency Fund GL General Ledger AB Agency Budget GP Grant AP Appropriation CF Contract CC Cash Control PJ Project