DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_HOLIDAY_RULES

Object Details
Object Name: XTR_HOLIDAY_RULES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_HOLIDAY_RULES
Subobject Name:
Status: VALID


XTR_HOLIDAY_RULES stores information about rules for calculating holidays for each currency. Each row corresponds to a holiday rule for a currency. You can enter constant dates or define rules to generate a holiday schedule. Treasury stores this set of holiday dates in the XTR_HOLIDAYS table.
This table corresponds to the Currency Holiday Rules window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CALCULATED_OUT_TO DATE

Date to which a holiday rule is calculated out
CURRENCY VARCHAR2 (15) Yes Currency code
DAY_RULE VARCHAR2 (3)
Day of the week of the holiday
EXTRA_HOLIDAY_DAYS NUMBER

Number of additional days that the holiday is observed
HOLIDAY_DAY NUMBER

Date of the month of the holiday
HOLIDAY_DESC VARCHAR2 (20) Yes Holiday description
HOLIDAY_MONTH VARCHAR2 (3) Yes Month of the holiday
HOLIDAY_RULE NUMBER

Week of the month for the holiday
HOLIDAY_TYPE VARCHAR2 (1) Yes Type of holiday (Rule, One off, or Constant)
HOLIDAY_YEAR NUMBER

Year of the holiday
HOL_SEQ NUMBER
Yes Holiday rule identifier
WEEKEND_ADJ VARCHAR2 (3)
Day of the week to adjust the holiday if it occurs on a weekend
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CALCULATED_OUT_TO
,      CURRENCY
,      DAY_RULE
,      EXTRA_HOLIDAY_DAYS
,      HOLIDAY_DAY
,      HOLIDAY_DESC
,      HOLIDAY_MONTH
,      HOLIDAY_RULE
,      HOLIDAY_TYPE
,      HOLIDAY_YEAR
,      HOL_SEQ
,      WEEKEND_ADJ
FROM XTR.XTR_HOLIDAY_RULES;

Dependencies

[top of page]

XTR.XTR_HOLIDAY_RULES does not reference any database object

XTR.XTR_HOLIDAY_RULES is referenced by following:

SchemaXTR
ViewXTR_HOLIDAY_RULES#