EXP_TYPE 
Default Table Name  EXP_TYPE 
Definition 
 Name: Expense Types.     Description: This table contains the user defined expense types.
 

EXP_TYPE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_TYPE_CD(PK)    VARCHAR2(10)  NO 
Name: Expense Type. Description: The expense type unique identifier.
 
EXP_TYPE_DESC    VARCHAR2(30)  NO 
Name: Expene Type Description. Description: The description of the expense type.
 
EXP_CATEGORY_CD    VARCHAR2(10)  NO 
Name: Expense Category. Description: The Expense Category Type of the expense type. 
 
PROVIDER_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Provider Required Flag. Description: Logical as to whether or not a provider is required for this expense type. This is valid for ALL expense categories.
 
PER_DIEM_FL    VARCHAR2(1)  NO 
Name: Per Diem Flag. Description: Logical as to whether this expense type uses per-diem schedule.
 
S_PER_DIEM_USE_CD    VARCHAR2(10)  YES 
Name: Per Diem Option. Description: Determines how the Per Diem rates will be used. Valid values are: ALLOW = Allowance; user will be reimbursed according to the Per Diem table. CEILING = Ceiling; user will enter actual amount spent and Per Diem table rate acts as a ceiling.
 
TICKET_NUMBER_REQUIRED_FL    VARCHAR2(1)  NO 
Ticket Number Required Flag. If checked, the user must enter a Ticket Number. This is valid for the following expense categories: TRANSPORT. CARRENTAL
 
MEAL_REQUIRED_FL    VARCHAR2(1)  NO 
Meal Identification Required Flag. If checked, the user must identify any meals that were served. This is valid for the following expense category types: TRANSPORT. ENTERTAIN
 
ODOMETER_MILES_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Odometer Reading Required Flag. Description: If checked, the user must enter the starting and ending odometer reading. This is valid for the following expense category types: MILEAGE
 
ATTENDEE_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Attendees Required Flag. Description: If checked, the user will be required to list the people that attended. This is valid for the following expense category types: ENTERTAIN
 
UNIT_LBL    VARCHAR2(10)  YES 
Unit Label. The label for the miscellaneous unit. This is valid for the following expense category types: MILEAGE. OTHER
 
AP_1099_FL    VARCHAR2(1)  NO 
Name: AP 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information.
 
AP_1099_TYPE_CD    VARCHAR2(6)  YES 
Name: AP 1099 Type. Description: Type of 1099 expense. 
 
RELOCATION_FL    VARCHAR2(1)  NO 
Name: Relocation Flag. Description: Logical as to whether this expense is a relocation expense.
 
RELOCATION_CD    VARCHAR2(6)  YES 
Name: Relocation Code. Description: Type of relocation expense. 
 
W2_FL    VARCHAR2(1)  NO 
Name: W2 Flag. Description: Logical as to whether this expense is W2 reimbursement.
 
W2_CD    VARCHAR2(6)  YES 
Name: W2 Code. Description: Type of W2 expense. 
 
OVERRIDE_RATE_FL    VARCHAR2(1)  NO 
Name: Override Unit Rate Flag. Description: Logical as to whether user can override unit rate.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: If checked, this expense type is active.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
MULTI_DAY_FL    VARCHAR2(1)  NO 
Name: Multi Day Expense Flag. Description: If checked, the expense will cover multiple days. This is valid for the following expense category types: OTHER
 
OVER_CEILING_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Over Ceiling Explanation Required Flag. Description: Logical as to whether reason for over ceiling amount charged are required. This is valid for ALL expense category types.
 
ITINERARY_REQUIRED_FL    VARCHAR2(1)  NO 
If checked, the user must enter the Origination and Destination city. This is valid for the following expense category types: TRANSPORT
 
UNALLOWABLE_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Unallowable Flag . Description: If checked, the user will be required to enter the amount of unallowable expenses incurred. (i.e. Alcohol). This is valid for the following expense category types: ENTERTAIN
 
S_OVER_CEILING_CD    VARCHAR2(1)  NO 
Name: Over Ceiling Reimburse Option. Description: Determines whether or not the over ceiling amounts are reimbursed to the employee. The valid values are: R – Reimburse. N – Non-Reimburse
 
DESC_CATEGORY_FL    VARCHAR2(1)  NO 
Description Category Flag. Logical as to whether or not the Category will be used in the description of the expense report. 
 
