InfoAccess

  

DATA VIEW NAME

GLNO _ TRANSLATE _ STOUT

OVERVIEW 

Translate table of Datatel GL Numbers to SFG GL Number

LOAD FREQUENCY

Daily

DATA CUSTODIAN

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 web site

SPECIAL CONSIDERATIONS

  

QUESTIONS

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

LAST UPDATED

 09/04 New view created.

DATA FORMATS

Primary Key Columns are identified with an asterisk(*)

Alphanumeric Data

VARCHAR2(N)  (N)=maximum length. Field contains letters and/or numbers Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’

Numeric Data

NUMBER (N)  (N)=length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER(6,2) represents 2500.12

DATE

DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)


Column Name

Format

Description

FISCAL_YEAR

VARCHAR2 (4)

*Fiscal Year – Key

GL_ACCOUNT_NO

VARCHAR2 (15)

*Datatel Account ID - Key

FUND

VARCHAR2 (3)

Datatel Fund

ACTIVITY

VARCHAR2 (1)

Datatel Activity

DEPARTMENT

VARCHAR2 (6)

Datatel Department

ACCOUNT_NO

VARCHAR2 (5)

Datatel Account Number

SFS_GL_ACCOUNT_NO

VARCHAR2 (16)

SFS GL Account Number

SFS_FUND_NO

VARCHAR2 (3)

SFS Fund Number

SFS_ACTIVITY

VARCHAR2 (1)

SFS Activity

SFS_DEPARTMENT

VARCHAR2 (6)

SFS Department

SFS_ACCOUNT_NBR

VARCHAR2 (6)

SFS Account number

LAST_UPDATE_DATE_TIME

DATE (19)

The date & time data was extracted Format: YYYYMMDD HH24:MI:SS