VIEW: APPS.GHR_MT_PEOPLE_F_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 PERSON_ID , INFORMATION8 EFFECTIVE_START_DATE , INFORMATION9 EFFECTIVE_END_DATE , INFORMATION10 BUSINESS_GROUP_ID , INFORMATION11 PERSON_TYPE_ID , INFORMATION12 LAST_NAME , INFORMATION13 START_DATE , INFORMATION14 APPLICANT_NUMBER , INFORMATION15 BACKGROUND_CHECK_STATUS , INFORMATION16 BACKGROUND_DATE_CHECK , INFORMATION17 BLOOD_TYPE , INFORMATION18 COMMENT_ID , INFORMATION19 CORRESPONDENCE_LANGUAGE , INFORMATION20 CURRENT_APPLICANT_FLAG , INFORMATION21 CURRENT_EMP_OR_APL_FLAG , INFORMATION22 CURRENT_EMPLOYEE_FLAG , INFORMATION23 DATE_EMPLOYEE_DATA_VERIFIED , INFORMATION24 DATE_OF_BIRTH , INFORMATION25 EMAIL_ADDRESS , INFORMATION26 EMPLOYEE_NUMBER , INFORMATION27 EXPENSE_CHECK_SEND_TO_ADDRESS, INFORMATION28 FAST_PATH_EMPLOYEE , INFORMATION29 FIRST_NAME , INFORMATION30 FTE_CAPACITY , INFORMATION31 FULL_NAME , INFORMATION32 HOLD_APPLICANT_DATE_UNTIL , INFORMATION33 HONORS , INFORMATION34 INTERNAL_LOCATION , INFORMATION35 KNOWN_AS , INFORMATION36 LAST_MEDICAL_TEST_BY , INFORMATION37 LAST_MEDICAL_TEST_DATE , INFORMATION38 MAILSTOP , INFORMATION39 MARITAL_STATUS , INFORMATION40 MIDDLE_NAMES , INFORMATION41 NATIONALITY , INFORMATION42 NATIONAL_IDENTIFIER , INFORMATION43 OFFICE_NUMBER , INFORMATION44 ON_MILITARY_SERVICE , INFORMATION45 ORDER_NAME , INFORMATION46 PRE_NAME_ADJUNCT , INFORMATION47 PREVIOUS_LAST_NAME , INFORMATION48 PROJECTED_START_DATE , INFORMATION49 REHIRE_AUTHORIZOR , INFORMATION50 REHIRE_RECOMMENDATION , INFORMATION51 RESUME_EXISTS , INFORMATION52 RESUME_LAST_UPDATED , INFORMATION53 REGISTERED_DISABLED_FLAG , INFORMATION54 SECOND_PASSPORT_EXISTS , INFORMATION55 SEX , INFORMATION56 STUDENT_STATUS , INFORMATION57 SUFFIX , INFORMATION58 TITLE , INFORMATION59 VENDOR_ID, INFORMATION60 WORK_SCHEDULE , INFORMATION61 WORK_TELEPHONE , INFORMATION62 REQUEST_ID , INFORMATION63 PROGRAM_APPLICATION_ID , INFORMATION64 PROGRAM_ID , INFORMATION65 PROGRAM_UPDATE_DATE , INFORMATION66 ATTRIBUTE_CATEGORY , INFORMATION67 ATTRIBUTE1 , INFORMATION68 ATTRIBUTE2 , INFORMATION69 ATTRIBUTE3 , INFORMATION70 ATTRIBUTE4 , INFORMATION71 ATTRIBUTE5 , INFORMATION72 ATTRIBUTE6 , INFORMATION73 ATTRIBUTE7 , INFORMATION74 ATTRIBUTE8 , INFORMATION75 ATTRIBUTE9 , INFORMATION76 ATTRIBUTE10 , INFORMATION77 ATTRIBUTE11 , INFORMATION78 ATTRIBUTE12 , INFORMATION79 ATTRIBUTE13 , INFORMATION80 ATTRIBUTE14 , INFORMATION81 ATTRIBUTE15 , INFORMATION82 ATTRIBUTE16 , INFORMATION83 ATTRIBUTE17 , INFORMATION84 ATTRIBUTE18 , INFORMATION85 ATTRIBUTE19 , INFORMATION86 ATTRIBUTE20 , INFORMATION87 ATTRIBUTE21 , INFORMATION88 ATTRIBUTE22 , INFORMATION89 ATTRIBUTE23 , INFORMATION90 ATTRIBUTE24 , INFORMATION91 ATTRIBUTE25 , INFORMATION92 ATTRIBUTE26 , INFORMATION93 ATTRIBUTE27 , INFORMATION94 ATTRIBUTE28, INFORMATION95 ATTRIBUTE29 , INFORMATION96 ATTRIBUTE30 , INFORMATION97 LAST_UPDATE_DATE , INFORMATION98 LAST_UPDATED_BY , INFORMATION99 LAST_UPDATE_LOGIN , INFORMATION100 CREATED_BY , INFORMATION101 CREATION_DATE , INFORMATION102 PER_INFORMATION_CATEGORY , INFORMATION103 PER_INFORMATION1 , INFORMATION104 PER_INFORMATION2 , INFORMATION105 PER_INFORMATION3 , INFORMATION106 PER_INFORMATION4 , INFORMATION107 PER_INFORMATION5 , INFORMATION108 PER_INFORMATION6 , INFORMATION109 PER_INFORMATION7 , INFORMATION110 PER_INFORMATION8 , INFORMATION111 PER_INFORMATION9 , INFORMATION112 PER_INFORMATION10 , INFORMATION113 PER_INFORMATION11 , INFORMATION114 PER_INFORMATION12 , INFORMATION115 PER_INFORMATION13 , INFORMATION116 PER_INFORMATION14 , INFORMATION117 PER_INFORMATION15 , INFORMATION118 PER_INFORMATION16 , INFORMATION119 PER_INFORMATION17 , INFORMATION120 PER_INFORMATION18 , INFORMATION121 PER_INFORMATION19 , INFORMATION122 PER_INFORMATION20 , INFORMATION123 PER_INFORMATION21 , INFORMATION124 PER_INFORMATION22, INFORMATION125 PER_INFORMATION23 , INFORMATION126 PER_INFORMATION24 , INFORMATION127 PER_INFORMATION25 , INFORMATION128 PER_INFORMATION26 , INFORMATION129 PER_INFORMATION27 , INFORMATION130 PER_INFORMATION28 , INFORMATION131 PER_INFORMATION29 , INFORMATION132 PER_INFORMATION30 , INFORMATION133 OBJECT_VERSION_NUMBER , INFORMATION134 DATE_OF_DEATH , INFORMATION135 REHIRE_REASON FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_PEOPLE_F'

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 PERSON_ID
, INFORMATION8 EFFECTIVE_START_DATE
, INFORMATION9 EFFECTIVE_END_DATE
, INFORMATION10 BUSINESS_GROUP_ID
, INFORMATION11 PERSON_TYPE_ID
, INFORMATION12 LAST_NAME
, INFORMATION13 START_DATE
, INFORMATION14 APPLICANT_NUMBER
, INFORMATION15 BACKGROUND_CHECK_STATUS
, INFORMATION16 BACKGROUND_DATE_CHECK
, INFORMATION17 BLOOD_TYPE
, INFORMATION18 COMMENT_ID
, INFORMATION19 CORRESPONDENCE_LANGUAGE
, INFORMATION20 CURRENT_APPLICANT_FLAG
, INFORMATION21 CURRENT_EMP_OR_APL_FLAG
, INFORMATION22 CURRENT_EMPLOYEE_FLAG
, INFORMATION23 DATE_EMPLOYEE_DATA_VERIFIED
, INFORMATION24 DATE_OF_BIRTH
, INFORMATION25 EMAIL_ADDRESS
, INFORMATION26 EMPLOYEE_NUMBER
, INFORMATION27 EXPENSE_CHECK_SEND_TO_ADDRESS
, INFORMATION28 FAST_PATH_EMPLOYEE
, INFORMATION29 FIRST_NAME
, INFORMATION30 FTE_CAPACITY
, INFORMATION31 FULL_NAME
, INFORMATION32 HOLD_APPLICANT_DATE_UNTIL
, INFORMATION33 HONORS
, INFORMATION34 INTERNAL_LOCATION
, INFORMATION35 KNOWN_AS
, INFORMATION36 LAST_MEDICAL_TEST_BY
, INFORMATION37 LAST_MEDICAL_TEST_DATE
, INFORMATION38 MAILSTOP
, INFORMATION39 MARITAL_STATUS
, INFORMATION40 MIDDLE_NAMES
, INFORMATION41 NATIONALITY
, INFORMATION42 NATIONAL_IDENTIFIER
, INFORMATION43 OFFICE_NUMBER
, INFORMATION44 ON_MILITARY_SERVICE
, INFORMATION45 ORDER_NAME
, INFORMATION46 PRE_NAME_ADJUNCT
, INFORMATION47 PREVIOUS_LAST_NAME
, INFORMATION48 PROJECTED_START_DATE
, INFORMATION49 REHIRE_AUTHORIZOR
, INFORMATION50 REHIRE_RECOMMENDATION
, INFORMATION51 RESUME_EXISTS
, INFORMATION52 RESUME_LAST_UPDATED
, INFORMATION53 REGISTERED_DISABLED_FLAG
, INFORMATION54 SECOND_PASSPORT_EXISTS
, INFORMATION55 SEX
, INFORMATION56 STUDENT_STATUS
, INFORMATION57 SUFFIX
, INFORMATION58 TITLE
, INFORMATION59 VENDOR_ID
, INFORMATION60 WORK_SCHEDULE
, INFORMATION61 WORK_TELEPHONE
, INFORMATION62 REQUEST_ID
, INFORMATION63 PROGRAM_APPLICATION_ID
, INFORMATION64 PROGRAM_ID
, INFORMATION65 PROGRAM_UPDATE_DATE
, INFORMATION66 ATTRIBUTE_CATEGORY
, INFORMATION67 ATTRIBUTE1
, INFORMATION68 ATTRIBUTE2
, INFORMATION69 ATTRIBUTE3
, INFORMATION70 ATTRIBUTE4
, INFORMATION71 ATTRIBUTE5
, INFORMATION72 ATTRIBUTE6
, INFORMATION73 ATTRIBUTE7
, INFORMATION74 ATTRIBUTE8
, INFORMATION75 ATTRIBUTE9
, INFORMATION76 ATTRIBUTE10
, INFORMATION77 ATTRIBUTE11
, INFORMATION78 ATTRIBUTE12
, INFORMATION79 ATTRIBUTE13
, INFORMATION80 ATTRIBUTE14
, INFORMATION81 ATTRIBUTE15
, INFORMATION82 ATTRIBUTE16
, INFORMATION83 ATTRIBUTE17
, INFORMATION84 ATTRIBUTE18
, INFORMATION85 ATTRIBUTE19
, INFORMATION86 ATTRIBUTE20
, INFORMATION87 ATTRIBUTE21
, INFORMATION88 ATTRIBUTE22
, INFORMATION89 ATTRIBUTE23
, INFORMATION90 ATTRIBUTE24
, INFORMATION91 ATTRIBUTE25
, INFORMATION92 ATTRIBUTE26
, INFORMATION93 ATTRIBUTE27
, INFORMATION94 ATTRIBUTE28
, INFORMATION95 ATTRIBUTE29
, INFORMATION96 ATTRIBUTE30
, INFORMATION97 LAST_UPDATE_DATE
, INFORMATION98 LAST_UPDATED_BY
, INFORMATION99 LAST_UPDATE_LOGIN
, INFORMATION100 CREATED_BY
, INFORMATION101 CREATION_DATE
, INFORMATION102 PER_INFORMATION_CATEGORY
, INFORMATION103 PER_INFORMATION1
, INFORMATION104 PER_INFORMATION2
, INFORMATION105 PER_INFORMATION3
, INFORMATION106 PER_INFORMATION4
, INFORMATION107 PER_INFORMATION5
, INFORMATION108 PER_INFORMATION6
, INFORMATION109 PER_INFORMATION7
, INFORMATION110 PER_INFORMATION8
, INFORMATION111 PER_INFORMATION9
, INFORMATION112 PER_INFORMATION10
, INFORMATION113 PER_INFORMATION11
, INFORMATION114 PER_INFORMATION12
, INFORMATION115 PER_INFORMATION13
, INFORMATION116 PER_INFORMATION14
, INFORMATION117 PER_INFORMATION15
, INFORMATION118 PER_INFORMATION16
, INFORMATION119 PER_INFORMATION17
, INFORMATION120 PER_INFORMATION18
, INFORMATION121 PER_INFORMATION19
, INFORMATION122 PER_INFORMATION20
, INFORMATION123 PER_INFORMATION21
, INFORMATION124 PER_INFORMATION22
, INFORMATION125 PER_INFORMATION23
, INFORMATION126 PER_INFORMATION24
, INFORMATION127 PER_INFORMATION25
, INFORMATION128 PER_INFORMATION26
, INFORMATION129 PER_INFORMATION27
, INFORMATION130 PER_INFORMATION28
, INFORMATION131 PER_INFORMATION29
, INFORMATION132 PER_INFORMATION30
, INFORMATION133 OBJECT_VERSION_NUMBER
, INFORMATION134 DATE_OF_DEATH
, INFORMATION135 REHIRE_REASON
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_PEOPLE_F'