DESC_EXPENSE_TYPE_FL    VARCHAR2(1)  NO 
Name: Description Expense Type Flag. Description: Logical as to whether or not the Expense Type will be used in the description of the expense report.
 
DESC_PROVIDER_FL    VARCHAR2(1)  NO 
Name: Description Provider Flag. Description: Logical as to whether or not the Provider will be used in the description of the expense report.
 
DESC_EXPENSE_DATE_FL    VARCHAR2(1)  NO 
Name: Description Expense Date Flag. Description: Logical as to whether or not the Expense Date will be used in the description of the expense report.
 
DESC_START_END_DATE_FL    VARCHAR2(1)  NO 
Name: Description Start/End Date Flag. Description: Logical as to whether or not the Start and End Date will be used in the description of the expense report.
 
DESC_TICKET_NUMBER_FL    VARCHAR2(1)  NO 
Name: Description Ticket Number Flag. Description: Logical as to whether or not the Ticket Number will be used in the description of the expense report.
 
DESC_ITINERARY_FL    VARCHAR2(1)  NO 
Name: Description Itinerary Flag. Description: Logical as to whether or not the Itinerary will be used in the description of the expense report.
 
COMBINE_PER_DIEM_FL    VARCHAR2(1)  NO 
Name: Combine Per Diem Flag. Description: If checked, the Lodging and Meals Per Diem amounts will be combined.
 
BREAKFAST_FL    VARCHAR2(1)  NO 
Name: Breakfast Flag. Description: If checked, the expense will include Breakfast amounts.
 
LUNCH_FL    VARCHAR2(1)  NO 
Name: Lunch Flag. Description: If checked, the expense will include Lunch amounts.
 
DINNER_FL    VARCHAR2(1)  NO 
Name: Dinner Flag. Description: If checked, the expense will include Dinner amounts.
 
DESC_EMPL_ID_FL    VARCHAR2(1)  NO 
Name: Description Employee ID Flag. Description: Logical as to whether or not the Employee ID will be used in the description of the expense report.
 
DESC_EXP_RPT_ID_FL    VARCHAR2(1)  NO 
Name: Description Expense Report ID Flag. Description: Logical as to whether or not the Expense Report ID will be used in the description of the expense report.
 
SECOND_TIER_CEILING_FL    VARCHAR2(1)  NO 
Name: 2nd Tier Per Diem Ceiling Flag. Description: Logical as to whether a per diem expense should use Expense Type ceiling as 2nd tier ceiling.
 
S_TYPE_CD    VARCHAR2(10)  NO 
Name: Wizard Type. Description: Internal system reference code of the type of this expense type. The valid values are: CARRENTAL. ENTERTAIN. LODGING. MEALS. MILEAGE. OTHER. TRANSPORT
 
CODE1_REQUIRED_FL    VARCHAR2(1)  NO 
Name: User Defined Code 1 Required Flag. Description: If checked, the user must choose a value for Code1 user defined field.
 
CODE2_REQUIRED_FL    VARCHAR2(1)  NO 
Name: User Defined Code 2 Required Flag. Description: If checked, the user must choose a value for Code2 user defined field.
 
CODE3_REQUIRED_FL    VARCHAR2(1)  NO 
Name: User Defined Code 3 Required Flag. Description: If checked, the user must choose a value for Code3 user defined field.
 
DESC_CODE1_FL    VARCHAR2(1)  NO 
Name: Description User Defined Code 1 Flag. Description: Logical as to whether or not the Code1 will be used in the description of the expense report.
 
DESC_CODE2_FL    VARCHAR2(1)  NO 
Name: Description User Defined Code 2 Flag. Description: Logical as to whether or not the Code2 will be used in the description of the expense report.
 
DESC_CODE3_FL    VARCHAR2(1)  NO 
Name: Description User Defined Code 3 Flag. Description: Logical as to whether or not the Code3 will be used in the description of the expense report.
 
CODE1_VALIDATE_FL    VARCHAR2(1)  NO 
Name: User Defined Code 1 Validate Flag. Description: Logical as to whether code1 is required. If "Y", the user must choose a value for Code1.
 
CODE2_VALIDATE_FL    VARCHAR2(1)  NO 
Name: User Defined Code 2 Validate Flag. Description: Logical as to whether code2 is required. If "Y", the user must choose a value for Code2.
 
CODE3_VALIDATE_FL    VARCHAR2(1)  NO 
Name: User Defined Code 3 Validate Flag. Description: Logical as to whether code3 is required. If "Y", the user must choose a value for Code3.
 
