Penn Computing

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

CT_TA_RATE Table - Data Element Index

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



Data element Definition
BREAKFAST_DEDUCTION

Indexed - no
Format - number (23,8)
May be null? yes

Deduction for breakfast expenses.

DINNER_DEDUCTION

Indexed - no
Format - number (23,8)
May be null? yes
Deduction for dinner expenses..
END_DATE

Indexed - no
Format - date
May be null? yes
Date to which the rate is effective.
INCIDENTALS_RATE

Indexed - no
Format - number (23,8)
May be null? yes
Rate for incidentals expenses.
LAST_MODIFIED

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

Indexed - no
Format - number (23,8)
May be null? yes
Rate for lodging expenses.
LUNCH_DEDUCTION

Indexed - no
Format - number (23,8)
May be null? yes
Deduction for lunch expenses.
MEALS_RATE

Indexed - no
Format - number (23,8)
May be null? yes
Rate for meals expenses.
RATE_KEY

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

Indexed - no
Format - date
May be null? yes
Date from which the rate is effective.

CT_TA_RATE 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