1. Tables and Views
  2. PSC_LNP_CNTRCTR_LIC

PSC_LNP_CNTRCTR_LIC

This table contains transaction contractor license detail pertaining to the license number.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_LNP_CNTRCTR_LIC_PK

LNP_LICENSE_KEY

Columns

Name Datatype Length Precision Not-null Comments
LNP_LICENSE_KEY NUMBER 18 Yes Auto generated number used uniquely to identify the license on the transaction.
LNP_LICENSE_PUID VARCHAR2 480 Yes PUID for record. Alternate key used by CRM Import.
LNP_RECORD_KEY NUMBER 18 Yes Unique identifier for the related transaction.
LNP_RECORD_ID VARCHAR2 50 Yes Indicates the meaningful transaction identifier.
RECORD_NUMBER VARCHAR2 64 Yes PUID for permit record. Used by CRM Import.
LICENSE_KEY NUMBER 18 Auto generated number used uniquely to identify the license.
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.
SYNC_TYPE VARCHAR2 30 Defines the sync type of contractor license.
LICENSE_LMF_PRE VARCHAR2 10 Suffix associated with the contractor HIS license number.
LICENSE_NUMBER2 VARCHAR2 50 Identifies the number portion of the contractor license.
SOURCE_STATUS VARCHAR2 100 License status as listed in the source.
SUBJECT_ID VARCHAR2 30 Attribute used to identify where the data should be displayed.
NAME VARCHAR2 360 Name on the contractor's license.
DBA VARCHAR2 360 Name the contractor is doing business as.
OWNER VARCHAR2 360 Owner name(s) on the contractor's license.
ADDRESS1 VARCHAR2 240 First address line on contractor's license.
ADDRESS2 VARCHAR2 240 Second address line on contractor's license.
ADDRESS3 VARCHAR2 240 Third address line on contractor's license.
ADDRESS4 VARCHAR2 240 Fourth address line on contractor's license.
CITY VARCHAR2 60 Name of City on contractor's license.
STATE VARCHAR2 60 Name of State on contractor's license.
COUNTRY VARCHAR2 60 Name of Country on contractor's license.
POSTAL_CODE VARCHAR2 60 Postal code on contractor?s license.
COUNTY VARCHAR2 60 Name of county on contractor's license.
PROVINCE VARCHAR2 60 Name of province on contractor's license.
POSTAL_PLUS4_CODE VARCHAR2 60 Postal code on contractor's license.
PHONE_COUNTRY_CODE VARCHAR2 10 Phone country code on the contractor's license.
PHONE_AREA_CODE VARCHAR2 10 Phone Area Code on the contractor's license.
PHONE_NUMBER VARCHAR2 40 Phone number on the contractor's license.
PHONE_EXTENSION VARCHAR2 20 Phone extension on the contractor's license.
ENTITY VARCHAR2 30 Entity identified on the contractor's license.
ISSUE_DATE DATE Date contractor's license was issued or in effect.
REISSUE_DATE DATE Reissue date of contractor's license.
EXPIRE_DATE DATE Expiration date of contractor's license.
REACTIVATE_DATE DATE Reissue or renewal date of contractor's license.
INACTIVE_DATE DATE Date contractor's license was inactivated.
SUSPEND_DATE DATE First date of contract's license suspension.
COMPLAINT_DISCLOURE_IND VARCHAR2 1 Indicates whether a complaint has been disclosed against license.
EMAIL_ADDRESS VARCHAR2 320 Email address on contractor's license.
AGENCY_ID NUMBER Identifies the agency id this transaction belongs to.
INTEGRATION_SOURCE VARCHAR2 30 Identifies 3rd party integration.
INT_LAST_UPDATE_BY VARCHAR2 64 Indicates the user who updated record with 3rd party integration data.
INT_LAST_UPDATE_DT DATE Indicates date the last user updated with 3rd party integration data.
APPLICANT_IS_AUTH_AGENT_FLAG VARCHAR2 1 Yes Indicates applicant is the authorized agent for a contractor license.
INTERNAL_LICENSE_STATUS VARCHAR2 30 Internally assigned status by the agent on the license.
INT_STATUS_LAST_UPDATE_BY VARCHAR2 64 Indicates the user who updated the internal license status.
INT_STATUS_LAST_UPDATE_DT DATE Indicates date when the user updated the internal license status.
LICENSE_SYNC_DATE TIMESTAMP Indicates the date and time the license was sync to Contractor License File.
CONTRACTOR_IN_USE VARCHAR2 1 Yes Indicates if contractor is used for the application.
IN_USE_LAST_UPDATE_DATE DATE Indicates the date when the contractor's In Use status was last updated.
IN_USE_LAST_UPDATE_BY VARCHAR2 64 Indicates the user who last updated contractor's In Use status.
ADDED_AFTER_SUBMIT VARCHAR2 1 Indicates that contractor license was added after application submit.
MIGRATED_DATA_FLAG VARCHAR2 3 Indicates In-flight or Historical transaction for data migration.
LICENSE_CATEGORY VARCHAR2 30 Identifies the type of license issued.
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_CNTRCTR_LIC psc_lnp_record LNP_RECORD_KEY
PSC_LNP_CNTRCTR_LIC psc_lnp_record RECORD_NUMBER
psc_lnp_cntrctr_lic_ins psc_lnp_cntrctr_lic LNP_LICENSE_KEY
psc_lnp_cntrctr_lic_ins psc_lnp_cntrctr_lic LNP_LICENSE_PUID
psc_lnp_cntrctr_lic_fact psc_lnp_cntrctr_lic LNP_LICENSE_KEY
psc_lnp_cntrctr_lic_fact psc_lnp_cntrctr_lic LNP_LICENSE_PUID

Indexes

Index Uniqueness Tablespace Columns
PSC_LNP_CNTRCTR_LIC_N1 Non Unique Default LICENSE_SETUP_CODE, LICENSE_TYPE, LICENSE_NUMBER
PSC_LNP_CNTRCTR_LIC_N2 Non Unique Default LNP_RECORD_KEY
PSC_LNP_CNTRCTR_LIC_U1 Unique Default LNP_LICENSE_KEY
PSC_LNP_CNTRCTR_LIC_U2 Unique Default LNP_LICENSE_PUID