CORRECT_EXP_RPT_EXPENSE_DAY 
Default Table Name  CORRECT_EXP_RPT_EXPENSE_DAY 
Definition 
Name: Correct Expense Report Expense Day. Description: This table contains the details of a corrected expense at the daily level.
 

CORRECT_EXP_RPT_EXPENSE_DAY Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_RPT_ID(PK)(FK)    VARCHAR(10)  NO 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 
CORRECTION_NO(PK)(FK)    NUMERIC(10, 0)  NO 
Name: Correction Number. Description: The correction number used for this expense report.
 
EXPENSE_ID(PK)(FK)    NUMERIC(10, 0)  NO 
Name: Expense ID. Description: The unique identifier for the expense.
 
EXP_DT(PK)    DATE  NO 
Name: Expense Date. Description: The date of the expense.
 
BREAKFAST_FL    VARCHAR(1)  NO 
Name: Breakfast Flag. Description: Logical as to whether this expense is breakfast.
 
LUNCH_FL    VARCHAR(1)  NO 
Name: Lunch Flag. Description: Logical as to whether this expense is lunch.
 
DINNER_FL    VARCHAR(1)  NO 
Name: Dinner Flag. Description: Logical as to whether this expense is dinner.
 
TRANS_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Currency Ceiling Amount. Description: The ceiling amount in transaction currency.
 
TRANS_EXPENSE_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Currency Expense Amount. Description: The net expense in the transaction currency. (INCURRED – OTHER).
 
PAY_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Pay Currency Ceiling Amount. Description: The ceiling amount in pay currency.
 
PAY_EXPENSE_AMT    NUMERIC(15, 5)  NO 
Name: Pay Currency Expense Amount. Description: The net expense in the pay currency. , (INCURRED – OTHER).
 
BASE_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Base Currency Ceiling Amount. Description: The ceiling amount in system base currency.
 
BASE_EXPENSE_AMT    NUMERIC(15, 5)  NO 
Name: Base Currency Expense Amount. Description: The net expense in the system base currency. , (INCURRED – OTHER).
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(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.
 
INCIDENTAL_FL    VARCHAR(1)  NO 
Name: Incidental Flag. Description: Logical as to whether expense included incidentals.
 
TRANS_BREAKFAST_AMT    NUMERIC(15, 5)  NO 
 
TRANS_LUNCH_AMT    NUMERIC(15, 5)  NO 
 
TRANS_DINNER_AMT    NUMERIC(15, 5)  NO 
 
TRANS_INCIDENTAL_AMT    NUMERIC(15, 5)  NO 
 
BASE_BREAKFAST_AMT    NUMERIC(15, 5)  NO 
 
BASE_LUNCH_AMT    NUMERIC(15, 5)  NO 
 
BASE_DINNER_AMT    NUMERIC(15, 5)  NO 
 
BASE_INCIDENTAL_AMT    NUMERIC(15, 5)  NO 
 
PAY_BREAKFAST_AMT    NUMERIC(15, 5)  NO 
 
PAY_LUNCH_AMT    NUMERIC(15, 5)  NO 
 
PAY_DINNER_AMT    NUMERIC(15, 5)  NO 
 
PAY_INCIDENTAL_AMT    NUMERIC(15, 5)  NO 
 
TRANS_DAILY_ROOM_RATE    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Daily Room Rate Description: The daily room rate in transaction currency.
 
TRANS_DAILY_TAX_RATE    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Daily Tax Rate  Description: The daily room tax rate in transaction currency.
 
TRANS_ADJUST_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in transaction currency.
 
TRANS_ADJUST_UNDER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in transaction currency.
 
TRANS_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Over Ceiling Amount  Description: The over ceiling amount in transaction currency.
 
TRANS_UNALLOWABLE_AMT    NUMERIC(15, 5)  NO 
Name: Daily Transaction Currency Unallowable Amount  Description: The unallowable amount in transaction currency.
 
TRANS_NON_REIMBURSE_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in transaction currency.
 
ADJUSTMENT_REASON_TEXT    VARCHAR(254)  YES 
 
BASE_DAILY_ROOM_RATE    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Daily Room Rate  Description: The daily room rate in system base currency.
 
BASE_DAILY_TAX_RATE    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Daily Tax Rate  Description: The daily room tax rate in system base currency.
 
BASE_ADJUST_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in system base currency.
 
BASE_ADJUST_UNDER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in system base currency.
 
BASE_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Over Ceiling Amount  Description: The over ceiling amount in system base currency.
 
BASE_UNALLOWABLE_AMT    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Unallowable Amount  Description: The unallowable amount in system base currency.
 
BASE_NON_REIMBURSE_AMT    NUMERIC(15, 5)  NO 
Name: Daily Base Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in system base currency.
 
PAY_DAILY_ROOM_RATE    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Daily Room Rate  Description: The daily room rate in pay currency.
 
PAY_DAILY_TAX_RATE    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Daily Tax Rate  Description: The daily room tax rate in pay currency.
 
PAY_ADJUST_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in pay currency.
 
PAY_ADJUST_UNDER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in pay currency.
 
PAY_OVER_CEILING_AMT    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Over Ceiling Amount  Description: The over ceiling amount in pay currency.
 
PAY_UNALLOWABLE_AMT    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Unallowable Amount  Description: The unallowable amount in pay currency.
 
PAY_NON_REIMBURSE_AMT    NUMERIC(15, 5)  NO 
Name: Daily Pay Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in pay currency.
 
PERSONAL_FL    VARCHAR(1)  NO 
Name: Personal Flag Description: Logical as to whether this transaction is a personal expense.
 
TRANS_PERSONAL_AMT    NUMERIC(15, 5)  NO 
 
BASE_PERSONAL_AMT    NUMERIC(15, 5)  NO 
 
PAY_PERSONAL_AMT    NUMERIC(15, 5)  NO 
 

CORRECT_EXP_RPT_EXPENSE_DAY Keys 
Key Name  Key Type  Keys 
RI_F00428  Inversion Entry  EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID 
PI_0290  PrimaryKey  EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID, EXP_DT 

CORRECT_EXP_RPT_EXPENSE_DAY Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CORRECT_EXP_RPT_EXPENSE  Identifying  One To Zero or More        EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype