|
InfoAccess |
|
|
DATA VIEW NAME |
GL_ACCOUNT_DESC_STOUT |
|
OVERVIEW |
This view contains the account number descriptions. Also known as the object code description. |
|
LOAD FREQUENCY |
As changes occur. |
|
DATA CUSTODIAN |
Director of Accounting
Services |
|
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. |
|
| 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 |
|---|---|---|
|
ACCOUNT_NO |
CHAR 5 |
Account number |
|
ACCOUNT_NO_DESC |
CHAR 30 |
Account number description |
|
EXTRACT_DATE_TIME |
DATE |
Date time transaction loaded on data warehouse |