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: APPS.GHR_PA_REQUESTS_V

Object Details

Object Name:	GHR_PA_REQUESTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_PA_REQUESTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PA_REQUEST_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_PA_REQUESTS_S.
ROW_ID	ROWID	(10)		Row ID
NOA_FAMILY_CODE	VARCHAR2	(30)	Yes	Nature of action family code.
ACTION_REQUESTED	VARCHAR2	(100)	Yes	Action Requested
ROUTING_GROUP_ID	NUMBER	(15)		Foreign key to GHR_ROUTING_GROUPS.
ACADEMIC_DISCIPLINE	VARCHAR2	(30)		Academic discipline.
ADDITIONAL_INFO_PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE_F
ADDITIONAL_INFO_TEL_NUMBER	VARCHAR2	(60)		Telephone Number of the Person for Additional Information
ALTERED_PA_REQUEST_ID	NUMBER	(15)		Foreign Key to PER_PEOPLE_F
ANNUITANT_INDICATOR	VARCHAR2	(30)		Annuitant indicator.
AUTHORIZED_BY_TITLE	VARCHAR2	(240)		Title of authorizer.
APPROPRIATION_CODE1	VARCHAR2	(30)		Appropriation code 1.
APPROPRIATION_CODE2	VARCHAR2	(30)		Appropriation code 2.
AUTHORIZED_BY_PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE_F.
APPROVAL_DATE	DATE			Approval date of the RPA
APPROVING_OFFICIAL_FULL_NAME	VARCHAR2	(240)		Full Name of the RPA Approving Official
APPROVING_OFFICIAL_WORK_TITLE	VARCHAR2	(60)		Work Title of the RPA Approving Official
BARGAINING_UNIT_STATUS	VARCHAR2	(30)		Bargaining unit status.
CITIZENSHIP	VARCHAR2	(30)		Citizenship.
CONCURRENCE_DATE	DATE			Date of concurrence.
CUSTOM_PAY_CALC_FLAG	VARCHAR2	(1)		Flag to indicate if Pay was calculated or need to be entered by user
DUTY_STATION_CODE	VARCHAR2	(9)		Duty station code.
DUTY_STATION_DESC	VARCHAR2	(150)		Description of the duty station.
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.
PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE_F.
EFFECTIVE_DATE	DATE			Effective date of Request for Personnel Action.
EMPLOYEE_NATIONAL_IDENTIFIER	VARCHAR2	(30)		Employee's national identifier.
EMPLOYEE_DATE_OF_BIRTH	DATE			Employee's date of birth.
EMPLOYEE_ASSIGNMENT_ID	NUMBER	(15)		Foreign key to PER_ASSIGNMENTS_F.
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.
FEGLI	VARCHAR2	(30)		Federal employee?s group life insurance.
FIRST_ACTION_LA_CODE1	VARCHAR2	(30)		First action legal authority code 1.
FIRST_ACTION_LA_CODE2	VARCHAR2	(30)		First action legal authority code 2.
FIRST_ACTION_LA_DESC1	VARCHAR2	(240)		Description of the first action legal authority code 1.
FIRST_ACTION_LA_DESC2	VARCHAR2	(240)		Description of the first action legal authority code 2.
FIRST_NOA_CANCEL_OR_CORRECT	VARCHAR2	(10)		Indicates whether First Action has been canceled or corrected.
FIRST_NOA_CODE	VARCHAR2	(4)		First nature of action code.
FIRST_NOA_DESC	VARCHAR2	(240)		Description of the first nature of action code.
FIRST_NOA_ID	NUMBER	(15)		Foreign key to GHR_NATURE_OF_ACTIONS.
FIRST_NOA_PA_REQUEST_ID	NUMBER	(15)		Foreign key to GHR_PA_REQUESTS, request for personnel action for cancellation / correction of first action.
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	VARCHAR2	(60)		Forwarding country.
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.
FROM_ADJ_BASIC_PAY	NUMBER	(15)		From adjusted basic pay.
FROM_AGENCY_CODE	VARCHAR2	(30)		From agency code.
FROM_AGENCY_DESC	VARCHAR2	(80)		Description of the from agency code.
FROM_BASIC_PAY	NUMBER	(15)		From basic pay.
FROM_GRADE_OR_LEVEL	VARCHAR2	(30)		From grade or level.
FROM_LOCALITY_ADJ	NUMBER	(15)		From locality adjustment.
FROM_OCC_CODE	VARCHAR2	(150)		From occupational code.
FROM_OFFICE_SYMBOL	VARCHAR2	(30)		From office symbol.
FROM_OTHER_PAY_AMOUNT	NUMBER	(15)		From other pay amount.
FROM_PAY_BASIS	VARCHAR2	(30)		From pay basis.
FROM_PAY_PLAN	VARCHAR2	(2)		From pay plan.
FROM_POSITION_ID	NUMBER	(15)		Foreign key to PER_POSITIONS.
FROM_POSITION_ORG_LINE1	VARCHAR2	(40)		From position?s organization line 1.
FROM_POSITION_ORG_LINE2	VARCHAR2	(40)		From position?s organization line 2.
FROM_POSITION_ORG_LINE3	VARCHAR2	(40)		From position?s organization line 3.
FROM_POSITION_ORG_LINE4	VARCHAR2	(40)		From position?s organization line 4.
FROM_POSITION_ORG_LINE5	VARCHAR2	(40)		From position?s organization line 5.
FROM_POSITION_ORG_LINE6	VARCHAR2	(40)		From position?s organization line 6.
FROM_POSITION_NUMBER	VARCHAR2	(15)		From position number.
FROM_POSITION_SEQ_NO	NUMBER	(15)		From Position Sequence Number
FROM_POSITION_TITLE	VARCHAR2	(240)		From Position Title
FROM_STEP_OR_RATE	VARCHAR2	(30)		From Step Or rate
FROM_TOTAL_SALARY	NUMBER	(15)		From Total Salary
FUNCTIONAL_CLASS	VARCHAR2	(30)		Functional Class
AWARD_AMOUNT	NUMBER	(15)		Award Amount
AWARD_UOM	VARCHAR2	(30)		Award Unit of measure
AWARD_PERCENTAGE	NUMBER	(5)		Award Percentage
NOTEPAD	VARCHAR2	(2000)		Notepad Information
PA_NOTIFICATION_ID	NUMBER	(22)		Personnel Action Notification ID
PART_TIME_HOURS	NUMBER	(5)		Part time hours
PAY_RATE_DETERMINANT	VARCHAR2	(30)		Pay Rate Determinant
REQUESTED_BY_TITLE	VARCHAR2	(240)		Requested By Title
POSITION_OCCUPIED	VARCHAR2	(30)		Position Occupied
PROPOSED_EFFECTIVE_DATE	DATE			Proposed Effective Date
PROPOSED_EFFECTIVE_ASAP_FLAG	VARCHAR2	(1)	Yes	Proposed Effective ASAP Flag
REQUEST_NUMBER	VARCHAR2	(25)		Request Number
REQUESTED_BY_PERSON_ID	NUMBER	(10)		Requested by Person ID
REQUESTED_DATE	DATE			Requested Date
REQUESTING_OFFICE_REMARKS_DESC	VARCHAR2	(2000)		Requesting Office Remarks Description
REQUESTING_OFFICE_REMARKS_FLAG	VARCHAR2	(1)		Requesting Office Remarks Flag
RESIGN_AND_RETIRE_REASON_DESC	VARCHAR2	(2000)		Resign and Retire reason Description
RETIREMENT_PLAN	VARCHAR2	(30)		Retirement Plan
SECOND_ACTION_LA_CODE1	VARCHAR2	(30)		Second Action Legal Authority Code1
SECOND_ACTION_LA_CODE2	VARCHAR2	(30)		Second Action Legal Authority Code2
SECOND_ACTION_LA_DESC1	VARCHAR2	(240)		Second Action Legal Authority Code1 Description
SECOND_ACTION_LA_DESC2	VARCHAR2	(240)		Second Action Legal Authority Code2 Description
SECOND_NOA_CANCEL_OR_CORRECT	VARCHAR2	(10)		Second NOA Cancel or Correct
SECOND_NOA_CODE	VARCHAR2	(4)		Second NOA Code
SECOND_NOA_DESC	VARCHAR2	(240)		Second NOA Description
SECOND_NOA_ID	NUMBER	(15)		Second NOA ID
SECOND_NOA_PA_REQUEST_ID	NUMBER	(15)		Second NOA Personnel Action Request ID
SERVICE_COMP_DATE	DATE			Service Comp Date
STATUS	VARCHAR2	(30)		Status
SUPERVISORY_STATUS	VARCHAR2	(30)		Supervisory Status
TENURE	VARCHAR2	(30)		Tenure
TO_ADJ_BASIC_PAY	NUMBER	(15)		To Adjusted basic Pay
TO_BASIC_PAY	NUMBER	(15)		To Basic Pay
TO_LOCALITY_ADJ	NUMBER	(15)		To Locality Adjustment
TO_GRADE_ID	NUMBER	(15)		To Grade ID
TO_GRADE_OR_LEVEL	VARCHAR2	(30)		TO Grade Or Level
TO_JOB_ID	NUMBER	(15)		To Job ID
TO_ORGANIZATION_ID	NUMBER	(15)		To Organization ID
TO_POSITION_ORG_LINE1	VARCHAR2	(40)		To Position Organization Line1
TO_POSITION_ORG_LINE2	VARCHAR2	(40)		To Position Organization Line2
TO_POSITION_ORG_LINE3	VARCHAR2	(40)		To Position Organization Line3
TO_POSITION_ORG_LINE4	VARCHAR2	(40)		To Position Organization Line4
TO_POSITION_ORG_LINE5	VARCHAR2	(40)		To Position Organization Line5
TO_POSITION_ORG_LINE6	VARCHAR2	(40)		To Position Organization Line6
TO_POSITION_NUMBER	VARCHAR2	(15)		To Position Number
TO_POSITION_SEQ_NO	NUMBER	(15)		To Position Sequence Number
TO_POSITION_TITLE	VARCHAR2	(240)		To Position Title
TO_OCC_CODE	VARCHAR2	(30)		To Occupation Code
TO_OTHER_PAY_AMOUNT	NUMBER	(15)		To Other Pay Amount
TO_AU_OVERTIME	NUMBER	(15)		To AU Overtime
TO_AUO_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)		To AUO Premium Pay Indicator
TO_AVAILABILITY_PAY	NUMBER	(15)		To Availability Pay
TO_AP_PREMIUM_PAY_INDICATOR	VARCHAR2	(30)		To Availability Pay Indicator
TO_RETENTION_ALLOWANCE	NUMBER	(15)		To Retention Allowance
TO_RETENTION_ALLOW_PERCENTAGE	NUMBER	(5)		To Retention Allowance Percentage
TO_SUPERVISORY_DIFFERENTIAL	NUMBER	(15)		To Supervisory Differential
TO_SUPERVISORY_DIFF_PERCENTAGE	NUMBER	(5)		To Supervisory Differential Percentage
TO_STAFFING_DIFFERENTIAL	NUMBER	(15)		To Staffing Differentail
TO_STAFFING_DIFF_PERCENTAGE	NUMBER	(5)		To Staffing Differentail Percentage
TO_PAY_BASIS	VARCHAR2	(30)		To Pay Basis
TO_PAY_PLAN	VARCHAR2	(2)		To Pay Plan
TO_POSITION_ID	NUMBER	(15)		To Position ID
TO_STEP_OR_RATE	VARCHAR2	(30)		To Step Or Rate
TO_TOTAL_SALARY	NUMBER	(15)		To Total Salary
VETERANS_PREF_FOR_RIF	VARCHAR2	(30)		Veterans Preference For RIF
VETERANS_PREFERENCE	VARCHAR2	(30)		Veterans Preference
VETERANS_STATUS	VARCHAR2	(30)		Veterans Status
WORK_SCHEDULE	VARCHAR2	(30)		Work Schedule
YEAR_DEGREE_ATTAINED	NUMBER	(4)		Year Degree Attained
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flex Field
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Who Column
CREATED_BY	NUMBER	(15)	Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
FIRST_NOA_INFORMATION_CAT	VARCHAR2	(4)		Nature of action Information Category
FIRST_NOA_INFORMATION1	VARCHAR2	(240)		Nature of Action insertion value1
FIRST_NOA_INFORMATION2	VARCHAR2	(150)		Nature of Action insertion value2
FIRST_NOA_INFORMATION3	VARCHAR2	(150)		Nature of Action insertion value3
FIRST_NOA_INFORMATION4	VARCHAR2	(150)		Nature of Action insertion value4
FIRST_NOA_INFORMATION5	VARCHAR2	(150)		Nature of Action insertion value5
FIRST_LAC1_INFORMATION_CAT	VARCHAR2	(30)		First Legal Authority Code1 Category
FIRST_LAC1_INFORMATION1	VARCHAR2	(240)		First Legal Authority Code1 Insertion Value1
FIRST_LAC1_INFORMATION2	VARCHAR2	(150)		First Legal Authority Code1 Insertion Value2
FIRST_LAC1_INFORMATION3	VARCHAR2	(150)		First Legal Authority Code1 Insertion Value3
FIRST_LAC1_INFORMATION4	VARCHAR2	(150)		First Legal Authority Code1 Insertion Value4
FIRST_LAC1_INFORMATION5	VARCHAR2	(150)		First Legal Authority Code1 Insertion Value5
FIRST_LAC2_INFORMATION_CAT	VARCHAR2	(30)		First Legal Authority Code2 Category
FIRST_LAC2_INFORMATION1	VARCHAR2	(240)		First Legal Authority Code2 Insertion Value1
FIRST_LAC2_INFORMATION2	VARCHAR2	(150)		First Legal Authority Code2 Insertion Value2
FIRST_LAC2_INFORMATION3	VARCHAR2	(150)		First Legal Authority Code2 Insertion Value3
FIRST_LAC2_INFORMATION4	VARCHAR2	(150)		First Legal Authority Code2 Insertion Value4
FIRST_LAC2_INFORMATION5	VARCHAR2	(150)		First Legal Authority Code2 Insertion Value5
SECOND_NOA_INFORMATION_CAT	VARCHAR2	(4)		Second Nature of Action Category
SECOND_NOA_INFORMATION1	VARCHAR2	(240)		Second Nature of action insertion value1
SECOND_NOA_INFORMATION2	VARCHAR2	(150)		Second Nature of action insertion value2
SECOND_NOA_INFORMATION3	VARCHAR2	(150)		Second Nature of action insertion value3
SECOND_NOA_INFORMATION4	VARCHAR2	(150)		Second Nature of action insertion value4
SECOND_NOA_INFORMATION5	VARCHAR2	(150)		Second Nature of action insertion value5
SECOND_LAC1_INFORMATION_CAT	VARCHAR2	(30)		Second Legal Authority Code1 Category
SECOND_LAC1_INFORMATION1	VARCHAR2	(240)		Second Legal Authority Code1 Insertion Value1
SECOND_LAC1_INFORMATION2	VARCHAR2	(150)		Second Legal Authority Code1 Insertion Value2
SECOND_LAC1_INFORMATION3	VARCHAR2	(150)		Second Legal Authority Code1 Insertion Value3
SECOND_LAC1_INFORMATION4	VARCHAR2	(150)		Second Legal Authority Code1 Insertion Value4
SECOND_LAC1_INFORMATION5	VARCHAR2	(150)		Second Legal Authority Code1 Insertion Value5
SECOND_LAC2_INFORMATION_CAT	VARCHAR2	(30)		Second Legal Authority Code2 Category
SECOND_LAC2_INFORMATION1	VARCHAR2	(240)		Second Legal Authority Code2 Insertion Value1
SECOND_LAC2_INFORMATION2	VARCHAR2	(150)		Second Legal Authority Code2 Insertion Value2
SECOND_LAC2_INFORMATION3	VARCHAR2	(150)		Second Legal Authority Code2 Insertion Value3
SECOND_LAC2_INFORMATION4	VARCHAR2	(150)		Second Legal Authority Code2 Insertion Value4
SECOND_LAC2_INFORMATION5	VARCHAR2	(150)		Second Legal Authority Code2 Insertion Value5
NOTIFICATION_PRINTED_BY	NUMBER	(15)		Notification Printed by
FROM_PAY_TABLE_IDENTIFIER	NUMBER	(9)
INPUT_PAY_RATE_DETERMINANT	VARCHAR2	(30)
TO_PAY_TABLE_IDENTIFIER	NUMBER	(9)
AWARD_SALARY	NUMBER	(15)
PA_INCENTIVE_PAYMENT_OPTION	VARCHAR2	(1)
AUTHORIZED_BY_FULL_NAME	VARCHAR2	(240)
REQUESTED_BY_FULL_NAME	VARCHAR2	(240)

