Skip to content

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

VIEW: HR.GHR_MULTI_IA_PREVIEW#

Object Details
Object Name: GHR_MULTI_IA_PREVIEW#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
IA_PREVIEW_ID NUMBER (15) Yes
SESSION_ID NUMBER (9) Yes
ACADEMIC_DISCIPLINE VARCHAR2 (30)
AGENCY_CODE VARCHAR2 (30)
ALTERED_PA_REQUEST_ID NUMBER (15)
ANNUITANT_INDICATOR VARCHAR2 (30)
ANNUITANT_INDICATOR_DESC VARCHAR2 (80)
APPROPRIATION_CODE1 VARCHAR2 (30)
APPROPRIATION_CODE2 VARCHAR2 (30)
AWARD_AMOUNT NUMBER (15)
AWARD_PERCENTAGE NUMBER (5)
AWARD_SALARY NUMBER (15)
AWARD_UOM VARCHAR2 (30)
BARGAINING_UNIT_STATUS VARCHAR2 (30)
CITIZENSHIP VARCHAR2 (30)
DUTY_STATION_CODE VARCHAR2 (9)
DUTY_STATION_DESC VARCHAR2 (150)
DUTY_STATION_ID NUMBER (15)
DUTY_STATION_LOCATION_ID NUMBER (15)
EDUCATION_LEVEL VARCHAR2 (30)
EFFECTIVE_DATE DATE

EMPLOYEE_ASSIGNMENT_ID NUMBER (15)
EMPLOYEE_DATE_OF_BIRTH DATE

EMPLOYEE_DEPT_OR_AGENCY VARCHAR2 (80)
EMPLOYEE_FIRST_NAME VARCHAR2 (150)
EMPLOYEE_LAST_NAME VARCHAR2 (150)
EMPLOYEE_MIDDLE_NAMES VARCHAR2 (60)
EMPLOYEE_NATIONAL_IDENTIFIER VARCHAR2 (30)
FEGLI VARCHAR2 (30)
FEGLI_DESC VARCHAR2 (80)
FIRST_ACTION_LA_CODE1 VARCHAR2 (30)
FIRST_ACTION_LA_CODE2 VARCHAR2 (30)
FIRST_ACTION_LA_DESC1 VARCHAR2 (240)
FIRST_ACTION_LA_DESC2 VARCHAR2 (240)
FIRST_LAC1_INFORMATION1 VARCHAR2 (240)
FIRST_LAC1_INFORMATION2 VARCHAR2 (150)
FIRST_LAC1_INFORMATION3 VARCHAR2 (150)
FIRST_LAC2_INFORMATION1 VARCHAR2 (240)
FIRST_LAC2_INFORMATION2 VARCHAR2 (150)
FIRST_LAC2_INFORMATION3 VARCHAR2 (150)
FIRST_NOA_ID NUMBER (15)
FIRST_NOA_CODE VARCHAR2 (4)
FIRST_NOA_DESC VARCHAR2 (240)
FIRST_NOA_INFORMATION1 VARCHAR2 (240)
FIRST_NOA_INFORMATION2 VARCHAR2 (150)
FLSA_CATEGORY VARCHAR2 (30)
FORWARDING_ADDRESS_LINE1 VARCHAR2 (240)
FORWARDING_ADDRESS_LINE2 VARCHAR2 (240)
FORWARDING_ADDRESS_LINE3 VARCHAR2 (240)
FORWARDING_COUNTRY VARCHAR2 (60)
FORWARDING_COUNTRY_SHORT_NAME VARCHAR2 (80)
FORWARDING_POSTAL_CODE VARCHAR2 (30)
FORWARDING_REGION_2 VARCHAR2 (120)
FORWARDING_TOWN_OR_CITY VARCHAR2 (30)
FROM_ADJ_BASIC_PAY NUMBER (15)
FROM_AGENCY_CODE VARCHAR2 (30)
FROM_AGENCY_DESC VARCHAR2 (80)
FROM_BASIC_PAY NUMBER (15)
FROM_GRADE_OR_LEVEL VARCHAR2 (30)
FROM_LOCALITY_ADJ NUMBER (15)
FROM_OCC_CODE VARCHAR2 (150)
FROM_OFFICE_SYMBOL VARCHAR2 (30)
FROM_OTHER_PAY_AMOUNT NUMBER (15)
FROM_PAY_BASIS VARCHAR2 (30)
FROM_PAY_PLAN VARCHAR2 (2)
FROM_PAY_TABLE_IDENTIFIER NUMBER (9)
FROM_POSITION_ID NUMBER (15)
FROM_POSITION_NUMBER VARCHAR2 (15)
FROM_POSITION_ORG_LINE1 VARCHAR2 (40)
FROM_POSITION_ORG_LINE2 VARCHAR2 (40)
FROM_POSITION_ORG_LINE3 VARCHAR2 (40)
FROM_POSITION_ORG_LINE4 VARCHAR2 (40)
FROM_POSITION_ORG_LINE5 VARCHAR2 (40)
FROM_POSITION_ORG_LINE6 VARCHAR2 (40)
FROM_POSITION_SEQ_NO NUMBER (15)
FROM_POSITION_TITLE VARCHAR2 (240)
FROM_STEP_OR_RATE VARCHAR2 (30)
FROM_TOTAL_SALARY VARCHAR2 (15)
FUNCTIONAL_CLASS VARCHAR2 (30)
INPUT_PAY_RATE_DETERMINANT VARCHAR2 (30)
MASS_ACTION_COMMENTS VARCHAR2 (255)
MASS_ACTION_ELIGIBLE_FLAG VARCHAR2 (1)
MASS_ACTION_ID NUMBER (15)
MASS_ACTION_SELECT_FLAG VARCHAR2 (1)
NOA_FAMILY_CODE VARCHAR2 (30) Yes
PA_INCENTIVE_PAYMENT_OPTION VARCHAR2 (1)
PA_REQUEST_ID NUMBER (15)
PART_TIME_HOURS NUMBER (5)
PAY_RATE_DETERMINANT VARCHAR2 (30)
PERSON_ID NUMBER (10)
PERSONNEL_OFFICE_ID VARCHAR2 (4)
POSITION_OCCUPIED VARCHAR2 (30)
RETIREMENT_PLAN VARCHAR2 (30)
RETIREMENT_PLAN_DESC VARCHAR2 (80)
RPA_TYPE VARCHAR2 (30)
SECOND_ACTION_LA_CODE1 VARCHAR2 (30)
SECOND_ACTION_LA_CODE2 VARCHAR2 (30)
SECOND_ACTION_LA_DESC1 VARCHAR2 (240)
SECOND_ACTION_LA_DESC2 VARCHAR2 (240)
SECOND_LAC1_INFORMATION1 VARCHAR2 (240)
SECOND_LAC1_INFORMATION2 VARCHAR2 (150)
SECOND_LAC1_INFORMATION3 VARCHAR2 (150)
SECOND_LAC2_INFORMATION1 VARCHAR2 (240)
SECOND_LAC2_INFORMATION2 VARCHAR2 (150)
SECOND_LAC2_INFORMATION3 VARCHAR2 (150)
SECOND_NOA_CODE VARCHAR2 (30)
SECOND_NOA_DESC VARCHAR2 (240)
SECOND_NOA_ID NUMBER (15)
SECOND_NOA_INFORMATION1 VARCHAR2 (240)
SECOND_NOA_INFORMATION2 VARCHAR2 (150)
SERVICE_COMP_DATE DATE

