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(PK)    VARCHAR(40)  NO 
Name: Location ID Description: Unique Identifier for Location.
 
LOCATION_EMPL_ID(FK)    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