PERSON_IDSP_FUNCTION_TYPEINDP=Independent Provider
PRCT=Provider Contact
PROV=Provider
SPB_VENDOR_CON(SQL View) |
Index Back |
|---|
| SELECT PERSON_ID , VENDOR_ID , SP_FUNCTION_TYPE FROM PS_SPB_SERVICE_PRV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | SP_FUNCTION_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Function Type
INDP=Independent Provider PRCT=Provider Contact PROV=Provider |