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: GHR_PA_REQUESTS

Product:	GHR - US Federal Human Resources
Description:	Stores all the information about the Request to Personnel Action.
Implementation/DBA Data:	HR.GHR_PA_REQUESTS

Primary Key: GHR_PA_REQUESTS_PK

PA_REQUEST_ID

Primary Key: GHR_PA_REQUESTS_UK1

PA_NOTIFICATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
GHR_PA_REQUESTS	GHR_FAMILIES	GHR_PA_REQUESTS.NOA_FAMILY_CODE
GHR_PA_REQUESTS	GHR_ROUTING_GROUPS	GHR_PA_REQUESTS.ROUTING_GROUP_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PAY_PLANS	GHR_PA_REQUESTS.FROM_PAY_PLAN
GHR_PA_REQUESTS	GHR_NATURE_OF_ACTIONS	GHR_PA_REQUESTS.FIRST_NOA_ID
GHR_PA_REQUESTS	GHR_NATURE_OF_ACTIONS	GHR_PA_REQUESTS.SECOND_NOA_ID
GHR_PA_REQUESTS	GHR_PAY_PLANS	GHR_PA_REQUESTS.TO_PAY_PLAN
GHR_PA_REQUESTS	PER_JOBS	GHR_PA_REQUESTS.TO_JOB_ID
GHR_PA_REQUESTS	PER_GRADES	GHR_PA_REQUESTS.TO_GRADE_ID
GHR_PA_REQUESTS	HR_ALL_ORGANIZATION_UNITS	GHR_PA_REQUESTS.TO_ORGANIZATION_ID
GHR_PA_REQUESTS	GHR_POIS	GHR_PA_REQUESTS.PERSONNEL_OFFICE_ID
GHR_PA_REQUESTS	GHR_PA_REQUEST_SHADOW	GHR_PA_REQUESTS.GHR_PA_REQUESTS_PA_REQUEST_ID
GHR_EVENTS	GHR_PA_REQUESTS	GHR_EVENTS.GHR_EVENTS_PA_REQUEST_ID
GHR_MASS_REALIGNMENT	GHR_PA_REQUESTS	GHR_MASS_REALIGNMENT.PA_REQUEST_ID
GHR_MASS_SALARIES	GHR_PA_REQUESTS	GHR_MASS_SALARIES.PA_REQUEST_ID
GHR_MASS_TRANSFERS	GHR_PA_REQUESTS	GHR_MASS_TRANSFERS.PA_REQUEST_ID
GHR_PA_HISTORY	GHR_PA_REQUESTS	GHR_PA_HISTORY.PA_REQUEST_ID
GHR_PA_HISTORY	GHR_PA_REQUESTS	GHR_PA_HISTORY.ALTERED_PA_REQUEST_ID
GHR_PA_REMARKS	GHR_PA_REQUESTS	GHR_PA_REMARKS.PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID
GHR_PA_REQUESTS	GHR_PA_REQUESTS	GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID
GHR_PA_REQUEST_EI_SHADOW	GHR_PA_REQUESTS	GHR_PA_REQUEST_EI_SHADOW.PA_REQUEST_ID
GHR_PA_REQUEST_EXTRA_INFO	GHR_PA_REQUESTS	GHR_PA_REQUEST_EXTRA_INFO.PA_REQUEST_ID
GHR_PA_ROUTING_HISTORY	GHR_PA_REQUESTS	GHR_PA_ROUTING_HISTORY.PA_REQUEST_ID