CALENDAR_IDA=Academic - 10 months
F=Fiscal - 12 months
Default Value: 12
Default Value: Y
M=Month
Q=Quarter
S=Semester
T=Term
Y=Computational Year
EG_CAL_DEFN_TBL(SQL Table) |
Index Back |
|---|---|
CalendarsCalendars |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EG_CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Year
A=Academic - 10 months F=Fiscal - 12 months |
| 4 | NUMBER_OF_MONTHS | Number(3,0) | SMALLINT NOT NULL |
Months in a Year
Default Value: 12 |
| 5 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL |
Detail Calendar
Default Value: Y |
| 6 | EG_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Computational Period
M=Month Q=Quarter S=Semester T=Term Y=Computational Year |
| 7 | NUMBER_OF_PERIODS | Number(3,0) | SMALLINT NOT NULL | Periods in a Year |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |