DP_EVINSTANCES

(SQL Table)
Index Back

Event Instances

Event Instances

  • Parent record: DP_EVENTS
  • # 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