OBP24_HST_WFTASKHISTORY
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_HST_WFTASKHISTORY
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACQUIREDBY | CHARACTER VARYING(40) | 40 |
| 2 | ASSIGNEES | CHARACTER VARYING(4000) | 4000 |
| 3 | ASSIGNEESDISPLAYNAME | CHARACTER VARYING(4000) | 4000 |
| 4 | REVIEWERS | CHARACTER VARYING(200) | 200 |
| 5 | REVIEWERSDISPLAYNAME | CHARACTER VARYING(20) | 20 |
| 6 | ASSIGNEEGROUPS | CHARACTER VARYING(200) | 200 |
| 7 | ASSIGNEEGROUPSDISPLAYNAME | CHARACTER VARYING(20) | 20 |
| 8 | ASSIGNEEUSERS | CHARACTER VARYING(200) | 200 |
| 9 | ASSIGNEEUSERSDISPLAYNAME | CHARACTER VARYING(20) | 20 |
| 10 | CALLBACKCONTEXT | CHARACTER VARYING(20) | 20 |
| 11 | CALLBACKID | CHARACTER VARYING(1500) | 1500 |
| 12 | CALLBACKTYPE | CHARACTER VARYING(20) | 20 |
| 13 | CREATOR | CHARACTER VARYING(40) | 40 |
| 14 | DIGITALSIGNATUREREQUIRED | CHARACTER VARYING(1) | 1 |
| 15 | EXPIRATIONDATE | TIMESTAMP | 8 |
| 16 | EXPIRATIONDURATION | CHARACTER VARYING(64) | 64 |
| 17 | IDENTITYCONTEXT | CHARACTER VARYING(20) | 20 |
| 18 | OWNERUSER | CHARACTER VARYING(40) | 40 |
| 19 | OWNERGROUP | CHARACTER VARYING(400) | 400 |
| 20 | PASSWORDREQUIREDONUPDATE | CHARACTER VARYING(1) | 1 |
| 21 | PRIORITY | INTEGER | 4 |
| 22 | DOMAINID | CHARACTER VARYING(100) | 100 |
| 23 | INSTANCEID | CHARACTER VARYING(20) | 20 |
| 24 | PROCESSID | CHARACTER VARYING(100) | 100 |
| 25 | PROCESSNAME | CHARACTER VARYING(40) | 40 |
| 26 | PROCESSTYPE | CHARACTER VARYING(10) | 10 |
| 27 | PROCESSVERSION | CHARACTER VARYING(100) | 100 |
| 28 | SECURENOTIFICATIONS | CHARACTER VARYING(1) | 1 |
| 29 | ACCESSKEY | CHARACTER VARYING(80) | 80 |
| 30 | APPROVALDURATION | INTEGER | 4 |
| 31 | APPROVERS | CHARACTER VARYING(200) | 200 |
| 32 | ASSIGNEDDATE | TIMESTAMP | 8 |
| 33 | CREATEDDATE | TIMESTAMP | 8 |
| 34 | ELAPSEDTIME | INTEGER | 4 |
| 35 | ENDDATE | TIMESTAMP | 8 |
| 36 | FROMUSER | CHARACTER VARYING(40) | 40 |
| 37 | FROMUSERDISPLAYNAME | CHARACTER VARYING(40) | 40 |
| 38 | HASSUBTASK | CHARACTER VARYING(1) | 1 |
| 39 | INSHORTHISTORY | CHARACTER VARYING(1) | 1 |
| 40 | ISGROUP | CHARACTER VARYING(1) | 1 |
| 41 | LANGUAGE | CHARACTER VARYING(4) | 4 |
| 42 | MAILSTATUS | CHARACTER VARYING(8) | 8 |
| 43 | NUMBEROFTIMESMODIFIED | INTEGER | 4 |
| 44 | ORIGINALASSIGNEEUSER | CHARACTER VARYING(40) | 40 |
| 45 | OUTCOME | CHARACTER VARYING(100) | 100 |
| 46 | PARALLELOUTCOMECOUNT | CHARACTER VARYING(20) | 20 |
| 47 | PUSHBACKSEQUENCE | CHARACTER VARYING(20) | 20 |
| 48 | STATE | CHARACTER VARYING(100) | 100 |
| 49 | SUBSTATE | CHARACTER VARYING(20) | 20 |
| 50 | SYSTEMSTRING1 | CHARACTER VARYING(20) | 20 |
| 51 | SYSTEMSTRING2 | CHARACTER VARYING(20) | 20 |
| 52 | SYSTEMSTRING3 | CHARACTER VARYING(20) | 20 |
| 53 | TASKGROUPID | CHARACTER VARYING(64) | 64 |
| 54 | TASKID | CHARACTER VARYING(64) | 64 |
| 55 | TASKNUMBER | INTEGER | 4 |
| 56 | UPDATEDBY | CHARACTER VARYING(40) | 40 |
| 57 | UPDATEDBYDISPLAYNAME | CHARACTER VARYING(40) | 40 |
| 58 | UPDATEDDATE | TIMESTAMP | 8 |
| 59 | UPDATEDNOTIFICATIONID | CHARACTER VARYING(20) | 20 |
| 60 | VERSION | INTEGER | 4 |
| 61 | VERSIONREASON | CHARACTER VARYING(1500) | 1500 |
| 62 | WORKFLOWPATTERN | CHARACTER VARYING(20) | 20 |
| 63 | TEXTATTRIBUTE1 | CHARACTER VARYING(2000) | 2000 |
| 64 | TEXTATTRIBUTE2 | CHARACTER VARYING(2000) | 2000 |
| 65 | TEXTATTRIBUTE3 | CHARACTER VARYING(2000) | 2000 |
| 66 | TEXTATTRIBUTE4 | CHARACTER VARYING(2000) | 2000 |
| 67 | TEXTATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 68 | TEXTATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 69 | TEXTATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 70 | TEXTATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 71 | TEXTATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 72 | TEXTATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 73 | FORMATTRIBUTE1 | CHARACTER VARYING(20) | 20 |
| 74 | FORMATTRIBUTE2 | CHARACTER VARYING(20) | 20 |
| 75 | FORMATTRIBUTE3 | CHARACTER VARYING(20) | 20 |
| 76 | FORMATTRIBUTE4 | CHARACTER VARYING(20) | 20 |
| 77 | FORMATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 78 | URLATTRIBUTE1 | CHARACTER VARYING(20) | 20 |
| 79 | URLATTRIBUTE2 | CHARACTER VARYING(20) | 20 |
| 80 | URLATTRIBUTE3 | CHARACTER VARYING(20) | 20 |
| 81 | URLATTRIBUTE4 | CHARACTER VARYING(20) | 20 |
| 82 | URLATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 83 | DATEATTRIBUTE1 | TIMESTAMP | 8 |
| 84 | DATEATTRIBUTE2 | TIMESTAMP | 8 |
| 85 | DATEATTRIBUTE3 | TIMESTAMP | 8 |
| 86 | DATEATTRIBUTE4 | TIMESTAMP | 8 |
| 87 | DATEATTRIBUTE5 | TIMESTAMP | 8 |
| 88 | NUMBERATTRIBUTE1 | INTEGER | 4 |
| 89 | NUMBERATTRIBUTE2 | INTEGER | 4 |
| 90 | NUMBERATTRIBUTE3 | INTEGER | 4 |
| 91 | NUMBERATTRIBUTE4 | INTEGER | 4 |
| 92 | NUMBERATTRIBUTE5 | INTEGER | 4 |
| 93 | PROTECTEDTEXTATTRIBUTE1 | CHARACTER VARYING(20) | 20 |
| 94 | PROTECTEDTEXTATTRIBUTE2 | CHARACTER VARYING(20) | 20 |
| 95 | PROTECTEDTEXTATTRIBUTE3 | CHARACTER VARYING(20) | 20 |
| 96 | PROTECTEDTEXTATTRIBUTE4 | CHARACTER VARYING(20) | 20 |
| 97 | PROTECTEDTEXTATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 98 | PROTECTEDTEXTATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 99 | PROTECTEDTEXTATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 100 | PROTECTEDTEXTATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 101 | PROTECTEDTEXTATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 102 | PROTECTEDTEXTATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 103 | PROTECTEDFORMATTRIBUTE1 | CHARACTER VARYING(20) | 20 |
| 104 | PROTECTEDFORMATTRIBUTE2 | CHARACTER VARYING(20) | 20 |
| 105 | PROTECTEDFORMATTRIBUTE3 | CHARACTER VARYING(20) | 20 |
| 106 | PROTECTEDFORMATTRIBUTE4 | CHARACTER VARYING(20) | 20 |
| 107 | PROTECTEDFORMATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 108 | PROTECTEDURLATTRIBUTE1 | CHARACTER VARYING(20) | 20 |
| 109 | PROTECTEDURLATTRIBUTE2 | CHARACTER VARYING(20) | 20 |
| 110 | PROTECTEDURLATTRIBUTE3 | CHARACTER VARYING(20) | 20 |
| 111 | PROTECTEDURLATTRIBUTE4 | CHARACTER VARYING(20) | 20 |
| 112 | PROTECTEDURLATTRIBUTE5 | CHARACTER VARYING(20) | 20 |
| 113 | PROTECTEDDATEATTRIBUTE1 | TIMESTAMP | 8 |
| 114 | PROTECTEDDATEATTRIBUTE2 | TIMESTAMP | 8 |
| 115 | PROTECTEDDATEATTRIBUTE3 | TIMESTAMP | 8 |
| 116 | PROTECTEDDATEATTRIBUTE4 | TIMESTAMP | 8 |
| 117 | PROTECTEDDATEATTRIBUTE5 | TIMESTAMP | 8 |
| 118 | PROTECTEDNUMBERATTRIBUTE1 | INTEGER | 4 |
| 119 | PROTECTEDNUMBERATTRIBUTE2 | INTEGER | 4 |
| 120 | PROTECTEDNUMBERATTRIBUTE3 | INTEGER | 4 |
| 121 | PROTECTEDNUMBERATTRIBUTE4 | INTEGER | 4 |
| 122 | PROTECTEDNUMBERATTRIBUTE5 | INTEGER | 4 |
| 123 | TITLE | CHARACTER VARYING(500) | 500 |
| 124 | TITLERESOURCEKEY | CHARACTER VARYING(100) | 100 |
| 125 | IDENTIFICATIONKEY | CHARACTER VARYING(100) | 100 |
| 126 | USERCOMMENT | CHARACTER VARYING(20) | 20 |
| 127 | WORKFLOWDESCRIPTORURI | CHARACTER VARYING(2000) | 2000 |
| 128 | TASKDEFINITIONID | CHARACTER VARYING(200) | 200 |
| 129 | TASKDEFINITIONNAME | CHARACTER VARYING(200) | 200 |
| 130 | APPLICATIONCONTEXT | CHARACTER VARYING(20) | 20 |
| 131 | APPLICATIONNAME | CHARACTER VARYING(20) | 20 |
| 132 | CATEGORY | CHARACTER VARYING(20) | 20 |
| 133 | COMPONENTNAME | CHARACTER VARYING(500) | 500 |
| 134 | COMPOSITEDN | CHARACTER VARYING(500) | 500 |
| 135 | COMPOSITEINSTANCEID | CHARACTER VARYING(20) | 20 |
| 136 | COMPOSITENAME | CHARACTER VARYING(20) | 20 |
| 137 | COMPOSITEVERSION | CHARACTER VARYING(20) | 20 |
| 138 | CONVERSATIONID | CHARACTER VARYING(20) | 20 |
| 139 | DUEDATE | TIMESTAMP | 8 |
| 140 | ECID | CHARACTER VARYING(20) | 20 |
| 141 | ISPUBLIC | CHARACTER VARYING(1) | 1 |
| 142 | ISTESTTASK | CHARACTER VARYING(1) | 1 |
| 143 | PARENTCOMPONENTINSTANCEID | CHARACTER VARYING(20) | 20 |
| 144 | PARENTCOMPONENTINSTREFID | CHARACTER VARYING(1024) | 1024 |
| 145 | INVOKEDCOMPONENT | CHARACTER VARYING(500) | 500 |
| 146 | PARTICIPANTNAME | CHARACTER VARYING(20) | 20 |
| 147 | PERCENTAGECOMPLETE | INTEGER | 4 |
| 148 | READBYUSERS | CHARACTER VARYING(200) | 200 |
| 149 | STARTDATE | TIMESTAMP | 8 |
| 150 | PARENTTASKVERSION | INTEGER | 4 |
| 151 | TASKGROUPINSTANCEID | CHARACTER VARYING(20) | 20 |
| 152 | SUBTASKGROUPINSTANCEID | CHARACTER VARYING(20) | 20 |
| 153 | OWNERROLE | CHARACTER VARYING(40) | 40 |
| 154 | TASKNAMESPACE | CHARACTER VARYING(20) | 20 |
| 155 | TIMERS | CHARACTER VARYING(300) | 300 |
| 156 | AGROOTID | INTEGER | 4 |
| 157 | AGMILESTONEPATH | CHARACTER VARYING(20) | 20 |
| 158 | ROOTTASKID | CHARACTER VARYING(64) | 64 |
| 159 | PARENTTASKID | CHARACTER VARYING(64) | 64 |
| 160 | SYSTEMSTRINGACTIONS | CHARACTER VARYING(20) | 20 |
| 161 | TASKDISPLAYURL | CHARACTER VARYING(200) | 200 |
| 162 | DOCUMENTPACKAGEID | CHARACTER VARYING(20) | 20 |
| 163 | SUBCATEGORY | CHARACTER VARYING(20) | 20 |
| 164 | CORRELATIONID | CHARACTER VARYING(64) | 64 |
| 165 | STAGE | CHARACTER VARYING(20) | 20 |
| 166 | ASSIGNMENTCONTEXT | CHARACTER VARYING(200) | 200 |
| 167 | PREACTIONUSERSTEPS | CHARACTER VARYING(40) | 40 |
| 168 | AGGREGATIONTASKID | CHARACTER VARYING(64) | 64 |
| 169 | MDSLABEL | CHARACTER VARYING(20) | 20 |
| 170 | ISTEMPLATETASK | CHARACTER VARYING(1) | 1 |
| 171 | COMPONENTTYPE | CHARACTER VARYING(10) | 10 |
| 172 | ACTIVITYNAME | CHARACTER VARYING(20) | 20 |
| 173 | ACTIVITYID | CHARACTER VARYING(20) | 20 |
| 174 | PROCESSDUEDATE | TIMESTAMP | 8 |
| 175 | THREAD | INTEGER | 4 |
| 176 | PARENTTHREAD | INTEGER | 4 |
| 177 | STEP | INTEGER | 4 |
| 178 | VRCVALUES | CHARACTER VARYING(200) | 200 |
| 179 | ORGANIZATIONALUNITID | CHARACTER VARYING(64) | 64 |
| 180 | TEXTATTRIBUTE11 | CHARACTER VARYING(20) | 20 |
| 181 | TEXTATTRIBUTE12 | CHARACTER VARYING(20) | 20 |
| 182 | TEXTATTRIBUTE13 | CHARACTER VARYING(20) | 20 |
| 183 | TEXTATTRIBUTE14 | CHARACTER VARYING(20) | 20 |
| 184 | TEXTATTRIBUTE15 | CHARACTER VARYING(20) | 20 |
| 185 | TEXTATTRIBUTE16 | CHARACTER VARYING(20) | 20 |
| 186 | TEXTATTRIBUTE17 | CHARACTER VARYING(20) | 20 |
| 187 | TEXTATTRIBUTE18 | CHARACTER VARYING(20) | 20 |
| 188 | TEXTATTRIBUTE19 | CHARACTER VARYING(20) | 20 |
| 189 | TEXTATTRIBUTE20 | CHARACTER VARYING(20) | 20 |
| 190 | FORMATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 191 | FORMATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 192 | FORMATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 193 | FORMATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 194 | FORMATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 195 | URLATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 196 | URLATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 197 | URLATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 198 | URLATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 199 | URLATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 200 | DATEATTRIBUTE6 | TIMESTAMP | 8 |
| 201 | DATEATTRIBUTE7 | TIMESTAMP | 8 |
| 202 | DATEATTRIBUTE8 | TIMESTAMP | 8 |
| 203 | DATEATTRIBUTE9 | TIMESTAMP | 8 |
| 204 | DATEATTRIBUTE10 | TIMESTAMP | 8 |
| 205 | NUMBERATTRIBUTE6 | INTEGER | 4 |
| 206 | NUMBERATTRIBUTE7 | INTEGER | 4 |
| 207 | NUMBERATTRIBUTE8 | INTEGER | 4 |
| 208 | NUMBERATTRIBUTE9 | INTEGER | 4 |
| 209 | NUMBERATTRIBUTE10 | INTEGER | 4 |
| 210 | PROTECTEDTEXTATTRIBUTE11 | CHARACTER VARYING(20) | 20 |
| 211 | PROTECTEDTEXTATTRIBUTE12 | CHARACTER VARYING(20) | 20 |
| 212 | PROTECTEDTEXTATTRIBUTE13 | CHARACTER VARYING(20) | 20 |
| 213 | PROTECTEDTEXTATTRIBUTE14 | CHARACTER VARYING(20) | 20 |
| 214 | PROTECTEDTEXTATTRIBUTE15 | CHARACTER VARYING(20) | 20 |
| 215 | PROTECTEDTEXTATTRIBUTE16 | CHARACTER VARYING(20) | 20 |
| 216 | PROTECTEDTEXTATTRIBUTE17 | CHARACTER VARYING(20) | 20 |
| 217 | PROTECTEDTEXTATTRIBUTE18 | CHARACTER VARYING(20) | 20 |
| 218 | PROTECTEDTEXTATTRIBUTE19 | CHARACTER VARYING(20) | 20 |
| 219 | PROTECTEDTEXTATTRIBUTE20 | CHARACTER VARYING(20) | 20 |
| 220 | PROTECTEDFORMATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 221 | PROTECTEDFORMATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 222 | PROTECTEDFORMATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 223 | PROTECTEDFORMATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 224 | PROTECTEDFORMATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 225 | PROTECTEDURLATTRIBUTE6 | CHARACTER VARYING(20) | 20 |
| 226 | PROTECTEDURLATTRIBUTE7 | CHARACTER VARYING(20) | 20 |
| 227 | PROTECTEDURLATTRIBUTE8 | CHARACTER VARYING(20) | 20 |
| 228 | PROTECTEDURLATTRIBUTE9 | CHARACTER VARYING(20) | 20 |
| 229 | PROTECTEDURLATTRIBUTE10 | CHARACTER VARYING(20) | 20 |
| 230 | PROTECTEDDATEATTRIBUTE6 | TIMESTAMP | 8 |
| 231 | PROTECTEDDATEATTRIBUTE7 | TIMESTAMP | 8 |
| 232 | PROTECTEDDATEATTRIBUTE8 | TIMESTAMP | 8 |
| 233 | PROTECTEDDATEATTRIBUTE9 | TIMESTAMP | 8 |
| 234 | PROTECTEDDATEATTRIBUTE10 | TIMESTAMP | 8 |
| 235 | PROTECTEDNUMBERATTRIBUTE6 | INTEGER | 4 |
| 236 | PROTECTEDNUMBERATTRIBUTE7 | INTEGER | 4 |
| 237 | PROTECTEDNUMBERATTRIBUTE8 | INTEGER | 4 |
| 238 | PROTECTEDNUMBERATTRIBUTE9 | INTEGER | 4 |
| 239 | PROTECTEDNUMBERATTRIBUTE10 | INTEGER | 4 |
| 240 | COMPOSITECREATEDTIME | TIMESTAMP | 8 |
| 241 | TENANTID | CHARACTER VARYING(40) | 40 |
| 242 | TENANT_ID | INTEGER | 4 |
| 243 | LISTBUILDERID | CHARACTER VARYING(64) | 64 |
| 244 | CASEID | CHARACTER VARYING(64) | 64 |
| 245 | SWIMLANEROLE | CHARACTER VARYING(20) | 20 |
| 246 | EXCLUDEDPARTICIPANTS | CHARACTER VARYING(20) | 20 |
| 247 | CUSTOMATTRIBUTESTRING1 | CHARACTER VARYING(20) | 20 |
| 248 | CUSTOMATTRIBUTESTRING2 | CHARACTER VARYING(20) | 20 |
| 249 | CUSTOMATTRIBUTENUMBER1 | INTEGER | 4 |
| 250 | CUSTOMATTRIBUTENUMBER2 | INTEGER | 4 |
| 251 | CUSTOMATTRIBUTEDATE1 | TIMESTAMP | 8 |
| 252 | CUSTOMATTRIBUTEDATE2 | TIMESTAMP | 8 |
| 253 | TIMERSSUSPENDED | CHARACTER VARYING(1) | 1 |
| 254 | ISDECOMPOSEDTASK | CHARACTER VARYING(1) | 1 |
| 255 | FORMNAME | CHARACTER VARYING(20) | 20 |
| 256 | DECOMPOSEDTASKGRPINSTANCEID | CHARACTER VARYING(64) | 64 |
| 257 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 258 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 259 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 260 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |