Table slot9.WORLD.TSTA.DS_ICR_INCIDENT_ERRORS
This table stores Incident Errors when processing for DS_ICR and DS_NIBR
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID Implied Constraint R
CORRESPONDS TO INCIDENT ID IN INCIDENTS TABLE
DATASETID number 0
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
CORRESPONDS TO DATASETID IN DS_ICR_DATA_SETS TABLE
ERROR_ID number 0
ERROR_CODES.ERROR_ID Implied Constraint R
CORRESPONDS TO ERROR_ID IN ERROR_CODES TABLE
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICR_IE_DATASETID_NN
"ERROR_ID" IS NOT NULL DSICR_IE_ERROR_ID_NN
"INCIDENT_ID" IS NOT NULL DSICR_IE_INCIDENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INCIDENT_ID + DATASETID + ERROR_ID Primary key Asc/Asc/Asc DSICR_IE_PK

Close relationships: