| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
T4A_CODE_016_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 016 Amount
|
| 3 |
T4A_CODE_018_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 018 Amount
|
| 4 |
T4A_CODE_020_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 020 Amount
|
| 5 |
T4A_CODE_022_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 022 Amount
|
| 6 |
T4A_CODE_024_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 024 Amount
|
| 7 |
T4A_CODE_026_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 026 Amount
|
| 8 |
T4A_CODE_027_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 027 Amount
|
| 9 |
T4A_CODE_028_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 028 Amount
|
| 10 |
T4A_CODE_030_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 030 Amount
|
| 11 |
T4A_CODE_032_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 032 Amount
|
| 12 |
T4A_CODE_034_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 034 Amount
|
| 13 |
T4A_CODE_037_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 037 Amount
|
| 14 |
T4A_CODE_040_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 040 Amount
|
| 15 |
T4A_CODE_042_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 042 Amount
|
| 16 |
T4A_CODE_046_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 046 Amount
|
| 17 |
T4A_CODE_048_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 048 Amount
|
| 18 |
T4A_CODE_102_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 102 Amount
|
| 19 |
T4A_CODE_104_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 104 Amount
|
| 20 |
T4A_CODE_105_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 105 Amount
|
| 21 |
T4A_CODE_106_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 106 Amount
|
| 22 |
T4A_CODE_107_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 107 Amount
|
| 23 |
T4A_CODE_108_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 108 Amount
|
| 24 |
T4A_CODE_109_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 109 Amount
|
| 25 |
T4A_CODE_110_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 110 Amount
|
| 26 |
T4A_CODE_111_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 111 Amount
|
| 27 |
T4A_CODE_115_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 115 Amount
|
| 28 |
T4A_CODE_116_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 116 Amount
|
| 29 |
T4A_CODE_117_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 117 Amount
|
| 30 |
T4A_CODE_118_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 118 Amount
|
| 31 |
T4A_CODE_119_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 119 Amount
|
| 32 |
T4A_CODE_122_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 122 Amount
|
| 33 |
T4A_CODE_123_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 123 Amount
|
| 34 |
T4A_CODE_124_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 124 Amount
|
| 35 |
T4A_CODE_125_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 125 Amount
|
| 36 |
T4A_CODE_126_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 126 Amount
|
| 37 |
T4A_CODE_127_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 127 Amount
|
| 38 |
T4A_CODE_128_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 128 Amount
|
| 39 |
T4A_CODE_129_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 129 Amount
|
| 40 |
T4A_CODE_130_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 130 Amount
|
| 41 |
T4A_CODE_131_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 131 Amount
|
| 42 |
T4A_CODE_132_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 132 Amount
|
| 43 |
T4A_CODE_133_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 133 Amount
|
| 44 |
T4A_CODE_134_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 134 Amount
|
| 45 |
T4A_CODE_135_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 135 Amount
|
| 46 |
T4A_CODE_136_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 136 Amount
|
| 47 |
T4A_CODE_142_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 142 Amount
|
| 48 |
T4A_CODE_143_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 143 Amount
|
| 49 |
T4A_CODE_144_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 144 Amount
|
| 50 |
T4A_CODE_146_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 146 Amount
|
| 51 |
T4A_CODE_148_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 148 Amount
|
| 52 |
T4A_CODE_150_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 150 Amount
|
| 53 |
T4A_CODE_152_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 152 Amount
|
| 54 |
T4A_CODE_154_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 154 Amount
|
| 55 |
T4A_CODE_156_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 156 Amount
|
| 56 |
T4A_CODE_158_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 158 Amount
|
| 57 |
T4A_CODE_162_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 162 Amount
|
| 58 |
T4A_CODE_180_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 180 Amount
|
| 59 |
T4A_CODE_190_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 190 Amount
|
| 60 |
T4A_CODE_194_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 194 Amount
|
| 61 |
T4A_CODE_195_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 195 Amount
|
| 62 |
T4A_CODE_196_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 196 Amount
|
| 63 |
T4A_CODE_200_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 200 Amount
|
| 64 |
T4A_CODE_201_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 201 Amount
|
| 65 |
T4A_CODE_205_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 205 Amount
|
| 66 |
T4A_CODE_210_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
T4A Code 210 Amount
|
| 67 |
T4A_CODE_016_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 016 Total Amount
|
| 68 |
T4A_CODE_018_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 018 Total Amount
|
| 69 |
T4A_CODE_020_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 020 Total Amount
|
| 70 |
T4A_CODE_022_TOT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
T4A Code 022 Total Amount
|
| 71 |
T4A_CODE_024_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 024 Total Amount
|
| 72 |
T4A_CODE_028_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 028 Total Amount
|
| 73 |
T4A_CODE_030_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 030 Total Amount
|
| 74 |
T4A_CODE_032_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 032 Total Amount
|
| 75 |
T4A_CODE_034_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 034 Total Amount
|
| 76 |
T4A_CODE_040_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 040 Total Amount
|
| 77 |
T4A_CODE_042_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 042 Total Amount
|
| 78 |
T4A_CODE_048_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Code 048 Total Amount
|
| 79 |
T4A_CODE_OTH_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
T4A Other Codes Total Amount
|
| 80 |
GRO_INCAMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Withholding Basis Amount
|
| 81 |
ITX_DDCT_AMT |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
Withholding Basis Amount
|
| 82 |
TRVL_EXAMT |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
Withholding Basis Amount
|
| 83 |
TOT_GRO_INCAMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Withholding Basis Amount
|
| 84 |
TOT_ITX_DDCT_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Withholding Basis Amount
|
| 85 |
TOT_TRVL_EXAMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Withholding Basis Amount
|
| 86 |
AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 87 |
AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 88 |
AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 89 |
AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 90 |
AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 91 |
AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 6
|
| 92 |
AMT7 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 7
|
| 93 |
AMT8 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 8
|
| 94 |
AMT9 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 9
|
| 95 |
AMT10 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 10
|
| 96 |
AMT11 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 11
|
| 97 |
AMT12 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 12
|
| 98 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 99 |
AMT_CODE_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Rent
|
| 100 |
AMT_CODE_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Royalties
|
| 101 |
AMT_CODE_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 102 |
AMT_CODE_4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 103 |
AMT_CODE_5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 104 |
AMT_CODE_6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 105 |
AMT_CODE_7 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 106 |
AMT_CODE_8 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 107 |
AMT_CODE_9 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 108 |
AMT_CODE_10 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 109 |
AMT_CODE_11 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|
| 110 |
AMT_CODE_12 |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Code
|