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