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]

VIEW: HR.GHR_PA_REQUEST_SHADOW#

Object Details

Object Name:	GHR_PA_REQUEST_SHADOW#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PA_REQUEST_ID	NUMBER	(15)	Yes
ACADEMIC_DISCIPLINE	VARCHAR2	(30)
ANNUITANT_INDICATOR	VARCHAR2	(30)
APPROPRIATION_CODE1	VARCHAR2	(30)
APPROPRIATION_CODE2	VARCHAR2	(30)
BARGAINING_UNIT_STATUS	VARCHAR2	(30)
CITIZENSHIP	VARCHAR2	(30)
DUTY_STATION_ID	NUMBER	(15)
DUTY_STATION_LOCATION_ID	NUMBER	(15)
EDUCATION_LEVEL	VARCHAR2	(30)
EMPLOYEE_DATE_OF_BIRTH	DATE
EMPLOYEE_FIRST_NAME	VARCHAR2	(150)
EMPLOYEE_LAST_NAME	VARCHAR2	(150)
EMPLOYEE_MIDDLE_NAMES	VARCHAR2	(60)
EMPLOYEE_NATIONAL_IDENTIFIER	VARCHAR2	(30)
FEGLI	VARCHAR2	(30)
FLSA_CATEGORY	VARCHAR2	(30)
FORWARDING_ADDRESS_LINE1	VARCHAR2	(240)
FORWARDING_ADDRESS_LINE2	VARCHAR2	(240)
FORWARDING_ADDRESS_LINE3	VARCHAR2	(240)
FORWARDING_COUNTRY_SHORT_NAME	VARCHAR2	(80)
FORWARDING_POSTAL_CODE	VARCHAR2	(30)
FORWARDING_REGION_2	VARCHAR2	(120)
FORWARDING_TOWN_OR_CITY	VARCHAR2	(30)
FUNCTIONAL_CLASS	VARCHAR2	(30)
PART_TIME_HOURS	NUMBER	(5)
PAY_RATE_DETERMINANT	VARCHAR2	(30)
POSITION_OCCUPIED	VARCHAR2	(30)
RETIREMENT_PLAN	VARCHAR2	(30)
SERVICE_COMP_DATE	DATE
SUPERVISORY_STATUS	VARCHAR2	(30)
TENURE	VARCHAR2	(30)
TO_AP_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)
TO_AUO_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)
TO_OCC_CODE	VARCHAR2	(30)
TO_POSITION_ID	NUMBER	(15)
TO_RETENTION_ALLOWANCE	NUMBER	(15)
TO_RETENTION_ALLOW_PERCENTAGE	NUMBER	(5)
TO_STAFFING_DIFFERENTIAL	NUMBER	(15)
TO_STAFFING_DIFF_PERCENTAGE	NUMBER	(5)
TO_STEP_OR_RATE	VARCHAR2	(30)
TO_SUPERVISORY_DIFFERENTIAL	NUMBER	(15)
TO_SUPERVISORY_DIFF_PERCENTAGE	NUMBER	(5)
VETERANS_PREFERENCE	VARCHAR2	(30)
VETERANS_PREF_FOR_RIF	VARCHAR2	(30)
VETERANS_STATUS	VARCHAR2	(30)
WORK_SCHEDULE	VARCHAR2	(30)
YEAR_DEGREE_ATTAINED	NUMBER	(4)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
AWARD_AMOUNT	NUMBER	(15)
AWARD_UOM	VARCHAR2	(30)
AWARD_PERCENTAGE	NUMBER	(5)
TO_GRADE_OR_LEVEL	VARCHAR2	(30)
TO_GRADE_ID	NUMBER	(15)
FIRST_ACTION_LA_CODE1	VARCHAR2	(30)
FIRST_ACTION_LA_CODE2	VARCHAR2	(30)
SECOND_ACTION_LA_CODE1	VARCHAR2	(30)
SECOND_ACTION_LA_CODE2	VARCHAR2	(30)

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# references the following:

HR: GHR_PA_REQUEST_SHADOW

HR.GHR_PA_REQUEST_SHADOW# is referenced by following:

APPS: GHR_PA_REQUEST_SHADOW; GHR_PA_REQUEST_SHADOW_WHO