VIEW: APPS.GHR_MT_ELEMENT_ENTRIES_V

Source

View Text - Preformatted

SELECT INTERFACE_ID GHR_INTERFACE_ID , PROCESS_DATE MT_PROCESS_DATE , SOURCE_NAME MT_SOURCE , DATE_FROM MT_EFFECTIVE_DATE , INFORMATION1 MT_NAME , INFORMATION2 MT_STATUS , INFORMATION3 MT_PERSON_ID , INFORMATION4 MT_TABLE_NAME , INFORMATION5 MT_INFORMATION_TYPE , INFORMATION6 MT_INTER_BG_TRANSFER , INFORMATION7 TOTAL_SALARY , INFORMATION8 SALARY , INFORMATION9 LOCALITY_ADJUSTMENT , INFORMATION10 ADJUSTED_PAY , INFORMATION11 OTHER_PAY , INFORMATION12 FEGLI , INFORMATION13 ELIGIBILITY_EXPIRATION , INFORMATION14 RETIREMENT_PLAN , INFORMATION15 RETENTION_ALLOWANCE , INFORMATION16 STAFFING_DIFFERENTIAL , INFORMATION17 SUPERVISORY_DIFFERENTIAL , INFORMATION18 ENROLLMENT , INFORMATION19 HEALTH_PLAN , INFORMATION20 TEMPS_TOTAL_COST , INFORMATION21 TSP_AMOUNT , INFORMATION22 TSP_RATE , INFORMATION23 TSP_G_FUND , INFORMATION24 TSP_F_FUND , INFORMATION25 TSP_C_FUND , INFORMATION26 TSP_STATUS , INFORMATION27 TSP_STATUS_DATE , INFORMATION28 TSP_ELIGIBILITY_DATE , INFORMATION29 WGI_STATUS , INFORMATION30 WGI_DATE_DUE, INFORMATION31 WGI_PAY_DATE , INFORMATION32 WGI_LAST_INCREASE_DATE , INFORMATION33 WGI_POSTPONMT_EFFECTIVE , INFORMATION34 WGI_POSTPONMT_DETERM_DUE , INFORMATION35 FEGLI_MEANING , INFORMATION36 RETIREMENT_PLAN_MEANING , information37 auo_amount , information38 auo_premium_pay_ind , information39 ap_amount , information40 ap_premium_pay_ind , information41 TO_RETENTION_ALLOW_PERCENTAGE , information42 TO_SUPERVISORY_DIFF_PERCENTAGE , information43 TO_STAFFING_DIFF_PERCENTAGE, information44 TO_BASIC_SALARY_RATE, information45 TO_ADJUSTED_BASIC_PAY, information46 TO_TOTAL_SALARY FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_ELEMENT_ENTRIES'

View Text - HTML Formatted

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 TOTAL_SALARY
, INFORMATION8 SALARY
, INFORMATION9 LOCALITY_ADJUSTMENT
, INFORMATION10 ADJUSTED_PAY
, INFORMATION11 OTHER_PAY
, INFORMATION12 FEGLI
, INFORMATION13 ELIGIBILITY_EXPIRATION
, INFORMATION14 RETIREMENT_PLAN
, INFORMATION15 RETENTION_ALLOWANCE
, INFORMATION16 STAFFING_DIFFERENTIAL
, INFORMATION17 SUPERVISORY_DIFFERENTIAL
, INFORMATION18 ENROLLMENT
, INFORMATION19 HEALTH_PLAN
, INFORMATION20 TEMPS_TOTAL_COST
, INFORMATION21 TSP_AMOUNT
, INFORMATION22 TSP_RATE
, INFORMATION23 TSP_G_FUND
, INFORMATION24 TSP_F_FUND
, INFORMATION25 TSP_C_FUND
, INFORMATION26 TSP_STATUS
, INFORMATION27 TSP_STATUS_DATE
, INFORMATION28 TSP_ELIGIBILITY_DATE
, INFORMATION29 WGI_STATUS
, INFORMATION30 WGI_DATE_DUE
, INFORMATION31 WGI_PAY_DATE
, INFORMATION32 WGI_LAST_INCREASE_DATE
, INFORMATION33 WGI_POSTPONMT_EFFECTIVE
, INFORMATION34 WGI_POSTPONMT_DETERM_DUE
, INFORMATION35 FEGLI_MEANING
, INFORMATION36 RETIREMENT_PLAN_MEANING
, INFORMATION37 AUO_AMOUNT
, INFORMATION38 AUO_PREMIUM_PAY_IND
, INFORMATION39 AP_AMOUNT
, INFORMATION40 AP_PREMIUM_PAY_IND
, INFORMATION41 TO_RETENTION_ALLOW_PERCENTAGE
, INFORMATION42 TO_SUPERVISORY_DIFF_PERCENTAGE
, INFORMATION43 TO_STAFFING_DIFF_PERCENTAGE
, INFORMATION44 TO_BASIC_SALARY_RATE
, INFORMATION45 TO_ADJUSTED_BASIC_PAY
, INFORMATION46 TO_TOTAL_SALARY
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_ELEMENT_ENTRIES'