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_PEOPLE_H_V

Source

View Text - Preformatted


SELECT PA_HISTORY_ID , PROCESS_DATE , EFFECTIVE_DATE , DML_OPERATION , PRE_VALUES_FLAG , ALTERED_PA_REQUEST_ID , PA_REQUEST_ID , NATURE_OF_ACTION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION1) PERSON_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION4) DATE_OF_DEATH , TO_NUMBER(INFORMATION5) PERSON_TYPE_ID , SUBSTR(INFORMATION6,1,150) LAST_NAME , FND_DATE.CANONICAL_TO_DATE(INFORMATION7) START_DATE , SUBSTR(INFORMATION8,1,30) APPLICANT_NUMBER , SUBSTR(INFORMATION9,1,30) BACKGROUND_CHECK_STATUS , FND_DATE.CANONICAL_TO_DATE(INFORMATION10) BACKGROUND_DATE_CHECK , SUBSTR(INFORMATION11,1,30) BLOOD_TYPE , GHR_GENERAL.RETURN_NUMBER(INFORMATION12) COMMENT_ID , SUBSTR(INFORMATION13,1,30) CORRESPONDENCE_LANGUAGE , SUBSTR(INFORMATION14,1,30) CURRENT_APPLICANT_FLAG , SUBSTR(INFORMATION15,1,30) CURRENT_EMP_OR_APL_FLAG , SUBSTR(INFORMATION16,1,30) CURRENT_EMPLOYEE_FLAG , FND_DATE.CANONICAL_TO_DATE(INFORMATION17) DATE_EMPLOYEE_DATA_VERIFIED , FND_DATE.CANONICAL_TO_DATE(INFORMATION18) DATE_OF_BIRTH , SUBSTR(INFORMATION19,1,240) EMAIL_ADDRESS , SUBSTR(INFORMATION20,1,30) EMPLOYEE_NUMBER , SUBSTR(INFORMATION21,1,30) EXPENSE_CHECK_SEND_TO_ADDRESS , SUBSTR(INFORMATION22,1,30) FAST_PATH_EMPLOYEE , SUBSTR(INFORMATION23,1,150) FIRST_NAME , GHR_GENERAL.RETURN_NUMBER(INFORMATION24) FTE_CAPACITY , SUBSTR(INFORMATION25,1,240) FULL_NAME , FND_DATE.CANONICAL_TO_DATE(INFORMATION26) HOLD_APPLICANT_DATE_UNTIL , SUBSTR(INFORMATION27,1,45) HONORS , SUBSTR(INFORMATION28,1,45) INTERNAL_LOCATION , SUBSTR(INFORMATION29,1,80) KNOWN_AS , SUBSTR(INFORMATION30,1,60) LAST_MEDICAL_TEST_BY , FND_DATE.CANONICAL_TO_DATE(INFORMATION31) LAST_MEDICAL_TEST_DATE , SUBSTR(INFORMATION32,1,45) MAILSTOP , SUBSTR(INFORMATION33,1,30) MARITAL_STATUS , SUBSTR(INFORMATION34,1,60) MIDDLE_NAMES , SUBSTR(INFORMATION35,1,30) NATIONALITY , SUBSTR(INFORMATION36,1,30) NATIONAL_IDENTIFIER , SUBSTR(INFORMATION37,1,45) OFFICE_NUMBER , SUBSTR(INFORMATION38,1,30) ON_MILITARY_SERVICE , SUBSTR(INFORMATION39,1,240) ORDER_NAME , SUBSTR(INFORMATION40,1,30) PRE_NAME_ADJUNCT , SUBSTR(INFORMATION41,1,150) PREVIOUS_LAST_NAME , FND_DATE.CANONICAL_TO_DATE(INFORMATION42) PROJECTED_START_DATE , SUBSTR(INFORMATION43,1,30) REHIRE_AUTHORIZOR , SUBSTR(INFORMATION44,1,30) REHIRE_RECOMMENDATION , SUBSTR(INFORMATION45,1,30) RESUME_EXISTS , FND_DATE.CANONICAL_TO_DATE(INFORMATION46) RESUME_LAST_UPDATED , SUBSTR(INFORMATION47,1,30) REGISTERED_DISABLED_FLAG , SUBSTR(INFORMATION48,1,30) SECOND_PASSPORT_EXISTS , SUBSTR(INFORMATION49,1,30) SEX , SUBSTR(INFORMATION50,1,30) STUDENT_STATUS , SUBSTR(INFORMATION51,1,30) SUFFIX , SUBSTR(INFORMATION52,1,30) TITLE , GHR_GENERAL.RETURN_NUMBER(INFORMATION53) VENDOR_ID , SUBSTR(INFORMATION54,1,30) WORK_SCHEDULE , SUBSTR(INFORMATION55,1,60) WORK_TELEPHONE , SUBSTR(INFORMATION56,1,30) PER_INFORMATION_CATEGORY , SUBSTR(INFORMATION57,1,150) PER_INFORMATION1 , SUBSTR(INFORMATION58,1,150) PER_INFORMATION2 , SUBSTR(INFORMATION59,1,150) PER_INFORMATION3 , SUBSTR(INFORMATION60,1,150) PER_INFORMATION4 , SUBSTR(INFORMATION61,1,150) PER_INFORMATION5 , SUBSTR(INFORMATION62,1,150) PER_INFORMATION6 , SUBSTR(INFORMATION63,1,150) PER_INFORMATION7 , SUBSTR(INFORMATION64,1,150) PER_INFORMATION8 , SUBSTR(INFORMATION65,1,150) PER_INFORMATION9 , SUBSTR(INFORMATION66,1,150) PER_INFORMATION10 , SUBSTR(INFORMATION67,1,150) PER_INFORMATION11 , SUBSTR(INFORMATION68,1,150) PER_INFORMATION12 , SUBSTR(INFORMATION69,1,150) PER_INFORMATION13 , SUBSTR(INFORMATION70,1,150) PER_INFORMATION14 , SUBSTR(INFORMATION71,1,150) PER_INFORMATION15 , SUBSTR(INFORMATION72,1,150) PER_INFORMATION16 , SUBSTR(INFORMATION73,1,150) PER_INFORMATION17 , SUBSTR(INFORMATION74,1,150) PER_INFORMATION18 , SUBSTR(INFORMATION75,1,150) PER_INFORMATION19 , SUBSTR(INFORMATION76,1,150) PER_INFORMATION20 , SUBSTR(INFORMATION77,1,150) PER_INFORMATION21 , SUBSTR(INFORMATION78,1,150) PER_INFORMATION22 , SUBSTR(INFORMATION79,1,150) PER_INFORMATION23 , SUBSTR(INFORMATION80,1,150) PER_INFORMATION24 , SUBSTR(INFORMATION81,1,150) PER_INFORMATION25 , SUBSTR(INFORMATION82,1,150) PER_INFORMATION26 , SUBSTR(INFORMATION83,1,150) PER_INFORMATION27 , SUBSTR(INFORMATION84,1,150) PER_INFORMATION28 , SUBSTR(INFORMATION85,1,150) PER_INFORMATION29 , SUBSTR(INFORMATION86,1,150) PER_INFORMATION30 , SUBSTR(INFORMATION87,1,150) REHIRE_REASON , GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION123) PROGRAM_UPDATE_DATE , SUBSTR(INFORMATION125,1,30) ATTRIBUTE_CATEGORY , SUBSTR(INFORMATION126,1,150) ATTRIBUTE1 , SUBSTR(INFORMATION127,1,150) ATTRIBUTE2 , SUBSTR(INFORMATION128,1,150) ATTRIBUTE3 , SUBSTR(INFORMATION129,1,150) ATTRIBUTE4 , SUBSTR(INFORMATION130,1,150) ATTRIBUTE5 , SUBSTR(INFORMATION131,1,150) ATTRIBUTE6 , SUBSTR(INFORMATION132,1,150) ATTRIBUTE7 , SUBSTR(INFORMATION133,1,150) ATTRIBUTE8 , SUBSTR(INFORMATION134,1,150) ATTRIBUTE9 , SUBSTR(INFORMATION135,1,150) ATTRIBUTE10 , SUBSTR(INFORMATION136,1,150) ATTRIBUTE11 , SUBSTR(INFORMATION137,1,150) ATTRIBUTE12 , SUBSTR(INFORMATION138,1,150) ATTRIBUTE13 , SUBSTR(INFORMATION139,1,150) ATTRIBUTE14 , SUBSTR(INFORMATION140,1,150) ATTRIBUTE15 , SUBSTR(INFORMATION141,1,150) ATTRIBUTE16 , SUBSTR(INFORMATION142,1,150) ATTRIBUTE17 , SUBSTR(INFORMATION143,1,150) ATTRIBUTE18 , SUBSTR(INFORMATION144,1,150) ATTRIBUTE19 , SUBSTR(INFORMATION145,1,150) ATTRIBUTE20 , SUBSTR(INFORMATION146,1,150) ATTRIBUTE21 , SUBSTR(INFORMATION147,1,150) ATTRIBUTE22 , SUBSTR(INFORMATION148,1,150) ATTRIBUTE23 , SUBSTR(INFORMATION149,1,150) ATTRIBUTE24 , SUBSTR(INFORMATION150,1,150) ATTRIBUTE25 , SUBSTR(INFORMATION151,1,150) ATTRIBUTE26 , SUBSTR(INFORMATION152,1,150) ATTRIBUTE27 , SUBSTR(INFORMATION153,1,150) ATTRIBUTE28 , SUBSTR(INFORMATION154,1,150) ATTRIBUTE29 , SUBSTR(INFORMATION155,1,150) ATTRIBUTE30 , GHR_GENERAL.RETURN_NUMBER(INFORMATION162) BUSINESS_GROUP_ID FROM GHR_PA_HISTORY WHERE TABLE_NAME = 'PER_PEOPLE_F'

