eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_LOCATIONS

Product:	PA - Projects
Description:	This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project or a team role. There would be no way for user to enter new locations into this table
Implementation/DBA Data:	PA.PA_LOCATIONS

Primary Key: PA_LOCATIONS_PK

LOCATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_ASGMTS_HSTRY_AR	PA_LOCATIONS	PA_ASGMTS_HSTRY_AR.LOCATION_ID
PA_ASSIGNMENTS_HISTORY	PA_LOCATIONS	PA_ASSIGNMENTS_HISTORY.LOCATION_ID
PA_PROJECTS_ALL	PA_LOCATIONS	PA_PROJECTS_ALL.LOCATION_ID
PA_PROJECTS_ALL	PA_LOCATIONS	PA_PROJECTS_ALL.LOCATION_ID
PA_PROJECT_ASGMTS_AR	PA_LOCATIONS	PA_PROJECT_ASGMTS_AR.LOCATION_ID
PA_PROJECT_ASSIGNMENTS	PA_LOCATIONS	PA_PROJECT_ASSIGNMENTS.LOCATION_ID
PA_PROJ_ELEMENTS	PA_LOCATIONS	PA_PROJ_ELEMENTS.LOCATION_ID