DP_CALENDARIDPrompt Table: DP_CALENDARS
DP_TIMEPERIODCODEPrompt Table: DP_CALPRDTYPES
DP_CALTIMECODES(SQL Table) |
Index Back |
|---|---|
Calendar Time CodesCalendar Time Codes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CALENDARID |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CALENDARID
Prompt Table: DP_CALENDARS |
| 2 | DP_TIMEPERIODCODE |
Character(10) | VARCHAR2(10) NOT NULL | DP_TIMEPERIODCODE |
| 3 | DP_PDSPERYEAR | Number(2,0) | SMALLINT NOT NULL | DP_PDSPERYEAR |
| 4 | DP_PERIODTYPE | Character(10) | VARCHAR2(10) NOT NULL |
DP_PERIODTYPE
Prompt Table: DP_CALPRDTYPES |
| 5 | DP_CORPSTARTPD | Number(2,0) | SMALLINT NOT NULL | DP_CORPSTARTPD |
| 6 | DP_CORPSTARTYR | Number(4,0) | SMALLINT NOT NULL | DP_CORPSTARTYR |
| 7 | DP_CORPENDPD | Number(2,0) | SMALLINT NOT NULL | DP_CORPENDPD |
| 8 | DP_CORPENDYR | Number(4,0) | SMALLINT NOT NULL | DP_CORPENDYR |
| 9 | DP_NUMPERIODS | Number(3,0) | SMALLINT NOT NULL | DP_NUMPERIODS |
| 10 | DP_PERIODDESC | Character(40) | VARCHAR2(40) NOT NULL | DP_PERIODDESC |
| 11 | DP_ENDDATE | Date(10) | DATE NOT NULL | DP_ENDDATE |
| 12 | DP_STARTDATE | Date(10) | DATE NOT NULL | DP_STARTDATE |