Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_CURRENCY Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_CURRENCY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ALPHA_CODE

Indexed - yes
Format - char(3)
May be null? yes
Alphabetical code for the currency.
CRN_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a currency.
CURR_CODE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the currency record was last modified.
CURR_NAME_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the currency name was last modified.
CURRENCY_NAME

Indexed - no
Format - varchar2(64)
May be null? yes
Name of the currency.
DECIMAL_DIGITS

Indexed - no
Format - number
May be null? yes
Number of decimal digits used for the currency.
IS_DELETED

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the currency record has been deleted from Concur.
IS_REIMBURSEMENT_CURRENCY

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the currency is used for reimbursements via Concur Expense.
NUM_CODE

Indexed - no
Format - char(3)
May be null? yes
Numeric code for the currency.
WITHDRAWN_DATE

Indexed - no
Format - date
May be null? yes
Date on which the currency was withdrawn.

CT_CURRENCY Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania