FINDING

2643 rows


Description

This is a table for Finding. Stores Inspection findings.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FINDING_ID NUMBER 18 null
FINDING_LEGAL_REQUIREMENT.FINDING_ID FINDING_LEGAL_REQUIREMENT_FK2R
NEW_STAT_COUNT_BASE.FINDING_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_1.FINDING_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_2.FINDING_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_3.FINDING_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_4.FINDING_ID Implied ConstraintR
VIEW_FINDING_AUX.FINDING_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.FINDING_ID Implied ConstraintR
VIEW_STATISTICS_ALL_P.FINDING_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.FINDING_ID Implied ConstraintR

Field Finding ID. Stores primary key for this table.

COMENT VARCHAR2 4000 null

Field Coment. Stores the description of the finding.

ENUM_FINDING_TYPE_ID NUMBER 18 null
ENUM_FINDING_TYPE.ENUM_FINDING_TYPE_ID FINDING_ENUM_FINDING_TYPE_FK1R

Field Enumeration Finding Type ID. Stores type of the finding, foreign key to table enum_finding_type of this record.

CORRECTED NUMBER 1 null

Field Corrected. Stores if this finding was already corrected or not.

CORRECTIVE_ACTIONS VARCHAR2 4000 null

Field Corrective Actions. Stores wich actions are taken to correct this finding.

MEASURE VARCHAR2 4000 null

Field Measure. Stores the measures taken.

DEADLINE TIMESTAMP(6) 11,6 null

Field Deadline. Stores the deadline to have this finding corrected.

SECTION_REPORT VARCHAR2 1000 null

Field Section Report. Stores the section in report of this finding.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID FINDING_ENUM_STATUS_FK1R

Field Status. Stores the status of the record, foreign key to table enum_status.

VERSION_ID NUMBER 18 0

Field Version. Stores the version of the record.

CUSER VARCHAR2 75 null

Field Create User. Stores who create the record.

CDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Create Date. Stores when the record was created.

MDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Modified Date. Stores when the record was modified.

MUSER VARCHAR2 75 null

Field Modified User. Stores who modified the record.

LEGAL_REQUIREMENT_PROCESS_ID NUMBER 0 null
LEGAL_REQUIREMENT_PROCESS.LEGAL_REQUIREMENT_PROCESS_ID FINDING_PROCESS_L_REQ_FK1R

Field Legal Requirement Process ID. Stores the legal requirement in the process where this finding occurs, foreign key to table legal_requirement_process of this record.

INSPECTION_LEGAL_ENTITY_ID NUMBER 18 0
INSPECTION_LEGAL_ENTITY.INSPECTION_LEGAL_ENTITY_ID FINDING_INSP_L_ENTITY_FKR

Field Inspection Legal Entity ID. Stores in wich inspection of a entity this finding occurs, foreign key to table legal_requirement_process of this record.

Indexes

Constraint Name Type Sort Column(s)
REPORT_FINDINGS_PK Primary key Asc FINDING_ID
FINDING_FINDING_TYPE_ID_IDX Performance Asc ENUM_FINDING_TYPE_ID
FINDING_STATUS_ID_IDX Performance Asc ENUM_STATUS_ID

Relationships