SPB_SC_LOG_VW

(SQL View)
 Index Back

Search record for Serv Coord

Search record for Serv Coord

SELECT DISTINCT B.FROM_SRVC_COD , A.FIRST_NAME , A.LAST_NAME FROM PS_SPB_REPLASC_LOG B , PS_SPB_PERSON_TBL A WHERE B.FROM_SRVC_COD = A.PERSON_ID AND (A.SPRO_PERSON_TYPE = 'SC' OR A.SPRO_PERSON_TYPE = 'BH' OR A.SPRO_PERSON_TYPE = 'SP')

# 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name