1. Tables and Views
  2. PSC_LNP_CONTACT_LIST

PSC_LNP_CONTACT_LIST

This table contains license and permit transaction contact list.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_LNP_CONTACT_LIST_PK

CONTACT_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
CONTACT_KEY NUMBER 18 Yes This column is used to indicate contact key Active
PREVIOUS_APPLICANT_FLAG VARCHAR2 1 Yes Indicates the contact person is a previous applicant.
MAKE_APPLICANT_DATE DATE Date when the contact was made applicant.
MAKE_APPLICANT_BY VARCHAR2 64 User who made contact as applicant.
LNP_RECORD_KEY NUMBER 18 Yes This column is used to indicate lnp record key Active
LNP_RECORD_ID VARCHAR2 50 Yes This column is used to indicate lnp record id Active
CONTACT_TYPE VARCHAR2 30 Yes This column is used to indicate contact type Active
OWNER_TABLE_NAME VARCHAR2 30 Yes This column is used to indicate owner table record name such as psc_lnp_record,psc_com_re_record
FAX_NUMBER VARCHAR2 40 This column is used to indicate fax number
PRIMARY_FLAG VARCHAR2 1 This column is used to indicate primary flag Active
CONTACT_PARTY_ID NUMBER 18 This column is used to indicate contact party id Active
CONTACT_BIZ_PARTY_ID NUMBER 18 This column is used to indicate contact biz party id Active
PERSON_PRE_NAME_ADJUNCT VARCHAR2 30 This column is used to indicate person pre name adjunct Active
PERSON_FIRST_NAME VARCHAR2 150 This column is used to indicate person first name Active
PERSON_MIDDLE_NAME VARCHAR2 60 This column is used to indicate person middle name Active
PERSON_LAST_NAME VARCHAR2 150 This column is used to indicate person last name Active
PERSON_NAME_SUFFIX VARCHAR2 30 This column is used to indicate person name suffix Active
PERSON_TITLE VARCHAR2 60 This column is used to indicate person title Active
DATE_OF_BIRTH DATE This column is used to indicate date of birth Active
PERSON_NAME VARCHAR2 450 This column is used to indicate person name Active
GENDER VARCHAR2 30 This column is used to indicate gender Active
ORGANIZATION_NAME VARCHAR2 360 This column is used to indicate organization name Active
EMAIL_ADDRESS1 VARCHAR2 320 This column is used to indicate email address1 Active
PHONE_NUMBER VARCHAR2 40 This column is used to indicate phone number Active
COUNTRY VARCHAR2 3 This column is used to indicate country Active
ADDRESS1 VARCHAR2 240 This column is used to indicate address1 Active
ADDRESS2 VARCHAR2 240 This column is used to indicate address2 Active
ADDRESS3 VARCHAR2 240 This column is used to indicate address3 Active
ADDRESS4 VARCHAR2 240 This column is used to indicate address4 Active
CITY VARCHAR2 60 This column is used to indicate city Active
STATE VARCHAR2 60 This column is used to indicate state Active
PROVINCE VARCHAR2 60 This column is used to indicate province Active
COUNTY VARCHAR2 60 This column is used to indicate county Active
POSTAL_CODE VARCHAR2 60 This column is used to indicate postal code Active
POSTAL_PLUS4_CODE VARCHAR2 10 This column is used to indicate postal plus4 code 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
PHONE_COUNTRY_CODE VARCHAR2 10 International country code for a telephone number. For example, 33 for France.
PHONE_AREA_CODE VARCHAR2 10 The area code within a country code.
PHONE_EXTENSION VARCHAR2 20 Additional number addressed after inital connection to an internal telephone system.
CONTACT_PROFILE_ID NUMBER 18 The user profile that is associated with a contact person.
CONTACT_BIZ_PROFILE_ID NUMBER 18 The business profile that is associated with a contact person.
CONTACT_ID NUMBER 18 A unique identifier for a contact person who is associated with a user.
CONTACT_PUID VARCHAR2 480 Yes Indicates the PUID for contacts object.
RECORD_NUMBER VARCHAR2 64 Indicates parent PUID.
MIGRATED_DATA_FLAG VARCHAR2 3 This column is used to indicate migrated flag value.
CONTACT_ACTIVE VARCHAR2 1 Yes Indicates if the person is an active contact for the application.
ACTIVE_LAST_UPDATE_DATE DATE Indicates the date when the contact's active status was last updated.
ACTIVE_LAST_UPDATE_BY VARCHAR2 64 ACTIVE_LAST_UPDATE_BY
PHONE_COUNTRY_CODE_ALT VARCHAR2 10 International country code for a telephone number. For example, 33 for France.
PHONE_AREA_CODE_ALT VARCHAR2 10 The area code within a country code.
PHONE_NUMBER_ALT VARCHAR2 40 Mobile phone number for the contact.
LICENSE_SETUP_CODE VARCHAR2 30 Identifies Setup code for the contractor license when contact is a contractor.
LICENSE_TYPE VARCHAR2 30 Identifies license type for the contractor license when contact is a contractor.
LICENSE_NUMBER VARCHAR2 30 Identifies license number for the contractor license when contact is a contractor.
APPLICANT_FLAG VARCHAR2 1 Yes Indicates if the contact person is the applicant for the application.
JOB_TITLE VARCHAR2 60 Identifies the person's job title associated with the contact.
CONTACT_ACCESS VARCHAR2 30 Yes Indicates whether the contact will be granted access to the application.
OWNER_FLAG VARCHAR2 1 Yes Indicates if the contact person is a business owner.
LNP_BUSINESS_OWNERS_KEY NUMBER 18 Unique identifier for the business owner.
LNP_BUSINESS_OWNERS_PUID VARCHAR2 480 Unique identifier for business owner in the legacy system.
LICENSE_HOLDER_FLAG VARCHAR2 1 Identifies the person that the contractor license was issued to.
AUTHORIZE_AGENT_FLAG VARCHAR2 1 Yes Indicates the contact person is an authorized user of the license.
CONTACT_UID VARCHAR2 30 Indicates the link between Contact and Owner
ORG_CONTACT_ID NUMBER 18 Uniquely identifies the organization contact.
ORG_CONTACT_CLASS VARCHAR2 30 Specifies the role or category assigned to the organization contact.
ORG_CONTACT_BILL_FLAG VARCHAR2 1 Indicates if the contact is designated for billing purposes.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_LNP_CONTACT_LIST psc_lnp_record LNP_RECORD_KEY

Indexes

Index Uniqueness Tablespace Columns Status
PSC_LNP_CONTACT_LIST_FK1 Non Unique Default LNP_RECORD_KEY Active
PSC_LNP_CONTACT_LIST_PK Unique Default CONTACT_KEY Active
PSC_LNP_CONTACT_LIST_U1 Unique Default CONTACT_PUID