[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_MULTI_IA_PREVIEW |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
This table is used for show preview screen for Multiple Intervenig actions.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IA_PREVIEW_ID | NUMBER | (15) | Yes | IA Preview Id |
| SESSION_ID | NUMBER | (9) | Yes | Session Id |
| ACADEMIC_DISCIPLINE | VARCHAR2 | (30) | Acadamic Discipline | |
| AGENCY_CODE | VARCHAR2 | (30) | Agency Code | |
| ALTERED_PA_REQUEST_ID | NUMBER | (15) | Altered PA Request Id | |
| ANNUITANT_INDICATOR | VARCHAR2 | (30) | Annultant Indicator | |
| ANNUITANT_INDICATOR_DESC | VARCHAR2 | (80) | Annuitant Indecator Desc | |
| APPROPRIATION_CODE1 | VARCHAR2 | (30) | Appropriation code1 | |
| APPROPRIATION_CODE2 | VARCHAR2 | (30) | Appropriation code2 | |
| AWARD_AMOUNT | NUMBER | (15) | Award Amount | |
| AWARD_PERCENTAGE | NUMBER | (5) | Award Percentage | |
| AWARD_SALARY | NUMBER | (15) | Award Salary | |
| AWARD_UOM | VARCHAR2 | (30) | Award UOM | |
| BARGAINING_UNIT_STATUS | VARCHAR2 | (30) | Bargaining Unit Status | |
| CITIZENSHIP | VARCHAR2 | (30) | citizenship | |
| DUTY_STATION_CODE | VARCHAR2 | (9) | Duty Station code | |
| DUTY_STATION_DESC | VARCHAR2 | (150) | Duty Station Desc | |
| DUTY_STATION_ID | NUMBER | (15) | Duty Station Id | |
| DUTY_STATION_LOCATION_ID | NUMBER | (15) | Duty Station Location Id | |
| EDUCATION_LEVEL | VARCHAR2 | (30) | Education Level | |
| EFFECTIVE_DATE | DATE | Effective Date | ||
| EMPLOYEE_ASSIGNMENT_ID | NUMBER | (15) | Employee Assignment Id | |
| EMPLOYEE_DATE_OF_BIRTH | DATE | employee Date of Birth | ||
| EMPLOYEE_DEPT_OR_AGENCY | VARCHAR2 | (80) | Employee Dept Or Agency | |
| EMPLOYEE_FIRST_NAME | VARCHAR2 | (150) | Employee First Name | |
| EMPLOYEE_LAST_NAME | VARCHAR2 | (150) | Employee Last Name | |
| EMPLOYEE_MIDDLE_NAMES | VARCHAR2 | (60) | Employee middle Name | |
| EMPLOYEE_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | Employee National identifier | |
| FEGLI | VARCHAR2 | (30) | Fegli | |
| FEGLI_DESC | VARCHAR2 | (80) | Fegli Descirption | |
| FIRST_ACTION_LA_CODE1 | VARCHAR2 | (30) | First Action La Code1 | |
| FIRST_ACTION_LA_CODE2 | VARCHAR2 | (30) | First Action La Code2 | |
| FIRST_ACTION_LA_DESC1 | VARCHAR2 | (240) | First Action LA Desc1 | |
| FIRST_ACTION_LA_DESC2 | VARCHAR2 | (240) | First Action LA Desc2 | |
| FIRST_LAC1_INFORMATION1 | VARCHAR2 | (240) | First LAC1 Information1 | |
| FIRST_LAC1_INFORMATION2 | VARCHAR2 | (150) | First LAC1 Information2 | |
| FIRST_LAC1_INFORMATION3 | VARCHAR2 | (150) | First LAC1 Information3 | |
| FIRST_LAC2_INFORMATION1 | VARCHAR2 | (240) | First LAC2 Information1 | |
| FIRST_LAC2_INFORMATION2 | VARCHAR2 | (150) | First LAC2 Information2 | |
| FIRST_LAC2_INFORMATION3 | VARCHAR2 | (150) | First Lac2 Information3 | |
| FIRST_NOA_ID | NUMBER | (15) | First NOA Id | |
| FIRST_NOA_CODE | VARCHAR2 | (4) | First NOA code | |
| FIRST_NOA_DESC | VARCHAR2 | (240) | First NOA Desc | |
| FIRST_NOA_INFORMATION1 | VARCHAR2 | (240) | First NOA Info1 | |
| FIRST_NOA_INFORMATION2 | VARCHAR2 | (150) | First NOA Info2 | |
| FLSA_CATEGORY | VARCHAR2 | (30) | FLSA Category | |
| FORWARDING_ADDRESS_LINE1 | VARCHAR2 | (240) | Forwarding Address Line1 | |
| FORWARDING_ADDRESS_LINE2 | VARCHAR2 | (240) | Forwarding Address Line2 | |
| FORWARDING_ADDRESS_LINE3 | VARCHAR2 | (240) | Forwarding Address Line3 | |
| 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 Adj Basic Pay | |
| FROM_AGENCY_CODE | VARCHAR2 | (30) | From Agency code | |
| FROM_AGENCY_DESC | VARCHAR2 | (80) | From Agency Desc | |
| 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 Adj | |
| FROM_OCC_CODE | VARCHAR2 | (150) | From OCC 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_PAY_TABLE_IDENTIFIER | NUMBER | (9) | From Pay Table Identifier | |
| FROM_POSITION_ID | NUMBER | (15) | From Position Id | |
| FROM_POSITION_NUMBER | VARCHAR2 | (15) | From Position Number | |
| FROM_POSITION_ORG_LINE1 | VARCHAR2 | (40) | From Position Org Line1 | |
| FROM_POSITION_ORG_LINE2 | VARCHAR2 | (40) | From Position Org Line2 | |
| FROM_POSITION_ORG_LINE3 | VARCHAR2 | (40) | From Position Org Line3 | |
| FROM_POSITION_ORG_LINE4 | VARCHAR2 | (40) | From Position Org Line4 | |
| FROM_POSITION_ORG_LINE5 | VARCHAR2 | (40) | From Position Org Line5 | |
| FROM_POSITION_ORG_LINE6 | VARCHAR2 | (40) | From Position Org Line6 | |
| FROM_POSITION_SEQ_NO | NUMBER | (15) | From Position Seq No | |
| FROM_POSITION_TITLE | VARCHAR2 | (240) | From Position Title | |
| FROM_STEP_OR_RATE | VARCHAR2 | (30) | From Step or Rate | |
| FROM_TOTAL_SALARY | VARCHAR2 | (15) | From Total Salary | |
| FUNCTIONAL_CLASS | VARCHAR2 | (30) | Functional Class | |
| INPUT_PAY_RATE_DETERMINANT | VARCHAR2 | (30) | Input PRD | |
| MASS_ACTION_COMMENTS | VARCHAR2 | (255) | Mass Action Comments | |
| MASS_ACTION_ELIGIBLE_FLAG | VARCHAR2 | (1) | Mass Action Eligible Flag | |
| MASS_ACTION_ID | NUMBER | (15) | Mass action Id | |
| MASS_ACTION_SELECT_FLAG | VARCHAR2 | (1) | Mass action Select Flag | |
| NOA_FAMILY_CODE | VARCHAR2 | (30) | Yes | Noa Familiy Code |
| PA_INCENTIVE_PAYMENT_OPTION | VARCHAR2 | (1) | Pa Incentive Payment Option | |
| PA_REQUEST_ID | NUMBER | (15) | Pa Request Id | |
| PART_TIME_HOURS | NUMBER | (5) | Part Time Hours | |
| PAY_RATE_DETERMINANT | VARCHAR2 | (30) | Pay Rate Determinant | |
| PERSON_ID | NUMBER | (10) | Person Id | |
| PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel Office Id | |
| POSITION_OCCUPIED | VARCHAR2 | (30) | Position Occupied | |
| RETIREMENT_PLAN | VARCHAR2 | (30) | Retirement Plan | |
| RETIREMENT_PLAN_DESC | VARCHAR2 | (80) | Retirement Plan Desc | |
| RPA_TYPE | VARCHAR2 | (30) | RPA type | |
| SECOND_ACTION_LA_CODE1 | VARCHAR2 | (30) | Second Action LA Code1 | |
| SECOND_ACTION_LA_CODE2 | VARCHAR2 | (30) | Second Action LA Code2 | |
| SECOND_ACTION_LA_DESC1 | VARCHAR2 | (240) | Second Action LA desc1 | |
| SECOND_ACTION_LA_DESC2 | VARCHAR2 | (240) | Second Action LA desc2 | |
| SECOND_LAC1_INFORMATION1 | VARCHAR2 | (240) | Second LAC1 Info1 | |
| SECOND_LAC1_INFORMATION2 | VARCHAR2 | (150) | Second LAC1 Info2 | |
| SECOND_LAC1_INFORMATION3 | VARCHAR2 | (150) | Second LAC1 Info3 | |
| SECOND_LAC2_INFORMATION1 | VARCHAR2 | (240) | Second LAC2 Info1 | |
| SECOND_LAC2_INFORMATION2 | VARCHAR2 | (150) | Second LAC2 Info2 | |
| SECOND_LAC2_INFORMATION3 | VARCHAR2 | (150) | Second LAC2 Info3 | |
| SECOND_NOA_CODE | VARCHAR2 | (30) | Second NOA Code | |
| SECOND_NOA_DESC | VARCHAR2 | (240) | Second NOA Desc | |
| SECOND_NOA_ID | NUMBER | (15) | Second NOA Id | |
| SECOND_NOA_INFORMATION1 | VARCHAR2 | (240) | Second NOa Info1 | |
| SECOND_NOA_INFORMATION2 | VARCHAR2 | (150) | Second NOa Info2 | |
| SERVICE_COMP_DATE | DATE | Service Comp Date | ||
| STATUS | VARCHAR2 | (30) | Status | |
| SUPERVISORY_STATUS | VARCHAR2 | (30) | Suervisory Status | |
| TENURE | VARCHAR2 | (30) | Tenure | |
| TO_ADJ_BASIC_PAY | NUMBER | (15) | To Adj Basic Pay | |
| TO_AP_PREMIUM_PAY_INDICATOR | VARCHAR2 | (30) | To AP Premium Pay Indicator | |
| 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_BASIC_PAY | NUMBER | (15) | To Basic Pay | |
| 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_LOCALITY_ADJ | NUMBER | (15) | To Locality Adj | |
| TO_OCC_CODE | VARCHAR2 | (30) | To Occ Code | |
| TO_OFFICE_SYMBOL | VARCHAR2 | (30) | To Office Symbol | |
| TO_ORGANIZATION_ID | NUMBER | (15) | To Organization Id | |
| 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_PAY_TABLE_IDENTIFIER | NUMBER | (9) | To Pay Table Identifier | |
| TO_POSITION_ID | NUMBER | (15) | To Position Id | |
| TO_POSITION_NUMBER | VARCHAR2 | (15) | To Position Number | |
| TO_POSITION_ORG_LINE1 | VARCHAR2 | (40) | To Position Org Line1 | |
| TO_POSITION_ORG_LINE2 | VARCHAR2 | (40) | To Position Org Line2 | |
| TO_POSITION_ORG_LINE3 | VARCHAR2 | (40) | To Position Org Line3 | |
| TO_POSITION_ORG_LINE4 | VARCHAR2 | (40) | To Position Org Line4 | |
| TO_POSITION_ORG_LINE5 | VARCHAR2 | (40) | To Position Org Line5 | |
| TO_POSITION_ORG_LINE6 | VARCHAR2 | (40) | To Position Org Line6 | |
| TO_POSITION_SEQ_NO | NUMBER | (15) | To Position Seq No | |
| TO_POSITION_TITLE | VARCHAR2 | (240) | To Position Title | |
| TO_RETENTION_ALLOW_PERCENTAGE | NUMBER | (5) | To Retention Allow Percentage | |
| TO_RETENTION_ALLOWANCE | NUMBER | (15) | To Retention Allowance | |
| TO_STAFFING_DIFF_PERCENTAGE | NUMBER | (5) | To Staffing diff Percentage | |
| TO_STAFFING_DIFFERENTIAL | NUMBER | (15) | To Staffing Differenctial | |
| TO_STEP_OR_RATE | VARCHAR2 | (30) | To Step Or Rate | |
| TO_SUPERVISORY_DIFF_PERCENTAGE | NUMBER | (5) | To Supervisory Diff Percentage | |
| TO_SUPERVISORY_DIFFERENTIAL | NUMBER | (15) | To Supervisory Differential | |
| TO_TOTAL_SALARY | NUMBER | (15) | To Total salary | |
| VETERANS_PREF_FOR_RIF | VARCHAR2 | (30) | Veterans Pref For Rif | |
| VETERANS_PREFERENCE | VARCHAR2 | (30) | Veterans Preference | |
| VETERANS_STATUS | VARCHAR2 | (30) | Veterans Status | |
| WORK_SCHEDULE | VARCHAR2 | (30) | Work Schedule | |
| WORK_SCHEDULE_DESC | VARCHAR2 | (80) | Work Schedule Desc | |
| YEAR_DEGREE_ATTAINED | NUMBER | (4) | Year Degree Attained | |
| INFORMATION1 | VARCHAR2 | (240) | Information1 | |
| INFORMATION2 | VARCHAR2 | (240) | Information2 | |
| INFORMATION3 | VARCHAR2 | (240) | Information3 | |
| INFORMATION4 | VARCHAR2 | (240) | Information4 | |
| INFORMATION5 | VARCHAR2 | (240) | Information5 | |
| CREATED_BY | NUMBER | (15) | Yes | Created By |
| CREATION_DATE | DATE | Yes | Creation Date | |
| LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last Update Login | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By |
Cut, paste (and edit) the following text to query this object:
SELECT IA_PREVIEW_ID
, SESSION_ID
, ACADEMIC_DISCIPLINE
, AGENCY_CODE
, ALTERED_PA_REQUEST_ID
, ANNUITANT_INDICATOR
, ANNUITANT_INDICATOR_DESC
, APPROPRIATION_CODE1
, APPROPRIATION_CODE2
, AWARD_AMOUNT
, AWARD_PERCENTAGE
, AWARD_SALARY
, AWARD_UOM
, BARGAINING_UNIT_STATUS
, CITIZENSHIP
, 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_LAC1_INFORMATION1
, FIRST_LAC1_INFORMATION2
, FIRST_LAC1_INFORMATION3
, FIRST_LAC2_INFORMATION1
, FIRST_LAC2_INFORMATION2
, FIRST_LAC2_INFORMATION3
, FIRST_NOA_ID
, FIRST_NOA_CODE
, FIRST_NOA_DESC
, FIRST_NOA_INFORMATION1
, FIRST_NOA_INFORMATION2
, 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_PAY_TABLE_IDENTIFIER
, FROM_POSITION_ID
, FROM_POSITION_NUMBER
, 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_SEQ_NO
, FROM_POSITION_TITLE
, FROM_STEP_OR_RATE
, FROM_TOTAL_SALARY
, FUNCTIONAL_CLASS
, INPUT_PAY_RATE_DETERMINANT
, MASS_ACTION_COMMENTS
, MASS_ACTION_ELIGIBLE_FLAG
, MASS_ACTION_ID
, MASS_ACTION_SELECT_FLAG
, NOA_FAMILY_CODE
, PA_INCENTIVE_PAYMENT_OPTION
, PA_REQUEST_ID
, PART_TIME_HOURS
, PAY_RATE_DETERMINANT
, PERSON_ID
, PERSONNEL_OFFICE_ID
, POSITION_OCCUPIED
, RETIREMENT_PLAN
, RETIREMENT_PLAN_DESC
, RPA_TYPE
, SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2
, SECOND_ACTION_LA_DESC1
, SECOND_ACTION_LA_DESC2
, SECOND_LAC1_INFORMATION1
, SECOND_LAC1_INFORMATION2
, SECOND_LAC1_INFORMATION3
, SECOND_LAC2_INFORMATION1
, SECOND_LAC2_INFORMATION2
, SECOND_LAC2_INFORMATION3
, SECOND_NOA_CODE
, SECOND_NOA_DESC
, SECOND_NOA_ID
, SECOND_NOA_INFORMATION1
, SECOND_NOA_INFORMATION2
, SERVICE_COMP_DATE
, STATUS
, SUPERVISORY_STATUS
, TENURE
, TO_ADJ_BASIC_PAY
, TO_AP_PREMIUM_PAY_INDICATOR
, TO_AU_OVERTIME
, TO_AUO_PREMIUM_PAY_INDICATOR
, 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_PAY_TABLE_IDENTIFIER
, TO_POSITION_ID
, TO_POSITION_NUMBER
, 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_SEQ_NO
, TO_POSITION_TITLE
, TO_RETENTION_ALLOW_PERCENTAGE
, TO_RETENTION_ALLOWANCE
, TO_STAFFING_DIFF_PERCENTAGE
, TO_STAFFING_DIFFERENTIAL
, TO_STEP_OR_RATE
, TO_SUPERVISORY_DIFF_PERCENTAGE
, TO_SUPERVISORY_DIFFERENTIAL
, TO_TOTAL_SALARY
, VETERANS_PREF_FOR_RIF
, VETERANS_PREFERENCE
, VETERANS_STATUS
, WORK_SCHEDULE
, WORK_SCHEDULE_DESC
, YEAR_DEGREE_ATTAINED
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM HR.GHR_MULTI_IA_PREVIEW;
HR.GHR_MULTI_IA_PREVIEW does not reference any database object
HR.GHR_MULTI_IA_PREVIEW is referenced by following:
HR
GHR_MULTI_IA_PREVIEW#
|
|
|
|