FC_BUS_CAL_HOL (SQL View)	Index Back
Business Calendar Holidays Business Calendar Holiday view used by Forecasting

FC_BUS_CAL_HOL

(SQL View)

Business Calendar Holidays

Business Calendar Holiday view used by Forecasting

SELECT HOLIDAY_LIST_ID ,HOLIDAY_DT ,HOLIDAY_NAME FROM PS_BUS_CAL_HOLIDAY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.
Prompt Table: BUS_CAL_HOL_VW

2 HOLIDAY_DT Date(10) DATE The date associated with a defined business holiday.

3 HOLIDAY_NAME Character(30) VARCHAR2(30) NOT NULL The user-defined business holiday stored in the business calendar future.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups. Prompt Table: BUS_CAL_HOL_VW
2	HOLIDAY_DT	Date(10)	DATE	The date associated with a defined business holiday.
3	HOLIDAY_NAME	Character(30)	VARCHAR2(30) NOT NULL	The user-defined business holiday stored in the business calendar future.