PERSON_IDSP_FUNCTION_TYPEINDP=Independent Provider
PRCT=Provider Contact
PROV=Provider
EFFDTDefault Value: %date
SPB_PROV_CNT_VW(SQL View) |
Index Back |
|---|---|
Service Provider and ContactService Provider and Provider Contact view |
| SELECT PERSON_ID , SP_FUNCTION_TYPE , EFFDT , VENDOR_SETID , VENDOR_ID , LOCATION , PROVIDER_CONTACT , ROW_MODIFY_DATE FROM PS_SPB_SERVICE_PRV A WHERE SP_FUNCTION_TYPE <> 'PRCT' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SPB_SERVICE_PRV B WHERE A.PERSON_ID = B.PERSON_ID AND A.SP_FUNCTION_TYPE = B.SP_FUNCTION_TYPE AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | SP_FUNCTION_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Function Type
INDP=Independent Provider PRCT=Provider Contact PROV=Provider |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 7 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | PROVIDER CONTACT |
| 8 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP | Modified Date Time |