VIEW: HR.PER_CALENDAR_ENTRIES#

Source

View Text - Preformatted

select CALENDAR_ENTRY_ID CALENDAR_ENTRY_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, TYPE TYPE, START_DATE START_DATE, START_HOUR START_HOUR, START_MIN START_MIN, END_DATE END_DATE, END_HOUR END_HOUR, END_MIN END_MIN, HIERARCHY_ID HIERARCHY_ID, VALUE_SET_ID VALUE_SET_ID, DESCRIPTION DESCRIPTION, 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, LEGISLATION_CODE LEGISLATION_CODE, IDENTIFIER_KEY IDENTIFIER_KEY, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PER_CALENDAR_ENTRIES"

View Text - HTML Formatted

SELECT CALENDAR_ENTRY_ID CALENDAR_ENTRY_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, TYPE TYPE
, START_DATE START_DATE
, START_HOUR START_HOUR
, START_MIN START_MIN
, END_DATE END_DATE
, END_HOUR END_HOUR
, END_MIN END_MIN
, HIERARCHY_ID HIERARCHY_ID
, VALUE_SET_ID VALUE_SET_ID
, DESCRIPTION DESCRIPTION
, 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
, LEGISLATION_CODE LEGISLATION_CODE
, IDENTIFIER_KEY IDENTIFIER_KEY
, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PER_CALENDAR_ENTRIES"