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.

VIEW: APPS.GHR_MT_INTERFACE_V

Source

View Text - Preformatted


SELECT PEOP.MT_NAME , PEOP.MT_PROCESS_DATE , PEOP.MT_EFFECTIVE_DATE , PEOP.MT_SOURCE , PEOP.MT_STATUS , TO_NUMBER(PEOP.MT_PERSON_ID) MT_PERSON_ID , PEOP.MT_INTER_BG_TRANSFER MT_INTER_BG_TRANSFER , TO_DATE(PEOP.DATE_OF_BIRTH, 'DD/MM/YYYY') DATE_OF_BIRTH , TO_DATE(PEOP.EFFECTIVE_END_DATE, 'DD/MM/YYYY') EFFECTIVE_END_DATE , TO_DATE(PEOP.EFFECTIVE_START_DATE, 'DD/MM/YYYY') EFFECTIVE_START_DATE , SUBSTR(PEOP.FIRST_NAME, 1, 150) FIRST_NAME , SUBSTR(PEOP.FULL_NAME, 1, 240) FULL_NAME , SUBSTR(PEOP.LAST_NAME, 1, 150) LAST_NAME , SUBSTR(PEOP.MARITAL_STATUS, 1, 30) MARITAL_STATUS , SUBSTR(PEOP.MIDDLE_NAMES, 1, 60) MIDDLE_NAMES , SUBSTR(PEOP.NATIONAL_IDENTIFIER, 1, 30) NATIONAL_IDENTIFIER , SUBSTR(PEOP.EMPLOYEE_NUMBER, 1, 30) EMPLOYEE_NUMBER , SUBSTR(PEOP.NATIONALITY, 1, 30) NATIONALITY , SUBSTR(PEOP.REHIRE_REASON, 1, 60) REHIRE_REASON , SUBSTR(PEOP.SEX, 1, 30) SEX , TO_DATE(PEOP.START_DATE, 'DD/MM/YYYY') START_DATE , SUBSTR(PEOP.TITLE, 1, 30) TITLE , SUBSTR(PEOP.WORK_TELEPHONE, 1, 60) WORK_TELEPHONE , SUBSTR(PEI_1.PEI_INFORMATION3, 1, 30) CITIZENSHIP, SUBSTR(PEI_1.PEI_INFORMATION4, 1, 30) VETERANS_PREFERENCE , SUBSTR(PEI_1.PEI_INFORMATION5, 1, 30) VETERANS_PREFERENCE_FOR_RIF , SUBSTR(PEI_1.PEI_INFORMATION6, 1, 30) VETERANS_STATUS , SUBSTR(PEI_1.INFO3_MEANING, 1, 80) CITIZENSHIP_DESC , SUBSTR(PEI_1.INFO4_MEANING, 1, 80) VETERANS_PREFERENCE_DESC , SUBSTR(PEI_1.INFO5_MEANING, 1, 80) VETERANS_PREFERENCE_RIF_DESC , SUBSTR(PEI_1.INFO6_MEANING, 1, 80) VETERANS_STATUS_DESC , SUBSTR(PEI_2.PEI_INFORMATION3, 1, 2) APPOINTMENT_TYPE , SUBSTR(PEI_4.PEI_INFORMATION3, 1, 80) FERS_COVERAGE , SUBSTR(PEI_4.INFO3_MEANING, 1, 80) FERS_COVERAGE_DESC , SUBSTR(PEI_2.PEI_INFORMATION4, 1, 1) TYPE_OF_EMPLOYMENT , SUBSTR(PEI_2.PEI_INFORMATION5, 1, 1) RACE_OR_NATIONAL_ORIGIN , SUBSTR(MISC.FROM_AGENCY_CODE, 1, 4) AGENCY_CODE_TRANSFER_FROM , SUBSTR(PEI_2.PEI_INFORMATION8, 1, 3) ORIG_APPOINTMENT_AUTH_CODE_1 , SUBSTR(PEI_2.PEI_INFORMATION9, 1, 3) ORIG_APPOINTMENT_AUTH_CODE_2 , SUBSTR(PEI_2.PEI_INFORMATION11, 1, 3) HANDICAP_CODE , SUBSTR(PEI_2.INFO3_MEANING, 1, 80) APPOINTMENT_TYPE_DESC , SUBSTR(PEI_2.INFO4_MEANING, 1, 80) TYPE_OF_EMPLOYMENT_DESC, SUBSTR(PEI_2.INFO5_MEANING, 1, 80) RACE_OR_NATIONAL_ORIGIN_DESC , SUBSTR(MISC.FROM_AGENCY_CODE_DESC, 1, 80) AGENCY_CODE_TRANSFER_FROM_DESC , SUBSTR(PEI_2.PEI_INFORMATION22, 1, 80) ORIG_APPT_AUTH_CODE_1_DESC , SUBSTR(PEI_2.PEI_INFORMATION23, 1, 80) ORIG_APPT_AUTH_CODE_2_DESC , SUBSTR(PEI_2.INFO11_MEANING, 1, 80) HANDICAP_CODE_DESC , fnd_date.canonical_to_date(PEI_3.PEI_INFORMATION3) SERVICE_COMP_DATE , SUBSTR(PEI_4.PEI_INFORMATION4, 1, 1) PREVIOUS_RETIREMENT_COVERAGE , SUBSTR(PEI_4.PEI_INFORMATION5, 1, 4) FROZEN_SERVICE , SUBSTR(PEI_4.INFO4_MEANING, 1, 80) PREV_RETIREMENT_COVERAGE_DESC , SUBSTR(PEI_5.PEI_INFORMATION5, 1, 4) CREDITABLE_MILITARY_SERVICE , SUBSTR(POEI_1.POEI_INFORMATION7, 1, 1) FLSA_CATEGORY , SUBSTR(POEI_1.POEI_INFORMATION8, 1, 6) BARGAINING_UNIT_STATUS , SUBSTR(POEI_1.POEI_INFORMATION11, 1, 3) FUNCTIONAL_CLASS , SUBSTR(POEI_1.POEI_INFORMATION12, 1, 60) POSITION_WORKING_TITLE , SUBSTR(POEI_1.POEI_INFORMATION16, 1, 1) SUPERVISORY_STATUS , SUBSTR(POEI_1.INFO7_MEANING, 1, 80) FLSA_CATEGORY_DESC, SUBSTR(POEI_1.INFO8_MEANING, 1, 80) BARGAINING_UNIT_STATUS_DESC , SUBSTR(POEI_1.INFO11_MEANING, 1, 80) FUNCTIONAL_CLASS_DESC , SUBSTR(POEI_1.INFO16_MEANING, 1, 80) SUPERVISORY_STATUS_DESC , SUBSTR(POEI_2.POEI_INFORMATION3, 1, 1) POSITION_OCCUPIED , SUBSTR(POEI_2.POEI_INFORMATION13, 1, 30) APPROPRIATION_CODE1 , SUBSTR(POEI_2.POEI_INFORMATION14, 1, 30) APPROPRIATION_CODE2 , SUBSTR(POEI_2.INFO3_MEANING, 1, 80) POSITION_OCCUPIED_DESC , SUBSTR(POEI_2.INFO13_MEANING, 1, 80) APPROPRIATION_CODE1_DESC , SUBSTR(POEI_2.INFO14_MEANING, 1, 80) APPROPRIATION_CODE2_DESC , TO_NUMBER(ELE_1.TOTAL_SALARY) TOTAL_SALARY , TO_NUMBER(ELE_1.SALARY) BASIC_SALARY_RATE , TO_NUMBER(ELE_1.LOCALITY_ADJUSTMENT) LOCALITY_ADJUSTMENT , TO_NUMBER(ELE_1.ADJUSTED_PAY) ADJUSTED_BASIC_PAY , TO_NUMBER(ELE_1.OTHER_PAY) OTHER_PAY , SUBSTR(ELE_1.FEGLI, 1, 30) FEGLI , SUBSTR(ELE_1.RETIREMENT_PLAN, 1, 30) RETIREMENT_PLAN , TO_NUMBER(ELE_1.RETENTION_ALLOWANCE) RETENTION_ALLOWANCE , TO_NUMBER(ELE_1.STAFFING_DIFFERENTIAL) STAFFING_DIFFERENTIAL, TO_NUMBER(ELE_1.SUPERVISORY_DIFFERENTIAL) SUPERVISORY_DIFFERENTIAL , fnd_date.canonical_to_date(ELE_1.WGI_DATE_DUE) WGI_DATE_DUE , ELE_1.FEGLI_MEANING FEGLI_DESC , ELE_1.RETIREMENT_PLAN_MEANING RETIREMENT_PLAN_DESC , TO_NUMBER(AUO_AMOUNT) AU_OVERTIME , TO_NUMBER(AP_AMOUNT) AVAILABILITY_PAY , SUBSTR(AUO_PREMIUM_PAY_IND, 1, 1) AUO_PREMIUM_PAY_INDICATOR , SUBSTR(AP_PREMIUM_PAY_IND, 1, 1) AP_PREMIUM_PAY_INDICATOR , TO_NUMBER(MISC.TO_POSITION_ID) TO_POSITION_ID , SUBSTR(MISC.FROM_GRADE_OR_LEVEL, 1, 60) FROM_GRADE_OR_LEVEL , SUBSTR(MISC.FROM_PAY_PLAN, 1, 2) FROM_PAY_PLAN , SUBSTR(MISC.FROM_POSITION_TITLE, 1, 240) FROM_POSITION_TITLE , TO_NUMBER(MISC.FROM_POSITION_SEQ_NUM) FROM_POSITION_SEQ_NUM , SUBSTR(MISC.FROM_POSITION_DESC_NUM, 1, 240) FROM_POSITION_DESC_NUM , SUBSTR(MISC.DUTY_STATION_CODE, 1, 30) DUTY_STATION_CODE , SUBSTR(MISC.DUTY_STATION_DESC, 1, 80) DUTY_STATION_DESC , SUBSTR(ASGEI_1.AEI_INFORMATION3, 1, 2) FROM_STEP_OR_RATE , SUBSTR(ASGEI_1.AEI_INFORMATION4, 1, 30) TENURE , SUBSTR(ASGEI_1.AEI_INFORMATION5, 1, 30) ANNUITANT_INDICATOR, SUBSTR(ASGEI_1.AEI_INFORMATION6, 1, 30) PAY_RATE_DETERMINANT , SUBSTR(ASGEI_1.AEI_INFORMATION7, 1, 30) WORK_SCHEDULE , TO_NUMBER(ASGEI_1.AEI_INFORMATION8) PART_TIME_HOURS , SUBSTR(ASGEI_1.INFO4_MEANING, 1, 80) TENURE_DESC , SUBSTR(ASGEI_1.INFO5_MEANING, 1, 80) ANNUITANT_INDICATOR_DESC , SUBSTR(ASGEI_1.INFO6_MEANING, 1, 80) PAY_RATE_DETERMINANT_DESC , SUBSTR(ASGEI_1.INFO7_MEANING, 1, 80) WORK_SCHEDULE_DESC , fnd_date.canonical_to_date(ASGEI_2.AEI_INFORMATION3) DATE_ARRIVED_PERSONNEL_OFFICE , SUBSTR(ASGEI_2.AEI_INFORMATION6, 1, 1) NON_DISCLOSURE_AGMT_STATUS , SUBSTR(ASGEI_2.AEI_INFORMATION8, 1, 1) PART_TIME_INDICATOR , SUBSTR(ASGEI_2.AEI_INFORMATION9, 1, 1) QUALIF_STANDARDS_WAIVER , SUBSTR(ASGEI_2.INFO6_MEANING, 1, 80) NON_DISCLOSURE_AGMT_STAT_DESC , SUBSTR(ASGEI_2.INFO8_MEANING, 1, 80) PART_TIME_INDICATOR_DESC , SUBSTR(ASGEI_2.INFO9_MEANING, 1, 80) QUALIF_STANDARDS_WAIVER_DESC , SUBSTR(PEA.SEGMENT1, 1, 2) EDUCATIONAL_LEVEL , SUBSTR(PEA.SEGMENT2, 1, 6) ACADEMIC_DISCIPLINE, SUBSTR(PEA.SEGMENT3, 1, 4) YEAR_DEGREE_ATTAINED , SUBSTR(PEA.SEGMENT1_MEANING, 1, 80) EDUCATIONAL_LEVEL_DESC , SUBSTR(PEA.SEGMENT2_MEANING, 1, 80) ACADEMIC_DISCIPLINE_DESC , ELE_1.TO_RETENTION_ALLOW_PERCENTAGE , ELE_1.TO_SUPERVISORY_DIFF_PERCENTAGE , ELE_1.TO_STAFFING_DIFF_PERCENTAGE, TO_NUMBER(ELE_1.TO_BASIC_SALARY_RATE) TO_BASIC_SALARY_RATE, TO_NUMBER(ELE_1.TO_ADJUSTED_BASIC_PAY) TO_ADJUSTED_BASIC_PAY, TO_NUMBER(ELE_1.TO_TOTAL_SALARY) TO_TOTAL_SALARY, fnd_date.canonical_to_date(ASGEI_3.AEI_INFORMATION3) ASSIGNMENT_NTE_START_DATE, fnd_date.canonical_to_date(ASGEI_3.AEI_INFORMATION4) ASSIGNMENT_NTE FROM GHR_MT_PEOPLE_EI_V PEI_1,GHR_MT_PEOPLE_EI_V PEI_2,GHR_MT_PEOPLE_EI_V PEI_3,GHR_MT_PEOPLE_EI_V PEI_4,GHR_MT_PEOPLE_EI_V PEI_5,GHR_MT_POSITIONS_V POSN,GHR_MT_POSITION_EI_V POEI_1,GHR_MT_POSITION_EI_V POEI_2,GHR_MT_ELEMENT_ENTRIES_V ELE_1,GHR_MT_MISC_V MISC,GHR_MT_ASSIGNMENTS_F_V ASGN,GHR_MT_ASSIGNMENT_EI_V ASGEI_1,GHR_MT_ASSIGNMENT_EI_V ASGEI_2,GHR_MT_ASSIGNMENT_EI_V ASGEI_3,GHR_MT_ANALYSIS_CRITERIA_V PEA,GHR_MT_PEOPLE_F_V PEOP WHERE PEOP.MT_NAME = PEI_1.MT_NAME (+) AND PEOP.PERSON_ID = PEI_1.PERSON_ID (+) AND 'GHR_US_PER_SF52' = PEI_1.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = PEI_2.MT_NAME (+) AND PEOP.PERSON_ID = PEI_2.PERSON_ID (+) AND 'GHR_US_PER_GROUP1'= PEI_2.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = PEI_3.MT_NAME (+) AND PEOP.PERSON_ID = PEI_3.PERSON_ID (+) AND 'GHR_US_PER_SCD_INFORMATION' = PEI_3.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = PEI_4.MT_NAME (+) AND PEOP.PERSON_ID = PEI_4.PERSON_ID (+) AND 'GHR_US_PER_SEPARATE_RETIRE' = PEI_4.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = PEI_5.MT_NAME (+) AND PEOP.PERSON_ID = PEI_5.PERSON_ID (+) AND 'GHR_US_PER_UNIFORMED_SERVICES'=PEI_5.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = POSN.MT_NAME (+) AND PEOP.PERSON_ID = POSN.MT_PERSON_ID (+) AND POSN.MT_NAME = POEI_1.MT_NAME (+) AND POSN.MT_PERSON_ID = POEI_1.MT_PERSON_ID (+) AND POSN.POSITION_ID = POEI_1.POSITION_ID (+) AND 'GHR_US_POS_GRP1' = POEI_1.MT_INFORMATION_TYPE (+) AND POSN.MT_NAME = POEI_2.MT_NAME (+) AND POSN.MT_PERSON_ID = POEI_2.MT_PERSON_ID (+) AND POSN.POSITION_ID = POEI_2.POSITION_ID (+) AND 'GHR_US_POS_GRP2' = POEI_2.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = ELE_1.MT_NAME (+) AND PEOP.PERSON_ID = ELE_1.MT_PERSON_ID (+) AND PEOP.MT_NAME = MISC.MT_NAME (+) AND PEOP.PERSON_ID = MISC.MT_PERSON_ID (+) AND PEOP.MT_NAME = ASGN.MT_NAME (+) AND PEOP.PERSON_ID = ASGN.MT_PERSON_ID (+) AND ASGN.MT_NAME = ASGEI_1.MT_NAME (+) AND ASGN.PERSON_ID = ASGEI_1.MT_PERSON_ID (+) AND ASGN.ASSIGNMENT_ID= ASGEI_1.ASSIGNMENT_ID (+) AND 'GHR_US_ASG_SF52' = ASGEI_1.MT_INFORMATION_TYPE (+) AND ASGN.MT_NAME = ASGEI_2.MT_NAME (+) AND ASGN.PERSON_ID = ASGEI_2.MT_PERSON_ID (+) AND ASGN.ASSIGNMENT_ID= ASGEI_2.ASSIGNMENT_ID (+) AND 'GHR_US_ASG_NON_SF52'= ASGEI_2.MT_INFORMATION_TYPE (+) AND ASGN.MT_NAME = ASGEI_3.MT_NAME (+) AND ASGN.PERSON_ID = ASGEI_3.MT_PERSON_ID (+) AND ASGN.ASSIGNMENT_ID= ASGEI_3.ASSIGNMENT_ID (+) AND 'GHR_US_ASG_NTE_DATES'= ASGEI_3.MT_INFORMATION_TYPE (+) AND PEOP.MT_NAME = PEA.MT_NAME (+) AND PEOP.PERSON_ID = PEA.MT_PERSON_ID (+) AND 'US Fed Education'= PEA.MT_INFORMATION_TYPE (+)

