[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_PA_REQUESTS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  GHR.GHR_PA_REQUESTS
|
| Subobject Name: | |
| Status: | VALID |
Stores all the information about the Request to Personnel Action.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
PA_REQUEST_IDPA_NOTIFICATION_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GHR_PA_REQUESTS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PA_REQUEST_ID
|
| GHR_PA_REQUESTS_UK1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PA_NOTIFICATION_ID
|
| GHR_PA_REQUESTS_UK2 | FUNCTION-BASED NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
UPPER(SUBSTR("EMPLOYEE_LAST_NAME"||', '||"EMPLOYEE_FIRST_NAME"||' '||"EMPLOYEE_MIDDLE_NAMES",1,200)||' '||TO_CHAR("PA_REQUEST_ID"))
|
| GHR_PA_REQUESTS_UK3 | FUNCTION-BASED NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SUBSTR("EMPLOYEE_LAST_NAME"||', '||"EMPLOYEE_FIRST_NAME"||' '||"EMPLOYEE_MIDDLE_NAMES",1,200)||' '||TO_CHAR("PA_REQUEST_ID")
|
| GHR_PA_REQUESTS_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NOA_FAMILY_CODE
|
| GHR_PA_REQUESTS_FK10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ROUTING_GROUP_ID
|
| GHR_PA_REQUESTS_FK11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FIRST_NOA_PA_REQUEST_ID
|
| GHR_PA_REQUESTS_FK12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SECOND_NOA_PA_REQUEST_ID
|
| GHR_PA_REQUESTS_FK13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ALTERED_PA_REQUEST_ID
|
| GHR_PA_REQUESTS_FK14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_PAY_PLAN
|
| GHR_PA_REQUESTS_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FIRST_NOA_ID
|
| GHR_PA_REQUESTS_FK3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SECOND_NOA_ID
|
| GHR_PA_REQUESTS_FK4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_PAY_PLAN
|
| GHR_PA_REQUESTS_FK5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_POSITION_ID
|
| GHR_PA_REQUESTS_FK6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_JOB_ID
|
| GHR_PA_REQUESTS_FK7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_GRADE_ID
|
| GHR_PA_REQUESTS_FK8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_ORGANIZATION_ID
|
| GHR_PA_REQUESTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
EFFECTIVE_DATE
|
| GHR_PA_REQUESTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EFFECTIVE_DATE
PA_NOTIFICATION_ID
APPROVAL_DATE
|
| GHR_PA_REQUESTS_N4 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRUNC("SF50_APPROVAL_DATE")
|
| GHR_PA_REQUESTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MASS_ACTION_ID
RPA_TYPE
PA_REQUEST_ID
|
| Table | |
Foreign Table | Foreign Key Column | GHR_PA_REQUESTS |  |
GHR_PA_REQUESTS
|
GHR_PA_REQUESTS ALTERED_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 FIRST_NOA_PA_REQUEST_ID | GHR_PA_REQUESTS | |
GHR_ROUTING_GROUPS
|
GHR_PA_REQUESTS ROUTING_GROUP_ID | GHR_PA_REQUESTS | |
HR_ALL_ORGANIZATION_UNITS
|
GHR_PA_REQUESTS TO_ORGANIZATION_ID | GHR_PA_REQUESTS | |
PER_GRADES
|
GHR_PA_REQUESTS TO_GRADE_ID | GHR_PA_REQUESTS | |
PER_JOBS
|
GHR_PA_REQUESTS TO_JOB_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 |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_REQUEST_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_PA_REQUESTS_S. |
| PA_NOTIFICATION_ID | NUMBER | (22) | Unique Id for the Notification to Personnel Action. Generated from the sequence, GHR_PA_NOTIFICATIONS_S | |
| NOA_FAMILY_CODE | VARCHAR2 | (30) | Yes | Nature of action family code. |
| 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 | |
| AGENCY_CODE | VARCHAR2 | (30) | Agency code. | |
| ALTERED_PA_REQUEST_ID | NUMBER | (15) | Foreign Key to PER_PEOPLE_F | |
| ANNUITANT_INDICATOR | VARCHAR2 | (30) | Annuitant indicator. | |
| ANNUITANT_INDICATOR_DESC | VARCHAR2 | (80) | Description of the annuitant indicator. | |
| APPROPRIATION_CODE1 | VARCHAR2 | (30) | Appropriation code 1. | |
| APPROPRIATION_CODE2 | VARCHAR2 | (30) | Appropriation code 2. | |
| 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 | |
| AUTHORIZED_BY_PERSON_ID | NUMBER | (10) | Foreign key to PER_PEOPLE_F. | |
| AUTHORIZED_BY_TITLE | VARCHAR2 | (240) | Title of authorizer. | |
| AWARD_AMOUNT | NUMBER | (15) | Award amount. | |
| AWARD_PERCENTAGE | NUMBER | (5) | Award Percentage. | |
| AWARD_UOM | VARCHAR2 | (30) | Award unit of measure. | |
| 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. | |
| EFFECTIVE_DATE | DATE | Effective date of Request for Personnel Action. | ||
| EMPLOYEE_ASSIGNMENT_ID | NUMBER | (15) | Foreign key to PER_ASSIGNMENTS_F. | |
| EMPLOYEE_DATE_OF_BIRTH | DATE | Employee?s date of birth. | ||
| EMPLOYEE_DEPT_OR_AGENCY | VARCHAR2 | (80) | Employee?s department or agency. | |
| 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. | |
| FEGLI_DESC | VARCHAR2 | (80) | Description of the 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_CANC_PA_REQUEST_ID | NUMBER | (15) | Determines which PA Request is cancelling this action. | |
| 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. | |
| NOTEPAD | VARCHAR2 | (2000) | Remarks. | |
| NOTIFICATION_PRINTED_BY | NUMBER | (15) | UserId of the user that printed the notification | |
| NO_OF_NOTIFICATION_PRINTED | NUMBER | (5) | Number of Notifications Printed | |
| PART_TIME_HOURS | NUMBER | (5) | Part-time hours. | |
| PAY_RATE_DETERMINANT | VARCHAR2 | (30) | Pay rate determinant. | |
| PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel office id. | |
| PERSON_ID | NUMBER | (10) | Foreign key to PER_PEOPLE_F. | |
| POSITION_OCCUPIED | VARCHAR2 | (30) | Position occupied. | |
| PROPOSED_EFFECTIVE_ASAP_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the Request to Personnel Action is proposed to be effective ASAP |
| PROPOSED_EFFECTIVE_DATE | DATE | Proposed effective date. | ||
| REQUESTED_BY_PERSON_ID | NUMBER | (10) | Foreign key to PER_PEOPLE_F. | |
| REQUESTED_BY_TITLE | VARCHAR2 | (240) | Title of requester. | |
| REQUESTED_DATE | DATE | Date requested. | ||
| REQUESTING_OFFICE_REMARKS_DESC | VARCHAR2 | (2000) | Description of the requesting office remarks. | |
| REQUESTING_OFFICE_REMARKS_FLAG | VARCHAR2 | (1) | Remarks entered by the Requesting Office | |
| REQUEST_NUMBER | VARCHAR2 | (25) | Request Number | |
| RESIGN_AND_RETIRE_REASON_DESC | VARCHAR2 | (2000) | Description of the reason for resignation or retirement. | |
| RETIREMENT_PLAN | VARCHAR2 | (30) | Retirement plan. | |
| RETIREMENT_PLAN_DESC | VARCHAR2 | (80) | Description of the retirement plan. | |
| SECOND_ACTION_LA_CODE1 | VARCHAR2 | (30) | Second action legal authority code 1. | |
| SECOND_ACTION_LA_CODE2 | VARCHAR2 | (30) | Second action legal authority code 2. | |
| SECOND_ACTION_LA_DESC1 | VARCHAR2 | (240) | Description of the second action legal authority code 1. | |
| SECOND_ACTION_LA_DESC2 | VARCHAR2 | (240) | Description of the second action legal authority code 2. | |
| SECOND_NOA_CANCEL_OR_CORRECT | VARCHAR2 | (10) | Indicates whether second Action has been canceled or corrected. | |
| SECOND_NOA_CANC_PA_REQUEST_ID | NUMBER | (15) | Determines which PA Request is cancelling this action. | |
| SECOND_NOA_CODE | VARCHAR2 | (30) | Second nature of action code. | |
| SECOND_NOA_DESC | VARCHAR2 | (240) | Description of the second nature of action code. | |
| SECOND_NOA_ID | NUMBER | (15) | Foreign key to GHR_NATURE_OF_ACTIONS. | |
| SECOND_NOA_PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS, RPA for cancellation/correction of second action. | |
| SERVICE_COMP_DATE | DATE | Service computation date. | ||
| SF50_APPROVAL_DATE | DATE | Approval Date of the NPA | ||
| SF50_APPROVING_OFCL_FULL_NAME | VARCHAR2 | (240) | Full Name of the NPA approving official | |
| SF50_APPROVING_OFCL_WORK_TITLE | VARCHAR2 | (60) | Work Title of the NPA approving official | |
| STATUS | VARCHAR2 | (30) | Current Status of the RPA | |
| SUPERVISORY_STATUS | VARCHAR2 | (30) | Supervisory status. | |
| TENURE | VARCHAR2 | (30) | Tenure. | |
| TO_ADJ_BASIC_PAY | NUMBER | (15) | To adjusted basic pay. | |
| 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_AU_OVERTIME | NUMBER | (15) | To authorized uncontrollable overtime premium pay. | |
| TO_AVAILABILITY_PAY | NUMBER | (15) | To availability pay. | |
| TO_BASIC_PAY | NUMBER | (15) | To basic pay. | |
| TO_GRADE_ID | NUMBER | (15) | Foreign key to PER_GRADES. | |
| TO_GRADE_OR_LEVEL | VARCHAR2 | (30) | To grade or level. | |
| TO_JOB_ID | NUMBER | (15) | Foreign key to PER_JOBS. | |
| TO_LOCALITY_ADJ | NUMBER | (15) | To locality adjustment. | |
| TO_OCC_CODE | VARCHAR2 | (30) | To occupational code. | |
| TO_OFFICE_SYMBOL | VARCHAR2 | (30) | To office symbol. | |
| TO_ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
| TO_OTHER_PAY_AMOUNT | NUMBER | (15) | To other pay amount. | |
| TO_PAY_BASIS | VARCHAR2 | (30) | To pay basis. | |
| TO_PAY_PLAN | VARCHAR2 | (2) | To pay plan. | |
| TO_POSITION_ID | NUMBER | (15) | Foreign key to PER_POSITIONS. | |
| TO_POSITION_ORG_LINE1 | VARCHAR2 | (40) | To position?s organization line 1. | |
| TO_POSITION_ORG_LINE2 | VARCHAR2 | (40) | To position?s organization line 2. | |
| TO_POSITION_ORG_LINE3 | VARCHAR2 | (40) | To position?s organization line 3. | |
| TO_POSITION_ORG_LINE4 | VARCHAR2 | (40) | To position?s organization line 4. | |
| TO_POSITION_ORG_LINE5 | VARCHAR2 | (40) | To position?s organization line 5. | |
| TO_POSITION_ORG_LINE6 | VARCHAR2 | (40) | To position?s organization line 6. | |
| 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_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. | |
| TO_TOTAL_SALARY | NUMBER | (15) | To total salary. | |
| 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. | |
| WORK_SCHEDULE_DESC | VARCHAR2 | (80) | Description for the work schedule. | |
| YEAR_DEGREE_ATTAINED | NUMBER | (4) | Year degree attained. | |
| FIRST_NOA_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| FIRST_NOA_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for first nature of action description. | |
| FIRST_NOA_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action description. | |
| FIRST_NOA_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action description. | |
| FIRST_NOA_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action description. | |
| FIRST_NOA_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action description. | |
| SECOND_LAC1_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| SECOND_LAC1_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC1_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC1_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC1_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC1_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC2_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| SECOND_LAC2_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC2_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC2_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC2_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_LAC2_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action?s legal authority description. | |
| SECOND_NOA_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| SECOND_NOA_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for second nature of action description. | |
| SECOND_NOA_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action description. | |
| SECOND_NOA_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action description. | |
| SECOND_NOA_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action description. | |
| SECOND_NOA_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for second nature of action description. | |
| FIRST_LAC1_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| FIRST_LAC1_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC1_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC1_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC1_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC1_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC2_INFORMATION_CAT | VARCHAR2 | (30) | Developer descriptive flexfield. | |
| FIRST_LAC2_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC2_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC2_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC2_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| FIRST_LAC2_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield for first nature of action?s legal authority description. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
| CREATION_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update. |
| RPA_TYPE | VARCHAR2 | (30) | RPA Type. | |
| MASS_ACTION_ID | NUMBER | (15) | Id of the Mass Action that created the RPA. For eg. (Mass Award) | |
| MASS_ACTION_ELIGIBLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the employee is eligible for the Mass Action | |
| MASS_ACTION_SELECT_FLAG | VARCHAR2 | (1) | Flag to indicate if the employee is selected for the Mass Action | |
| MASS_ACTION_COMMENTS | VARCHAR2 | (255) | Comments specific to selection or deselection of the employee for the Mass action | |
| AWARD_SALARY | NUMBER | (15) | Salary On which Award is calculated. | |
| PA_INCENTIVE_PAYMENT_OPTION | VARCHAR2 | (1) | Payment Option used for Incentive Actions | |
| INPUT_PAY_RATE_DETERMINANT | VARCHAR2 | (30) | Input Pay Rate Determinant | |
| FROM_PAY_TABLE_IDENTIFIER | NUMBER | (9) | From Pay Table Identifier | |
| TO_PAY_TABLE_IDENTIFIER | NUMBER | (9) | To Pay Table Identifier | |
| AUTHORIZED_BY_FULL_NAME | VARCHAR2 | (240) | Full Name of Authorized by person | |
| REQUESTED_BY_FULL_NAME | VARCHAR2 | (240) | Full Name of Requested By person |
Cut, paste (and edit) the following text to query this object:
SELECT PA_REQUEST_ID
, PA_NOTIFICATION_ID
, NOA_FAMILY_CODE
, ROUTING_GROUP_ID
, ACADEMIC_DISCIPLINE
, ADDITIONAL_INFO_PERSON_ID
, ADDITIONAL_INFO_TEL_NUMBER
, AGENCY_CODE
, ALTERED_PA_REQUEST_ID
, ANNUITANT_INDICATOR
, ANNUITANT_INDICATOR_DESC
, APPROPRIATION_CODE1
, APPROPRIATION_CODE2
, APPROVAL_DATE
, APPROVING_OFFICIAL_FULL_NAME
, APPROVING_OFFICIAL_WORK_TITLE
, AUTHORIZED_BY_PERSON_ID
, AUTHORIZED_BY_TITLE
, AWARD_AMOUNT
, AWARD_PERCENTAGE
, AWARD_UOM
, 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
, EFFECTIVE_DATE
, EMPLOYEE_ASSIGNMENT_ID
, EMPLOYEE_DATE_OF_BIRTH
, EMPLOYEE_DEPT_OR_AGENCY
, EMPLOYEE_FIRST_NAME
, EMPLOYEE_LAST_NAME
, EMPLOYEE_MIDDLE_NAMES
, EMPLOYEE_NATIONAL_IDENTIFIER
, FEGLI
, FEGLI_DESC
, FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2
, FIRST_ACTION_LA_DESC1
, FIRST_ACTION_LA_DESC2
, FIRST_NOA_CANCEL_OR_CORRECT
, FIRST_NOA_CANC_PA_REQUEST_ID
, 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
, NOTEPAD
, NOTIFICATION_PRINTED_BY
, NO_OF_NOTIFICATION_PRINTED
, PART_TIME_HOURS
, PAY_RATE_DETERMINANT
, PERSONNEL_OFFICE_ID
, PERSON_ID
, POSITION_OCCUPIED
, PROPOSED_EFFECTIVE_ASAP_FLAG
, PROPOSED_EFFECTIVE_DATE
, REQUESTED_BY_PERSON_ID
, REQUESTED_BY_TITLE
, REQUESTED_DATE
, REQUESTING_OFFICE_REMARKS_DESC
, REQUESTING_OFFICE_REMARKS_FLAG
, REQUEST_NUMBER
, RESIGN_AND_RETIRE_REASON_DESC
, RETIREMENT_PLAN
, RETIREMENT_PLAN_DESC
, SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2
, SECOND_ACTION_LA_DESC1
, SECOND_ACTION_LA_DESC2
, SECOND_NOA_CANCEL_OR_CORRECT
, SECOND_NOA_CANC_PA_REQUEST_ID
, SECOND_NOA_CODE
, SECOND_NOA_DESC
, SECOND_NOA_ID
, SECOND_NOA_PA_REQUEST_ID
, SERVICE_COMP_DATE
, SF50_APPROVAL_DATE
, SF50_APPROVING_OFCL_FULL_NAME
, SF50_APPROVING_OFCL_WORK_TITLE
, STATUS
, SUPERVISORY_STATUS
, TENURE
, TO_ADJ_BASIC_PAY
, TO_AP_PREMIUM_PAY_INDICATOR
, TO_AUO_PREMIUM_PAY_INDICATOR
, TO_AU_OVERTIME
, TO_AVAILABILITY_PAY
, TO_BASIC_PAY
, TO_GRADE_ID
, TO_GRADE_OR_LEVEL
, TO_JOB_ID
, TO_LOCALITY_ADJ
, TO_OCC_CODE
, TO_OFFICE_SYMBOL
, TO_ORGANIZATION_ID
, TO_OTHER_PAY_AMOUNT
, TO_PAY_BASIS
, TO_PAY_PLAN
, TO_POSITION_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_RETENTION_ALLOWANCE
, TO_RETENTION_ALLOW_PERCENTAGE
, TO_STAFFING_DIFFERENTIAL
, TO_STAFFING_DIFF_PERCENTAGE
, TO_STEP_OR_RATE
, TO_SUPERVISORY_DIFFERENTIAL
, TO_SUPERVISORY_DIFF_PERCENTAGE
, TO_TOTAL_SALARY
, VETERANS_PREFERENCE
, VETERANS_PREF_FOR_RIF
, VETERANS_STATUS
, WORK_SCHEDULE
, WORK_SCHEDULE_DESC
, YEAR_DEGREE_ATTAINED
, FIRST_NOA_INFORMATION_CAT
, FIRST_NOA_INFORMATION1
, FIRST_NOA_INFORMATION2
, FIRST_NOA_INFORMATION3
, FIRST_NOA_INFORMATION4
, FIRST_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
, SECOND_NOA_INFORMATION_CAT
, SECOND_NOA_INFORMATION1
, SECOND_NOA_INFORMATION2
, SECOND_NOA_INFORMATION3
, SECOND_NOA_INFORMATION4
, SECOND_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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, RPA_TYPE
, MASS_ACTION_ID
, MASS_ACTION_ELIGIBLE_FLAG
, MASS_ACTION_SELECT_FLAG
, MASS_ACTION_COMMENTS
, AWARD_SALARY
, PA_INCENTIVE_PAYMENT_OPTION
, INPUT_PAY_RATE_DETERMINANT
, FROM_PAY_TABLE_IDENTIFIER
, TO_PAY_TABLE_IDENTIFIER
, AUTHORIZED_BY_FULL_NAME
, REQUESTED_BY_FULL_NAME
FROM HR.GHR_PA_REQUESTS;
HR.GHR_PA_REQUESTS does not reference any database object
HR.GHR_PA_REQUESTS is referenced by following:
HR
GHR_PA_REQUESTS#
|
|
|
|