PSARCH_IDDP_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
DPA_SEASPROFILE(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_SEASPROFILES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_SI_VW1USR_VW |
| 3 | DP_SEASONALITYPROF |
Character(20) | VARCHAR2(20) NOT NULL | DP_SEASONALITYPROF |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_GRPPROFPROCCTL | Character(1) | VARCHAR2(1) NOT NULL | DP_GRPPROFPROCCTL |
| 6 | DP_PERIODS | Number(2,0) | SMALLINT NOT NULL | DP_PERIODS |
| 7 | DP_LASTCALCDATE | DateTime(26) | TIMESTAMP | DP_LASTCALCDATE |
| 8 | DP_MANUALLYUPDATED | Character(1) | VARCHAR2(1) NOT NULL |
DP_MANUALLYUPDATED
Y/N Table Edit Default Value: Y |
| 9 | DP_CONTROLGROUP | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONTROLGROUP
Prompt Table: DP_CONTROLGRPS |
| 10 | DP_EFFDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_EFFDEMANDPDS |
| 11 | DP_ELIMDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_ELIMDEMANDPDS |
| 12 | DP_DETERBYLEVEL | Number(2,0) | SMALLINT NOT NULL |
DP_DETERBYLEVEL
Default Value: 1 Prompt Table: DP_CONFIGLEVELS |
| 13 | DP_UOMGROUP | Character(10) | VARCHAR2(10) NOT NULL |
DP_UOMGROUP
Prompt Table: DP_UOMGROUPS |
| 14 | DP_NUMBER01 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER01 |
| 15 | DP_NUMBER02 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER02 |
| 16 | DP_NUMBER03 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER03 |
| 17 | DP_NUMBER04 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER04 |
| 18 | DP_NUMBER05 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER05 |
| 19 | DP_NUMBER06 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER06 |
| 20 | DP_NUMBER07 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER07 |
| 21 | DP_NUMBER08 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER08 |
| 22 | DP_NUMBER09 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER09 |
| 23 | DP_NUMBER10 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER10 |
| 24 | DP_NUMBER11 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER11 |
| 25 | DP_NUMBER12 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER12 |
| 26 | DP_NUMBER13 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER13 |
| 27 | DP_NUMBER14 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER14 |
| 28 | DP_NUMBER15 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER15 |
| 29 | DP_NUMBER16 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER16 |
| 30 | DP_NUMBER17 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER17 |
| 31 | DP_NUMBER18 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER18 |
| 32 | DP_NUMBER19 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER19 |
| 33 | DP_NUMBER20 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER20 |
| 34 | DP_NUMBER21 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER21 |
| 35 | DP_NUMBER22 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER22 |
| 36 | DP_NUMBER23 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER23 |
| 37 | DP_NUMBER24 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER24 |
| 38 | DP_NUMBER25 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER25 |
| 39 | DP_NUMBER26 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER26 |
| 40 | DP_NUMBER27 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER27 |
| 41 | DP_NUMBER28 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER28 |
| 42 | DP_NUMBER29 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER29 |
| 43 | DP_NUMBER30 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Number Field |
| 44 | DP_NUMBER31 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER31 |
| 45 | DP_NUMBER32 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER32 |
| 46 | DP_NUMBER33 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER33 |
| 47 | DP_NUMBER34 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER34 |
| 48 | DP_NUMBER35 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER35 |
| 49 | DP_NUMBER36 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER36 |
| 50 | DP_NUMBER37 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER37 |
| 51 | DP_NUMBER38 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER38 |
| 52 | DP_NUMBER39 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER39 |
| 53 | DP_NUMBER40 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER40 |
| 54 | DP_NUMBER41 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER41 |
| 55 | DP_NUMBER42 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER42 |
| 56 | DP_NUMBER43 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER43 |
| 57 | DP_NUMBER44 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER44 |
| 58 | DP_NUMBER45 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER45 |
| 59 | DP_NUMBER46 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER46 |
| 60 | DP_NUMBER47 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER47 |
| 61 | DP_NUMBER48 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER48 |
| 62 | DP_NUMBER49 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER49 |
| 63 | DP_NUMBER50 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER50 |
| 64 | DP_NUMBER51 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER51 |
| 65 | DP_NUMBER52 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER52 |
| 66 | DP_NUMBER53 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER53 |
| 67 | DP_NUMBER54 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER54 |
| 68 | DP_NUMBER55 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER55 |
| 69 | DP_NUMBER56 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER56 |
| 70 | DP_NUMBER57 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER57 |
| 71 | DP_NUMBER58 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER58 |
| 72 | DP_NUMBER59 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER59 |
| 73 | DP_NUMBER60 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER60 |
| 74 | DP_GROUPPROFDESC | Long Character | CLOB | DP_GROUPPROFDESC |