InfoAccess

  

DATA VIEW NAME

AR_CASH _RECEIPT _STOUT

OVERVIEW 

Contains cash receipt information. Current and historical data.

LOAD FREQUENCY

Data is updated every night.

DATA CUSTODIAN

Student Business Services
 Contact: Rick Olson

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

Key fields are identified with an asterisk (*).

QUESTIONS

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

LAST UPDATED

2/2003 Created
9/2008 Custodian Change c4j.

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. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (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

 
PERSON_ID*

CHAR 7

Datatel person ID

ARCR_CASH_RCPT_ID*

CHAR 9

Cash receipt ID

ARCR_RCPT_NO

CHAR 9

Cash receipt number

ARCR_RCPT_DATE

DATE 19

Cash receipt date

ARCR_RCPT_SESSION

CHAR 5

Cash receipt session

ARCR_RCPT_PAYER

CHAR 40

Cash receipt payer name

ARCR_DEPOSIT_AMT

NUM 14.2

Cash receipt deposit amount

ARCR_GL_DISTR_CODE

CHAR 5

Cash receipt GL distribution code

ARCR_CONTROL_NO1

CHAR 20

Cash receipt control number (ie credit card no)

ARCR_CONTROL_NO2

CHAR 20

Cash receipt control number (ie credit card no)

ARCR_CONTROL_NO3

CHAR 20

Cash receipt control number (ie credit card no)

ARCR_CONTROL_NO4

CHAR 20

Cash receipt control number (ie credit card no)

ARCR_CONTROL_NO5

CHAR 20

Cash receipt control number (ie credit card no)

ARCR_EXPIRE_DATE1

DATE 19

Cash receipt credit card expire date

ARCR_EXPIRE_DATE2

DATE 19

Cash receipt credit card expire date

ARCR_EXPIRE_DATE3

DATE 19

Cash receipt credit card expire date

ARCR_EXPIRE_DATE4

DATE 19

Cash receipt credit card expire date

ARCR_EXPIRE_DATE5

DATE 19

Cash receipt credit card expire date

ARCR_CONFIRMATION_NO1

CHAR 20

Cash receipt credit card confirm number

ARCR_CONFIRMATION_NO2

CHAR 20

Cash receipt credit card confirm number

ARCR_CONFIRMATION_NO3

CHAR 20

Cash receipt credit card confirm number

ARCR_CONFIRMATION_NO4

CHAR 20

Cash receipt credit card confirm number

ARCR_CONFIRMATION_NO5

CHAR 20

Cash receipt credit card confirm number

ARCR_NON_CASH_AMT1

NUM 14.2

Cash receipt non cash amount

ARCR_NON_CASH_AMT2

NUM 14.2

Cash receipt non cash amount

ARCR_NON_CASH_AMT3

NUM 14.2

Cash receipt non cash amount

 
ARCR_NON_CASH_AMT4

NUM (14,2)

Cash receipt non cash amount

 
ARCR_NON_CASH_AMT5

NUM (14,2)

Cash receipt non cash amount

 
ARCR_PAY_METHOD1

CHAR 5

Cash receipt pay method code (ie ck, tmc)

 
ARCR_PAY_METHOD2

CHAR 5

Cash receipt pay method code (ie ck, tmc)

 
ARCR_PAY_METHOD3

CHAR 5

Cash receipt pay method code (ie ck, tmc)

 
ARCR_PAY_METHOD4

CHAR 5

Cash receipt pay method code (ie ck, tmc)

 
ARCR_PAY_METHOD5

CHAR 5

Cash receipt pay method code (ie ck, tmc)

 
ARCR_CASH_AMT

NUM (14,2)

Cash receipt cash amount

 
ARCR_CHANGE_RETUNED

NUM (14,2)

Cash receipt change returned

 
ARCR_COMMENTS

CHAR 200

Cash receipt comments

 
ARCR_REVERSAL_REASON

CHAR 5

Cash receipt reversal updated

 
LAST_UPDATE_DATE_TIME

DATE 19

Date record last updated