LOCATION |
Default Table Name | LOCATION |
Definition | Name: Locations Description: This table contains the various locations that are used while planning or recording expenses. Employees can mark some of the locations as frequent locations. The frequent locations are saved per employee. |
LOCATION Columns |
ColumnName | Domain | Datatype | NULL | Definition |
LOCATION_ID![]() |
VARCHAR2(40) | NO | Name: Location ID Description: Unique Identifier for Location. |
|
LOCATION_EMPL_ID![]() |
VARCHAR2(20) | YES | Name: Location’s Employee ID Description: The employee ID when employee favorite. Otherwise Null. |
|
ACTIVE_FL | VARCHAR2(1) | NO | Name: Active Indicator Description: Indicator as to whether location is active. |
|
LOCATION_DESC | VARCHAR2(30) | NO | Name: Location Description: User provided description for the location. |
|
LOCATION_TEXT | VARCHAR2(254) | YES | Name: Location Comments Description: Comments for the location. This is a default. |
|
COUNTRY_NAME | VARCHAR2(45) | YES | Name: Country Name Description: The name of the country for the schedule location. |
|
STATE_NAME | VARCHAR2(35) | YES | Name: State Name Description: The name of the state for the schedule location. |
|
CITY_NAME | VARCHAR2(35) | YES | Name: City Name Description: The name of the city for the schedule location. |
|
COUNTY_NAME | VARCHAR2(35) | YES | Name: County Name Description: The name of the county for the schedule location. |
|
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO |
LOCATION Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0301 | PrimaryKey | LOCATION_ID |
LOCATION Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable |
EMPL | Non-Identifying | Zero or One to Zero or More | F00442 | LOCATION_EMPL_ID | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable |
EXP_AUTH_EXPENSE | Non-Identifying | One To Zero or More | F00443 | NO | NO | |||
EXP_RPT_EXPENSE | Non-Identifying | One To Zero or More | F00444 | NO | NO | |||
EXP_AUTH_LOCATION | Non-Identifying | One To Zero or More | F00446 | NO | NO | |||
EXP_RPT_LOCATION | Non-Identifying | One To Zero or More | F00448 | NO | NO | |||
CORRECT_EXP_RPT_LOCATION | Non-Identifying | One To Zero or More | F00450 | NO | NO |