InfoAccess

  

DATA VIEW NAME

GL_ACCOUNT_STOUT

OVERVIEW 

This view contains aggregate information by general ledger account number and fiscal year.  Data from the GL_DETAIL_STOUT is summarized to the general ledger account number and fiscal year.

LOAD FREQUENCY

Daily

DATA CUSTODIAN

Director of Accounting Services
Ted Wenum

AUTHORIZATION

You must receive approval to access data from the data custodian.  For information about how to get authorized for InfoAccess data views, connect to the Infoaccess home page.

SPECIAL CONSIDERATIONS

  

QUESTIONS

Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)

LAST UPDATED

  

DATA FORMATS

The codes following the field names in this document define the field.  The different types are:
 

CHAR2(N) OR CHAR (N) - Alphanumeric.  (N) is the length of the field.  Field contains letters and/or numbers. 
Example: CHAR (5) could contain 'ABC12' or '12345' or 'ABCDEF' (N) is the length of the field.  Field contains letters and/or numbers.
  NUM (N) - Numeric field. (N) is the length of the field.  Field contains only numbers.  Numbers with decimal points are represented as NUM (X.Y) X=total number of digits Y=the number of decimals after the decimal
Examples: NUM (6,2) could contain 2500.12   NUM (6) could contain 000005 or 550000
  DATE  (XXXX) - Date field. (XXXX) is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. 
Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY)

Column Name

Format

Description

FISCAL_YEAR

CHAR 4

Fiscal year

GL_ACCOUNT_NO

CHAR 15

General Ledger Account number

FUND

CHAR 3

General Ledger Fund

ACTIVITY

CHAR 1

General Ledger Activity

DEPARTMENT

CHAR 6

General Ledger Department

ACCOUNT_NO

CHAR 5

General Ledger Account number

SFS_FUND_NO

CHAR 3

Translated from Datatel fund number for PeopleSoft Shared Financial System (SFS)

SFS_ACCOUNT_NO

CHAR 4

Translated from Datatel object number PeopleSoft Shared Financial System (SFS)

FUND_BALANCE_AMT

NUM 14,2

Fund Balance amount

ADJUSTED_BUDGET_AMT

NUM 14,2

Adjusted budget amount

TRANSFER_AMT

NUM 14,2

Transfer amount

EXPENSE_AMT

NUM 14,2

Expense amount

REVENUE_AMT

NUM 14,2

Revenue amount

ENCUMBRANCE_AMT

NUM 14,2

Encumbrance amount

CASH_AMT

NUM 14,2

Cash amount

DO_TO_FROM_AMT

NUM 14,2

DO-TO-DO-FROM amount

EXTRACT_DATE_TIME

DATE

Date time transaction loaded on data warehouse.