PERSON_IDSPB_PROVRSLT_V(SQL View) |
Index Back |
|---|---|
Service Provider search resultService Provider search results view |
| SELECT P.PERSON_ID , FIRST_NAME , MIDDLE_NAME , LAST_NAME , NAME , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , COUNTRY , SP_PROV_ID , VALUE FROM PS_SPB_PERSON_TBL P , PS_SPB_SRV_PROV_ID I WHERE SPRO_PERSON_TYPE IN ('SP','PC') AND P.PERSON_ID = I.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 3 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 7 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | PROVIDER CONTACT |
| 8 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 11 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL | Proficiency |
| 12 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL | Years Experience |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 14 | SP_PROV_ID | Character(30) | VARCHAR2(30) NOT NULL | Service Provider Identifier |
| 15 | VALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |