RS_PERS_SRCH(SQL View) |
Index Back |
---|---|
Provider Contact Search RecordSELECT A.PERSON_ID , A.SPRO_PERSON_TYPE , A.FIRST_NAME , A.LAST_NAME , B.SP_FUNCTION_TYPE FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B WHERE B.PERSON_ID = A.PERSON_ID AND A.SPRO_PERSON_TYPE = 'SP' AND B.SP_FUNCTION_TYPE = 'PRCT' |
SELECT DISTINCT A.PERSON_ID , A.SPRO_PERSON_TYPE , A.FIRST_NAME , A.LAST_NAME , B.SP_FUNCTION_TYPE FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B WHERE B.PERSON_ID = A.PERSON_ID AND A.SPRO_PERSON_TYPE IN ('SP','PC') AND (B.SP_FUNCTION_TYPE = 'PRCT' OR B.SP_FUNCTION_TYPE = 'INDP' OR B.SP_FUNCTION_TYPE = 'PROV') AND NOT EXISTS ( SELECT AC.PERSON_ID FROM PS_RS_EMPLID_TBL AC WHERE A.PERSON_ID = AC.PERSON_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: NEXT |
2 | SPRO_PERSON_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Person Type
BH=Coordinator/Provider Contact PC=Service Provider/Coordinator SC=Service Coordinator SP=Service Provider |
3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
5 | SP_FUNCTION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Function Type
INDP=Independent Provider PRCT=Provider Contact PROV=Provider |