HRC_DL_ROLLBACK_PHY_LINES

Each row in this table corresponds to a Fusion Row that will be MERGED/DELETED on Fusion tables. It Stores actual fusion data using generic columns. It also holds information of its status during IMPORT,LOAD and VALIDATE which are used to calculate status counts of its logical row.

Details

  • Schema: FUSION

  • Object owner: HRC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HRC_DL_ROLLBACK_PHY_LINES_PK

PHYSICAL_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
PHYSICAL_LINE_ID NUMBER 18 Yes PHYSICAL_LINE_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
LINE_OPERATION VARCHAR2 20 Yes LINE_OPERATION
P_EFFECTIVE_START_DATE DATE P_EFFECTIVE_START_DATE
P_EFFECTIVE_END_DATE DATE P_EFFECTIVE_END_DATE
P_EFFECTIVE_SEQUENCE NUMBER 18 P_EFFECTIVE_SEQUENCE
P_EFFECTIVE_LATEST_CHANGE VARCHAR2 1 P_EFFECTIVE_LATEST_CHANGE
KEY_LANGUAGE VARCHAR2 4 KEY_LANGUAGE
FUSION_ASSIGNED_KEY NUMBER Fusion Assigned Key
LOGICAL_LINE_ID NUMBER 18 Yes LOGICAL_LINE_ID
DATA_SET_BUS_OBJ_ID NUMBER 18 Yes DATA_SET_BUS_OBJ_ID
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
VO_MAPPING_ID NUMBER 18 This column will contain the vo_mapping_id for the current row.
PVAL001 VARCHAR2 4000 PVAL001
PVAL002 VARCHAR2 4000 PVAL002
PVAL003 VARCHAR2 4000 PVAL003
PVAL004 VARCHAR2 4000 PVAL004
PVAL005 VARCHAR2 4000 PVAL005
PVAL006 VARCHAR2 4000 PVAL006
PVAL007 VARCHAR2 4000 PVAL007
PVAL008 VARCHAR2 4000 PVAL008
PVAL009 VARCHAR2 4000 PVAL009
PVAL010 VARCHAR2 4000 PVAL0010
PVAL011 VARCHAR2 4000 PVAL011
PVAL012 VARCHAR2 4000 PVAL012
PVAL013 VARCHAR2 4000 PVAL013
PVAL014 VARCHAR2 4000 PVAL014
PVAL015 VARCHAR2 4000 PVAL015
PVAL016 VARCHAR2 4000 PVAL016
PVAL017 VARCHAR2 4000 PVAL017
PVAL018 VARCHAR2 4000 PVAL018
PVAL019 VARCHAR2 4000 PVAL019
PVAL020 VARCHAR2 4000 PVAL020
PVAL021 VARCHAR2 4000 PVAL021
PVAL022 VARCHAR2 4000 PVAL022
PVAL023 VARCHAR2 4000 PVAL023
PVAL024 VARCHAR2 4000 PVAL024
PVAL025 VARCHAR2 4000 PVAL025
PVAL026 VARCHAR2 4000 PVAL026
PVAL027 VARCHAR2 4000 PVAL027
PVAL028 VARCHAR2 4000 PVAL028
PVAL029 VARCHAR2 4000 PVAL029
PVAL030 VARCHAR2 4000 PVAL030
PVAL031 VARCHAR2 4000 PVAL031
PVAL032 VARCHAR2 4000 PVAL032
PVAL033 VARCHAR2 4000 PVAL033
PVAL034 VARCHAR2 4000 PVAL034
PVAL035 VARCHAR2 4000 PVAL035
PVAL036 VARCHAR2 4000 PVAL036
PVAL037 VARCHAR2 4000 PVAL037
PVAL038 VARCHAR2 4000 PVAL038
PVAL039 VARCHAR2 4000 PVAL039
PVAL040 VARCHAR2 4000 PVAL040
PVAL041 VARCHAR2 4000 PVAL041
PVAL042 VARCHAR2 4000 PVAL042
PVAL043 VARCHAR2 4000 PVAL043
PVAL044 VARCHAR2 4000 PVAL044
PVAL045 VARCHAR2 4000 PVAL045
PVAL046 VARCHAR2 4000 PVAL046
PVAL047 VARCHAR2 4000 PVAL047
PVAL048 VARCHAR2 4000 PVAL048
PVAL049 VARCHAR2 4000 PVAL049
PVAL050 VARCHAR2 4000 PVAL050
PVAL051 VARCHAR2 4000 PVAL051
PVAL052 VARCHAR2 4000 PVAL052
PVAL053 VARCHAR2 4000 PVAL053
PVAL054 VARCHAR2 4000 PVAL054
PVAL055 VARCHAR2 4000 PVAL055
PVAL056 VARCHAR2 4000 PVAL056
PVAL057 VARCHAR2 4000 PVAL057
PVAL058 VARCHAR2 4000 PVAL058
PVAL059 VARCHAR2 4000 PVAL059
PVAL060 VARCHAR2 4000 PVAL060
PVAL061 VARCHAR2 4000 PVAL061
PVAL062 VARCHAR2 4000 PVAL062
PVAL063 VARCHAR2 4000 PVAL063
PVAL064 VARCHAR2 4000 PVAL064
PVAL065 VARCHAR2 4000 PVAL065
PVAL066 VARCHAR2 4000 PVAL066
PVAL067 VARCHAR2 4000 PVAL067
PVAL068 VARCHAR2 4000 PVAL068
PVAL069 VARCHAR2 4000 PVAL069
PVAL070 VARCHAR2 4000 PVAL070
PVAL071 VARCHAR2 4000 PVAL071
PVAL072 VARCHAR2 4000 PVAL072
PVAL073 VARCHAR2 4000 PVAL073
PVAL074 VARCHAR2 4000 PVAL074
PVAL075 VARCHAR2 4000 PVAL075
PVAL076 VARCHAR2 4000 PVAL076
PVAL077 VARCHAR2 4000 PVAL077
PVAL078 VARCHAR2 4000 PVAL078
PVAL079 VARCHAR2 4000 PVAL079
PVAL080 VARCHAR2 4000 PVAL080
PVAL081 VARCHAR2 4000 PVAL081
PVAL082 VARCHAR2 4000 PVAL082
PVAL083 VARCHAR2 4000 PVAL083
PVAL084 VARCHAR2 4000 PVAL084
PVAL085 VARCHAR2 4000 PVAL085
PVAL086 VARCHAR2 4000 PVAL086
PVAL087 VARCHAR2 4000 PVAL087
PVAL088 VARCHAR2 4000 PVAL088
PVAL089 VARCHAR2 4000 PVAL089
PVAL090 VARCHAR2 4000 PVAL090
PVAL091 VARCHAR2 4000 PVAL091
PVAL092 VARCHAR2 4000 PVAL092
PVAL093 VARCHAR2 4000 PVAL093
PVAL094 VARCHAR2 4000 PVAL094
PVAL095 VARCHAR2 4000 PVAL095
PVAL096 VARCHAR2 4000 PVAL096
PVAL097 VARCHAR2 4000 PVAL097
PVAL098 VARCHAR2 4000 PVAL098
PVAL099 VARCHAR2 4000 PVAL099
PVAL100 VARCHAR2 4000 PVAL100
PVAL101 VARCHAR2 4000 PVAL101
PVAL102 VARCHAR2 4000 PVAL102
PVAL103 VARCHAR2 4000 PVAL103
PVAL104 VARCHAR2 4000 PVAL104
PVAL105 VARCHAR2 4000 PVAL105
PVAL106 VARCHAR2 4000 PVAL106
PVAL107 VARCHAR2 4000 PVAL107
PVAL108 VARCHAR2 4000 PVAL108
PVAL109 VARCHAR2 4000 PVAL109
PVAL110 VARCHAR2 4000 PVAL110
PVAL111 VARCHAR2 4000 PVAL111
PVAL112 VARCHAR2 4000 PVAL112
PVAL113 VARCHAR2 4000 PVAL113
PVAL114 VARCHAR2 4000 PVAL114
PVAL115 VARCHAR2 4000 PVAL115
PVAL116 VARCHAR2 4000 PVAL116
PVAL117 VARCHAR2 4000 PVAL117
PVAL118 VARCHAR2 4000 PVAL118
PVAL119 VARCHAR2 4000 PVAL119
PVAL120 VARCHAR2 4000 PVAL120
PVAL121 VARCHAR2 4000 PVAL121
PVAL122 VARCHAR2 4000 PVAL122
PVAL123 VARCHAR2 4000 PVAL123
PVAL124 VARCHAR2 4000 PVAL124
PVAL125 VARCHAR2 4000 PVAL125
PVAL126 VARCHAR2 4000 PVAL126
PVAL127 VARCHAR2 4000 PVAL127
PVAL128 VARCHAR2 4000 PVAL128
PVAL129 VARCHAR2 4000 PVAL129
PVAL130 VARCHAR2 4000 PVAL130
PVAL131 VARCHAR2 4000 PVAL131
PVAL132 VARCHAR2 4000 PVAL132
PVAL133 VARCHAR2 4000 PVAL133
PVAL134 VARCHAR2 4000 PVAL134
PVAL135 VARCHAR2 4000 PVAL135
PVAL136 VARCHAR2 4000 PVAL136
PVAL137 VARCHAR2 4000 PVAL137
PVAL138 VARCHAR2 4000 PVAL138
PVAL139 VARCHAR2 4000 PVAL139
PVAL140 VARCHAR2 4000 PVAL140
PVAL141 VARCHAR2 4000 PVAL141
PVAL142 VARCHAR2 4000 PVAL142
PVAL143 VARCHAR2 4000 PVAL143
PVAL144 VARCHAR2 4000 PVAL144
PVAL145 VARCHAR2 4000 PVAL145
PVAL146 VARCHAR2 4000 PVAL146
PVAL147 VARCHAR2 4000 PVAL147
PVAL148 VARCHAR2 4000 PVAL148
PVAL149 VARCHAR2 4000 PVAL149
PVAL150 VARCHAR2 4000 PVAL150
PVAL151 VARCHAR2 4000 PVAL151
PVAL152 VARCHAR2 4000 PVAL152
PVAL153 VARCHAR2 4000 PVAL153
PVAL154 VARCHAR2 4000 PVAL154
PVAL155 VARCHAR2 4000 PVAL155
PVAL156 VARCHAR2 4000 PVAL156
PVAL157 VARCHAR2 4000 PVAL157
PVAL158 VARCHAR2 4000 PVAL158
PVAL159 VARCHAR2 4000 PVAL159
PVAL160 VARCHAR2 4000 PVAL160
PVAL161 VARCHAR2 4000 PVAL161
PVAL162 VARCHAR2 4000 PVAL162
PVAL163 VARCHAR2 4000 PVAL163
PVAL164 VARCHAR2 4000 PVAL164
PVAL165 VARCHAR2 4000 PVAL165
PVAL166 VARCHAR2 4000 PVAL166
PVAL167 VARCHAR2 4000 PVAL167
PVAL168 VARCHAR2 4000 PVAL168
PVAL169 VARCHAR2 4000 PVAL169
PVAL170 VARCHAR2 4000 PVAL170
PVAL171 VARCHAR2 4000 PVAL171
PVAL172 VARCHAR2 4000 PVAL172
PVAL173 VARCHAR2 4000 PVAL173
PVAL174 VARCHAR2 4000 PVAL174
PVAL175 VARCHAR2 4000 PVAL175
PVAL176 VARCHAR2 4000 PVAL176
PVAL177 VARCHAR2 4000 PVAL177
PVAL178 VARCHAR2 4000 PVAL178
PVAL179 VARCHAR2 4000 PVAL179
PVAL180 VARCHAR2 4000 PVAL180
PVAL181 VARCHAR2 4000 PVAL181
PVAL182 VARCHAR2 4000 PVAL182
PVAL183 VARCHAR2 4000 PVAL183
PVAL184 VARCHAR2 4000 PVAL184
PVAL185 VARCHAR2 4000 PVAL185
PVAL186 VARCHAR2 4000 PVAL186
PVAL187 VARCHAR2 4000 PVAL187
PVAL188 VARCHAR2 4000 PVAL188
PVAL189 VARCHAR2 4000 PVAL189
PVAL190 VARCHAR2 4000 PVAL190
PVAL191 VARCHAR2 4000 PVAL191
PVAL192 VARCHAR2 4000 PVAL192
PVAL193 VARCHAR2 4000 PVAL193
PVAL194 VARCHAR2 4000 PVAL194
PVAL195 VARCHAR2 4000 PVAL195
PVAL196 VARCHAR2 4000 PVAL196
PVAL197 VARCHAR2 4000 PVAL197
PVAL198 VARCHAR2 4000 PVAL198
PVAL199 VARCHAR2 4000 PVAL199
PVAL200 VARCHAR2 4000 PVAL200
PVAL201 VARCHAR2 4000 PVAL201
PVAL202 VARCHAR2 4000 PVAL202
PVAL203 VARCHAR2 4000 PVAL203
PVAL204 VARCHAR2 4000 PVAL204
PVAL205 VARCHAR2 4000 PVAL205
PVAL206 VARCHAR2 4000 PVAL206
PVAL207 VARCHAR2 4000 PVAL207
PVAL208 VARCHAR2 4000 PVAL208
PVAL209 VARCHAR2 4000 PVAL209
PVAL210 VARCHAR2 4000 PVAL210
PVAL211 VARCHAR2 4000 PVAL211
PVAL212 VARCHAR2 4000 PVAL212
PVAL213 VARCHAR2 4000 PVAL213
PVAL214 VARCHAR2 4000 PVAL214
PVAL215 VARCHAR2 4000 PVAL215
PVAL216 VARCHAR2 4000 PVAL216
PVAL217 VARCHAR2 4000 PVAL217
PVAL218 VARCHAR2 4000 PVAL218
PVAL219 VARCHAR2 4000 PVAL219
PVAL220 VARCHAR2 4000 PVAL220
PVAL221 VARCHAR2 4000 PVAL221
PVAL222 VARCHAR2 4000 PVAL222
PVAL223 VARCHAR2 4000 PVAL223
PVAL224 VARCHAR2 4000 PVAL224
PVAL225 VARCHAR2 4000 PVAL225
PVAL226 VARCHAR2 4000 PVAL226
PVAL227 VARCHAR2 4000 PVAL227
PVAL228 VARCHAR2 4000 PVAL228
PVAL229 VARCHAR2 4000 PVAL229
PVAL230 VARCHAR2 4000 PVAL230
PVAL231 VARCHAR2 4000 PVAL231
PVAL232 VARCHAR2 4000 PVAL232
PVAL233 VARCHAR2 4000 PVAL233
PVAL234 VARCHAR2 4000 PVAL234
PVAL235 VARCHAR2 4000 PVAL235
PVAL236 VARCHAR2 4000 PVAL236
PVAL237 VARCHAR2 4000 PVAL237
PVAL238 VARCHAR2 4000 PVAL238
PVAL239 VARCHAR2 4000 PVAL239
PVAL240 VARCHAR2 4000 PVAL240
PVAL241 VARCHAR2 4000 PVAL241
PVAL242 VARCHAR2 4000 PVAL242
PVAL243 VARCHAR2 4000 PVAL243
PVAL244 VARCHAR2 4000 PVAL244
PVAL245 VARCHAR2 4000 PVAL245
PVAL246 VARCHAR2 4000 PVAL246
PVAL247 VARCHAR2 4000 PVAL247
PVAL248 VARCHAR2 4000 PVAL248
PVAL249 VARCHAR2 4000 PVAL249
PVAL250 VARCHAR2 4000 PVAL250
PVAL251 VARCHAR2 4000 PVAL251
PVAL252 VARCHAR2 4000 PVAL252
PVAL253 VARCHAR2 4000 PVAL253
PVAL254 VARCHAR2 4000 PVAL254
PVAL255 VARCHAR2 4000 PVAL255
PVAL256 VARCHAR2 4000 PVAL256
PVAL257 VARCHAR2 4000 PVAL257
PVAL258 VARCHAR2 4000 PVAL258
PVAL259 VARCHAR2 4000 PVAL259
PVAL260 VARCHAR2 4000 PVAL260
PVAL261 VARCHAR2 4000 PVAL261
PVAL262 VARCHAR2 4000 PVAL262
PVAL263 VARCHAR2 4000 PVAL263
PVAL264 VARCHAR2 4000 PVAL264
PVAL265 VARCHAR2 4000 PVAL265
PVAL266 VARCHAR2 4000 PVAL266
PVAL267 VARCHAR2 4000 PVAL267
PVAL268 VARCHAR2 4000 PVAL268
PVAL269 VARCHAR2 4000 PVAL269
PVAL270 VARCHAR2 4000 PVAL270
PVAL271 VARCHAR2 4000 PVAL271
PVAL272 VARCHAR2 4000 PVAL272
PVAL273 VARCHAR2 4000 PVAL273
PVAL274 VARCHAR2 4000 PVAL274
PVAL275 VARCHAR2 4000 PVAL275
PVAL276 VARCHAR2 4000 PVAL276
PVAL277 VARCHAR2 4000 PVAL277
PVAL278 VARCHAR2 4000 PVAL278
PVAL279 VARCHAR2 4000 PVAL279
PVAL280 VARCHAR2 4000 PVAL280
PVAL281 VARCHAR2 4000 PVAL281
PVAL282 VARCHAR2 4000 PVAL282
PVAL283 VARCHAR2 4000 PVAL283
PVAL284 VARCHAR2 4000 PVAL284
PVAL285 VARCHAR2 4000 PVAL285
PVAL286 VARCHAR2 4000 PVAL286
PVAL287 VARCHAR2 4000 PVAL287
PVAL288 VARCHAR2 4000 PVAL288
PVAL289 VARCHAR2 4000 PVAL289
PVAL290 VARCHAR2 4000 PVAL290
PVAL291 VARCHAR2 4000 PVAL291
PVAL292 VARCHAR2 4000 PVAL292
PVAL293 VARCHAR2 4000 PVAL293
PVAL294 VARCHAR2 4000 PVAL294
PVAL295 VARCHAR2 4000 PVAL295
PVAL296 VARCHAR2 4000 PVAL296
PVAL297 VARCHAR2 4000 PVAL297
PVAL298 VARCHAR2 4000 PVAL298
PVAL299 VARCHAR2 4000 PVAL299
PVAL300 VARCHAR2 4000 PVAL300
PVAL301 VARCHAR2 4000 PVAL301
PVAL302 VARCHAR2 4000 PVAL302
PVAL303 VARCHAR2 4000 PVAL303
PVAL304 VARCHAR2 4000 PVAL304
PVAL305 VARCHAR2 4000 PVAL305
PVAL306 VARCHAR2 4000 PVAL306
PVAL307 VARCHAR2 4000 PVAL307
PVAL308 VARCHAR2 4000 PVAL308
PVAL309 VARCHAR2 4000 PVAL309
PVAL310 VARCHAR2 4000 PVAL310
PVAL311 VARCHAR2 4000 PVAL311
PVAL312 VARCHAR2 4000 PVAL312
PVAL313 VARCHAR2 4000 PVAL313
PVAL314 VARCHAR2 4000 PVAL314
PVAL315 VARCHAR2 4000 PVAL315
PVAL316 VARCHAR2 4000 PVAL316
PVAL317 VARCHAR2 4000 PVAL317
PVAL318 VARCHAR2 4000 PVAL318
PVAL319 VARCHAR2 4000 PVAL319
PVAL320 VARCHAR2 4000 PVAL320
PVAL321 VARCHAR2 4000 PVAL321
PVAL322 VARCHAR2 4000 PVAL322
PVAL323 VARCHAR2 4000 PVAL323
PVAL324 VARCHAR2 4000 PVAL324
PVAL325 VARCHAR2 4000 PVAL325
PVAL326 VARCHAR2 4000 PVAL326
PVAL327 VARCHAR2 4000 PVAL327
PVAL328 VARCHAR2 4000 PVAL328
PVAL329 VARCHAR2 4000 PVAL329
PVAL330 VARCHAR2 4000 PVAL330
PVAL331 VARCHAR2 4000 PVAL331
PVAL332 VARCHAR2 4000 PVAL332
PVAL333 VARCHAR2 4000 PVAL333
PVAL334 VARCHAR2 4000 PVAL334
PVAL335 VARCHAR2 4000 PVAL335
PVAL336 VARCHAR2 4000 PVAL336
PVAL337 VARCHAR2 4000 PVAL337
PVAL338 VARCHAR2 4000 PVAL338
PVAL339 VARCHAR2 4000 PVAL339
PVAL340 VARCHAR2 4000 PVAL340
PVAL341 VARCHAR2 4000 PVAL341
PVAL342 VARCHAR2 4000 PVAL342
PVAL343 VARCHAR2 4000 PVAL343
PVAL344 VARCHAR2 4000 PVAL344
PVAL345 VARCHAR2 4000 PVAL345
PVAL346 VARCHAR2 4000 PVAL346
PVAL347 VARCHAR2 4000 PVAL347
PVAL348 VARCHAR2 4000 PVAL348
PVAL349 VARCHAR2 4000 PVAL349
PVAL350 VARCHAR2 4000 PVAL350
PVAL351 VARCHAR2 4000 PVAL351
PVAL352 VARCHAR2 4000 PVAL352
PVAL353 VARCHAR2 4000 PVAL353
PVAL354 VARCHAR2 4000 PVAL354
PVAL355 VARCHAR2 4000 PVAL355
PVAL356 VARCHAR2 4000 PVAL356
PVAL357 VARCHAR2 4000 PVAL357
PVAL358 VARCHAR2 4000 PVAL358
PVAL359 VARCHAR2 4000 PVAL359
PVAL360 VARCHAR2 4000 PVAL360
PVAL361 VARCHAR2 4000 PVAL361
PVAL362 VARCHAR2 4000 PVAL362
PVAL363 VARCHAR2 4000 PVAL363
PVAL364 VARCHAR2 4000 PVAL364
PVAL365 VARCHAR2 4000 PVAL365
PVAL366 VARCHAR2 4000 PVAL366
PVAL367 VARCHAR2 4000 PVAL367
PVAL368 VARCHAR2 4000 PVAL368
PVAL369 VARCHAR2 4000 PVAL369
PVAL370 VARCHAR2 4000 PVAL370
PVAL371 VARCHAR2 4000 PVAL371
PVAL372 VARCHAR2 4000 PVAL372
PVAL373 VARCHAR2 4000 PVAL373
PVAL374 VARCHAR2 4000 PVAL374
PVAL375 VARCHAR2 4000 PVAL375
PVAL376 VARCHAR2 4000 PVAL376
PVAL377 VARCHAR2 4000 PVAL377
PVAL378 VARCHAR2 4000 PVAL378
PVAL379 VARCHAR2 4000 PVAL379
PVAL380 VARCHAR2 4000 PVAL380
PVAL381 VARCHAR2 4000 PVAL381
PVAL382 VARCHAR2 4000 PVAL382
PVAL383 VARCHAR2 4000 PVAL383
PVAL384 VARCHAR2 4000 PVAL384
PVAL385 VARCHAR2 4000 PVAL385
PVAL386 VARCHAR2 4000 PVAL386
PVAL387 VARCHAR2 4000 PVAL387
PVAL388 VARCHAR2 4000 PVAL388
PVAL389 VARCHAR2 4000 PVAL389
PVAL390 VARCHAR2 4000 PVAL390
PVAL391 VARCHAR2 4000 PVAL391
PVAL392 VARCHAR2 4000 PVAL392
PVAL393 VARCHAR2 4000 PVAL393
PVAL394 VARCHAR2 4000 PVAL394
PVAL395 VARCHAR2 4000 PVAL395
PVAL396 VARCHAR2 4000 PVAL396
PVAL397 VARCHAR2 4000 PVAL397
PVAL398 VARCHAR2 4000 PVAL398
PVAL399 VARCHAR2 4000 PVAL399
PVAL400 VARCHAR2 4000 PVAL400
PVAL401 VARCHAR2 4000 PVAL401
PVAL402 VARCHAR2 4000 PVAL402
PVAL403 VARCHAR2 4000 PVAL403
PVAL404 VARCHAR2 4000 PVAL404
PVAL405 VARCHAR2 4000 PVAL405
PVAL406 VARCHAR2 4000 PVAL406
PVAL407 VARCHAR2 4000 PVAL407
PVAL408 VARCHAR2 4000 PVAL408
PVAL409 VARCHAR2 4000 PVAL409
PVAL410 VARCHAR2 4000 PVAL410
PVAL411 VARCHAR2 4000 PVAL411
PVAL412 VARCHAR2 4000 PVAL412
PVAL413 VARCHAR2 4000 PVAL413
PVAL414 VARCHAR2 4000 PVAL414
PVAL415 VARCHAR2 4000 PVAL415
PVAL416 VARCHAR2 4000 PVAL416
PVAL417 VARCHAR2 4000 PVAL417
PVAL418 VARCHAR2 4000 PVAL418
PVAL419 VARCHAR2 4000 PVAL419
PVAL420 VARCHAR2 4000 PVAL420
PVAL421 VARCHAR2 4000 PVAL421
PVAL422 VARCHAR2 4000 PVAL422
PVAL423 VARCHAR2 4000 PVAL423
PVAL424 VARCHAR2 4000 PVAL424
PVAL425 VARCHAR2 4000 PVAL425
PVAL426 VARCHAR2 4000 PVAL426
PVAL427 VARCHAR2 4000 PVAL427
PVAL428 VARCHAR2 4000 PVAL428
PVAL429 VARCHAR2 4000 PVAL429
PVAL430 VARCHAR2 4000 PVAL430
PVAL431 VARCHAR2 4000 PVAL431
PVAL432 VARCHAR2 4000 PVAL432
PVAL433 VARCHAR2 4000 PVAL433
PVAL434 VARCHAR2 4000 PVAL434
PVAL435 VARCHAR2 4000 PVAL435
PVAL436 VARCHAR2 4000 PVAL436
PVAL437 VARCHAR2 4000 PVAL437
PVAL438 VARCHAR2 4000 PVAL438
PVAL439 VARCHAR2 4000 PVAL439
PVAL440 VARCHAR2 4000 PVAL440
PVAL441 VARCHAR2 4000 PVAL441
PVAL442 VARCHAR2 4000 PVAL442
PVAL443 VARCHAR2 4000 PVAL443
PVAL444 VARCHAR2 4000 PVAL444
PVAL445 VARCHAR2 4000 PVAL445
PVAL446 VARCHAR2 4000 PVAL446
PVAL447 VARCHAR2 4000 PVAL447
PVAL448 VARCHAR2 4000 PVAL448
PVAL449 VARCHAR2 4000 PVAL449
PVAL450 VARCHAR2 4000 PVAL450
PVAL451 VARCHAR2 4000 PVAL451
PVAL452 VARCHAR2 4000 PVAL452
PVAL453 VARCHAR2 4000 PVAL453
PVAL454 VARCHAR2 4000 PVAL454
PVAL455 VARCHAR2 4000 PVAL455
PVAL456 VARCHAR2 4000 PVAL456
PVAL457 VARCHAR2 4000 PVAL457
PVAL458 VARCHAR2 4000 PVAL458
PVAL459 VARCHAR2 4000 PVAL459
PVAL460 VARCHAR2 4000 PVAL460
PVAL461 VARCHAR2 4000 PVAL461
PVAL462 VARCHAR2 4000 PVAL462
PVAL463 VARCHAR2 4000 PVAL463
PVAL464 VARCHAR2 4000 PVAL464
PVAL465 VARCHAR2 4000 PVAL465
PVAL466 VARCHAR2 4000 PVAL466
PVAL467 VARCHAR2 4000 PVAL467
PVAL468 VARCHAR2 4000 PVAL468
PVAL469 VARCHAR2 4000 PVAL469
PVAL470 VARCHAR2 4000 PVAL470
PVAL471 VARCHAR2 4000 PVAL471
PVAL472 VARCHAR2 4000 PVAL472
PVAL473 VARCHAR2 4000 PVAL473
PVAL474 VARCHAR2 4000 PVAL474
PVAL475 VARCHAR2 4000 PVAL475
PVAL476 VARCHAR2 4000 PVAL476
PVAL477 VARCHAR2 4000 PVAL477
PVAL478 VARCHAR2 4000 PVAL478
PVAL479 VARCHAR2 4000 PVAL479
PVAL480 VARCHAR2 4000 PVAL480
PVAL481 VARCHAR2 4000 PVAL481
PVAL482 VARCHAR2 4000 PVAL482
PVAL483 VARCHAR2 4000 PVAL483
PVAL484 VARCHAR2 4000 PVAL484
PVAL485 VARCHAR2 4000 PVAL485
PVAL486 VARCHAR2 4000 PVAL486
PVAL487 VARCHAR2 4000 PVAL487
PVAL488 VARCHAR2 4000 PVAL488
PVAL489 VARCHAR2 4000 PVAL489
PVAL490 VARCHAR2 4000 PVAL490
PVAL491 VARCHAR2 4000 PVAL491
PVAL492 VARCHAR2 4000 PVAL492
PVAL493 VARCHAR2 4000 PVAL493
PVAL494 VARCHAR2 4000 PVAL494
PVAL495 VARCHAR2 4000 PVAL495
PVAL496 VARCHAR2 4000 PVAL496
PVAL497 VARCHAR2 4000 PVAL497
PVAL498 VARCHAR2 4000 PVAL498
PVAL499 VARCHAR2 4000 PVAL499
PVAL500 VARCHAR2 4000 PVAL500
PDATE001 DATE PDATE001
PDATE002 DATE PDATE002
PDATE003 DATE PDATE003
PDATE004 DATE PDATE004
PDATE005 DATE PDATE005
PDATE006 DATE PDATE006
PDATE007 DATE PDATE007
PDATE008 DATE PDATE008
PDATE009 DATE PDATE009
PDATE010 DATE PDATE010
PDATE011 DATE PDATE011
PDATE012 DATE PDATE012
PDATE013 DATE PDATE013
PDATE014 DATE PDATE014
PDATE015 DATE PDATE015
PDATE016 DATE PDATE016
PDATE017 DATE PDATE017
PDATE018 DATE PDATE018
PDATE019 DATE PDATE019
PDATE020 DATE PDATE020
PDATE021 DATE PDATE021
PDATE022 DATE PDATE022
PDATE023 DATE PDATE023
PDATE024 DATE PDATE024
PDATE025 DATE PDATE025
PDATE026 DATE PDATE026
PDATE027 DATE PDATE027
PDATE028 DATE PDATE028
PDATE029 DATE PDATE029
PDATE030 DATE PDATE030
PDATE031 DATE PDATE031
PDATE032 DATE PDATE032
PDATE033 DATE PDATE033
PDATE034 DATE PDATE034
PDATE035 DATE PDATE035
PDATE036 DATE PDATE036
PDATE037 DATE PDATE037
PDATE038 DATE PDATE038
PDATE039 DATE PDATE039
PDATE040 DATE PDATE040
PDATE041 DATE PDATE041
PDATE042 DATE PDATE042
PDATE043 DATE PDATE043
PDATE044 DATE PDATE044
PDATE045 DATE PDATE045
PDATE046 DATE PDATE046
PDATE047 DATE PDATE047
PDATE048 DATE PDATE048
PDATE049 DATE PDATE049
PDATE050 DATE PDATE050
PDATE051 DATE PDATE051
PDATE052 DATE PDATE052
PDATE053 DATE PDATE053
PDATE054 DATE PDATE054
PDATE055 DATE PDATE055
PDATE056 DATE PDATE056
PDATE057 DATE PDATE057
PDATE058 DATE PDATE058
PDATE059 DATE PDATE059
PDATE060 DATE PDATE060
PDATE061 DATE PDATE061
PDATE062 DATE PDATE062
PDATE063 DATE PDATE063
PDATE064 DATE PDATE064
PDATE065 DATE PDATE065
PDATE066 DATE PDATE066
PDATE067 DATE PDATE067
PDATE068 DATE PDATE068
PDATE069 DATE PDATE069
PDATE070 DATE PDATE070
PDATE071 DATE PDATE071
PDATE072 DATE PDATE072
PDATE073 DATE PDATE073
PDATE074 DATE PDATE074
PDATE075 DATE PDATE075
PDATE076 DATE PDATE076
PDATE077 DATE PDATE077
PDATE078 DATE PDATE078
PDATE079 DATE PDATE079
PDATE080 DATE PDATE080
PDATE081 DATE PDATE081
PDATE082 DATE PDATE082
PDATE083 DATE PDATE083
PDATE084 DATE PDATE084
PDATE085 DATE PDATE085
PDATE086 DATE PDATE086
PDATE087 DATE PDATE087
PDATE088 DATE PDATE088
PDATE089 DATE PDATE089
PDATE090 DATE PDATE090
PDATE091 DATE PDATE091
PDATE092 DATE PDATE092
PDATE093 DATE PDATE093
PDATE094 DATE PDATE094
PDATE095 DATE PDATE095
PDATE096 DATE PDATE096
PDATE097 DATE PDATE097
PDATE098 DATE PDATE098
PDATE099 DATE PDATE099
PDATE100 DATE PDATE100
PTIMESTAMP001 TIMESTAMP PTIMESTAMP001
PTIMESTAMP002 TIMESTAMP PTIMESTAMP002
PTIMESTAMP003 TIMESTAMP PTIMESTAMP003
PTIMESTAMP004 TIMESTAMP PTIMESTAMP004
PTIMESTAMP005 TIMESTAMP PTIMESTAMP005
PTIMESTAMP006 TIMESTAMP PTIMESTAMP006
PTIMESTAMP007 TIMESTAMP PTIMESTAMP007
PTIMESTAMP008 TIMESTAMP PTIMESTAMP008
PTIMESTAMP009 TIMESTAMP PTIMESTAMP009
PTIMESTAMP010 TIMESTAMP PTIMESTAMP010
PTIMESTAMP011 TIMESTAMP PTIMESTAMP011
PTIMESTAMP012 TIMESTAMP PTIMESTAMP012
PTIMESTAMP013 TIMESTAMP PTIMESTAMP013
PTIMESTAMP014 TIMESTAMP PTIMESTAMP014
PTIMESTAMP015 TIMESTAMP PTIMESTAMP015
PTIMESTAMP016 TIMESTAMP PTIMESTAMP016
PTIMESTAMP017 TIMESTAMP PTIMESTAMP017
PTIMESTAMP018 TIMESTAMP PTIMESTAMP018
PTIMESTAMP019 TIMESTAMP PTIMESTAMP019
PTIMESTAMP020 TIMESTAMP PTIMESTAMP020
SOURCE_REFERENCE001 VARCHAR2 200 SOURCE_REFERENCE001
SOURCE_REFERENCE002 VARCHAR2 200 SOURCE_REFERENCE002
SOURCE_REFERENCE003 VARCHAR2 200 SOURCE_REFERENCE003
SOURCE_REFERENCE004 VARCHAR2 200 SOURCE_REFERENCE004
SOURCE_REFERENCE005 VARCHAR2 200 SOURCE_REFERENCE005
SOURCE_REFERENCE006 VARCHAR2 200 SOURCE_REFERENCE006
SOURCE_REFERENCE007 VARCHAR2 200 SOURCE_REFERENCE007
SOURCE_REFERENCE008 VARCHAR2 200 SOURCE_REFERENCE008
SOURCE_REFERENCE009 VARCHAR2 200 SOURCE_REFERENCE009
SOURCE_REFERENCE010 VARCHAR2 200 SOURCE_REFERENCE010
PVAL_SECURE001 VARCHAR2 4000 PVAL_SECURE001
PVAL_SECURE002 VARCHAR2 4000 PVAL_SECURE002
PVAL_SECURE003 VARCHAR2 4000 PVAL_SECURE003
PVAL_SECURE004 VARCHAR2 4000 PVAL_SECURE004
PVAL_SECURE005 VARCHAR2 4000 PVAL_SECURE005
PVAL_SECURE006 VARCHAR2 4000 PVAL_SECURE006
PVAL_SECURE007 VARCHAR2 4000 PVAL_SECURE007
PVAL_SECURE008 VARCHAR2 4000 PVAL_SECURE008
PVAL_SECURE009 VARCHAR2 4000 PVAL_SECURE009
PVAL_SECURE010 VARCHAR2 4000 PVAL_SECURE010
PVAL_SECURE011 VARCHAR2 4000 PVAL_SECURE011
PVAL_SECURE012 VARCHAR2 4000 PVAL_SECURE012
PVAL_SECURE013 VARCHAR2 4000 PVAL_SECURE013
PVAL_SECURE014 VARCHAR2 4000 PVAL_SECURE014
PVAL_SECURE015 VARCHAR2 4000 PVAL_SECURE015
PVAL_SECURE016 VARCHAR2 4000 PVAL_SECURE016
PVAL_SECURE017 VARCHAR2 4000 PVAL_SECURE017
PVAL_SECURE018 VARCHAR2 4000 PVAL_SECURE018
PVAL_SECURE019 VARCHAR2 4000 PVAL_SECURE019
PVAL_SECURE020 VARCHAR2 4000 PVAL_SECURE020
PVAL_SECURE021 VARCHAR2 4000 PVAL_SECURE021
PVAL_SECURE022 VARCHAR2 4000 PVAL_SECURE022
PVAL_SECURE023 VARCHAR2 4000 PVAL_SECURE023
PVAL_SECURE024 VARCHAR2 4000 PVAL_SECURE024
PVAL_SECURE025 VARCHAR2 4000 PVAL_SECURE025
PVAL_SECURE026 VARCHAR2 4000 PVAL_SECURE026
PVAL_SECURE027 VARCHAR2 4000 PVAL_SECURE027
PVAL_SECURE028 VARCHAR2 4000 PVAL_SECURE028
PVAL_SECURE029 VARCHAR2 4000 PVAL_SECURE029
PVAL_SECURE030 VARCHAR2 4000 PVAL_SECURE030
PVAL_SECURE031 VARCHAR2 4000 PVAL_SECURE031
PVAL_SECURE032 VARCHAR2 4000 PVAL_SECURE032
PVAL_SECURE033 VARCHAR2 4000 PVAL_SECURE033
PVAL_SECURE034 VARCHAR2 4000 PVAL_SECURE034
PVAL_SECURE035 VARCHAR2 4000 PVAL_SECURE035
PVAL_SECURE036 VARCHAR2 4000 PVAL_SECURE036
PVAL_SECURE037 VARCHAR2 4000 PVAL_SECURE037
PVAL_SECURE038 VARCHAR2 4000 PVAL_SECURE038
PVAL_SECURE039 VARCHAR2 4000 PVAL_SECURE039
PVAL_SECURE040 VARCHAR2 4000 PVAL_SECURE040
PVAL_SECURE041 VARCHAR2 4000 PVAL_SECURE041
PVAL_SECURE042 VARCHAR2 4000 PVAL_SECURE042
PVAL_SECURE043 VARCHAR2 4000 PVAL_SECURE043
PVAL_SECURE044 VARCHAR2 4000 PVAL_SECURE044
PVAL_SECURE045 VARCHAR2 4000 PVAL_SECURE045
PVAL_SECURE046 VARCHAR2 4000 PVAL_SECURE046
PVAL_SECURE047 VARCHAR2 4000 PVAL_SECURE047
PVAL_SECURE048 VARCHAR2 4000 PVAL_SECURE048
PVAL_SECURE049 VARCHAR2 4000 PVAL_SECURE049
PVAL_SECURE050 VARCHAR2 4000 PVAL_SECURE050
PDATE_SECURE001 DATE PDATE_SECURE001
PDATE_SECURE002 DATE PDATE_SECURE002
PDATE_SECURE003 DATE PDATE_SECURE003
PDATE_SECURE004 DATE PDATE_SECURE004
PDATE_SECURE005 DATE PDATE_SECURE005
PDATE_SECURE006 DATE PDATE_SECURE006
PDATE_SECURE007 DATE PDATE_SECURE007
PDATE_SECURE008 DATE PDATE_SECURE008
PDATE_SECURE009 DATE PDATE_SECURE009
PDATE_SECURE010 DATE PDATE_SECURE010
PDATE_SECURE011 DATE PDATE_SECURE011
PDATE_SECURE012 DATE PDATE_SECURE012
PDATE_SECURE013 DATE PDATE_SECURE013
PDATE_SECURE014 DATE PDATE_SECURE014
PDATE_SECURE015 DATE PDATE_SECURE015
PDATE_SECURE016 DATE PDATE_SECURE016
PDATE_SECURE017 DATE PDATE_SECURE017
PDATE_SECURE018 DATE PDATE_SECURE018
PDATE_SECURE019 DATE PDATE_SECURE019
PDATE_SECURE020 DATE PDATE_SECURE020
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REP_FIRST_EFFECTIVE_START_DATE VARCHAR2 1 Flag will be "Y" if current Effective Start Date can be Logical Start Date.
REP_LAST_EFFECTIVE_END_DATE VARCHAR2 1 Flag will be "Y" if current Effective End Date can be Logical End Date.
PTIMESTAMP_SECURE001 TIMESTAMP PTIMESTAMP_SECURE001
PTIMESTAMP_SECURE002 TIMESTAMP PTIMESTAMP_SECURE002
PTIMESTAMP_SECURE003 TIMESTAMP PTIMESTAMP_SECURE003
PTIMESTAMP_SECURE004 TIMESTAMP PTIMESTAMP_SECURE004
PTIMESTAMP_SECURE005 TIMESTAMP PTIMESTAMP_SECURE005

Foreign Keys

Table Foreign Table Foreign Key Column
HRC_DL_ROLLBACK_PHY_LINES hrc_dl_data_set_bus_objs DATA_SET_BUS_OBJ_ID
HRC_DL_ROLLBACK_PHY_LINES hrc_dl_logical_lines LOGICAL_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
HRC_DL_ROLLBACK_PHY_LINES_N1 Non Unique Default LOGICAL_LINE_ID
HRC_DL_ROLLBACK_PHY_LINES_N2 Non Unique Default DATA_SET_BUS_OBJ_ID
HRC_DL_ROLLBACK_PHY_LINES_PK Unique Default PHYSICAL_LINE_ID