EXP_AUTH |
Default Table Name | EXP_AUTH |
Definition |
EXP_AUTH Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EXP_AUTH_ID![]() |
VARCHAR2(10) | NO | ||
EMPL_ID![]() |
VARCHAR2(20) | NO | ||
EXP_AUTH_DESC | VARCHAR2(30) | NO | ||
EXP_AUTH_DT | DATE | NO | ||
REVISION_NO | NUMBER(10, 0) | NO | ||
S_EXP_AUTH_STATUS_CD | VARCHAR2(1) | NO | ||
START_DT | DATE | NO | ||
END_DT | DATE | NO | ||
PURPOSE_TEXT | VARCHAR2(4000) | YES | ||
PER_DIEM_SCHEDULE_CD![]() |
VARCHAR2(10) | YES | ||
CURRENCY_SCHEDULE_CD![]() |
VARCHAR2(10) | YES | ||
EXP_RPT_TYPE_CD![]() |
VARCHAR2(10) | NO | ||
EXP_CLASS_CD![]() |
VARCHAR2(20) | NO | ||
CP_COMPANY_CD![]() |
VARCHAR2(10) | NO | ||
SUBMIT_WARNING_TEXT | VARCHAR2(1000) | YES | ||
PAY_CURRENCY_CD![]() |
VARCHAR2(3) | NO | ||
BASE_CURRENCY_CD![]() |
VARCHAR2(3) | NO | ||
EXP_AUTH_UDT_ID | VARCHAR2(50) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
COPIED_AUTH_FL | VARCHAR2(1) | NO | ||
FIRST_DAY_TRIP_FL | VARCHAR2(1) | NO | ||
LAST_DAY_TRIP_FL | VARCHAR2(1) | NO | ||
SHORT_HEADER_TEXT | VARCHAR2(4000) | YES | ||
BLANKET_AUTH_FL | VARCHAR2(1) | NO | ||
BLANKET_CLOSED_FL | VARCHAR2(1) | NO | ||
PROXY_EMPL_ID | VARCHAR2(20) | YES | ||
FUNCTIONAL_ROLE_CD | VARCHAR2(15) | YES |
EXP_AUTH Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0240 | PrimaryKey | EXP_AUTH_ID |
EXP_AUTH Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
CP_COMPANY | Non-Identifying | One To Zero or More | F00347 | CP_COMPANY_CD | NO | NO | NO | ||
CURRENCY | Non-Identifying | One To Zero or More | F00348 | PAY_CURRENCY_CD | NO | NO | NO | ||
CURRENCY | Non-Identifying | One To Zero or More | F00349 | BASE_CURRENCY_CD | NO | NO | NO | ||
CURRENCY_SCHEDULE | Non-Identifying | Zero or One to Zero or More | F00350 | CURRENCY_SCHEDULE_CD | NO | NO | NO | ||
EMPL | Non-Identifying | One To Zero or More | F00351 | EMPL_ID | NO | NO | NO | ||
EXP_CLASS | Non-Identifying | One To Zero or More | F00352 | EXP_CLASS_CD | NO | NO | NO | ||
EXP_RPT_TYPE | Non-Identifying | One To Zero or More | F00353 | EXP_RPT_TYPE_CD | NO | NO | NO | ||
PER_DIEM | Non-Identifying | Zero or One to Zero or More | F00354 | PER_DIEM_SCHEDULE_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EXP_RPT | Non-Identifying | One To Zero or More | F00346 | NO | NO | NO | |||
EXP_AUTH_CHARGE_ALLOCATIONS | Identifying | One To Zero or More | F00357 | NO | NO | NO | |||
EXP_AUTH_EXPENSE | Identifying | One To Zero or More | F00359 | NO | NO | NO | |||
EXP_AUTH_REVISION | Identifying | One To Zero or More | F00366 | NO | NO | NO | |||
DESKTOP_AUTH_TASKS | Identifying | One To Zero or More | F00372 | NO | NO | NO | |||
ADVANCE_OUTSTANDING | Non-Identifying | One To Zero or More | F00374 | NO | NO | NO | |||
EXP_AUTH_LOCATION | Identifying | One To Zero or More | F00445 | NO | NO | NO | |||
EXP_ADVANCE | Non-Identifying | One To Zero or More | F00501 | NO | NO | NO | |||
TASK | Non-Identifying | One To Zero or More | F00506 | NO | NO | NO | |||
CORRECT_TASK | Non-Identifying | One To Zero or More | F00515 | NO | NO | NO | |||
EXP_AUTH_WARNING | Identifying | One To Zero or More | F00524 | NO | NO | NO | |||
EXP_RPT_ATTACHMENT | Non-Identifying | One To Zero or More | F00577 | NO | NO | NO |