Query Text

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


SELECT PA_REQUEST_ID
,      ROW_ID
,      NOA_FAMILY_CODE
,      ACTION_REQUESTED
,      ROUTING_GROUP_ID
,      ACADEMIC_DISCIPLINE
,      ADDITIONAL_INFO_PERSON_ID
,      ADDITIONAL_INFO_TEL_NUMBER
,      ALTERED_PA_REQUEST_ID
,      ANNUITANT_INDICATOR
,      AUTHORIZED_BY_TITLE
,      APPROPRIATION_CODE1
,      APPROPRIATION_CODE2
,      AUTHORIZED_BY_PERSON_ID
,      APPROVAL_DATE
,      APPROVING_OFFICIAL_FULL_NAME
,      APPROVING_OFFICIAL_WORK_TITLE
,      BARGAINING_UNIT_STATUS
,      CITIZENSHIP
,      CONCURRENCE_DATE
,      CUSTOM_PAY_CALC_FLAG
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      DUTY_STATION_ID
,      DUTY_STATION_LOCATION_ID
,      EDUCATION_LEVEL
,      PERSON_ID
,      EFFECTIVE_DATE
,      EMPLOYEE_NATIONAL_IDENTIFIER
,      EMPLOYEE_DATE_OF_BIRTH
,      EMPLOYEE_ASSIGNMENT_ID
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_MIDDLE_NAMES
,      FEGLI
,      FIRST_ACTION_LA_CODE1
,      FIRST_ACTION_LA_CODE2
,      FIRST_ACTION_LA_DESC1
,      FIRST_ACTION_LA_DESC2
,      FIRST_NOA_CANCEL_OR_CORRECT
,      FIRST_NOA_CODE
,      FIRST_NOA_DESC
,      FIRST_NOA_ID
,      FIRST_NOA_PA_REQUEST_ID
,      FLSA_CATEGORY
,      FORWARDING_ADDRESS_LINE1
,      FORWARDING_ADDRESS_LINE2
,      FORWARDING_ADDRESS_LINE3
,      FORWARDING_COUNTRY
,      FORWARDING_COUNTRY_SHORT_NAME
,      FORWARDING_POSTAL_CODE
,      FORWARDING_REGION_2
,      FORWARDING_TOWN_OR_CITY
,      FROM_ADJ_BASIC_PAY
,      FROM_AGENCY_CODE
,      FROM_AGENCY_DESC
,      FROM_BASIC_PAY
,      FROM_GRADE_OR_LEVEL
,      FROM_LOCALITY_ADJ
,      FROM_OCC_CODE
,      FROM_OFFICE_SYMBOL
,      FROM_OTHER_PAY_AMOUNT
,      FROM_PAY_BASIS
,      FROM_PAY_PLAN
,      FROM_POSITION_ID
,      FROM_POSITION_ORG_LINE1
,      FROM_POSITION_ORG_LINE2
,      FROM_POSITION_ORG_LINE3
,      FROM_POSITION_ORG_LINE4
,      FROM_POSITION_ORG_LINE5
,      FROM_POSITION_ORG_LINE6
,      FROM_POSITION_NUMBER
,      FROM_POSITION_SEQ_NO
,      FROM_POSITION_TITLE
,      FROM_STEP_OR_RATE
,      FROM_TOTAL_SALARY
,      FUNCTIONAL_CLASS
,      AWARD_AMOUNT
,      AWARD_UOM
,      AWARD_PERCENTAGE
,      NOTEPAD
,      PA_NOTIFICATION_ID
,      PART_TIME_HOURS
,      PAY_RATE_DETERMINANT
,      REQUESTED_BY_TITLE
,      POSITION_OCCUPIED
,      PROPOSED_EFFECTIVE_DATE
,      PROPOSED_EFFECTIVE_ASAP_FLAG
,      REQUEST_NUMBER
,      REQUESTED_BY_PERSON_ID
,      REQUESTED_DATE
,      REQUESTING_OFFICE_REMARKS_DESC
,      REQUESTING_OFFICE_REMARKS_FLAG
,      RESIGN_AND_RETIRE_REASON_DESC
,      RETIREMENT_PLAN
,      SECOND_ACTION_LA_CODE1
,      SECOND_ACTION_LA_CODE2
,      SECOND_ACTION_LA_DESC1
,      SECOND_ACTION_LA_DESC2
,      SECOND_NOA_CANCEL_OR_CORRECT
,      SECOND_NOA_CODE
,      SECOND_NOA_DESC
,      SECOND_NOA_ID
,      SECOND_NOA_PA_REQUEST_ID
,      SERVICE_COMP_DATE
,      STATUS
,      SUPERVISORY_STATUS
,      TENURE
,      TO_ADJ_BASIC_PAY
,      TO_BASIC_PAY
,      TO_LOCALITY_ADJ
,      TO_GRADE_ID
,      TO_GRADE_OR_LEVEL
,      TO_JOB_ID
,      TO_ORGANIZATION_ID
,      TO_POSITION_ORG_LINE1
,      TO_POSITION_ORG_LINE2
,      TO_POSITION_ORG_LINE3
,      TO_POSITION_ORG_LINE4
,      TO_POSITION_ORG_LINE5
,      TO_POSITION_ORG_LINE6
,      TO_POSITION_NUMBER
,      TO_POSITION_SEQ_NO
,      TO_POSITION_TITLE
,      TO_OCC_CODE
,      TO_OTHER_PAY_AMOUNT
,      TO_AU_OVERTIME
,      TO_AUO_PREMIUM_PAY_INDICATOR
,      TO_AVAILABILITY_PAY
,      TO_AP_PREMIUM_PAY_INDICATOR
,      TO_RETENTION_ALLOWANCE
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_SUPERVISORY_DIFFERENTIAL
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      TO_STAFFING_DIFFERENTIAL
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_PAY_BASIS
,      TO_PAY_PLAN
,      TO_POSITION_ID
,      TO_STEP_OR_RATE
,      TO_TOTAL_SALARY
,      VETERANS_PREF_FOR_RIF
,      VETERANS_PREFERENCE
,      VETERANS_STATUS
,      WORK_SCHEDULE
,      YEAR_DEGREE_ATTAINED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FIRST_NOA_INFORMATION_CAT
,      FIRST_NOA_INFORMATION1
,      FIRST_NOA_INFORMATION2
,      FIRST_NOA_INFORMATION3
,      FIRST_NOA_INFORMATION4
,      FIRST_NOA_INFORMATION5
,      FIRST_LAC1_INFORMATION_CAT
,      FIRST_LAC1_INFORMATION1
,      FIRST_LAC1_INFORMATION2
,      FIRST_LAC1_INFORMATION3
,      FIRST_LAC1_INFORMATION4
,      FIRST_LAC1_INFORMATION5
,      FIRST_LAC2_INFORMATION_CAT
,      FIRST_LAC2_INFORMATION1
,      FIRST_LAC2_INFORMATION2
,      FIRST_LAC2_INFORMATION3
,      FIRST_LAC2_INFORMATION4
,      FIRST_LAC2_INFORMATION5
,      SECOND_NOA_INFORMATION_CAT
,      SECOND_NOA_INFORMATION1
,      SECOND_NOA_INFORMATION2
,      SECOND_NOA_INFORMATION3
,      SECOND_NOA_INFORMATION4
,      SECOND_NOA_INFORMATION5
,      SECOND_LAC1_INFORMATION_CAT
,      SECOND_LAC1_INFORMATION1
,      SECOND_LAC1_INFORMATION2
,      SECOND_LAC1_INFORMATION3
,      SECOND_LAC1_INFORMATION4
,      SECOND_LAC1_INFORMATION5
,      SECOND_LAC2_INFORMATION_CAT
,      SECOND_LAC2_INFORMATION1
,      SECOND_LAC2_INFORMATION2
,      SECOND_LAC2_INFORMATION3
,      SECOND_LAC2_INFORMATION4
,      SECOND_LAC2_INFORMATION5
,      NOTIFICATION_PRINTED_BY
,      FROM_PAY_TABLE_IDENTIFIER
,      INPUT_PAY_RATE_DETERMINANT
,      TO_PAY_TABLE_IDENTIFIER
,      AWARD_SALARY
,      PA_INCENTIVE_PAYMENT_OPTION
,      AUTHORIZED_BY_FULL_NAME
,      REQUESTED_BY_FULL_NAME
FROM APPS.GHR_PA_REQUESTS_V;

Dependencies

[top of page]

APPS.GHR_PA_REQUESTS_V references the following:

APPS: GHR_FAMILIES; GHR_NATURE_OF_ACTIONS; GHR_PA_REQUESTS

APPS.GHR_PA_REQUESTS_V is not referenced by any database object