REQUIRE_TITLE_COMPANY_FL    VARCHAR2(1)  NO 
Name: Require Attendee Company/Title Flag. Description: Logical as to whether attendee wizard page should require title and company info for attendee. 
 
SUPPRESS_ATTENDEE_EMPL_ID_FL    VARCHAR2(1)  NO 
Name: Suppress Attendee Employee ID Flag. Description: Logical as to whether employee ID is suppressed in attendee lookup.
 
S_UNIT_DECIMAL_NO_CD    VARCHAR2(1)  NO 
Name: Unit Decimal Postion Option. Description: Number of decimals that expenses of this Expense Type can go out to the right of the decimal point.
 
INCIDENTAL_FL    VARCHAR2(1)  NO 
Name: Incidental Flag. Description: If checked, the expense will include Incidental amounts.
 
TRACK_MULTIPLE_LOCATIONS_FL    VARCHAR2(1)  NO 
Name: Track Multiple Locations Flag. Description: Logical that determines whether multiple locations can be tracked on specific expense types.
 
LOCATION_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Location Required Flag. Description: Logical whether location is required.
 
UNALLOWABLE_EXPL_REQUIRED_FL    VARCHAR2(1)  NO 
Name: Unallowable Explanation Required Flag. Description: Logical as to whether reason for unallowable amount charged are required. This is valid for ALL expense types.
 
OVERRIDE_FIRST_LAST_DAY_FL    VARCHAR2(1)  NO 
Name: Override First Last Day Flag. Description: Logical as to whether expenses of this type allow the override of the trip’s first/last day.
 
CONFERENCE_ADJUST_PCT    NUMBER(3, 2)  NO 
Name: Conference Adjustment Percentage. Description: Adjustment value for Per Diem Lodging expenses.
 
ALLOW_DATE_EDIT_FL    VARCHAR2(1)  NO 
Name: Allow Date Edit. Description: Determines whether the employee can change the Expense Date or Start End Date on Batch Expenses.
 
S_CEILING_CALCULATION_CD    VARCHAR2(10)  NO 
Name: Ceiling Calculation Description: Determines how the system will calculate the ceiling for the Expense Type. Valid values are: EXPENSE – ceiling amount is calculated by taking the ceiling amount one time ATTENDEE – ceiling is calculated by taking the ceiling amount times the number of attendees.
 
S_ENTER_ATTENDEES_CD    VARCHAR2(10)  YES 
Name: Enter Attendees Description: Logical as to how the user will enter the attendees. Values are: By Number of Attendees By Attendee Name.
 
S_CEILING_CALC_METHOD_CD    VARCHAR2(10)  NO 
Name: Ceiling Calculation Method Description: Determines whether the system will calculation ceiling amounts for each day or for all days of the expense combined: DAY – Each Day EXPENSE – all days combined.
 

EXP_TYPE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0149  PrimaryKey  EXP_TYPE_CD 

EXP_TYPE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EXP_TYPE_RATE_CEILING  Identifying  One To Zero or More  F00153        NO  NO 
EXP_TYPE_EXP_CHARGE_TYPE  Identifying  One To Zero or More  F00182        NO  NO 
EXP_TYPE_LABELS  Identifying  One To Zero or More  F00187        NO  NO 
EXP_TYPE_OTHER  Identifying  One To Zero or More  F00189        NO  NO 
EXP_TYPE_PROVIDER  Identifying  One To Zero or More  F00272        NO  NO 
EXP_TYPE_PAY_METHOD  Identifying  One To Zero or More  F00274        NO  NO 
EXP_TYPE_CODE1  Identifying  One To Zero or More  F00276        NO  NO 
EXP_TYPE_CODE2  Identifying  One To Zero or More  F00277        NO  NO 
EXP_TYPE_CODE3  Identifying  One To Zero or More  F00278        NO  NO 
EXP_RPT_TYPE_CATEGORY_EXP_TYPE  Identifying  One To Zero or More  F00284        NO  NO 
EXP_TYPE_OTHER  Non-Identifying  One To Zero or More  F00311        NO  NO 
EXP_RPT_EXPENSE  Non-Identifying  One To Zero or More  F00341        NO  NO 
EXP_AUTH_EXPENSE  Non-Identifying  One To Zero or More  F00362        NO  NO 
EXP_TYPE_TASK  Identifying  One To Zero or More  F00455        NO  NO