1. Tables and Views
  2. PSC_COM_CONDITION_LIST

PSC_COM_CONDITION_LIST

This table contains condition list information.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_COM_CONDITION_LIST_PK

CONDITION_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
CONDITION_KEY NUMBER 18 Yes This column is used to indicate condition key Active
OBJECT_TYPE VARCHAR2 3 Yes This column is used to indicate object type Active
OBJECT_SUB_TYPE VARCHAR2 3 Yes This column is used to indicate object sub type Active
OBJECT_KEY_NUM_VALUE1 NUMBER 18 This column is used to indicate object key num value1 Active
OBJECT_KEY_NUM_VALUE2 NUMBER 18 This column is used to indicate object key num value2 Active
OBJECT_KEY_NUM_VALUE3 NUMBER 18 This column is used to indicate object key num value3 Active
OBJECT_KEY_NUM_VALUE4 NUMBER 18 This column is used to indicate object key num value4 Active
OBJECT_KEY_NUM_VALUE5 NUMBER 18 This column is used to indicate object key num value5 Active
OBJECT_KEY_GEN_VALUE1 VARCHAR2 50 This column is used to indicate object key gen value1 Active
OBJECT_KEY_GEN_VALUE2 VARCHAR2 50 This column is used to indicate object key gen value2 Active
OBJECT_KEY_GEN_VALUE3 VARCHAR2 50 This column is used to indicate object key gen value3 Active
OBJECT_KEY_GEN_VALUE4 VARCHAR2 50 This column is used to indicate object key gen value4 Active
OBJECT_KEY_GEN_VALUE5 VARCHAR2 50 This column is used to indicate object key gen value5 Active
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency id Active
CONDITION_NAME VARCHAR2 50 Yes This column is used to indicate condition name Active
STATUS VARCHAR2 1 Yes This column is used to indicate status Active
PRIORITY NUMBER 1 This column is used to indicate priority Active
RESOLUTION_ACTION VARCHAR2 500 This column is used to indicate resolution action Active
ADDITIONAL_INFO VARCHAR2 500 This column is used to indicate additional info Active
APPLIED_DATE TIMESTAMP This column is used to indicate applied date Active
APPLIED_BY VARCHAR2 64 This column is used to indicate applied by Active
REMOVAL_DATE TIMESTAMP This column is used to indicate removal date Active
REMOVED_BY VARCHAR2 64 This column is used to indicate removed by Active
PARENT_CONDITION_KEY NUMBER 18 This column is used to indicate parent condition key 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
SEVERITY NUMBER 1 Yes This column is used to indicate Severity of the condition. Active
DESCRIPTION VARCHAR2 500 This column is used to indicate Description of the condition. Active
PUBLIC_FLAG VARCHAR2 1 This flag decides if the condition description needs to be displayed to the public. Active
INHERIT_FLAG VARCHAR2 1 This flag decides if this condition can be inherited. Active
APPLY_TO_IN_PROCESS_TRANS VARCHAR2 1 This field decides whether the transactions in process would need to inherit this condition.
RESOLVE_IN_PROCESS_TRANS VARCHAR2 1 This field decides whether the transactions in process would need to resolve the inherited conditions.
BR_PREVENT_NEW VARCHAR2 1 Prevent New business rule for Hold or Lock condition. Active
BR_PREVENT_WORKFLOW VARCHAR2 1 Prevent Workflow Advancing business rule for Hold or Lock condition. Active
BR_PREVENT_ISSUE VARCHAR2 1 Prevent Issue/Final business rule for Hold or Lock condition. Active
BR_PREVENT_RENEWAL VARCHAR2 1 Prevent Renewal business rule for Hold or Lock condition. Active
BR_PREVENT_INS_SCHED VARCHAR2 1 Prevent Inspection Schedule rule for Hold or Lock condition. Active
BR_PREVENT_INS_RESULT VARCHAR2 1 Prevent Resulting Inspection rule for Hold or Lock condition. Active
BR_RESTRICT_PAYMENT VARCHAR2 1 Restrict Payment business rule for Hold or Lock condition. Active
BR_PREVENT_FINAL_INS VARCHAR2 1 Prevent Scheduling and Resulting Inspection rule for Hold condition.
BR_PREVENT_FINAL VARCHAR2 1 Prevent Final business rule for Hold condition.
BR_PREVENT_AMENDMENT_FLAG VARCHAR2 1 (Y/N) Prevent Amendment business rule for Hold condition.
CONDITION_PUID VARCHAR2 480 Yes Indicates the PUID of conditions for data import.
PARENT_PUID VARCHAR2 480 Indicates parent PUID.
MIGRATED_DATA_FLAG VARCHAR2 3 This column is used to indicate migrated flag value.
REFERENCE_CLASSIFICATION VARCHAR2 30 This column used to store the reference classification.
REFERENCE_APPLICATION_ID VARCHAR2 50 This column used to store the reference application Id.
REFERENCE_KEY_NUM_VALUE1 NUMBER 18 First Key value of the Reference table.Use this in case reference transaction has number keys.
REFERENCE_KEY_NUM_VALUE2 NUMBER 18 Second Key value of the Reference table. Use this in case reference transaction has number keys.
REFERENCE_PUID VARCHAR2 480 Indicates reference PUID.

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_CONDITION_LIST_N1 Non Unique Default OBJECT_TYPE, OBJECT_KEY_NUM_VALUE1, OBJECT_KEY_NUM_VALUE2 Active
PSC_COM_CONDITION_LIST_PK Unique Default CONDITION_KEY Active
PSC_COM_CONDITION_LIST_U1 Unique Default CONDITION_PUID