USAS User’s Manual –
Chapter 12 – Understanding Financial Tables

Table of Contents

• Overview of USAS Financial Tables
  • About this Chapter
  • Function of Tables
  • Types of Tables
• Financial Tables
  • Primary Financial Tables
    • Appropriation Table
    • Cash Control Table
    • Agency Budget Table
    • Agency/Fund Table
    • Grant and Project Tables
    • Document Table
    • Contract Table
  • Purpose of Primary Tables
  • About Primary Tables
  • Secondary Financial Tables
    • General Ledger Table
    • Accounting Event Table
  • Purpose of Secondary Tables
  • Generating Reports
• Organization of Primary Financial Tables
  • Table Components
  • Records
  • Control Keys
    • Functions of Control Keys
    • Required and Optional Elements of Control Key
    • Required Elements
    • Optional Elements
    • Posting Optional Elements
  • Balance Types
    • Transaction Classification
    • Financial Data Classification
  • Balances
  • Types of Balances Stored
    • Fiscal Month Balances (01-13)
    • Prior Year Balance
    • Prior Prior Year Balance
  • 28A Transaction Code Decision Profile
• A Detailed Look At The Appropriation Table
  • Appropriation Table Data Elements and Balances
  • Control Key for the Appropriation Table
  • Balances of the Appropriation Table
• How USAS Identifies The Primary Table
  • About this Procedure
  • 28A Transaction Code Decision Profile
• How USAS Posts The Optional Elements To The Primary Tables
  • About this Procedure
  • Posting-Level Indicators
  • D23 Fund Profile
  • 24 Index Code Profile
  • 29 Grant Control Profile
  • D42 Project Number Profile
  • 20 Appropriation Number Profile
  • 26 Program Cost Account Profile
  • 27 Project Control Profile
  • D47 Grant Number Profile
• Posting To The Appropriation Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• How Optional Elements Post To The Appropriation Table
  • About this Procedure
• Posting To The Cash Control Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• How Optional Elements Post To The Cash Control Table
  • About this Procedure
• Posting To The Cash Control Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• How Optional Elements Post To The Cash Control Table
  • About this Procedure
• Posting To The Agency Budget Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• Posting To The Grant Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• Posting To The Project Table
  • About this Procedure
  • Required Elements
  • Optional Elements
• How USAS Edits Transactions
  • About this Procedure
  • Data-Element Edits
  • Funding Edits
  • Specific Algorithms
• Controlling Funding Edits
  • About this Procedure
  • Fund-Control Indicators
  • Profiles
• Appropriation And Agency Budget Tables
  • 20 Appropriation Number Profile
  • Fund-Control Indicators
  • Appropriation Table
  • Agency Budget Table
• Cash Control Table
  • D22 Appropriated Fund Profile
  • Grant Control Profile
• Project Table
  • 27 Project Control Profile
• Grant Table
  • 29 Grant Control Profile
• How USAS Performs Funding Edits Step-By-Step
  • Summary of Funding Edit Steps
• Importance of Posting Levels To Funding Edits
  • Relationship Between Posting Levels and Funding Edits
• USAS Inquiry Screens
  • About these Screens
  • Financial Inquiry dl
    • Financial Table Initials
• How Financial Tables Are Accessed
  • About this Procedure
    • Control Key
    • Access Paths
    • Appropriation Table
• Importance of Posting Levels To Inquiry
  • About this Procedure
  • Data Not Posted to Fund
  • Data Not Posted to Program
  • Success
• USAS Reports
  • Generating Reports
  • D64 Report Control Profile
  • USAS Valid Reporting Levels
• How Reports Access Information
  • 91 Report Request Profile
  • Data Not Posted to Fund
• USAS Primary Financial Tables And Associated Balance Types
  • Balance Types with Primary Tables
  • Primary Tables with Balance Types
  • Appropriation Financial Table (AP) and Agency/Fund Financial Table (AF)
  • Cash Control Table
  • Agency Budget Table
  • Grant Table
  • Project Table
• Funding-Edit Algorithm
• Calculated Balance S
• USAS Files And Extracts
  • Input Transaction File
  • Internal Transaction File
  • History File Extract
  • Other Extracts

Return to USAS User’s Manual Index