DP_CONFIGVIEWPrompt Table: DP_SI_VW1USR_VW
DP_SEASONALITYPROFY/N Table Edit
Default Value: Y
Prompt Table: DP_CONTROLGRPS
Default Value: 1
Prompt Table: DP_CONFIGLEVELS
Prompt Table: DP_UOMGROUPS
DP_SEASPROFILES(SQL Table) |
Index Back |
|---|---|
Seasonlaity ProfilesSeasonlaity Profiles |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_SI_VW1USR_VW |
| 2 | DP_SEASONALITYPROF |
Character(20) | VARCHAR2(20) NOT NULL | DP_SEASONALITYPROF |
| 3 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 4 | DP_GRPPROFPROCCTL | Character(1) | VARCHAR2(1) NOT NULL | DP_GRPPROFPROCCTL |
| 5 | DP_PERIODS | Number(2,0) | SMALLINT NOT NULL | DP_PERIODS |
| 6 | DP_LASTCALCDATE | DateTime(26) | TIMESTAMP | DP_LASTCALCDATE |
| 7 | DP_MANUALLYUPDATED | Character(1) | VARCHAR2(1) NOT NULL |
DP_MANUALLYUPDATED
Y/N Table Edit Default Value: Y |
| 8 | DP_CONTROLGROUP | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONTROLGROUP
Prompt Table: DP_CONTROLGRPS |
| 9 | DP_EFFDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_EFFDEMANDPDS |
| 10 | DP_ELIMDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_ELIMDEMANDPDS |
| 11 | DP_DETERBYLEVEL | Number(2,0) | SMALLINT NOT NULL |
DP_DETERBYLEVEL
Default Value: 1 Prompt Table: DP_CONFIGLEVELS |
| 12 | DP_UOMGROUP | Character(10) | VARCHAR2(10) NOT NULL |
DP_UOMGROUP
Prompt Table: DP_UOMGROUPS |
| 13 | DP_GROUPPROFDESC | Long Character | CLOB | DP_GROUPPROFDESC |