PERSON_IDPrompt Table: SPB_PERSON_TBL
VENDOR_SETIDVENDOR_IDCOMPETENCYPrompt Table:
SP_CMP_STID_VW1
Set Control Field: VENDOR_SETID
Prompt Table:
SP_EXPERIENC_VW
Set Control Field: VENDOR_SETID
Prompt Table: REVW_RATING_TBL
SPB_PROV_SKILLS(SQL Table) |
Index Back |
|---|---|
Provider CompetenciesService Provider Competencies. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: SPB_PERSON_TBL |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table:
SP_CMP_STID_VW1
|
| 5 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table:
SP_EXPERIENC_VW
|
| 6 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency
Prompt Table: REVW_RATING_TBL |