PSC_PBL_CONTACT

This table contains contacts associated with a person profile or business profile.

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_PBL_CONTACT_PK	CONTACT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CONTACT_ID	NUMBER		18	Yes	A unique identifier for a contact person who is associated with a user.	Active
PROFILE_ID	NUMBER		18	Yes	The user profile that is associated with a contact person. This is a foreign key to the profile ID at PSC_PBL_PROFILE.PROFILE_ID.	Active
PERSON_FIRST_NAME	VARCHAR2	150			The first name of the user's contact.	Active
PERSON_MIDDLE_NAME	VARCHAR2	60			The middle name of the user's contact.	Active
PERSON_LAST_NAME	VARCHAR2	150			The last name of the user's contact.	Active
ORGANIZATION_NAME	VARCHAR2	360			The organization or business name of the user's contact.	Active
EMAIL_ADDRESS	VARCHAR2	320			The email address of the user's contact.	Active
PHONE_COUNTRY_CODE	VARCHAR2	10			The international country code for a contact's telephone number.	Active
PHONE_AREA_CODE	VARCHAR2	10			The contact's phone area code within a country.	Active
PHONE_NUMBER	VARCHAR2	40			The phone number of the user's contact.	Active
PHONE_EXTENSION	VARCHAR2	20			The contact's additional extension number after initial connection to an internal telephone system.	Active
COUNTRY	VARCHAR2	3		Yes	The country of the contact address.	Active
ADDRESS1	VARCHAR2	240			The first line of the contact address.	Active
ADDRESS2	VARCHAR2	240			The second line of the contact address.	Active
ADDRESS3	VARCHAR2	240			The third line of the contact address.	Active
ADDRESS4	VARCHAR2	240			The fourth line of the contact address.	Active
CITY	VARCHAR2	60			The city of the contact address.	Active
POSTAL_CODE	VARCHAR2	60			The postal code of the contact address.	Active
STATE	VARCHAR2	60			The state of the contact address.	Active
PROVINCE	VARCHAR2	60			The province of the contact address.	Active
COUNTY	VARCHAR2	60			The county of the contact address.	Active
POSTAL_PLUS4_CODE	VARCHAR2	60			The four-digit extension to the postal code of the contact address.	Active
JOB_TITLE	VARCHAR2	60			Identifies the person's job title associated with the contact.
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

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_PBL_CONTACT	psc_pbl_profile	PROFILE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_PBL_CONTACT_FK1	Non Unique	Default	PROFILE_ID	Active
PSC_PBL_CONTACT_PK	Unique	Default	CONTACT_ID	Active