HXT Holiday Calendar Table

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Holiday Calendar Table Report (XML)
Short Name: HXT957A_XML
DB package: HXT_HXT957A_XMLP_PKG
SELECT ALL
 HXT_HOLIDAY_CALENDARS.ID, 
 HXT_HOLIDAY_CALENDARS.NAME, HXT_HOLIDAY_CALENDARS.DESCRIPTION, 
HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, 
HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE,
HXT_HOLIDAY_CALENDARS.organization_id,
NULL dummy, 
	HXT_HXT957A_XMLP_PKG.org_nameformula(HXT_HOLIDAY_CALENDARS.organization_id) ORG_NAME, 
	HXT_HXT957A_XMLP_PKG.earn_typeformula(HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE) EARN_TYPE
FROM HXT_HOLIDAY_CALENDARS
ORDER BY HXT_HOLIDAY_CALENDARS.NAME ASC
Parameter Name SQL text Validation
End Date
 
Date
Start Date
 
Date