VIEW_FINDING_AUX

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
INSPECTION_ID NUMBER 18 null
INSPECTION.INSPECTION_ID Implied ConstraintR
LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID Implied ConstraintR
LEGAL_REQUIREMENT_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID Implied ConstraintR
FINDING_ID NUMBER 18 null
FINDING.FINDING_ID Implied ConstraintR
FINDING_CORRECTED NUMBER 1 null
FINDING_COMMENT VARCHAR2 4000 null
SECTION_REPORT VARCHAR2 1000 null
FINDING_TYPE_ID NUMBER 0 null
FINDING_TYPE_NAME VARCHAR2 500 null
PROCESS_ID NUMBER 18 null
PROCESS.PROCESS_ID Implied ConstraintR
PROCESS_NAME VARCHAR2 1000 null
COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID Implied ConstraintR
COUNTRY_NAME VARCHAR2 250 null
COUNTRY_GROUP_ID NUMBER 18 null
COUNTRY_GROUP_NAME VARCHAR2 500 null
LEGAL_ENTITY_NAME VARCHAR2 1000 null
LEGAL_ENTITY_TYPE_ID NUMBER 18 null
LEGAL_ENTITY_TYPE_NAME VARCHAR2 500 null
INSPECTION_START_DATE DATE 7 null
INSPECTION_END_DATE DATE 7 null

Relationships

View Definition