AR_GL_ACCOUNT_STOUT

Contains billing GL information for invoices or payments. Current and historical data.

Data is updated every night.

Student Business Services
Contact: Rick Olson

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

Key fields are identified with an asterisk (*)

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

Key fields are identified with an asterisk (*). Field formats describe the field type and length.

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

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.

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 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)

CHAR 7

Datatel Person ID

CHAR 9

Invoice ID

CHAR 9

Payment ID

CHAR 9

Invoice or payment item ID

CHAR 3

GL line for this invoice or payment item

CHAR 15

GL account number

CHAR 3

GL fund

CHAR 1

GL activity

CHAR 6

GL department

CHAR 5

GL account

NUM (14,2)

GL account amount

CHAR 15

GL deferred account number

DATE 19

Date record last updated