View Text - HTML Formatted

SELECT PEOP.MT_NAME
, PEOP.MT_PROCESS_DATE
, PEOP.MT_EFFECTIVE_DATE
, PEOP.MT_SOURCE
, PEOP.MT_STATUS
, TO_NUMBER(PEOP.MT_PERSON_ID) MT_PERSON_ID
, PEOP.MT_INTER_BG_TRANSFER MT_INTER_BG_TRANSFER
, TO_DATE(PEOP.DATE_OF_BIRTH
, 'DD/MM/YYYY') DATE_OF_BIRTH
, TO_DATE(PEOP.EFFECTIVE_END_DATE
, 'DD/MM/YYYY') EFFECTIVE_END_DATE
, TO_DATE(PEOP.EFFECTIVE_START_DATE
, 'DD/MM/YYYY') EFFECTIVE_START_DATE
, SUBSTR(PEOP.FIRST_NAME
, 1
, 150) FIRST_NAME
, SUBSTR(PEOP.FULL_NAME
, 1
, 240) FULL_NAME
, SUBSTR(PEOP.LAST_NAME
, 1
, 150) LAST_NAME
, SUBSTR(PEOP.MARITAL_STATUS
, 1
, 30) MARITAL_STATUS
, SUBSTR(PEOP.MIDDLE_NAMES
, 1
, 60) MIDDLE_NAMES
, SUBSTR(PEOP.NATIONAL_IDENTIFIER
, 1
, 30) NATIONAL_IDENTIFIER
, SUBSTR(PEOP.EMPLOYEE_NUMBER
, 1
, 30) EMPLOYEE_NUMBER
, SUBSTR(PEOP.NATIONALITY
, 1
, 30) NATIONALITY
, SUBSTR(PEOP.REHIRE_REASON
, 1
, 60) REHIRE_REASON
, SUBSTR(PEOP.SEX
, 1
, 30) SEX
, TO_DATE(PEOP.START_DATE
, 'DD/MM/YYYY') START_DATE
, SUBSTR(PEOP.TITLE
, 1
, 30) TITLE
, SUBSTR(PEOP.WORK_TELEPHONE
, 1
, 60) WORK_TELEPHONE
, SUBSTR(PEI_1.PEI_INFORMATION3
, 1
, 30) CITIZENSHIP
, SUBSTR(PEI_1.PEI_INFORMATION4
, 1
, 30) VETERANS_PREFERENCE
, SUBSTR(PEI_1.PEI_INFORMATION5
, 1
, 30) VETERANS_PREFERENCE_FOR_RIF
, SUBSTR(PEI_1.PEI_INFORMATION6
, 1
, 30) VETERANS_STATUS
, SUBSTR(PEI_1.INFO3_MEANING
, 1
, 80) CITIZENSHIP_DESC
, SUBSTR(PEI_1.INFO4_MEANING
, 1
, 80) VETERANS_PREFERENCE_DESC
, SUBSTR(PEI_1.INFO5_MEANING
, 1
, 80) VETERANS_PREFERENCE_RIF_DESC
, SUBSTR(PEI_1.INFO6_MEANING
, 1
, 80) VETERANS_STATUS_DESC
, SUBSTR(PEI_2.PEI_INFORMATION3
, 1
, 2) APPOINTMENT_TYPE
, SUBSTR(PEI_4.PEI_INFORMATION3
, 1
, 80) FERS_COVERAGE
, SUBSTR(PEI_4.INFO3_MEANING
, 1
, 80) FERS_COVERAGE_DESC
, SUBSTR(PEI_2.PEI_INFORMATION4
, 1
, 1) TYPE_OF_EMPLOYMENT
, SUBSTR(PEI_2.PEI_INFORMATION5
, 1
, 1) RACE_OR_NATIONAL_ORIGIN
, SUBSTR(MISC.FROM_AGENCY_CODE
, 1
, 4) AGENCY_CODE_TRANSFER_FROM
, SUBSTR(PEI_2.PEI_INFORMATION8
, 1
, 3) ORIG_APPOINTMENT_AUTH_CODE_1
, SUBSTR(PEI_2.PEI_INFORMATION9
, 1
, 3) ORIG_APPOINTMENT_AUTH_CODE_2
, SUBSTR(PEI_2.PEI_INFORMATION11
, 1
, 3) HANDICAP_CODE
, SUBSTR(PEI_2.INFO3_MEANING
, 1
, 80) APPOINTMENT_TYPE_DESC
, SUBSTR(PEI_2.INFO4_MEANING
, 1
, 80) TYPE_OF_EMPLOYMENT_DESC
, SUBSTR(PEI_2.INFO5_MEANING
, 1
, 80) RACE_OR_NATIONAL_ORIGIN_DESC
, SUBSTR(MISC.FROM_AGENCY_CODE_DESC
, 1
, 80) AGENCY_CODE_TRANSFER_FROM_DESC
, SUBSTR(PEI_2.PEI_INFORMATION22
, 1
, 80) ORIG_APPT_AUTH_CODE_1_DESC
, SUBSTR(PEI_2.PEI_INFORMATION23
, 1
, 80) ORIG_APPT_AUTH_CODE_2_DESC
, SUBSTR(PEI_2.INFO11_MEANING
, 1
, 80) HANDICAP_CODE_DESC
, FND_DATE.CANONICAL_TO_DATE(PEI_3.PEI_INFORMATION3) SERVICE_COMP_DATE
, SUBSTR(PEI_4.PEI_INFORMATION4
, 1
, 1) PREVIOUS_RETIREMENT_COVERAGE
, SUBSTR(PEI_4.PEI_INFORMATION5
, 1
, 4) FROZEN_SERVICE
, SUBSTR(PEI_4.INFO4_MEANING
, 1
, 80) PREV_RETIREMENT_COVERAGE_DESC
, SUBSTR(PEI_5.PEI_INFORMATION5
, 1
, 4) CREDITABLE_MILITARY_SERVICE
, SUBSTR(POEI_1.POEI_INFORMATION7
, 1
, 1) FLSA_CATEGORY
, SUBSTR(POEI_1.POEI_INFORMATION8
, 1
, 6) BARGAINING_UNIT_STATUS
, SUBSTR(POEI_1.POEI_INFORMATION11
, 1
, 3) FUNCTIONAL_CLASS
, SUBSTR(POEI_1.POEI_INFORMATION12
, 1
, 60) POSITION_WORKING_TITLE
, SUBSTR(POEI_1.POEI_INFORMATION16
, 1
, 1) SUPERVISORY_STATUS
, SUBSTR(POEI_1.INFO7_MEANING
, 1
, 80) FLSA_CATEGORY_DESC
, SUBSTR(POEI_1.INFO8_MEANING
, 1
, 80) BARGAINING_UNIT_STATUS_DESC
, SUBSTR(POEI_1.INFO11_MEANING
, 1
, 80) FUNCTIONAL_CLASS_DESC
, SUBSTR(POEI_1.INFO16_MEANING
, 1
, 80) SUPERVISORY_STATUS_DESC
, SUBSTR(POEI_2.POEI_INFORMATION3
, 1
, 1) POSITION_OCCUPIED
, SUBSTR(POEI_2.POEI_INFORMATION13
, 1
, 30) APPROPRIATION_CODE1
, SUBSTR(POEI_2.POEI_INFORMATION14
, 1
, 30) APPROPRIATION_CODE2
, SUBSTR(POEI_2.INFO3_MEANING
, 1
, 80) POSITION_OCCUPIED_DESC
, SUBSTR(POEI_2.INFO13_MEANING
, 1
, 80) APPROPRIATION_CODE1_DESC
, SUBSTR(POEI_2.INFO14_MEANING
, 1
, 80) APPROPRIATION_CODE2_DESC
, TO_NUMBER(ELE_1.TOTAL_SALARY) TOTAL_SALARY
, TO_NUMBER(ELE_1.SALARY) BASIC_SALARY_RATE
, TO_NUMBER(ELE_1.LOCALITY_ADJUSTMENT) LOCALITY_ADJUSTMENT
, TO_NUMBER(ELE_1.ADJUSTED_PAY) ADJUSTED_BASIC_PAY
, TO_NUMBER(ELE_1.OTHER_PAY) OTHER_PAY
, SUBSTR(ELE_1.FEGLI
, 1
, 30) FEGLI
, SUBSTR(ELE_1.RETIREMENT_PLAN
, 1
, 30) RETIREMENT_PLAN
, TO_NUMBER(ELE_1.RETENTION_ALLOWANCE) RETENTION_ALLOWANCE
, TO_NUMBER(ELE_1.STAFFING_DIFFERENTIAL) STAFFING_DIFFERENTIAL
, TO_NUMBER(ELE_1.SUPERVISORY_DIFFERENTIAL) SUPERVISORY_DIFFERENTIAL
, FND_DATE.CANONICAL_TO_DATE(ELE_1.WGI_DATE_DUE) WGI_DATE_DUE
, ELE_1.FEGLI_MEANING FEGLI_DESC
, ELE_1.RETIREMENT_PLAN_MEANING RETIREMENT_PLAN_DESC
, TO_NUMBER(AUO_AMOUNT) AU_OVERTIME
, TO_NUMBER(AP_AMOUNT) AVAILABILITY_PAY
, SUBSTR(AUO_PREMIUM_PAY_IND
, 1
, 1) AUO_PREMIUM_PAY_INDICATOR
, SUBSTR(AP_PREMIUM_PAY_IND
, 1
, 1) AP_PREMIUM_PAY_INDICATOR
, TO_NUMBER(MISC.TO_POSITION_ID) TO_POSITION_ID
, SUBSTR(MISC.FROM_GRADE_OR_LEVEL
, 1
, 60) FROM_GRADE_OR_LEVEL
, SUBSTR(MISC.FROM_PAY_PLAN
, 1
, 2) FROM_PAY_PLAN
, SUBSTR(MISC.FROM_POSITION_TITLE
, 1
, 240) FROM_POSITION_TITLE
, TO_NUMBER(MISC.FROM_POSITION_SEQ_NUM) FROM_POSITION_SEQ_NUM
, SUBSTR(MISC.FROM_POSITION_DESC_NUM
, 1
, 240) FROM_POSITION_DESC_NUM
, SUBSTR(MISC.DUTY_STATION_CODE
, 1
, 30) DUTY_STATION_CODE
, SUBSTR(MISC.DUTY_STATION_DESC
, 1
, 80) DUTY_STATION_DESC
, SUBSTR(ASGEI_1.AEI_INFORMATION3
, 1
, 2) FROM_STEP_OR_RATE
, SUBSTR(ASGEI_1.AEI_INFORMATION4
, 1
, 30) TENURE
, SUBSTR(ASGEI_1.AEI_INFORMATION5
, 1
, 30) ANNUITANT_INDICATOR
, SUBSTR(ASGEI_1.AEI_INFORMATION6
, 1
, 30) PAY_RATE_DETERMINANT
, SUBSTR(ASGEI_1.AEI_INFORMATION7
, 1
, 30) WORK_SCHEDULE
, TO_NUMBER(ASGEI_1.AEI_INFORMATION8) PART_TIME_HOURS
, SUBSTR(ASGEI_1.INFO4_MEANING
, 1
, 80) TENURE_DESC
, SUBSTR(ASGEI_1.INFO5_MEANING
, 1
, 80) ANNUITANT_INDICATOR_DESC
, SUBSTR(ASGEI_1.INFO6_MEANING
, 1
, 80) PAY_RATE_DETERMINANT_DESC
, SUBSTR(ASGEI_1.INFO7_MEANING
, 1
, 80) WORK_SCHEDULE_DESC
, FND_DATE.CANONICAL_TO_DATE(ASGEI_2.AEI_INFORMATION3) DATE_ARRIVED_PERSONNEL_OFFICE
, SUBSTR(ASGEI_2.AEI_INFORMATION6
, 1
, 1) NON_DISCLOSURE_AGMT_STATUS
, SUBSTR(ASGEI_2.AEI_INFORMATION8
, 1
, 1) PART_TIME_INDICATOR
, SUBSTR(ASGEI_2.AEI_INFORMATION9
, 1
, 1) QUALIF_STANDARDS_WAIVER
, SUBSTR(ASGEI_2.INFO6_MEANING
, 1
, 80) NON_DISCLOSURE_AGMT_STAT_DESC
, SUBSTR(ASGEI_2.INFO8_MEANING
, 1
, 80) PART_TIME_INDICATOR_DESC
, SUBSTR(ASGEI_2.INFO9_MEANING
, 1
, 80) QUALIF_STANDARDS_WAIVER_DESC
, SUBSTR(PEA.SEGMENT1
, 1
, 2) EDUCATIONAL_LEVEL
, SUBSTR(PEA.SEGMENT2
, 1
, 6) ACADEMIC_DISCIPLINE
, SUBSTR(PEA.SEGMENT3
, 1
, 4) YEAR_DEGREE_ATTAINED
, SUBSTR(PEA.SEGMENT1_MEANING
, 1
, 80) EDUCATIONAL_LEVEL_DESC
, SUBSTR(PEA.SEGMENT2_MEANING
, 1
, 80) ACADEMIC_DISCIPLINE_DESC
, ELE_1.TO_RETENTION_ALLOW_PERCENTAGE
, ELE_1.TO_SUPERVISORY_DIFF_PERCENTAGE
, ELE_1.TO_STAFFING_DIFF_PERCENTAGE
, TO_NUMBER(ELE_1.TO_BASIC_SALARY_RATE) TO_BASIC_SALARY_RATE
, TO_NUMBER(ELE_1.TO_ADJUSTED_BASIC_PAY) TO_ADJUSTED_BASIC_PAY
, TO_NUMBER(ELE_1.TO_TOTAL_SALARY) TO_TOTAL_SALARY
, FND_DATE.CANONICAL_TO_DATE(ASGEI_3.AEI_INFORMATION3) ASSIGNMENT_NTE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(ASGEI_3.AEI_INFORMATION4) ASSIGNMENT_NTE
FROM GHR_MT_PEOPLE_EI_V PEI_1
, GHR_MT_PEOPLE_EI_V PEI_2
, GHR_MT_PEOPLE_EI_V PEI_3
, GHR_MT_PEOPLE_EI_V PEI_4
, GHR_MT_PEOPLE_EI_V PEI_5
, GHR_MT_POSITIONS_V POSN
, GHR_MT_POSITION_EI_V POEI_1
, GHR_MT_POSITION_EI_V POEI_2
, GHR_MT_ELEMENT_ENTRIES_V ELE_1
, GHR_MT_MISC_V MISC
, GHR_MT_ASSIGNMENTS_F_V ASGN
, GHR_MT_ASSIGNMENT_EI_V ASGEI_1
, GHR_MT_ASSIGNMENT_EI_V ASGEI_2
, GHR_MT_ASSIGNMENT_EI_V ASGEI_3
, GHR_MT_ANALYSIS_CRITERIA_V PEA
, GHR_MT_PEOPLE_F_V PEOP
WHERE PEOP.MT_NAME = PEI_1.MT_NAME (+)
AND PEOP.PERSON_ID = PEI_1.PERSON_ID (+)
AND 'GHR_US_PER_SF52' = PEI_1.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = PEI_2.MT_NAME (+)
AND PEOP.PERSON_ID = PEI_2.PERSON_ID (+)
AND 'GHR_US_PER_GROUP1'= PEI_2.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = PEI_3.MT_NAME (+)
AND PEOP.PERSON_ID = PEI_3.PERSON_ID (+)
AND 'GHR_US_PER_SCD_INFORMATION' = PEI_3.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = PEI_4.MT_NAME (+)
AND PEOP.PERSON_ID = PEI_4.PERSON_ID (+)
AND 'GHR_US_PER_SEPARATE_RETIRE' = PEI_4.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = PEI_5.MT_NAME (+)
AND PEOP.PERSON_ID = PEI_5.PERSON_ID (+)
AND 'GHR_US_PER_UNIFORMED_SERVICES'=PEI_5.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = POSN.MT_NAME (+)
AND PEOP.PERSON_ID = POSN.MT_PERSON_ID (+)
AND POSN.MT_NAME = POEI_1.MT_NAME (+)
AND POSN.MT_PERSON_ID = POEI_1.MT_PERSON_ID (+)
AND POSN.POSITION_ID = POEI_1.POSITION_ID (+)
AND 'GHR_US_POS_GRP1' = POEI_1.MT_INFORMATION_TYPE (+)
AND POSN.MT_NAME = POEI_2.MT_NAME (+)
AND POSN.MT_PERSON_ID = POEI_2.MT_PERSON_ID (+)
AND POSN.POSITION_ID = POEI_2.POSITION_ID (+)
AND 'GHR_US_POS_GRP2' = POEI_2.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = ELE_1.MT_NAME (+)
AND PEOP.PERSON_ID = ELE_1.MT_PERSON_ID (+)
AND PEOP.MT_NAME = MISC.MT_NAME (+)
AND PEOP.PERSON_ID = MISC.MT_PERSON_ID (+)
AND PEOP.MT_NAME = ASGN.MT_NAME (+)
AND PEOP.PERSON_ID = ASGN.MT_PERSON_ID (+)
AND ASGN.MT_NAME = ASGEI_1.MT_NAME (+)
AND ASGN.PERSON_ID = ASGEI_1.MT_PERSON_ID (+)
AND ASGN.ASSIGNMENT_ID= ASGEI_1.ASSIGNMENT_ID (+)
AND 'GHR_US_ASG_SF52' = ASGEI_1.MT_INFORMATION_TYPE (+)
AND ASGN.MT_NAME = ASGEI_2.MT_NAME (+)
AND ASGN.PERSON_ID = ASGEI_2.MT_PERSON_ID (+)
AND ASGN.ASSIGNMENT_ID= ASGEI_2.ASSIGNMENT_ID (+)
AND 'GHR_US_ASG_NON_SF52'= ASGEI_2.MT_INFORMATION_TYPE (+)
AND ASGN.MT_NAME = ASGEI_3.MT_NAME (+)
AND ASGN.PERSON_ID = ASGEI_3.MT_PERSON_ID (+)
AND ASGN.ASSIGNMENT_ID= ASGEI_3.ASSIGNMENT_ID (+)
AND 'GHR_US_ASG_NTE_DATES'= ASGEI_3.MT_INFORMATION_TYPE (+)
AND PEOP.MT_NAME = PEA.MT_NAME (+)
AND PEOP.PERSON_ID = PEA.MT_PERSON_ID (+)
AND 'US FED EDUCATION'= PEA.MT_INFORMATION_TYPE (+)