CALENDAR_DATEPOS_DAYS_TBL(SQL Table) |
Index Back |
|---|---|
Position Time Buckets |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALENDAR_DATE |
Date(10) | DATE | An internal work field utilized to store calendar dates for a given calendar year. The dates are displa |
| 2 | TRX_YEAR_NUM | Number(4,0) | SMALLINT NOT NULL | Year in numeric form |
| 3 | TRX_QUARTER_NUM | Number(3,0) | SMALLINT NOT NULL | Quarter of the year |
| 4 | TRX_MONTH_NUM | Number(3,0) | SMALLINT NOT NULL | Month in numeric form |
| 5 | TRX_WEEK_NUM | Number(3,0) | SMALLINT NOT NULL | Week in numeric form |
| 6 | TRX_DAY_OF_WK_NUM | Number(3,0) | SMALLINT NOT NULL | Day of Week |
| 7 | TRX_DAY_OF_YR_NUM | Number(3,0) | SMALLINT NOT NULL | Day of the Year(Julian) |