BO_IDRA_ATTRIB_SEQPrompt Table: RA_COMPETNCY_VW
Prompt Table: RA_PROFCNCY_VW
OLM_WRKR_CMP_VW(SQL View) |
Index Back |
|---|---|
profile for worker compWorker Competencies profile for profile |
| SELECT a.bo_id , b.syncid , b.competency , b.proficiency FROM ps_rf_wrkr_cmp_vw b , PS_RD_PERSON a WHERE b.person_id=a.person_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | RA_ATTRIB_SEQ |
Number(31,0) | DECIMAL(31) NOT NULL | Profile / attribute sequence numbers |
| 3 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL |
Competency - this field is brought over from HRMS
Prompt Table: RA_COMPETNCY_VW |
| 4 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency Field. This Field is imported into CRM DB from Human Resources Database.
Prompt Table: RA_PROFCNCY_VW |