1. Tables and Views
  2. PSC_PBL_PROFILE

PSC_PBL_PROFILE

This table contains basic information about a user profile, which could be a personal or business profile.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_PBL_PROFILE_PK

PROFILE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PROFILE_ID NUMBER 18 Yes The unique identifier for a user profile. Active
PSC_USER_ID NUMBER 18 Yes The unique identifier for the user who is associated with the profile.
PARTY_ID NUMBER 18 The party ID for a user profile. This is a foreign key to the party ID at HZ_PARTIES.PARTY_ID. Active
PROFILE_TYPE VARCHAR2 20 Yes A user profile type. It is a lookup code for lookup type ORA_PSC_CC_PROFILE_TYPE. Active
PERSON_TYPE VARCHAR2 10 Yes Indicates that a user is a public user. The only valid value is Public. Active
PROFILE_NAME VARCHAR2 60 Yes A profile name for a user profile. The default for a personal profile is the person's first name and last name. The default for a business profile is the business name.
HIDDEN_PERSONAL_PROFILE VARCHAR2 1 Yes Indicates if a user profile is hidden. Valid values are Y (Yes) and N (No). Active
PROFILE_STATUS VARCHAR2 1 Yes The user profile status. Valid values are A (Active) and I (Inactive). The default is A. Active
BUSINESS_NAME VARCHAR2 150 The business name for a user's business profile.
BUSINESS_TYPE VARCHAR2 30 The business type for a user's business profile. It is a lookup code for lookup type ORA_PSC_CC_BUSN_TYPE.
JOB_TITLE VARCHAR2 60 A person's job title for the business in a business profile.
PREFERRED_CONTACT_METHOD VARCHAR2 30 A user's preferred way to be contacted, such as by email or by phone.
IS_CONTRACTOR VARCHAR2 1 Yes Indicates if a user is a contractor. Valid values are Y (Yes) and N (No). Active
CNTRCTR_VERIFICATION_STATUS VARCHAR2 2 The contractor verification status. It is a lookup code for lookup type ORA_PSC_CC_VERIF_CODE. Active
CNTRCTR_LAST_ACTION_BY VARCHAR2 64 The user who last updated the contractor verification status. Active
CNTRCTR_LAST_ACTION_DATE TIMESTAMP The date and time that the verification status was last updated. Active
SENSITIVE_FLAG VARCHAR2 1 Yes Indicates if a user is a member of law enforcement or a judicial agency. If so, personal data may need special handling. Valid values are Y (Yes) and N (No). The default value is N. Active
SENSITIVE_VERIFICATION_STATUS VARCHAR2 2 Indicates the verification status for the indicator that identifies a user as a memeber of law enforcement or a judicial agency. It is a lookup code for lookup type ORA_PSC_CC_VERIF_CODE. Active
SENSITIVE_LAST_ACTION_BY VARCHAR2 64 The user who last updated the verification status for the indicator that identifies a user as a memeber of law enforcement or a judicial agency. Active
SENSITIVE_LAST_ACTION_DATE TIMESTAMP The date and time of the last update to the verification status for the indicator that identifies a user as a member of law enforcement or a judicial agency. Active
IVR_ACCESS_CODE VARCHAR2 512 Access code used to retrieve and update inspection transactions using IVR.
IVR_SALT VARCHAR2 64 Random data used in one-way function to hash access code.
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
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
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

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_PBL_PROFILE psc_pbl_user_ref PSC_USER_ID
PSC_PBL_PROFILE hz_parties PARTY_ID
psc_pbl_contact psc_pbl_profile PROFILE_ID
psc_pbl_contact_pt psc_pbl_profile PROFILE_ID
psc_pbl_payment_acct psc_pbl_profile PROFILE_ID
psc_pbl_location_site psc_pbl_profile PROFILE_ID
psc_pbl_license_ref psc_pbl_profile PROFILE_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_PBL_PROFILE_FK1 Non Unique Default PARTY_ID Active
PSC_PBL_PROFILE_FK2 Non Unique Default PSC_USER_ID
PSC_PBL_PROFILE_PK Unique Default PROFILE_ID Active