VIEW: HR.HR_PTL_SUMMARY_DATA#

Source

View Text - Preformatted

select SUMMARY_DATA_ID SUMMARY_DATA_ID, SUMMARY_CONTEXT_TYPE SUMMARY_CONTEXT_TYPE, SUMMARY_CONTEXT_ID SUMMARY_CONTEXT_ID, EFFECTIVE_DATE EFFECTIVE_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SOURCE_TYPE SOURCE_TYPE, SUM_INFORMATION_CATEGORY SUM_INFORMATION_CATEGORY, SUM_INFORMATION1 SUM_INFORMATION1, SUM_INFORMATION2 SUM_INFORMATION2, SUM_INFORMATION3 SUM_INFORMATION3, SUM_INFORMATION4 SUM_INFORMATION4, SUM_INFORMATION5 SUM_INFORMATION5, SUM_INFORMATION6 SUM_INFORMATION6, SUM_INFORMATION7 SUM_INFORMATION7, SUM_INFORMATION8 SUM_INFORMATION8, SUM_INFORMATION9 SUM_INFORMATION9, SUM_INFORMATION10 SUM_INFORMATION10, SUM_INFORMATION11 SUM_INFORMATION11, SUM_INFORMATION12 SUM_INFORMATION12, SUM_INFORMATION13 SUM_INFORMATION13, SUM_INFORMATION14 SUM_INFORMATION14, SUM_INFORMATION15 SUM_INFORMATION15, SUM_INFORMATION16 SUM_INFORMATION16, SUM_INFORMATION17 SUM_INFORMATION17, SUM_INFORMATION18 SUM_INFORMATION18, SUM_INFORMATION19 SUM_INFORMATION19, SUM_INFORMATION20 SUM_INFORMATION20, SUM_INFORMATION21 SUM_INFORMATION21, SUM_INFORMATION22 SUM_INFORMATION22, SUM_INFORMATION23 SUM_INFORMATION23, SUM_INFORMATION24 SUM_INFORMATION24, SUM_INFORMATION25 SUM_INFORMATION25, SUM_INFORMATION26 SUM_INFORMATION26, SUM_INFORMATION27 SUM_INFORMATION27, SUM_INFORMATION28 SUM_INFORMATION28, SUM_INFORMATION29 SUM_INFORMATION29, SUM_INFORMATION30 SUM_INFORMATION30, SUM_INFORMATION31 SUM_INFORMATION31, SUM_INFORMATION32 SUM_INFORMATION32, SUM_INFORMATION33 SUM_INFORMATION33, SUM_INFORMATION34 SUM_INFORMATION34, SUM_INFORMATION35 SUM_INFORMATION35, SUM_INFORMATION36 SUM_INFORMATION36, SUM_INFORMATION37 SUM_INFORMATION37, SUM_INFORMATION38 SUM_INFORMATION38, SUM_INFORMATION39 SUM_INFORMATION39, SUM_INFORMATION40 SUM_INFORMATION40 from "HR"."HR_PTL_SUMMARY_DATA"

View Text - HTML Formatted

SELECT SUMMARY_DATA_ID SUMMARY_DATA_ID
, SUMMARY_CONTEXT_TYPE SUMMARY_CONTEXT_TYPE
, SUMMARY_CONTEXT_ID SUMMARY_CONTEXT_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SOURCE_TYPE SOURCE_TYPE
, SUM_INFORMATION_CATEGORY SUM_INFORMATION_CATEGORY
, SUM_INFORMATION1 SUM_INFORMATION1
, SUM_INFORMATION2 SUM_INFORMATION2
, SUM_INFORMATION3 SUM_INFORMATION3
, SUM_INFORMATION4 SUM_INFORMATION4
, SUM_INFORMATION5 SUM_INFORMATION5
, SUM_INFORMATION6 SUM_INFORMATION6
, SUM_INFORMATION7 SUM_INFORMATION7
, SUM_INFORMATION8 SUM_INFORMATION8
, SUM_INFORMATION9 SUM_INFORMATION9
, SUM_INFORMATION10 SUM_INFORMATION10
, SUM_INFORMATION11 SUM_INFORMATION11
, SUM_INFORMATION12 SUM_INFORMATION12
, SUM_INFORMATION13 SUM_INFORMATION13
, SUM_INFORMATION14 SUM_INFORMATION14
, SUM_INFORMATION15 SUM_INFORMATION15
, SUM_INFORMATION16 SUM_INFORMATION16
, SUM_INFORMATION17 SUM_INFORMATION17
, SUM_INFORMATION18 SUM_INFORMATION18
, SUM_INFORMATION19 SUM_INFORMATION19
, SUM_INFORMATION20 SUM_INFORMATION20
, SUM_INFORMATION21 SUM_INFORMATION21
, SUM_INFORMATION22 SUM_INFORMATION22
, SUM_INFORMATION23 SUM_INFORMATION23
, SUM_INFORMATION24 SUM_INFORMATION24
, SUM_INFORMATION25 SUM_INFORMATION25
, SUM_INFORMATION26 SUM_INFORMATION26
, SUM_INFORMATION27 SUM_INFORMATION27
, SUM_INFORMATION28 SUM_INFORMATION28
, SUM_INFORMATION29 SUM_INFORMATION29
, SUM_INFORMATION30 SUM_INFORMATION30
, SUM_INFORMATION31 SUM_INFORMATION31
, SUM_INFORMATION32 SUM_INFORMATION32
, SUM_INFORMATION33 SUM_INFORMATION33
, SUM_INFORMATION34 SUM_INFORMATION34
, SUM_INFORMATION35 SUM_INFORMATION35
, SUM_INFORMATION36 SUM_INFORMATION36
, SUM_INFORMATION37 SUM_INFORMATION37
, SUM_INFORMATION38 SUM_INFORMATION38
, SUM_INFORMATION39 SUM_INFORMATION39
, SUM_INFORMATION40 SUM_INFORMATION40
FROM "HR"."HR_PTL_SUMMARY_DATA"