View Text - HTML Formatted

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) PERSON_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION4) DATE_OF_DEATH
, TO_NUMBER(INFORMATION5) PERSON_TYPE_ID
, SUBSTR(INFORMATION6
, 1
, 150) LAST_NAME
, FND_DATE.CANONICAL_TO_DATE(INFORMATION7) START_DATE
, SUBSTR(INFORMATION8
, 1
, 30) APPLICANT_NUMBER
, SUBSTR(INFORMATION9
, 1
, 30) BACKGROUND_CHECK_STATUS
, FND_DATE.CANONICAL_TO_DATE(INFORMATION10) BACKGROUND_DATE_CHECK
, SUBSTR(INFORMATION11
, 1
, 30) BLOOD_TYPE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION12) COMMENT_ID
, SUBSTR(INFORMATION13
, 1
, 30) CORRESPONDENCE_LANGUAGE
, SUBSTR(INFORMATION14
, 1
, 30) CURRENT_APPLICANT_FLAG
, SUBSTR(INFORMATION15
, 1
, 30) CURRENT_EMP_OR_APL_FLAG
, SUBSTR(INFORMATION16
, 1
, 30) CURRENT_EMPLOYEE_FLAG
, FND_DATE.CANONICAL_TO_DATE(INFORMATION17) DATE_EMPLOYEE_DATA_VERIFIED
, FND_DATE.CANONICAL_TO_DATE(INFORMATION18) DATE_OF_BIRTH
, SUBSTR(INFORMATION19
, 1
, 240) EMAIL_ADDRESS
, SUBSTR(INFORMATION20
, 1
, 30) EMPLOYEE_NUMBER
, SUBSTR(INFORMATION21
, 1
, 30) EXPENSE_CHECK_SEND_TO_ADDRESS
, SUBSTR(INFORMATION22
, 1
, 30) FAST_PATH_EMPLOYEE
, SUBSTR(INFORMATION23
, 1
, 150) FIRST_NAME
, GHR_GENERAL.RETURN_NUMBER(INFORMATION24) FTE_CAPACITY
, SUBSTR(INFORMATION25
, 1
, 240) FULL_NAME
, FND_DATE.CANONICAL_TO_DATE(INFORMATION26) HOLD_APPLICANT_DATE_UNTIL
, SUBSTR(INFORMATION27
, 1
, 45) HONORS
, SUBSTR(INFORMATION28
, 1
, 45) INTERNAL_LOCATION
, SUBSTR(INFORMATION29
, 1
, 80) KNOWN_AS
, SUBSTR(INFORMATION30
, 1
, 60) LAST_MEDICAL_TEST_BY
, FND_DATE.CANONICAL_TO_DATE(INFORMATION31) LAST_MEDICAL_TEST_DATE
, SUBSTR(INFORMATION32
, 1
, 45) MAILSTOP
, SUBSTR(INFORMATION33
, 1
, 30) MARITAL_STATUS
, SUBSTR(INFORMATION34
, 1
, 60) MIDDLE_NAMES
, SUBSTR(INFORMATION35
, 1
, 30) NATIONALITY
, SUBSTR(INFORMATION36
, 1
, 30) NATIONAL_IDENTIFIER
, SUBSTR(INFORMATION37
, 1
, 45) OFFICE_NUMBER
, SUBSTR(INFORMATION38
, 1
, 30) ON_MILITARY_SERVICE
, SUBSTR(INFORMATION39
, 1
, 240) ORDER_NAME
, SUBSTR(INFORMATION40
, 1
, 30) PRE_NAME_ADJUNCT
, SUBSTR(INFORMATION41
, 1
, 150) PREVIOUS_LAST_NAME
, FND_DATE.CANONICAL_TO_DATE(INFORMATION42) PROJECTED_START_DATE
, SUBSTR(INFORMATION43
, 1
, 30) REHIRE_AUTHORIZOR
, SUBSTR(INFORMATION44
, 1
, 30) REHIRE_RECOMMENDATION
, SUBSTR(INFORMATION45
, 1
, 30) RESUME_EXISTS
, FND_DATE.CANONICAL_TO_DATE(INFORMATION46) RESUME_LAST_UPDATED
, SUBSTR(INFORMATION47
, 1
, 30) REGISTERED_DISABLED_FLAG
, SUBSTR(INFORMATION48
, 1
, 30) SECOND_PASSPORT_EXISTS
, SUBSTR(INFORMATION49
, 1
, 30) SEX
, SUBSTR(INFORMATION50
, 1
, 30) STUDENT_STATUS
, SUBSTR(INFORMATION51
, 1
, 30) SUFFIX
, SUBSTR(INFORMATION52
, 1
, 30) TITLE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION53) VENDOR_ID
, SUBSTR(INFORMATION54
, 1
, 30) WORK_SCHEDULE
, SUBSTR(INFORMATION55
, 1
, 60) WORK_TELEPHONE
, SUBSTR(INFORMATION56
, 1
, 30) PER_INFORMATION_CATEGORY
, SUBSTR(INFORMATION57
, 1
, 150) PER_INFORMATION1
, SUBSTR(INFORMATION58
, 1
, 150) PER_INFORMATION2
, SUBSTR(INFORMATION59
, 1
, 150) PER_INFORMATION3
, SUBSTR(INFORMATION60
, 1
, 150) PER_INFORMATION4
, SUBSTR(INFORMATION61
, 1
, 150) PER_INFORMATION5
, SUBSTR(INFORMATION62
, 1
, 150) PER_INFORMATION6
, SUBSTR(INFORMATION63
, 1
, 150) PER_INFORMATION7
, SUBSTR(INFORMATION64
, 1
, 150) PER_INFORMATION8
, SUBSTR(INFORMATION65
, 1
, 150) PER_INFORMATION9
, SUBSTR(INFORMATION66
, 1
, 150) PER_INFORMATION10
, SUBSTR(INFORMATION67
, 1
, 150) PER_INFORMATION11
, SUBSTR(INFORMATION68
, 1
, 150) PER_INFORMATION12
, SUBSTR(INFORMATION69
, 1
, 150) PER_INFORMATION13
, SUBSTR(INFORMATION70
, 1
, 150) PER_INFORMATION14
, SUBSTR(INFORMATION71
, 1
, 150) PER_INFORMATION15
, SUBSTR(INFORMATION72
, 1
, 150) PER_INFORMATION16
, SUBSTR(INFORMATION73
, 1
, 150) PER_INFORMATION17
, SUBSTR(INFORMATION74
, 1
, 150) PER_INFORMATION18
, SUBSTR(INFORMATION75
, 1
, 150) PER_INFORMATION19
, SUBSTR(INFORMATION76
, 1
, 150) PER_INFORMATION20
, SUBSTR(INFORMATION77
, 1
, 150) PER_INFORMATION21
, SUBSTR(INFORMATION78
, 1
, 150) PER_INFORMATION22
, SUBSTR(INFORMATION79
, 1
, 150) PER_INFORMATION23
, SUBSTR(INFORMATION80
, 1
, 150) PER_INFORMATION24
, SUBSTR(INFORMATION81
, 1
, 150) PER_INFORMATION25
, SUBSTR(INFORMATION82
, 1
, 150) PER_INFORMATION26
, SUBSTR(INFORMATION83
, 1
, 150) PER_INFORMATION27
, SUBSTR(INFORMATION84
, 1
, 150) PER_INFORMATION28
, SUBSTR(INFORMATION85
, 1
, 150) PER_INFORMATION29
, SUBSTR(INFORMATION86
, 1
, 150) PER_INFORMATION30
, SUBSTR(INFORMATION87
, 1
, 150) REHIRE_REASON
, GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION123) PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION125
, 1
, 30) ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION126
, 1
, 150) ATTRIBUTE1
, SUBSTR(INFORMATION127
, 1
, 150) ATTRIBUTE2
, SUBSTR(INFORMATION128
, 1
, 150) ATTRIBUTE3
, SUBSTR(INFORMATION129
, 1
, 150) ATTRIBUTE4
, SUBSTR(INFORMATION130
, 1
, 150) ATTRIBUTE5
, SUBSTR(INFORMATION131
, 1
, 150) ATTRIBUTE6
, SUBSTR(INFORMATION132
, 1
, 150) ATTRIBUTE7
, SUBSTR(INFORMATION133
, 1
, 150) ATTRIBUTE8
, SUBSTR(INFORMATION134
, 1
, 150) ATTRIBUTE9
, SUBSTR(INFORMATION135
, 1
, 150) ATTRIBUTE10
, SUBSTR(INFORMATION136
, 1
, 150) ATTRIBUTE11
, SUBSTR(INFORMATION137
, 1
, 150) ATTRIBUTE12
, SUBSTR(INFORMATION138
, 1
, 150) ATTRIBUTE13
, SUBSTR(INFORMATION139
, 1
, 150) ATTRIBUTE14
, SUBSTR(INFORMATION140
, 1
, 150) ATTRIBUTE15
, SUBSTR(INFORMATION141
, 1
, 150) ATTRIBUTE16
, SUBSTR(INFORMATION142
, 1
, 150) ATTRIBUTE17
, SUBSTR(INFORMATION143
, 1
, 150) ATTRIBUTE18
, SUBSTR(INFORMATION144
, 1
, 150) ATTRIBUTE19
, SUBSTR(INFORMATION145
, 1
, 150) ATTRIBUTE20
, SUBSTR(INFORMATION146
, 1
, 150) ATTRIBUTE21
, SUBSTR(INFORMATION147
, 1
, 150) ATTRIBUTE22
, SUBSTR(INFORMATION148
, 1
, 150) ATTRIBUTE23
, SUBSTR(INFORMATION149
, 1
, 150) ATTRIBUTE24
, SUBSTR(INFORMATION150
, 1
, 150) ATTRIBUTE25
, SUBSTR(INFORMATION151
, 1
, 150) ATTRIBUTE26
, SUBSTR(INFORMATION152
, 1
, 150) ATTRIBUTE27
, SUBSTR(INFORMATION153
, 1
, 150) ATTRIBUTE28
, SUBSTR(INFORMATION154
, 1
, 150) ATTRIBUTE29
, SUBSTR(INFORMATION155
, 1
, 150) ATTRIBUTE30
, GHR_GENERAL.RETURN_NUMBER(INFORMATION162) BUSINESS_GROUP_ID
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PER_PEOPLE_F'