VIEW: HR.PER_DISABILITIES_F#

Source

View Text - Preformatted

select DISABILITY_ID DISABILITY_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PERSON_ID PERSON_ID, INCIDENT_ID INCIDENT_ID, ORGANIZATION_ID ORGANIZATION_ID, ASSIGNMENT_ID ASSIGNMENT_ID, REGISTRATION_ID REGISTRATION_ID, REGISTRATION_DATE REGISTRATION_DATE, REGISTRATION_EXP_DATE REGISTRATION_EXP_DATE, ASSESSMENT_DUE_DATE ASSESSMENT_DUE_DATE, CATEGORY CATEGORY, DESCRIPTION DESCRIPTION, DEGREE DEGREE, QUOTA_FTE QUOTA_FTE, REASON REASON, PRE_REGISTRATION_JOB PRE_REGISTRATION_JOB, WORK_RESTRICTION WORK_RESTRICTION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, DIS_INFORMATION_CATEGORY DIS_INFORMATION_CATEGORY, DIS_INFORMATION1 DIS_INFORMATION1, DIS_INFORMATION2 DIS_INFORMATION2, DIS_INFORMATION3 DIS_INFORMATION3, DIS_INFORMATION4 DIS_INFORMATION4, DIS_INFORMATION5 DIS_INFORMATION5, DIS_INFORMATION6 DIS_INFORMATION6, DIS_INFORMATION7 DIS_INFORMATION7, DIS_INFORMATION8 DIS_INFORMATION8, DIS_INFORMATION9 DIS_INFORMATION9, DIS_INFORMATION10 DIS_INFORMATION10, DIS_INFORMATION11 DIS_INFORMATION11, DIS_INFORMATION12 DIS_INFORMATION12, DIS_INFORMATION13 DIS_INFORMATION13, DIS_INFORMATION14 DIS_INFORMATION14, DIS_INFORMATION15 DIS_INFORMATION15, DIS_INFORMATION16 DIS_INFORMATION16, DIS_INFORMATION17 DIS_INFORMATION17, DIS_INFORMATION18 DIS_INFORMATION18, DIS_INFORMATION19 DIS_INFORMATION19, DIS_INFORMATION20 DIS_INFORMATION20, DIS_INFORMATION21 DIS_INFORMATION21, DIS_INFORMATION22 DIS_INFORMATION22, DIS_INFORMATION23 DIS_INFORMATION23, DIS_INFORMATION24 DIS_INFORMATION24, DIS_INFORMATION25 DIS_INFORMATION25, DIS_INFORMATION26 DIS_INFORMATION26, DIS_INFORMATION27 DIS_INFORMATION27, DIS_INFORMATION28 DIS_INFORMATION28, DIS_INFORMATION29 DIS_INFORMATION29, DIS_INFORMATION30 DIS_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS STATUS from "HR"."PER_DISABILITIES_F"

View Text - HTML Formatted

SELECT DISABILITY_ID DISABILITY_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PERSON_ID PERSON_ID
, INCIDENT_ID INCIDENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, REGISTRATION_ID REGISTRATION_ID
, REGISTRATION_DATE REGISTRATION_DATE
, REGISTRATION_EXP_DATE REGISTRATION_EXP_DATE
, ASSESSMENT_DUE_DATE ASSESSMENT_DUE_DATE
, CATEGORY CATEGORY
, DESCRIPTION DESCRIPTION
, DEGREE DEGREE
, QUOTA_FTE QUOTA_FTE
, REASON REASON
, PRE_REGISTRATION_JOB PRE_REGISTRATION_JOB
, WORK_RESTRICTION WORK_RESTRICTION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, DIS_INFORMATION_CATEGORY DIS_INFORMATION_CATEGORY
, DIS_INFORMATION1 DIS_INFORMATION1
, DIS_INFORMATION2 DIS_INFORMATION2
, DIS_INFORMATION3 DIS_INFORMATION3
, DIS_INFORMATION4 DIS_INFORMATION4
, DIS_INFORMATION5 DIS_INFORMATION5
, DIS_INFORMATION6 DIS_INFORMATION6
, DIS_INFORMATION7 DIS_INFORMATION7
, DIS_INFORMATION8 DIS_INFORMATION8
, DIS_INFORMATION9 DIS_INFORMATION9
, DIS_INFORMATION10 DIS_INFORMATION10
, DIS_INFORMATION11 DIS_INFORMATION11
, DIS_INFORMATION12 DIS_INFORMATION12
, DIS_INFORMATION13 DIS_INFORMATION13
, DIS_INFORMATION14 DIS_INFORMATION14
, DIS_INFORMATION15 DIS_INFORMATION15
, DIS_INFORMATION16 DIS_INFORMATION16
, DIS_INFORMATION17 DIS_INFORMATION17
, DIS_INFORMATION18 DIS_INFORMATION18
, DIS_INFORMATION19 DIS_INFORMATION19
, DIS_INFORMATION20 DIS_INFORMATION20
, DIS_INFORMATION21 DIS_INFORMATION21
, DIS_INFORMATION22 DIS_INFORMATION22
, DIS_INFORMATION23 DIS_INFORMATION23
, DIS_INFORMATION24 DIS_INFORMATION24
, DIS_INFORMATION25 DIS_INFORMATION25
, DIS_INFORMATION26 DIS_INFORMATION26
, DIS_INFORMATION27 DIS_INFORMATION27
, DIS_INFORMATION28 DIS_INFORMATION28
, DIS_INFORMATION29 DIS_INFORMATION29
, DIS_INFORMATION30 DIS_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS STATUS
FROM "HR"."PER_DISABILITIES_F"