SPA_EXP_ROST_VW(SQL View) |
Index Back |
---|---|
Provider Contact SearchSearch View for Expense roster |
SELECT A.PERSON_ID , A.NAME , V.NAME1 FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B , PSOPRALIAS C , PS_VENDOR V WHERE B.PERSON_ID = A.PERSON_ID AND C.PERSON_ID = B.PERSON_ID AND A.SPRO_PERSON_TYPE IN ('SP','PC','BH') AND (B.SP_FUNCTION_TYPE = 'PRCT' OR B.SP_FUNCTION_TYPE = 'PROV' OR B.SP_FUNCTION_TYPE = 'INDP') AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID AND A.USER_ACC_STATUS = '1' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |