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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.GHR_PA_REQUEST_SHADOW

Object Details

Object Name:	GHR_PA_REQUEST_SHADOW
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_PA_REQUEST_SHADOW
Subobject Name:
Status:	VALID

Stores all the columns of the corresponding record of GHR_PA_REQUESTS,
that have a potential to be refreshed. It stores only the
auotpopulated values for the corresponding columns and not the
values altered by the user on the RPA, so that it can be later on used
for comparisions to determine whehter or not to refresh the column on
the GHR_PA_REQUESTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: GHR_PA_REQUEST_SHADOW_PK

PA_REQUEST_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_PA_REQUEST_SHADOW_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PA_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PA_REQUEST_ID	NUMBER	(15)	Yes	Foreign key to GHR_PA_REQUESTS.
ACADEMIC_DISCIPLINE	VARCHAR2	(30)		Academic discipline.
ANNUITANT_INDICATOR	VARCHAR2	(30)		Annuitant indicator.
APPROPRIATION_CODE1	VARCHAR2	(30)		Appropriation code 1.
APPROPRIATION_CODE2	VARCHAR2	(30)		Appropriation code 2.
BARGAINING_UNIT_STATUS	VARCHAR2	(30)		Bargaining unit status.
CITIZENSHIP	VARCHAR2	(30)		Citizenship.
DUTY_STATION_ID	NUMBER	(15)		Foreign key to GHR_DUTY_STATIONS.
DUTY_STATION_LOCATION_ID	NUMBER	(15)		Foreign key to HR_LOCATIONS.
EDUCATION_LEVEL	VARCHAR2	(30)		Education level.
EMPLOYEE_DATE_OF_BIRTH	DATE			Employee's Date Of Birth
EMPLOYEE_FIRST_NAME	VARCHAR2	(150)		Employee's First Name
EMPLOYEE_LAST_NAME	VARCHAR2	(150)		Employee's Last Name
EMPLOYEE_MIDDLE_NAMES	VARCHAR2	(60)		Employee's Middle Names
EMPLOYEE_NATIONAL_IDENTIFIER	VARCHAR2	(30)		Employee's National Identifier
FEGLI	VARCHAR2	(30)		Federal employee?s group life insurance.
FLSA_CATEGORY	VARCHAR2	(30)		Fair labor standards act.
FORWARDING_ADDRESS_LINE1	VARCHAR2	(240)		Forwarding address line 1.
FORWARDING_ADDRESS_LINE2	VARCHAR2	(240)		Forwarding address line 2.
FORWARDING_ADDRESS_LINE3	VARCHAR2	(240)		Forwarding address line 3.
FORWARDING_COUNTRY_SHORT_NAME	VARCHAR2	(80)		Forwarding country short name.
FORWARDING_POSTAL_CODE	VARCHAR2	(30)		Forwarding postal code.
FORWARDING_REGION_2	VARCHAR2	(120)		Forwarding region 2.
FORWARDING_TOWN_OR_CITY	VARCHAR2	(30)		Forwarding town or city.
FUNCTIONAL_CLASS	VARCHAR2	(30)		Functional class.
PART_TIME_HOURS	NUMBER	(5)		Part-time hours.
PAY_RATE_DETERMINANT	VARCHAR2	(30)		Pay rate determinant.
POSITION_OCCUPIED	VARCHAR2	(30)		Position occupied.
RETIREMENT_PLAN	VARCHAR2	(30)		Retirement plan.
SERVICE_COMP_DATE	DATE			Service computation date.
SUPERVISORY_STATUS	VARCHAR2	(30)		Supervisory status.
TENURE	VARCHAR2	(30)		Tenure.
TO_AP_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)		To Availability Premium Pay Indicator
TO_AUO_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)		To authorized uncontrollable overtime premium pay indicator.
TO_OCC_CODE	VARCHAR2	(30)		To occupational code.
TO_POSITION_ID	NUMBER	(15)		Foreign key to PER_POSITIONS.
TO_RETENTION_ALLOWANCE	NUMBER	(15)		To retention allowance.
TO_RETENTION_ALLOW_PERCENTAGE	NUMBER	(5)		To retention allowance percentage.
TO_STAFFING_DIFFERENTIAL	NUMBER	(15)		To staffing differential.
TO_STAFFING_DIFF_PERCENTAGE	NUMBER	(5)		To staffing differential percentage
TO_STEP_OR_RATE	VARCHAR2	(30)		To step or rate.
TO_SUPERVISORY_DIFFERENTIAL	NUMBER	(15)		To supervisory differential.
TO_SUPERVISORY_DIFF_PERCENTAGE	NUMBER	(5)		To supervisory differential percentage.
VETERANS_PREFERENCE	VARCHAR2	(30)		Veteran?s preference.
VETERANS_PREF_FOR_RIF	VARCHAR2	(30)		Veteran?s preference for reduction in force.
VETERANS_STATUS	VARCHAR2	(30)		Veteran?s status.
WORK_SCHEDULE	VARCHAR2	(30)		Work schedule.
YEAR_DEGREE_ATTAINED	NUMBER	(4)		Year degree attained.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
AWARD_AMOUNT	NUMBER	(15)		Award Amount
AWARD_UOM	VARCHAR2	(30)		Award Unit of Measurement
AWARD_PERCENTAGE	NUMBER	(5)		Award Percentage
TO_GRADE_OR_LEVEL	VARCHAR2	(30)		To Grade or Level
TO_GRADE_ID	NUMBER	(15)		To Grade Id
FIRST_ACTION_LA_CODE1	VARCHAR2	(30)		First NOA LA Code1
FIRST_ACTION_LA_CODE2	VARCHAR2	(30)		First NOA LA Code2
SECOND_ACTION_LA_CODE1	VARCHAR2	(30)		Second NOA La code1
SECOND_ACTION_LA_CODE2	VARCHAR2	(30)		Second NOA LA Code2

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PA_REQUEST_ID
,      ACADEMIC_DISCIPLINE
,      ANNUITANT_INDICATOR
,      APPROPRIATION_CODE1
,      APPROPRIATION_CODE2
,      BARGAINING_UNIT_STATUS
,      CITIZENSHIP
,      DUTY_STATION_ID
,      DUTY_STATION_LOCATION_ID
,      EDUCATION_LEVEL
,      EMPLOYEE_DATE_OF_BIRTH
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_MIDDLE_NAMES
,      EMPLOYEE_NATIONAL_IDENTIFIER
,      FEGLI
,      FLSA_CATEGORY
,      FORWARDING_ADDRESS_LINE1
,      FORWARDING_ADDRESS_LINE2
,      FORWARDING_ADDRESS_LINE3
,      FORWARDING_COUNTRY_SHORT_NAME
,      FORWARDING_POSTAL_CODE
,      FORWARDING_REGION_2
,      FORWARDING_TOWN_OR_CITY
,      FUNCTIONAL_CLASS
,      PART_TIME_HOURS
,      PAY_RATE_DETERMINANT
,      POSITION_OCCUPIED
,      RETIREMENT_PLAN
,      SERVICE_COMP_DATE
,      SUPERVISORY_STATUS
,      TENURE
,      TO_AP_PREMIUM_PAY_INDICATOR
,      TO_AUO_PREMIUM_PAY_INDICATOR
,      TO_OCC_CODE
,      TO_POSITION_ID
,      TO_RETENTION_ALLOWANCE
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_STAFFING_DIFFERENTIAL
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_STEP_OR_RATE
,      TO_SUPERVISORY_DIFFERENTIAL
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      VETERANS_PREFERENCE
,      VETERANS_PREF_FOR_RIF
,      VETERANS_STATUS
,      WORK_SCHEDULE
,      YEAR_DEGREE_ATTAINED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      AWARD_AMOUNT
,      AWARD_UOM
,      AWARD_PERCENTAGE
,      TO_GRADE_OR_LEVEL
,      TO_GRADE_ID
,      FIRST_ACTION_LA_CODE1
,      FIRST_ACTION_LA_CODE2
,      SECOND_ACTION_LA_CODE1
,      SECOND_ACTION_LA_CODE2
FROM HR.GHR_PA_REQUEST_SHADOW;

Dependencies

[top of page]

HR.GHR_PA_REQUEST_SHADOW does not reference any database object

HR.GHR_PA_REQUEST_SHADOW is referenced by following:

HR: GHR_PA_REQUEST_SHADOW#