CUR_HOL_ID_XREF (SQL Table)	Index Back
Currency/Holiday List X-Ref This table is built as a cross reference table for accessing the BUS_CAL_HOLIDAY table when you have the currency code.

CUR_HOL_ID_XREF

(SQL Table)

Currency/Holiday List X-Ref

This table is built as a cross reference table for accessing the BUS_CAL_HOLIDAY table when you have the currency code.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

2 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_DFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
2	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_DFN