HXT Holiday Calendar Table

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Time and Labor
Source
Holiday Calendar Table Report (XML)
Short Name
HXT957A_XML
DB package
HXT_HXT957A_XMLP_PKG

SQL 12 lines

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

Parameters 2

ParameterTypeList of values SQL
Start DateDate
End DateDate