1. Tables and Views
  2. PSC_COM_BUS_ENTITY_XREF

PSC_COM_BUS_ENTITY_XREF

This table is a cross reference between Business Entities and Parties.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_COM_BUS_ENTITY_XREF_PK

REFERENCE_KEY

Columns

Name Datatype Length Precision Not-null Comments
REFERENCE_KEY NUMBER 18 Yes This is System-generated Reference key GUID
REFERENCE_PUID VARCHAR2 50 Yes This is System-generated Reference key PUID
REFERENCE_PARTY_ID NUMBER 18 This is Foreign key to hz_parties TCA table
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency Id.
BUSINESS_ENTITY_KEY NUMBER 18 Yes This column is Foreign Key to Business Entity Table
BUSINESS_ENTITY_ID VARCHAR2 50 Yes This is Foreign key to psc_com_business_entity table
BE_PERSON_ID VARCHAR2 200 Meaningful identifier of a responsible person for the business.
SAME_AS_APPLICANT_FLAG VARCHAR2 1 To indicate if the owner is the applicant.
BE_PERSON_LENGTH_AT_ADDRESS NUMBER 18 How long have the person been at this address.
BUS_CONTACT_DMV_LIC_NUM VARCHAR2 30 The contact DMV license number.
BUS_CONTACT_DMV_LIC_ST VARCHAR2 60 The contact DMV license state.
BUS_CONTACT_DMV_LIC_EXP DATE The contact DMV license expiration date.
SAME_MAIL_ADDRESS_FLAG VARCHAR2 1 To indicate if mailing address is the same as physical address.
OWNERSHIP_PCT NUMBER This field is used to store percentage of ownership.
DATE_OF_BIRTH DATE This field is used to store the date of birth of the person.
STATUS VARCHAR2 30 Status of responsible person for the business.
VERIFICATION_STATUS VARCHAR2 30 The verification status for the responsible person.
VERIFICATION_DATE DATE The date the responsible person was verified.
VERIFIED_BY VARCHAR2 30 The verification status for the responsible person.
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_LOGIN VARCHAR2 32 Who column: indicates the session login associated to 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.
OWNER_PROFILE_ID NUMBER 18 The user profile that is associated with an owner.
ENTITY_PARTY_ID NUMBER 18 Entity Party ID key from TCA.
JOB_TITLE VARCHAR2 100 Job title of the person - this is outside the context of any relationship the person may have.
PERSON_NAME VARCHAR2 450 The combination of title, first, middle, last, and suffix names.
PERSON_FIRST_NAME VARCHAR2 150 First name of the person.
PERSON_LAST_NAME VARCHAR2 150 Last or surname of the person.
PERSON_MIDDLE_NAME VARCHAR2 60 Middle name of the person.
PERSON_NAME_SUFFIX VARCHAR2 30 ndicates the place in a family structure. For example, in "Tom Jones III", the "III".
SALUTATION VARCHAR2 60 Phrase used to address a party in any correspondence.
ADDRESS1 VARCHAR2 240 First line for address.
ADDRESS2 VARCHAR2 240 Second line for address.
ADDRESS3 VARCHAR2 240 Third line for address.
ADDRESS4 VARCHAR2 240 Fourth line for address.
CITY VARCHAR2 60 City.
STATE VARCHAR2 60 State.
PROVINCE VARCHAR2 60 Province.
COUNTY VARCHAR2 60 County.
COUNTRY VARCHAR2 2 Country code from the TERRITORY_CODE column in the FND_TERRITORY table.
POSTAL_CODE VARCHAR2 60 Postal code.
POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States Postal ZIP code.
MAILING_ADDRESS1 VARCHAR2 240 First line for mailing address.
MAILING_ADDRESS2 VARCHAR2 240 Second line for mailing address.
MAILING_ADDRESS3 VARCHAR2 240 Third line for mailing address.
MAILING_ADDRESS4 VARCHAR2 240 Fourth line for mailing address.
MAILING_CITY VARCHAR2 60 Mailing city.
MAILING_STATE VARCHAR2 60 Mailing state.
MAILING_PROVINCE VARCHAR2 60 Mailing province.
MAILING_COUNTY VARCHAR2 60 Mailing county.
MAILING_COUNTRY VARCHAR2 2 Mailing country code from the TERRITORY_CODE column in the FND_TERRITORY table.
MAILING_POSTAL_CODE VARCHAR2 60 Mailing postal code.
MAILING_POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States mailing Postal ZIP code.
PHONE_TYPE VARCHAR2 30 Indicates the Type of Phone like Work, Home, Mobile etc.
PHONE_COUNTRY_CODE VARCHAR2 10 International country code for a telephone number. For example, 33 for France.
PHONE_AREA_CODE VARCHAR2 20 The area code within a country code.
PHONE_NUMBER VARCHAR2 40 A telephone number formatted in the local format. The number should not include area code, country code, or extension.
PHONE_EXTENSION VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system.
RAW_PHONE_NUMBER VARCHAR2 60 Unformatted telephone number.
EMAIL_ADDRESS VARCHAR2 320 E-mail address of the contact point.
ENTITY_ACCESS VARCHAR2 3 Access level to business entity.
CONTACT_TYPE VARCHAR2 30 Contact type for an owner.
MIGRATED_DATA_FLAG VARCHAR2 3 Attribute identifying data migrated from legacy system.
CITIZENSHIP_STATUS VARCHAR2 30 Citizenship status of an owner.

Foreign Keys

Table Foreign Table Foreign Key Column
psc_com_bus_attachment psc_com_bus_entity_xref REFERENCE_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_COM_BUS_ENTITY_XREF_PK Unique Default REFERENCE_KEY
PSC_COM_BUS_ENTITY_XREF_U1 Unique Default REFERENCE_PUID