1. Tables and Views for HCM
  2. HWR_PER_GBL_PRFL_B

HWR_PER_GBL_PRFL_B

The global person profile table is used to store a profile of a person.

Details

  • Schema: FUSION

  • Object owner: HWR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

HWR_PER_GBL_PRFL_B_PK

GBL_PRFL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
GLOBAL_PROFILE_ID VARCHAR2 400 Yes This is the primary key for the global profile tables. Obsolete
GBL_PRFL_ID NUMBER 18 Yes This is the primary key for the global profile tables.
GENDER_CODE VARCHAR2 80 Yes A string code for gender: MALE, FEMALE or NA (not available). Active
EMAIL VARCHAR2 800 This is the email address of the person. Active
MENTOR_STATUS NUMBER This is for storing mentor status.
IMAGE_URL VARCHAR2 4000 The URL to the person's photo image. Active
GAMIFICATION_USER_ID VARCHAR2 400 The Gamification user ID for this person.
GAMIFICATION_PLAYER_ID VARCHAR2 400 The Gamification player ID for this person.
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
hwr_soc_med_role_score_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_gbl_prfl_mtor_rnk_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_gbl_prfl_metrc_rep_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_gbl_prfl_rating hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_org_gbl_prfl_x hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_endorse_gbl_prfl_x hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_mentor_b hwr_per_gbl_prfl_b MENTOREE_GBL_PRFL_ID
hwr_mentor_b hwr_per_gbl_prfl_b MENTOR_GBL_PRFL_ID
hwr_per_gbl_prfl_prfl_x hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_recogn_gbl_prfl_x hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_gbl_prfl_metrc_cmp_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_prfl_hndl_lkup hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_rep_cntrl_issue_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_skills_mentor_b hwr_per_gbl_prfl_b MENTOREE_GBL_PRFL_ID
hwr_skills_mentor_b hwr_per_gbl_prfl_b MENTOR_GBL_PRFL_ID
hwr_rslt_result hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_gbl_prfl_query hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_soc_med_role_prfl_b hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_gbl_prfl_tl hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_resume_gbl_prfl_x hwr_per_gbl_prfl_b GBL_PRFL_ID
hwr_per_gbl_prfl_conn_x hwr_per_gbl_prfl_b GBL_PRFL_ID1
hwr_per_gbl_prfl_conn_x hwr_per_gbl_prfl_b GBL_PRFL_ID2
hwr_soc_med_rl_raw_scr_b hwr_per_gbl_prfl_b GBL_PRFL_ID

Indexes

Index Uniqueness Tablespace Columns Status
HWR_PER_GBL_PRFL_B_U1 Unique FUSION_TS_TX_DATA GBL_PRFL_ID Active