PSARCH_IDDP_CONFIGVIEWPrompt Table: DP_CONFIGVIEWS
DP_CONFIGLEVELPrompt Table: DP_CONFIGLEVELS
DP_EVENTIDDefault Value: DP_EVENTTYPES.DP_EVENTTYPE
Prompt Table: DP_EVENTTYPES
Y/N Table Edit
Default Value: N
DPA_EVENTS(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_EVENTS |
| # | 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_CONFIGVIEWS |
| 3 | DP_CONFIGLEVEL |
Number(2,0) | SMALLINT NOT NULL |
DP_CONFIGLEVEL
Prompt Table: DP_CONFIGLEVELS |
| 4 | DP_EVENTID |
Character(20) | VARCHAR2(20) NOT NULL | DP_EVENTID |
| 5 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 6 | DP_EVENTTYPE | Character(10) | VARCHAR2(10) NOT NULL |
DP_EVENTTYPE
Default Value: DP_EVENTTYPES.DP_EVENTTYPE Prompt Table: DP_EVENTTYPES |
| 7 | DP_EVENTDURATION | Number(3,0) | SMALLINT NOT NULL | DP_EVENTDURATION |
| 8 | DP_REAPPLYFLAG | Character(1) | VARCHAR2(1) NOT NULL |
DP_REAPPLYFLAG
Y/N Table Edit Default Value: N |
| 9 | DP_AMSPLITDATA | Character(30) | VARCHAR2(30) NOT NULL | DP_AMSPLITDATA |
| 10 | DP_LASTCALCDATE | DateTime(26) | TIMESTAMP | DP_LASTCALCDATE |
| 11 | DP_DESCRIPTION | Character(120) | VARCHAR2(120) NOT NULL | Description |
| 12 | DP_CHAR01 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR01 |
| 13 | DP_CHAR02 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR02 |
| 14 | DP_CHAR03 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR03 |
| 15 | DP_CHAR04 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR04 |
| 16 | DP_CHAR05 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR05 |
| 17 | DP_CHAR06 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR06 |
| 18 | DP_CHAR07 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR07 |
| 19 | DP_CHAR08 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR08 |
| 20 | DP_CHAR09 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR09 |
| 21 | DP_CHAR10 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR10 |
| 22 | DP_CHAR11 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR11 |
| 23 | DP_CHAR12 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR12 |
| 24 | DP_CHAR13 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR13 |
| 25 | DP_CHAR14 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR14 |
| 26 | DP_CHAR15 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR15 |
| 27 | DP_CHAR16 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR16 |
| 28 | DP_CHAR17 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR17 |
| 29 | DP_CHAR18 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR18 |
| 30 | DP_CHAR19 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR19 |
| 31 | DP_CHAR20 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR20 |
| 32 | DP_CHAR21 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR21 |
| 33 | DP_CHAR22 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR22 |
| 34 | DP_CHAR23 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR23 |
| 35 | DP_CHAR24 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR24 |
| 36 | DP_CHAR25 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR25 |
| 37 | DP_CHAR26 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR26 |
| 38 | DP_CHAR27 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR27 |
| 39 | DP_CHAR28 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR28 |
| 40 | DP_CHAR29 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR29 |
| 41 | DP_CHAR30 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR30 |
| 42 | DP_CHAR31 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR31 |
| 43 | DP_CHAR32 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR32 |
| 44 | DP_CHAR33 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR33 |
| 45 | DP_CHAR34 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR34 |
| 46 | DP_CHAR35 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR35 |
| 47 | DP_CHAR36 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR36 |
| 48 | DP_CHAR37 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR37 |
| 49 | DP_CHAR38 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR38 |
| 50 | DP_CHAR39 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR39 |
| 51 | DP_CHAR40 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR40 |
| 52 | DP_CHAR41 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR41 |
| 53 | DP_CHAR42 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR42 |
| 54 | DP_CHAR43 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR43 |
| 55 | DP_CHAR44 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR44 |
| 56 | DP_CHAR45 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR45 |
| 57 | DP_CHAR46 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR46 |
| 58 | DP_CHAR47 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR47 |
| 59 | DP_CHAR48 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR48 |
| 60 | DP_CHAR49 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR49 |
| 61 | DP_CHAR50 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR50 |
| 62 | DP_CHAR51 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR51 |
| 63 | DP_CHAR52 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR52 |
| 64 | DP_CHAR53 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR53 |
| 65 | DP_CHAR54 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR54 |
| 66 | DP_CHAR55 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR55 |
| 67 | DP_CHAR56 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR56 |
| 68 | DP_CHAR57 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR57 |
| 69 | DP_CHAR58 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR58 |
| 70 | DP_CHAR59 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR59 |
| 71 | DP_CHAR60 | Character(40) | VARCHAR2(40) NOT NULL | DP_CHAR60 |
| 72 | DP_NUMBER01 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER01 |
| 73 | DP_NUMBER02 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER02 |
| 74 | DP_NUMBER03 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER03 |
| 75 | DP_NUMBER04 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER04 |
| 76 | DP_NUMBER05 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER05 |
| 77 | DP_NUMBER06 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER06 |
| 78 | DP_NUMBER07 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER07 |
| 79 | DP_NUMBER08 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER08 |
| 80 | DP_NUMBER09 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER09 |
| 81 | DP_NUMBER10 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER10 |
| 82 | DP_NUMBER11 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER11 |
| 83 | DP_NUMBER12 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER12 |
| 84 | DP_NUMBER13 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER13 |
| 85 | DP_NUMBER14 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER14 |
| 86 | DP_NUMBER15 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER15 |
| 87 | DP_NUMBER16 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER16 |
| 88 | DP_NUMBER17 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER17 |
| 89 | DP_NUMBER18 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER18 |
| 90 | DP_NUMBER19 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER19 |
| 91 | DP_NUMBER20 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER20 |
| 92 | DP_NUMBER21 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER21 |
| 93 | DP_NUMBER22 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER22 |
| 94 | DP_NUMBER23 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER23 |
| 95 | DP_NUMBER24 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER24 |
| 96 | DP_NUMBER25 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER25 |
| 97 | DP_NUMBER26 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER26 |
| 98 | DP_NUMBER27 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER27 |
| 99 | DP_NUMBER28 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER28 |
| 100 | DP_NUMBER29 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER29 |
| 101 | DP_NUMBER30 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Number Field |
| 102 | DP_NUMBER31 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER31 |
| 103 | DP_NUMBER32 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER32 |
| 104 | DP_NUMBER33 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER33 |
| 105 | DP_NUMBER34 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER34 |
| 106 | DP_NUMBER35 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER35 |
| 107 | DP_NUMBER36 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER36 |
| 108 | DP_NUMBER37 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER37 |
| 109 | DP_NUMBER38 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER38 |
| 110 | DP_NUMBER39 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER39 |
| 111 | DP_NUMBER40 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER40 |
| 112 | DP_NUMBER41 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER41 |
| 113 | DP_NUMBER42 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER42 |
| 114 | DP_NUMBER43 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER43 |
| 115 | DP_NUMBER44 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER44 |
| 116 | DP_NUMBER45 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER45 |
| 117 | DP_NUMBER46 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER46 |
| 118 | DP_NUMBER47 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER47 |
| 119 | DP_NUMBER48 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER48 |
| 120 | DP_NUMBER49 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER49 |
| 121 | DP_NUMBER50 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER50 |
| 122 | DP_NUMBER51 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER51 |
| 123 | DP_NUMBER52 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER52 |
| 124 | DP_NUMBER53 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER53 |
| 125 | DP_NUMBER54 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER54 |
| 126 | DP_NUMBER55 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER55 |
| 127 | DP_NUMBER56 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER56 |
| 128 | DP_NUMBER57 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER57 |
| 129 | DP_NUMBER58 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER58 |
| 130 | DP_NUMBER59 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER59 |
| 131 | DP_NUMBER60 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_NUMBER60 |