D_FISCAL_DAY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DAY_DT	Date(10)	DATE	This is the calendar date.
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
5	PYEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Pattern Calendar Year Number (YYYY)
6	CALENDAR_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	CALENDAR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Calendar B=Budget Calendar D=Detail Calendar I=Summary Budget Period Calendar P=Budget Period Calendar S=Summary Calendar T=Promo Mgmt Sales Calendar
8	PPERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Period Name
9	PPERIOD_BEGIN_DT	Date(10)	DATE	This is the begin date for the pattern calendar period.
10	PPERIOD_END_DT	Date(10)	DATE	This is the end date for pattern calendar period.
11	BPERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	This is the budget period code.
12	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
13	BPERIOD_BEGIN_DT	Date(10)	DATE	This is the start date of the budget period.
14	BPERIOD_END_DT	Date(10)	DATE	This is the end date of a detailed budget period.
15	HOLIDAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate a holiday.
16	HOLIDAY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the holiday
17	DAY_JULIAN	Number(7,0)	INTEGER NOT NULL	Julian Date
18	OI_DAY_JULIAN	Number(7,0)	INTEGER NOT NULL	Julian Date
19	DAY_JULIAN_YYY	Number(6,0)	INTEGER NOT NULL	Julian Date
20	OI_DY_JULN_YYY	Character(20)	VARCHAR2(20) NOT NULL	Julian Date
21	DAY_WK_NUM	Number(1,0)	SMALLINT NOT NULL	This is the week number of the week in which the day falls.
22	DAY_MTH_NUM	Number(2,0)	SMALLINT NOT NULL	This is the day of the month.
23	DAY_YR_NUM	Number(3,0)	SMALLINT NOT NULL	This is the year number of the year in which the day falls.
24	OI_DAY_YR_NUM	Number(3,0)	SMALLINT NOT NULL	This is the year number of the year in which the day falls.
25	DAY_NUM	Number(9,0)	DECIMAL(9) NOT NULL	This is the day number within the entire calendar date range.
26	OI_DAY_NUM	Number(9,0)	DECIMAL(9) NOT NULL	This is the day number within the entire calendar date range.
27	DAY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the day.
28	DAY_ABBR	Character(3)	VARCHAR2(3) NOT NULL	This is the abbreviation of the day.
29	WEEK_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the week.
30	OI_WEEK_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the week.
31	OI_WEEK_ABBR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the week.
32	WEEK_MTH_NUM	Number(1,0)	SMALLINT NOT NULL	Week Month Number
33	WEEK_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Week Of Year Number
34	OI_WEEK_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Week Of Year Number
35	WEEK_NUM	Number(6,0)	INTEGER NOT NULL	This is the week number
36	OI_WEEK_NUM	Number(6,0)	INTEGER NOT NULL	This is the week number
37	MONTH_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Month Year Number
38	OI_MONTH_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Month Year Number
39	MONTH_NUM	Number(6,0)	INTEGER NOT NULL	Month Number
40	OI_MONTH_NUM	Number(6,0)	INTEGER NOT NULL	Month Number
41	MONTH_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the month.
42	OI_MONTH_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Month Description
43	MONTH_ABBR	Character(3)	VARCHAR2(3) NOT NULL	This is abbreviation of the month
44	OI_MONTH_ABBR	Character(30)	VARCHAR2(30) NOT NULL	This is abbreviation of the month
45	QUARTER_YR_NUM	Number(1,0)	SMALLINT NOT NULL	This is the quarter of year.
46	OI_QTR_YR_NUM	Number(1,0)	SMALLINT NOT NULL	This is the quarter of year.
47	QUARTER_NUM	Number(5,0)	INTEGER NOT NULL	This is the quarter number
48	OI_QUARTER_NUM	Number(5,0)	INTEGER NOT NULL	This is the quarter number
49	QUARTER_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the quarter.
50	OI_QTR_DESC	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the quarter.
51	QUARTER_ABBR	Character(5)	VARCHAR2(5) NOT NULL	This is the abbreviation for the quarter
52	OI_QTR_ABBR	Character(5)	VARCHAR2(5) NOT NULL	This is the abbreviation for the quarter
53	YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Year in Number
54	OI_YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Fiscal Year number
55	YEAR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the year.
56	OI_YEAR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the year.
57	OI_SEMI_ANNUAL_NBR	Character(20)	VARCHAR2(20) NOT NULL	Semi Annual Number
58	OI_SEMI_ANNUL_DESC	Character(50)	VARCHAR2(50) NOT NULL	OI_SEMI_ANNUL_DESC
59	OI_SEMI_ANNUL_ABBR	Character(50)	VARCHAR2(50) NOT NULL	OI_SEMI_ANNUL_ABBRV
60	FIRSTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the week.
61	OI_FIRSTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the week.
62	LASTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the week
63	OI_LASTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the week
64	FIRSTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the month.
65	OI_FIRSTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the month.
66	LASTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is flag to indicate last day of the month.
67	OI_LASTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is flag to indicate last day of the month.
68	FIRSTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of quarter.
69	OI_FIRSTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of quarter.
70	LASTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the quarter.
71	OI_LASTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the quarter.
72	FIRSTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the year.
73	OI_FIRSTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the year.
74	LASTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the year
75	OI_LASTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the year
76	DAY_WEEKEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate that the day is weekend day.