Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR(10) |
YES |
Name: Expense Authorization ID Description: The unique identifier for the expense authorization. |
LOCATION_ID |
|
VARCHAR(40) |
YES |
Name: Location ID Description: Unique Identifier for Location. |
DISPLAY_LOCATION_NO |
|
NUMERIC(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 |
|
VARCHAR(254) |
YES |
Name: Location Comments ID Description: Comments for the location. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
|
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
LOCATION_NO |
|
NUMERIC(10, 0) |
YES |
|