PSC_COM_CONDITION

Details

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

Primary Key

Name	Columns
PSC_COM_CONDITION_B_PK	AGENCY_ID, CONDITION_NAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
AGENCY_ID	NUMBER		8	Yes	This column is used to indicate agency id	Active
CONDITION_NAME	VARCHAR2	50		Yes	A user entered condition name. This will be the unique identifier.	Active
OBJECT_TYPE	VARCHAR2	3		Yes	Categorize the condition based on the object type to which it is applied.	Active
SEVERITY	NUMBER		1	Yes	Severity of the condition. 1- Lock, 2- Hold, 3- Notice.	Active
ENABLED_FLAG	VARCHAR2	1		Yes	(Y/N) To logically delete a condition. If the flag is set to N, then this condition will not be considered for any future application.	Active
INHERIT_FLAG	VARCHAR2	1			(Y/N) Decides if this condition can be inherited. Default value is N.	Active
PRIORITY	NUMBER		1		Priority of the condition, set by the agency.
BR_PREVENT_NEW	VARCHAR2	1			(Y/N) Prevent New business rule for Hold condition.
BR_PREVENT_WORKFLOW	VARCHAR2	1			(Y/N) Prevent Workflow Advancing business rule for Hold condition.
BR_PREVENT_ISSUE	VARCHAR2	1			(Y/N) Prevent Issue/Final business rule for Hold condition.
BR_PREVENT_FINAL	VARCHAR2	1			BR_PREVENT_FINAL
BR_PREVENT_RENEWAL	VARCHAR2	1			(Y/N) Prevent Renewal business rule for Hold condition.
BR_PREVENT_INS_SCHED	VARCHAR2	1			(Y/N) Prevent Inspection Schedule rule for Hold condition.
BR_PREVENT_INS_RESULT	VARCHAR2	1			(Y/N) Prevent Resulting Inspection rule for Hold condition.
BR_RESTRICT_PAYMENT	VARCHAR2	1			(Y/N) Restrict Payment business rule for Hold condition.
BR_PREVENT_FINAL_INS	VARCHAR2	1			(Y/N) Prevent Scheduling and Resulting Inspection rule for Hold condition.
BR_PREVENT_AMENDMENT_FLAG	VARCHAR2	1			(Y/N) Prevent Amendment business rule for Hold condition.
PARCEL_IMPORT_UPDATE_FLAG	VARCHAR2	1			(Y/N) Indicate whether condition is allowed to be updated by parcel import process.
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
MODULE_ID	VARCHAR2	32			Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
psc_com_condition_tl	psc_com_condition_b	AGENCY_ID, CONDITION_NAME

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_COM_CONDITION_B_PK	Unique	Default	AGENCY_ID, CONDITION_NAME	Active