PROCESS_INSTANCECS_DOC_ID001=Main Document
002=Amendment
003=Preview Document
004=Compare File
CS_DOC_USER_TMP(SQL Table) |
Index Back |
|---|---|
Shows user fields & labelsUsed in reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 3 | CS_SETID | Character(5) | VARCHAR2(5) NOT NULL | setid for the document objects |
| 4 | CS_DOCUMENT_TYPE | Character(20) | VARCHAR2(20) NOT NULL |
Document Type
001=Main Document 002=Amendment 003=Preview Document 004=Compare File |
| 5 | CS_CHAR_USER1 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 1 |
| 6 | CS_CHAR_USER2 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 2 |
| 7 | CS_CHAR_USER3 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 3 |
| 8 | CS_CHAR_USER4 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 4 |
| 9 | CS_CHAR_USER5 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 5 |
| 10 | CS_CHAR_USER6 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 6 |
| 11 | CS_CHAR_USER7 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 7 |
| 12 | CS_CHAR_USER8 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 8 |
| 13 | CS_CHAR_USER9 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 9 |
| 14 | CS_CHAR_USER10 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 10 |
| 15 | CS_CHAR_USER11 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 11 |
| 16 | CS_CHAR_USER12 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 12 |
| 17 | CS_CHAR_USER13 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 13 |
| 18 | CS_CHAR_USER14 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 14 |
| 19 | CS_CHAR_USER15 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 15 |
| 20 | CS_CHAR_USER16 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 16 |
| 21 | CS_CHAR_USER17 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 17 |
| 22 | CS_CHAR_USER18 | Character(10) | VARCHAR2(10) NOT NULL | Character 10 User Field 18 |
| 23 | CS_CHAR_USER19 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 19 |
| 24 | CS_CHAR_USER20 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 20 |
| 25 | CS_CHAR_USER21 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 21 |
| 26 | CS_CHAR_USER22 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 22 |
| 27 | CS_CHAR_USER23 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 23 |
| 28 | CS_CHAR_USER24 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 24 |
| 29 | CS_CHAR_USER25 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 25 |
| 30 | CS_CHAR_USER26 | Character(30) | VARCHAR2(30) NOT NULL | Character 30 User Field 26 |
| 31 | CS_CHAR_USER27 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 27 |
| 32 | CS_CHAR_USER28 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 28 |
| 33 | CS_CHAR_USER29 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 29 |
| 34 | CS_CHAR_USER30 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 30 |
| 35 | CS_CHAR_USER31 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 31 |
| 36 | CS_CHAR_USER32 | Character(60) | VARCHAR2(60) NOT NULL | Character 60 User Field 32 |
| 37 | CS_CHAR_USER33 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 33 |
| 38 | CS_CHAR_USER34 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 34 |
| 39 | CS_CHAR_USER35 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 35 |
| 40 | CS_CHAR_USER36 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 36 |
| 41 | CS_CHAR_USER37 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 37 |
| 42 | CS_CHAR_USER38 | Character(120) | VARCHAR2(120) NOT NULL | Character 120 User Field 38 |
| 43 | CS_DATE_USER1 | Date(10) | DATE | Date User Field 1 |
| 44 | CS_DATE_USER2 | Date(10) | DATE | Date User Field 2 |
| 45 | CS_DATE_USER3 | Date(10) | DATE | Date User Field 3 |
| 46 | CS_DATE_USER4 | Date(10) | DATE | Date User Field 4 |
| 47 | CS_DATE_USER5 | Date(10) | DATE | Date User Field 5 |
| 48 | CS_DATE_USER6 | Date(10) | DATE | Date User Field 6 |
| 49 | CS_DATE_USER7 | Date(10) | DATE | Date User Field 7 |
| 50 | CS_DATE_USER8 | Date(10) | DATE | Date User Field 8 |
| 51 | CS_DATE_USER9 | Date(10) | DATE | Date User Field 9 |
| 52 | CS_DATE_USER10 | Date(10) | DATE | Date User Field 10 |
| 53 | CS_DATE_USER11 | Date(10) | DATE | Date User Field 11 |
| 54 | CS_DATE_USER12 | Date(10) | DATE | Date User Field 12 |
| 55 | CS_DATE_USER13 | Date(10) | DATE | Date User Field 13 |
| 56 | CS_DATE_USER14 | Date(10) | DATE | Date User Field 14 |
| 57 | CS_DATE_USER15 | Date(10) | DATE | Date User Field 15 |
| 58 | CS_DEC_USER1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 1 (23.3) |
| 59 | CS_DEC_USER2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 2 (23.3) |
| 60 | CS_DEC_USER3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 3 (23.3) |
| 61 | CS_DEC_USER4 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 4 (11.4) |
| 62 | CS_DEC_USER5 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field5 (11.4) |
| 63 | CS_DEC_USER6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 6 (23.3) |
| 64 | CS_DEC_USER7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 7 (23.3) |
| 65 | CS_DEC_USER8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 8 (23.3) |
| 66 | CS_DEC_USER9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 9 (23.3) |
| 67 | CS_DEC_USER10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 10 (23.3) |
| 68 | CS_DEC_USER11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Decimal User Field 11 (23.3) |
| 69 | CS_DEC_USER12 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 12 (11.4) |
| 70 | CS_DEC_USER13 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 13 (11.4) |
| 71 | CS_DEC_USER14 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 14 (11.4) |
| 72 | CS_DEC_USER15 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Decimal User Field 15 (11.4) |
| 73 | CS_INT_USER1 | Number(8,0) | INTEGER NOT NULL | Integer User Field 1 |
| 74 | CS_INT_USER2 | Number(8,0) | INTEGER NOT NULL | Integer User Field 2 |
| 75 | CS_INT_USER3 | Number(8,0) | INTEGER NOT NULL | Integer User Field 3 |
| 76 | CS_INT_USER4 | Number(8,0) | INTEGER NOT NULL | Integer User Field 4 |
| 77 | CS_INT_USER5 | Number(8,0) | INTEGER NOT NULL | Integer User Field 5 |
| 78 | CS_INT_USER6 | Number(8,0) | INTEGER NOT NULL | Integer User Field 6 |
| 79 | CS_INT_USER7 | Number(8,0) | INTEGER NOT NULL | Integer User Field 7 |
| 80 | CS_INT_USER8 | Number(8,0) | INTEGER NOT NULL | Integer User Field 8 |
| 81 | CS_INT_USER9 | Number(8,0) | INTEGER NOT NULL | Integer User Field 9 |
| 82 | CS_INT_USER10 | Number(8,0) | INTEGER NOT NULL | Integer User Field 10 |
| 83 | CS_INT_USER11 | Number(8,0) | INTEGER NOT NULL | Integer User Field 11 |
| 84 | CS_INT_USER12 | Number(8,0) | INTEGER NOT NULL | Integer User Field 12 |
| 85 | CS_INT_USER13 | Number(8,0) | INTEGER NOT NULL | Integer User Field 13 |
| 86 | CS_INT_USER14 | Number(8,0) | INTEGER NOT NULL | Integer User Field 14 |
| 87 | CS_INT_USER15 | Number(8,0) | INTEGER NOT NULL | Integer User Field 15 |
| 88 | CS_INT_USER16 | Number(8,0) | INTEGER NOT NULL | Integer User Field 16 |
| 89 | CS_INT_USER17 | Number(8,0) | INTEGER NOT NULL | Integer User Field 17 |
| 90 | CS_INT_USER18 | Number(8,0) | INTEGER NOT NULL | Integer User Field 18 |
| 91 | CS_INT_USER19 | Number(8,0) | INTEGER NOT NULL | Integer User Field 19 |
| 92 | CS_INT_USER20 | Number(8,0) | INTEGER NOT NULL | Integer User Field 20 |
| 93 | CS_INT_USER21 | Number(8,0) | INTEGER NOT NULL | Integer User Field 21 |
| 94 | CS_INT_USER22 | Number(8,0) | INTEGER NOT NULL | Integer User Field 22 |
| 95 | CS_INT_USER23 | Number(8,0) | INTEGER NOT NULL | Integer User Field 23 |
| 96 | CS_INT_USER24 | Number(8,0) | INTEGER NOT NULL | Integer User Field 24 |
| 97 | CS_CHAR_USER1_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 98 | CS_CHAR_USER2_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 99 | CS_CHAR_USER3_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 100 | CS_CHAR_USER4_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 101 | CS_CHAR_USER5_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 102 | CS_CHAR_USER6_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 103 | CS_CHAR_USER7_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 104 | CS_CHAR_USER8_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 105 | CS_CHAR_USER9_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 106 | CS_CHAR_USER10_L | Character(30) | VARCHAR2(30) NOT NULL | Character User Field Label |
| 107 | CS_CHAR_USER11_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 11 |
| 108 | CS_CHAR_USER12_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 12 |
| 109 | CS_CHAR_USER13_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 13 |
| 110 | CS_CHAR_USER14_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 14 |
| 111 | CS_CHAR_USER15_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 15 |
| 112 | CS_CHAR_USER16_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 16 |
| 113 | CS_CHAR_USER17_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 17 |
| 114 | CS_CHAR_USER18_L | Character(30) | VARCHAR2(30) NOT NULL | Char-10 UDF Label 18 |
| 115 | CS_CHAR_USER19_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 19 |
| 116 | CS_CHAR_USER20_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 20 |
| 117 | CS_CHAR_USER21_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 21 |
| 118 | CS_CHAR_USER22_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 22 |
| 119 | CS_CHAR_USER23_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 23 |
| 120 | CS_CHAR_USER24_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 24 |
| 121 | CS_CHAR_USER25_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 25 |
| 122 | CS_CHAR_USER26_L | Character(30) | VARCHAR2(30) NOT NULL | Char-30 UDF label 26 |
| 123 | CS_CHAR_USER27_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 27 |
| 124 | CS_CHAR_USER28_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 28 |
| 125 | CS_CHAR_USER29_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 29 |
| 126 | CS_CHAR_USER30_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 30 |
| 127 | CS_CHAR_USER31_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 31 |
| 128 | CS_CHAR_USER32_L | Character(30) | VARCHAR2(30) NOT NULL | Char-60 UDF label 32 |
| 129 | CS_CHAR_USER33_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 33 |
| 130 | CS_CHAR_USER34_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 34 |
| 131 | CS_CHAR_USER35_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 35 |
| 132 | CS_CHAR_USER36_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 36 |
| 133 | CS_CHAR_USER37_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 37 |
| 134 | CS_CHAR_USER38_L | Character(30) | VARCHAR2(30) NOT NULL | Char-120 UDF Label 38 |
| 135 | CS_DATE_USER1_L | Character(30) | VARCHAR2(30) NOT NULL | User Date Field Label |
| 136 | CS_DATE_USER2_L | Character(30) | VARCHAR2(30) NOT NULL | User Date Field Label |
| 137 | CS_DATE_USER3_L | Character(30) | VARCHAR2(30) NOT NULL | User Date Field Label |
| 138 | CS_DATE_USER4_L | Character(30) | VARCHAR2(30) NOT NULL | User Date Field Label |
| 139 | CS_DATE_USER5_L | Character(30) | VARCHAR2(30) NOT NULL | User Date Field Label |
| 140 | CS_DATE_USER6_L | Character(30) | VARCHAR2(30) NOT NULL | Date 6 UDF Label |
| 141 | CS_DATE_USER7_L | Character(30) | VARCHAR2(30) NOT NULL | Date 7 UDF Label |
| 142 | CS_DATE_USER8_L | Character(30) | VARCHAR2(30) NOT NULL | Date 8 UDF Label |
| 143 | CS_DATE_USER9_L | Character(30) | VARCHAR2(30) NOT NULL | Date 9 UDF Label |
| 144 | CS_DATE_USER10_L | Character(30) | VARCHAR2(30) NOT NULL | Date 10 UDF Label |
| 145 | CS_DATE_USER11_L | Character(30) | VARCHAR2(30) NOT NULL | Date 11 UDF Label |
| 146 | CS_DATE_USER12_L | Character(30) | VARCHAR2(30) NOT NULL | Date 12 UDF Label |
| 147 | CS_DATE_USER13_L | Character(30) | VARCHAR2(30) NOT NULL | Date 13 UDF Label |
| 148 | CS_DATE_USER14_L | Character(30) | VARCHAR2(30) NOT NULL | Date 14 UDF Label |
| 149 | CS_DATE_USER15_L | Character(30) | VARCHAR2(30) NOT NULL | Date 15 UDF Label |
| 150 | CS_DEC_USER1_L | Character(30) | VARCHAR2(30) NOT NULL | User Decimal Field Label |
| 151 | CS_DEC_USER2_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal User Field |
| 152 | CS_DEC_USER3_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal User Field |
| 153 | CS_DEC_USER4_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal User Field |
| 154 | CS_DEC_USER5_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal User Field |
| 155 | CS_DEC_USER6_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 6 UDF Label |
| 156 | CS_DEC_USER7_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 7 UDF Label |
| 157 | CS_DEC_USER8_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 8 UDF Label |
| 158 | CS_DEC_USER9_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 9 UDF Label |
| 159 | CS_DEC_USER10_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 10 UDF Label |
| 160 | CS_DEC_USER11_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 11 UDF Label |
| 161 | CS_DEC_USER12_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 12 UDF Label |
| 162 | CS_DEC_USER13_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 13 UDF Label |
| 163 | CS_DEC_USER14_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 14 UDF Label |
| 164 | CS_DEC_USER15_L | Character(30) | VARCHAR2(30) NOT NULL | Decimal 15 UDF Label |
| 165 | CS_INT_USER1_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 166 | CS_INT_USER2_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 167 | CS_INT_USER3_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 168 | CS_INT_USER4_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 169 | CS_INT_USER5_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 170 | CS_INT_USER6_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 171 | CS_INT_USER7_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 172 | CS_INT_USER8_L | Character(30) | VARCHAR2(30) NOT NULL | Integer User Field |
| 173 | CS_INT_USER9_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 9 UDF Label |
| 174 | CS_INT_USER10_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 10 UDF Label |
| 175 | CS_INT_USER11_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 11 UDF Label |
| 176 | CS_INT_USER12_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 12 UDF Label |
| 177 | CS_INT_USER13_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 13 UDF Label |
| 178 | CS_INT_USER14_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 14 UDF Label |
| 179 | CS_INT_USER15_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 15 UDF Label |
| 180 | CS_INT_USER16_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 16 UDF Label |
| 181 | CS_INT_USER17_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 17 UDF Label |
| 182 | CS_INT_USER18_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 18 UDF Label |
| 183 | CS_INT_USER19_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 19 UDF Label |
| 184 | CS_INT_USER20_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 20 UDF Label |
| 185 | CS_INT_USER21_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 21 UDF Label |
| 186 | CS_INT_USER22_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 22 UDF Label |
| 187 | CS_INT_USER23_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 23 UDF Label |
| 188 | CS_INT_USER24_L | Character(30) | VARCHAR2(30) NOT NULL | Integer 24 UDF Label |