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 Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
LOCATION_ID![]() |
VARCHAR(40) | NO | Name: Location ID Description: Unique Identifier for Location. |
|
LOCATION_EMPL_ID![]() |
VARCHAR(20) | YES | Name: Location’s Employee ID Description: The employee ID when employee favorite. Otherwise Null. |
|
ACTIVE_FL | VARCHAR(1) | NO | Name: Active Indicator Description: Indicator as to whether location is active. |
|
LOCATION_DESC | VARCHAR(30) | NO | Name: Location Description: User provided description for the location. |
|
LOCATION_TEXT | VARCHAR(254) | YES | Name: Location Comments Description: Comments for the location. This is a default. |
|
COUNTRY_NAME | VARCHAR(45) | YES | Name: Country Name Description: The name of the country for the schedule location. |
|
STATE_NAME | VARCHAR(35) | YES | Name: State Name Description: The name of the state for the schedule location. |
|
CITY_NAME | VARCHAR(35) | YES | Name: City Name Description: The name of the city for the schedule location. |
|
COUNTY_NAME | VARCHAR(35) | YES | Name: County Name Description: The name of the county for the schedule location. |
|
MODIFIED_BY | VARCHAR(20) | NO | ||
ROWVERSION | NUMERIC(10, 0) | NO | ||
TIME_STAMP | DATE | NO |
LOCATION Keys |
Key Name | Key Type | Keys |
PI_0301 | PrimaryKey | LOCATION_ID |
LOCATION Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
EMPL | Non-Identifying | Zero or One to Zero or More | LOCATION_EMPL_ID | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
EXP_AUTH_EXPENSE | Non-Identifying | One To Zero or More | NO | ||||
EXP_RPT_EXPENSE | Non-Identifying | One To Zero or More | NO | ||||
EXP_AUTH_LOCATION | Non-Identifying | Zero or One to Zero or More | NO | ||||
EXP_RPT_LOCATION | Non-Identifying | One To Zero or More | NO | ||||
CORRECT_EXP_RPT_LOCATION | Non-Identifying | One To Zero or More | NO |