PSC_LNP_CNTR_LIC_INS

Details

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

Primary Key

Name	Columns
PSC_LNP_CNTR_LIC_INS_H_PK	LNP_LICENSE_INS_HIST_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LNP_LICENSE_INS_HIST_KEY	NUMBER		18	Yes	Auto generated number used uniquely to identify the license insurance transaction history.
LNP_LICENSE_HIST_KEY	NUMBER		18	Yes	Auto generated number used uniquely to identify the license transaction history.
LNP_LICENSE_INS_KEY	NUMBER		18	Yes	Indicates unique identifier of the license for the transaction.
LNP_RECORD_KEY	NUMBER		18	Yes	Unique identifier for the related transaction.
LNP_RECORD_ID	VARCHAR2	50		Yes	Indicates the meaningful transaction identifier.
LNP_LICENSE_KEY	NUMBER		18	Yes	Indicates unique identifier of the license transaction.
LICENSE_KEY	NUMBER		18		Indicates unique identifier of the license.
LICENSE_INSURANCE_KEY	NUMBER		18		Auto generated number used uniquely to identify the license.
INSURANCE_FACT_REC	VARCHAR2	30			Indicates type of insurance associated with state license.
INSURANCE_TYPE	VARCHAR2	360			Type of insurance on license.
LIC_QUALIFIER_NAME	VARCHAR2	360			Name of qualifying individual on bond.
LIC_QUALIFIER_NAME_TYPE	VARCHAR2	20			Type of qualifier bond on bond.
LICENSE_PERCENTAGE	NUMBER		6		Percentage of voting stock in company.
INSURER_CODE	VARCHAR2	30			Code associated with insurer on license.
INSURER_NAME	VARCHAR2	360			Name of insurer on contractor license.
INSURER_POLICY_NO	VARCHAR2	30			Policy number issued by insurer on license.
INSURER_AMT	NUMBER				Coverage amount on bond or policy on the license.
ISSUE_DATE	DATE				Issue date of Policy or Bond on the license.
EXPIRE_DATE	DATE				Expiry date of Policy or Bond on the license.
CANCEL_DATE	DATE				Cancellation date of Policy or Bond on the license.
RENEWAL_DATE	DATE				Renewal date of Policy or Bond on the license.
SUSPEND_DATE	DATE				Suspension date of Policy or Bond on the license.
INTENT_TO_SUSPEND_DATE	DATE				Intent to suspend policy notice date.
INSURER_LINK	VARCHAR2	500			Additional URL link to drill into insurer details.
EXEMPT	VARCHAR2	30			Indicates whether the contractor is exempt for workers compensation insurance.
EXEMPTDESC	VARCHAR2	500			Description of worker’s compensation exemption.
EXEMPTLONGDESC	CLOB				Long description of worker's compensation exemption.
INTEGRATION_SOURCE	VARCHAR2	30			Identifies 3rd party integration.
INT_LAST_UPD_DT	DATE				Date last updated by 3rd party’s system.
LICENSE_SETUP_CODE	VARCHAR2	30			Setup code identifying segments usages on the license.
LICENSE_TYPE	VARCHAR2	30			Identifies the type of license issued.
LICENSE_NUMBER	VARCHAR2	50			Identifies the license number issued by the government.
LNP_LICENSE_INS_PUID	VARCHAR2	480		Yes	PUID for record. Alternate key used by CRM Import.
MIGRATED_DATA_FLAG	VARCHAR2	3			Indicates In-flight or Historical transaction for data migration.
LNP_LICENSE_PUID	VARCHAR2	480		Yes	Parent PUID. Alternate key used by CRM Import.
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.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_LNP_CNTR_LIC_INS_H	psc_lnp_cntr_lic_h	LNP_LICENSE_HIST_KEY

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_LNP_CNTR_LIC_INS_H_N1	Non Unique	Default	LNP_RECORD_KEY
PSC_LNP_CNTR_LIC_INS_H_U1	Unique	Default	LNP_LICENSE_INS_HIST_KEY