Product: | GHR - US Federal Human Resources |
---|---|
Description: | This views is used by mass transfer in and out processes for datatransfer. |
Implementation/DBA Data: | APPS.GHR_MT_PEOPLE_F_V |
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'