Penn Computing

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

CT_TA_FIXED Table - Data Element Index

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



Data element Definition
ALLOWANCE_AMOUNT

Indexed - no
Format - number
May be null? yes

The allowance amount.

BASE_AMOUNT

Indexed - no
Format - number
May be null? yes
The base amount of the allowance.
BREAKFAST_PROVIDED

Indexed - no
Format - char(3)
May be null? yes
Indicates whether breakfast is provided.
DINNER_PROVIDED

Indexed - no
Format - char(3)
May be null? yes
Indicates whether dinner is provided
LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the fixed travel allowance record was last modified.
LUNCH_PROVIDED

Indexed - no
Format - char(3)
May be null? yes
Indicates whether lunch is provided.
MEAL_LODGING_TYPE

Indexed - no
Format - char(1)
May be null? yes
Flag that identifies the type of travel allowance (M = meals only; L = lodging)
OVERNIGHT

Indexed - no
Format - char(1)
May be null? yes
 
RATE_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies a travel allowance rate in the Concur system.
TA_DAY_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a travel allowance day record.

CT_TA_FIXED 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