SP_SERVCO_OPRVW

(SQL View)
Index Back

Service Coordinator View

Displays all the active service coordinators. SELECT PERSON_ID , FIRST_NAME , MIDDLE_NAME , LAST_NAME FROM PS_SPB_PERSON_TBL WHERE SPRO_PERSON_TYPE = 'SC' AND USER_ACC_STATUS = '1'

SELECT DISTINCT S.BUSINESS_UNIT , P.PERSON_ID , P.FIRST_NAME , P.MIDDLE_NAME , P.LAST_NAME FROM PS_SPB_PERSON_TBL P , PS_SPB_SERVICE_COD C , PS_SEC_BU_OPR S , PSOPRALIAS O , PSOPRDEFN D WHERE SPRO_PERSON_TYPE IN ('SC','BH','PC') AND USER_ACC_STATUS = '1' AND C.PERSON_ID = P.PERSON_ID AND C.SP_COOD_STATUS = 'A' AND D.OPRID = O.OPRID AND D.OPRID = S.OPRID AND O.PERSON_ID = P.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name