TEMP_EXP_AUTH_LOCATION |
Default Table Name | TEMP_EXP_AUTH_LOCATION |
Definition | Name: Expense Authorization Locations Description: This table contains temporary details regarding each expense that is used on an expense authorization. This is a temporary table that is populated pre-save for use with pre-save stored procedure. Table shall never have any permanent data. |
TEMP_EXP_AUTH_LOCATION Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EXP_AUTH_ID | VARCHAR2(10) | YES | Name: Expense Authorization ID Description: The unique identifier for the expense authorization. |
|
LOCATION_ID | VARCHAR2(40) | YES | Name: Location ID Description: Unique Identifier for Location. |
|
DISPLAY_LOCATION_NO | NUMBER(10, 0) | YES | Name: Location Sequence ID Description: The sequence of the location based on dates. |
|
START_DT | DATE | YES | Name: Start Date Description: Start date for employee being in this location. |
|
END_DT | DATE | YES | Name: End Date ID Description: End date for employee being in this location.. |
|
LOCATION_TEXT | VARCHAR2(254) | YES | Name: Location Comments ID Description: Comments for the location. |
|
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
LOCATION_NO | NUMBER(10, 0) | YES |
TEMP_EXP_AUTH_LOCATION Primary and Unique Keys |
Key Name | Key Type | Keys |
TEMP_EXP_AUTH_LOCATION 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 |