D_DAY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DAY_SID	Number(10,0)	DECIMAL(10) NOT NULL	Day Surrogate Key
2	DAY_DT	Date(10)	DATE	This is the calendar date.
3	DAY_NUM	Number(9,0)	DECIMAL(9) NOT NULL	This is the day number within the entire calendar date range.
4	DAY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the day.
5	DAY_ABBR	Character(3)	VARCHAR2(3) NOT NULL	This is the abbreviation of the day.
6	DAY_JULIAN	Number(7,0)	INTEGER NOT NULL	Julian Date
7	DAY_JULIAN_YYY	Number(6,0)	INTEGER NOT NULL	Julian Date
8	DAY_WK_NUM	Number(1,0)	SMALLINT NOT NULL	This is the week number of the week in which the day falls.
9	DAY_MTH_NUM	Number(2,0)	SMALLINT NOT NULL	This is the day of the month.
10	DAY_YR_NUM	Number(3,0)	SMALLINT NOT NULL	This is the year number of the year in which the day falls.
11	WEEK_SID	Number(10,0)	DECIMAL(10) NOT NULL	This is the surrogate ID for the week.
12	WEEK_NUM	Number(6,0)	INTEGER NOT NULL	This is the week number
13	WEEK_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the week.
14	WEEK_MTH_NUM	Number(1,0)	SMALLINT NOT NULL	Week Month Number
15	WEEK_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Week Of Year Number
16	MONTH_SID	Number(10,0)	DECIMAL(10) NOT NULL	Month Surrogate Key
17	MONTH_NUM	Number(6,0)	INTEGER NOT NULL	Month Number
18	MONTH_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the month.
19	MONTH_ABBR	Character(3)	VARCHAR2(3) NOT NULL	This is abbreviation of the month
20	MONTH_QTR_NUM	Number(1,0)	SMALLINT NOT NULL	This is the month of the quarter.
21	MONTH_YR_NUM	Number(2,0)	SMALLINT NOT NULL	Month Year Number
22	QUARTER_SID	Number(10,0)	DECIMAL(10) NOT NULL	This is the quarter surrogate ID.
23	QUARTER_NUM	Number(5,0)	INTEGER NOT NULL	This is the quarter number
24	QUARTER_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the quarter.
25	QUARTER_ABBR	Character(5)	VARCHAR2(5) NOT NULL	This is the abbreviation for the quarter
26	QUARTER_YR_NUM	Number(1,0)	SMALLINT NOT NULL	This is the quarter of year.
27	YEAR_SID	Number(10,0)	DECIMAL(10) NOT NULL	This is the surrogate ID for year
28	YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Year in Number
29	YEAR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This is the description of the year.
30	FIRSTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the week.
31	LASTDAYWK_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the week
32	FIRSTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the month.
33	LASTDAYMTH_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is flag to indicate last day of the month.
34	FIRSTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of quarter.
35	LASTDAYQTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the quarter.
36	FIRSTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate first day of the year.
37	LASTDAYYR_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate last day of the year
38	DAY_WEEKEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is the flag to indicate that the day is weekend day.