AR_REG_ITEM_STOUT

Contains registration item detail for billing. 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-4357 (HELP)

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

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

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 for this registration

CHAR 9

Item ID for this registration

CHAR 15

Course number

DATE 19

Course start date

DATE 19

Course end date

CHAR 1

Course status code (ie R, X, A, D)

DATE 19

Course status code date

CHAR 5

Course schedule type (ie 01, 08wk)

CHAR 5

Course refund policy (ie QTICS, TUTIN)

CHAR 5

Course refund other policies

NUM (5,2)

Course billing credits

CHAR 1

Course billing method (ie Table, Section)

DATE 19

Date registration item record last updated