VIEW: HR.IRC_PENDING_DATA#

Source

View Text - Preformatted

select PENDING_DATA_ID PENDING_DATA_ID, EMAIL_ADDRESS EMAIL_ADDRESS, VACANCY_ID VACANCY_ID, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, USER_PASSWORD USER_PASSWORD, RESUME_FILE_NAME RESUME_FILE_NAME, RESUME_DESCRIPTION RESUME_DESCRIPTION, RESUME_MIME_TYPE RESUME_MIME_TYPE, RESUME RESUME, SOURCE_TYPE SOURCE_TYPE, JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME, POSTING_CONTENT_ID POSTING_CONTENT_ID, PERSON_ID PERSON_ID, PROCESSED PROCESSED, SEX SEX, DATE_OF_BIRTH DATE_OF_BIRTH, PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY, PER_INFORMATION1 PER_INFORMATION1, PER_INFORMATION2 PER_INFORMATION2, PER_INFORMATION3 PER_INFORMATION3, PER_INFORMATION4 PER_INFORMATION4, PER_INFORMATION5 PER_INFORMATION5, PER_INFORMATION6 PER_INFORMATION6, PER_INFORMATION7 PER_INFORMATION7, PER_INFORMATION8 PER_INFORMATION8, PER_INFORMATION9 PER_INFORMATION9, PER_INFORMATION10 PER_INFORMATION10, PER_INFORMATION11 PER_INFORMATION11, PER_INFORMATION12 PER_INFORMATION12, PER_INFORMATION13 PER_INFORMATION13, PER_INFORMATION14 PER_INFORMATION14, PER_INFORMATION15 PER_INFORMATION15, PER_INFORMATION16 PER_INFORMATION16, PER_INFORMATION17 PER_INFORMATION17, PER_INFORMATION18 PER_INFORMATION18, PER_INFORMATION19 PER_INFORMATION19, PER_INFORMATION20 PER_INFORMATION20, PER_INFORMATION21 PER_INFORMATION21, PER_INFORMATION22 PER_INFORMATION22, PER_INFORMATION23 PER_INFORMATION23, PER_INFORMATION24 PER_INFORMATION24, PER_INFORMATION25 PER_INFORMATION25, PER_INFORMATION26 PER_INFORMATION26, PER_INFORMATION27 PER_INFORMATION27, PER_INFORMATION28 PER_INFORMATION28, PER_INFORMATION29 PER_INFORMATION29, PER_INFORMATION30 PER_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, ERROR_MESSAGE ERROR_MESSAGE, ALLOW_ACCESS ALLOW_ACCESS, USER_GUID USER_GUID, VISITOR_RESP_KEY VISITOR_RESP_KEY, VISITOR_RESP_APPL_ID VISITOR_RESP_APPL_ID, SECURITY_GROUP_KEY SECURITY_GROUP_KEY from "HR"."IRC_PENDING_DATA"

View Text - HTML Formatted

SELECT PENDING_DATA_ID PENDING_DATA_ID
, EMAIL_ADDRESS EMAIL_ADDRESS
, VACANCY_ID VACANCY_ID
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, USER_PASSWORD USER_PASSWORD
, RESUME_FILE_NAME RESUME_FILE_NAME
, RESUME_DESCRIPTION RESUME_DESCRIPTION
, RESUME_MIME_TYPE RESUME_MIME_TYPE
, RESUME RESUME
, SOURCE_TYPE SOURCE_TYPE
, JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME
, POSTING_CONTENT_ID POSTING_CONTENT_ID
, PERSON_ID PERSON_ID
, PROCESSED PROCESSED
, SEX SEX
, DATE_OF_BIRTH DATE_OF_BIRTH
, PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY
, PER_INFORMATION1 PER_INFORMATION1
, PER_INFORMATION2 PER_INFORMATION2
, PER_INFORMATION3 PER_INFORMATION3
, PER_INFORMATION4 PER_INFORMATION4
, PER_INFORMATION5 PER_INFORMATION5
, PER_INFORMATION6 PER_INFORMATION6
, PER_INFORMATION7 PER_INFORMATION7
, PER_INFORMATION8 PER_INFORMATION8
, PER_INFORMATION9 PER_INFORMATION9
, PER_INFORMATION10 PER_INFORMATION10
, PER_INFORMATION11 PER_INFORMATION11
, PER_INFORMATION12 PER_INFORMATION12
, PER_INFORMATION13 PER_INFORMATION13
, PER_INFORMATION14 PER_INFORMATION14
, PER_INFORMATION15 PER_INFORMATION15
, PER_INFORMATION16 PER_INFORMATION16
, PER_INFORMATION17 PER_INFORMATION17
, PER_INFORMATION18 PER_INFORMATION18
, PER_INFORMATION19 PER_INFORMATION19
, PER_INFORMATION20 PER_INFORMATION20
, PER_INFORMATION21 PER_INFORMATION21
, PER_INFORMATION22 PER_INFORMATION22
, PER_INFORMATION23 PER_INFORMATION23
, PER_INFORMATION24 PER_INFORMATION24
, PER_INFORMATION25 PER_INFORMATION25
, PER_INFORMATION26 PER_INFORMATION26
, PER_INFORMATION27 PER_INFORMATION27
, PER_INFORMATION28 PER_INFORMATION28
, PER_INFORMATION29 PER_INFORMATION29
, PER_INFORMATION30 PER_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, ERROR_MESSAGE ERROR_MESSAGE
, ALLOW_ACCESS ALLOW_ACCESS
, USER_GUID USER_GUID
, VISITOR_RESP_KEY VISITOR_RESP_KEY
, VISITOR_RESP_APPL_ID VISITOR_RESP_APPL_ID
, SECURITY_GROUP_KEY SECURITY_GROUP_KEY
FROM "HR"."IRC_PENDING_DATA"