PSC_INS_INSPECTION

Details

Schema: FUSION
Object owner: PSC_PER
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_INS_INSPECTION_CHKLIST_PK	INSPECTION_CHKLIST_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
INSPECTION_CHKLIST_KEY	NUMBER		18	Yes	The unique indentifier for an inspection check list.
INSPECTION_CHKLIST_PUID	VARCHAR2	480		Yes	Alternate key field used by CRM Import.
INSPECTION_KEY	NUMBER		18	Yes	The unique indentifier for an inspection.
INSPECTION_PUID	VARCHAR2	480		Yes	PUID is a unique Identifier for the parent inspection record. Used by CRM Import.
INSPECTION_ID	VARCHAR2	50		Yes	This column is used to indicate inspection id	Active
CHECKLIST_ID	VARCHAR2	15		Yes	This column is used to indicate checklist id	Active
CHECKLIST_NAME	VARCHAR2	100		Yes	This column is used to indicate checklist name	Active
REQUIRED_FLAG	VARCHAR2	1			Data on this field is copied from the checklist setup table (PSC_INS_CHECKLIST)
POSSIBLE_SCORE	NUMBER		5		Data on this field is copied from the checklist setup table (PSC_INS_CHECKLIST. SCORE)
MAJOR_VIOLATION_FLAG	VARCHAR2	1			Data on this field is copied from the checklist setup table (PSC_INS_CHECKLIST)
MAX_SCORE	NUMBER		5		This column is used to indicate max score	Active
MIN_PASSING_SCORE	NUMBER		5		This column is used to indicate min passing score	Active
ASSESSMENT_TYPE	VARCHAR2	15			This column is used to indicate assessment type	Active
SCORING_METHOD	VARCHAR2	15			This column is used to indicate scoring method	Active
COMMON_COMMENT	VARCHAR2	1000			This column is used to indicate common comment	Active
CHECKLIST_RESULT	VARCHAR2	15			This column is used to indicate checklist result	Active
CHECKLIST_SCORE	NUMBER		5		This column is used to indicate checklist score	Active
NUM_MAJOR_VIOLATIONS	NUMBER		5		This column is used to indicate num major violations	Active
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.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
AGENCY_ID	NUMBER		8	Yes	This column is used to indicate agency id	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_INS_INSPECTION_CHKLIST	psc_ins_inspection	INSPECTION_KEY
psc_ins_attachment	psc_ins_inspection_chklist	INSPECTION_CHKLIST_KEY
psc_ins_inspection_cl_item	psc_ins_inspection_chklist	INSPECTION_CHKLIST_KEY
psc_ins_comment	psc_ins_inspection_chklist	INSPECTION_CHKLIST_KEY

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_INS_INSPECTION_CHKLIST_FK1	Non Unique	Default	INSPECTION_KEY	Active
PSC_INS_INSPECTION_CHKLIST_PK	Unique	Default	INSPECTION_CHKLIST_KEY
PSC_INS_INSPECTION_CHKLIST_UK1	Unique	Default	AGENCY_ID, INSPECTION_ID, CHECKLIST_ID
PSC_INS_INSPECTION_CHKLIST_UK2	Unique	Default	INSPECTION_CHKLIST_PUID