ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expene Type. Description: The expense type unique identifier. |
EFFECTIVE_DT |
|
DATE |
NO |
Name: Effective Date. Description: Date the rate/ceiling is effective. |
UNIT_RATE |
|
NUMBER(15, 5) |
NO |
Name: Unit Rate. Description: Amount reimbursed per unit. |
CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Ceiling Amount. Description: Amount that the reimbursement cannot go over. |
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. |
CEILING_BREAKFAST_AMT |
|
NUMBER(15, 5) |
NO |
Name: Breakfast Ceiling Amount. Description: Amount that the reimbursement for breakfast cannot go over. |
CEILING_LUNCH_AMT |
|
NUMBER(15, 5) |
NO |
Name: Lunch Ceiling Amount. Description: Amount that the reimbursement for lunch cannot go over. |
CEILING_DINNER_AMT |
|
NUMBER(15, 5) |
NO |
Name: Dinner Ceiling Amount. Description: Amount that the reimbursement for dinner cannot go over. |
CEILING_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Incidentals Ceiling Amount. Description: Amount that the reimbursement for incidentals cannot go over. |
CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: Currency Code. Description: The currency that should be used for this rate. |