EXP_TYPE |
Default Table Name | EXP_TYPE |
Definition |
EXP_TYPE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EXP_TYPE_CD![]() |
VARCHAR2(10) | NO | ||
EXP_TYPE_DESC | VARCHAR2(30) | NO | ||
EXP_CATEGORY_CD | VARCHAR2(10) | NO | ||
PROVIDER_REQUIRED_FL | VARCHAR2(1) | NO | ||
PER_DIEM_FL | VARCHAR2(1) | NO | ||
S_PER_DIEM_USE_CD | VARCHAR2(10) | YES | ||
TICKET_NUMBER_REQUIRED_FL | VARCHAR2(1) | NO | ||
MEAL_REQUIRED_FL | VARCHAR2(1) | NO | ||
ODOMETER_MILES_REQUIRED_FL | VARCHAR2(1) | NO | ||
ATTENDEE_REQUIRED_FL | VARCHAR2(1) | NO | ||
UNIT_LBL | VARCHAR2(10) | YES | ||
AP_1099_FL | VARCHAR2(1) | NO | ||
AP_1099_TYPE_CD | VARCHAR2(6) | YES | ||
RELOCATION_FL | VARCHAR2(1) | NO | ||
RELOCATION_CD | VARCHAR2(6) | YES | ||
W2_FL | VARCHAR2(1) | NO | ||
W2_CD | VARCHAR2(6) | YES | ||
OVERRIDE_RATE_FL | VARCHAR2(1) | NO | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
MULTI_DAY_FL | VARCHAR2(1) | NO | ||
OVER_CEILING_REQUIRED_FL | VARCHAR2(1) | NO | ||
ITINERARY_REQUIRED_FL | VARCHAR2(1) | NO | ||
UNALLOWABLE_REQUIRED_FL | VARCHAR2(1) | NO | ||
S_OVER_CEILING_CD | VARCHAR2(1) | NO | ||
DESC_CATEGORY_FL | VARCHAR2(1) | NO | ||
DESC_EXPENSE_TYPE_FL | VARCHAR2(1) | NO | ||
DESC_PROVIDER_FL | VARCHAR2(1) | NO | ||
DESC_EXPENSE_DATE_FL | VARCHAR2(1) | NO | ||
DESC_START_END_DATE_FL | VARCHAR2(1) | NO | ||
DESC_TICKET_NUMBER_FL | VARCHAR2(1) | NO | ||
DESC_ITINERARY_FL | VARCHAR2(1) | NO | ||
COMBINE_PER_DIEM_FL | VARCHAR2(1) | NO | ||
BREAKFAST_FL | VARCHAR2(1) | NO | ||
LUNCH_FL | VARCHAR2(1) | NO | ||
DINNER_FL | VARCHAR2(1) | NO | ||
DESC_EMPL_ID_FL | VARCHAR2(1) | NO | ||
DESC_EXP_RPT_ID_FL | VARCHAR2(1) | NO | ||
SECOND_TIER_CEILING_FL | VARCHAR2(1) | NO | ||
S_TYPE_CD | VARCHAR2(10) | NO | ||
CODE1_REQUIRED_FL | VARCHAR2(1) | NO | ||
CODE2_REQUIRED_FL | VARCHAR2(1) | NO | ||
CODE3_REQUIRED_FL | VARCHAR2(1) | NO | ||
DESC_CODE1_FL | VARCHAR2(1) | NO | ||
DESC_CODE2_FL | VARCHAR2(1) | NO | ||
DESC_CODE3_FL | VARCHAR2(1) | NO | ||
CODE1_VALIDATE_FL | VARCHAR2(1) | NO | ||
CODE2_VALIDATE_FL | VARCHAR2(1) | NO | ||
CODE3_VALIDATE_FL | VARCHAR2(1) | NO | ||
REQUIRE_TITLE_COMPANY_FL | VARCHAR2(1) | NO | ||
SUPPRESS_ATTENDEE_EMPL_ID_FL | VARCHAR2(1) | NO | ||
S_UNIT_DECIMAL_NO_CD | VARCHAR2(1) | NO | ||
INCIDENTAL_FL | VARCHAR2(1) | NO | ||
TRACK_MULTIPLE_LOCATIONS_FL | VARCHAR2(1) | NO | ||
LOCATION_REQUIRED_FL | VARCHAR2(1) | NO | ||
UNALLOWABLE_EXPL_REQUIRED_FL | VARCHAR2(1) | NO | ||
OVERRIDE_FIRST_LAST_DAY_FL | VARCHAR2(1) | NO | ||
CONFERENCE_ADJUST_PCT | NUMBER(3, 2) | NO | ||
ALLOW_DATE_EDIT_FL | VARCHAR2(1) | NO | ||
S_CEILING_CALCULATION_CD | VARCHAR2(10) | NO | ||
S_ENTER_ATTENDEES_CD | VARCHAR2(10) | YES | ||
S_CEILING_CALC_METHOD_CD | VARCHAR2(10) | NO | ||
PER_DIEM_ADJUST_PCT | NUMBER(3, 2) | NO |
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 | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EXP_TYPE_RATE_CEILING | Identifying | One To Zero or More | F00153 | NO | NO | NO | |||
EXP_TYPE_EXP_CHARGE_TYPE | Identifying | One To Zero or More | F00182 | NO | NO | NO | |||
EXP_TYPE_LABELS | Identifying | One To Zero or More | F00187 | NO | NO | NO | |||
EXP_TYPE_OTHER | Identifying | One To Zero or More | F00189 | NO | NO | NO | |||
EXP_TYPE_PROVIDER | Identifying | One To Zero or More | F00272 | NO | NO | NO | |||
EXP_TYPE_PAY_METHOD | Identifying | One To Zero or More | F00274 | NO | NO | NO | |||
EXP_TYPE_CODE1 | Identifying | One To Zero or More | F00276 | NO | NO | NO | |||
EXP_TYPE_CODE2 | Identifying | One To Zero or More | F00277 | NO | NO | NO | |||
EXP_TYPE_CODE3 | Identifying | One To Zero or More | F00278 | NO | NO | NO | |||
EXP_RPT_TYPE_CATEGORY_EXP_TYPE | Identifying | One To Zero or More | F00284 | NO | NO | NO | |||
EXP_TYPE_OTHER | Non-Identifying | One To Zero or More | F00311 | NO | NO | NO | |||
EXP_RPT_EXPENSE | Non-Identifying | One To Zero or More | F00341 | NO | NO | NO | |||
EXP_AUTH_EXPENSE | Non-Identifying | One To Zero or More | F00362 | NO | NO | NO | |||
EXP_TYPE_TASK | Identifying | One To Zero or More | F00455 | NO | NO | NO | |||
BATCH_EXPENSE_OUTSTANDING | Non-Identifying | One To Zero or More | F00549 | NO | NO | NO |