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