STATUS VARCHAR2 (30)
SUPERVISORY_STATUS VARCHAR2 (30)
TENURE VARCHAR2 (30)
TO_ADJ_BASIC_PAY NUMBER (15)
TO_AP_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
TO_AU_OVERTIME NUMBER (15)
TO_AUO_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
TO_AVAILABILITY_PAY NUMBER (15)
TO_BASIC_PAY NUMBER (15)
TO_GRADE_ID NUMBER (15)
TO_GRADE_OR_LEVEL VARCHAR2 (30)
TO_JOB_ID NUMBER (15)
TO_LOCALITY_ADJ NUMBER (15)
TO_OCC_CODE VARCHAR2 (30)
TO_OFFICE_SYMBOL VARCHAR2 (30)
TO_ORGANIZATION_ID NUMBER (15)
TO_OTHER_PAY_AMOUNT NUMBER (15)
TO_PAY_BASIS VARCHAR2 (30)
TO_PAY_PLAN VARCHAR2 (2)
TO_PAY_TABLE_IDENTIFIER NUMBER (9)
TO_POSITION_ID NUMBER (15)
TO_POSITION_NUMBER VARCHAR2 (15)
TO_POSITION_ORG_LINE1 VARCHAR2 (40)
TO_POSITION_ORG_LINE2 VARCHAR2 (40)
TO_POSITION_ORG_LINE3 VARCHAR2 (40)
TO_POSITION_ORG_LINE4 VARCHAR2 (40)
TO_POSITION_ORG_LINE5 VARCHAR2 (40)
TO_POSITION_ORG_LINE6 VARCHAR2 (40)
TO_POSITION_SEQ_NO NUMBER (15)
TO_POSITION_TITLE VARCHAR2 (240)
TO_RETENTION_ALLOW_PERCENTAGE NUMBER (5)
TO_RETENTION_ALLOWANCE NUMBER (15)
TO_STAFFING_DIFF_PERCENTAGE NUMBER (5)
TO_STAFFING_DIFFERENTIAL NUMBER (15)
TO_STEP_OR_RATE VARCHAR2 (30)
TO_SUPERVISORY_DIFF_PERCENTAGE NUMBER (5)
TO_SUPERVISORY_DIFFERENTIAL NUMBER (15)
TO_TOTAL_SALARY NUMBER (15)
VETERANS_PREF_FOR_RIF VARCHAR2 (30)
VETERANS_PREFERENCE VARCHAR2 (30)
VETERANS_STATUS VARCHAR2 (30)
WORK_SCHEDULE VARCHAR2 (30)
WORK_SCHEDULE_DESC VARCHAR2 (80)
YEAR_DEGREE_ATTAINED NUMBER (4)
INFORMATION1 VARCHAR2 (240)
INFORMATION2 VARCHAR2 (240)
INFORMATION3 VARCHAR2 (240)
INFORMATION4 VARCHAR2 (240)
INFORMATION5 VARCHAR2 (240)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
Query Text

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#;

Dependencies

[top of page]

HR.GHR_MULTI_IA_PREVIEW# references the following:

SchemaHR
TableGHR_MULTI_IA_PREVIEW
HR.GHR_MULTI_IA_PREVIEW# is referenced by following:

SchemaAPPS
SynonymGHR_MULTI_IA_PREVIEW
TriggerGHR_MULTI_IA_PREVIEW_WHO