GL_P_CARD_TRANSACTIONS_STOUT

Contains statement billing record type 5(Card holder transactions) file info from US Bank. This is received for both Travel and Purchases.

Data is received bi weekly.

Financial Services.
Contact: Ted Wenum.

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)

7/07 Created.

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)

Varchar2(8)

Last 6 digits of card account number

Varchar2(23)

Reference number of the transaction.

Varchar2(5)

Used to make reference number unique.

Varchar2(4)

Last 4 digits of card account number

Varchar2(25)

Merchant for this transaction.

Date 19

Date of this transaction.

Date 19

Date posted to US Bank

Date 19

Date record last updated