AR_ACCOUNT _STOUT

Contains billing account information. Current and historical data.

Data is refreshed 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-4357 (HELP)

2/2003 Created
9/2008 Custodian Change c4j.

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 5

AR Account Type (ie. 01,03) Code

CHAR 30

Account Name

CHARr 30

Account Home Address line 1

CHAR 30

Account Home Address line 2

CHAR 25

Account Home City

CHAR 2

Account Home State

CHAR 10

Account Home Zip

CHAR 20

Account Home Country

NUM (14,2)

Account Total Balance

NUM (14,2)

Account Current Term Balance

DATE 19

Date Record Last Updated