SFA_SLC_EXTIDVW

(SQL View)
Index Back

SLC External System ID View

Retrieves an EMPLID for a SLC Student Support Number.

SELECT A.EXTERNAL_SYSTEM_ID ,A.EXTERNAL_SYSTEM ,A.EFFDT ,A.EMPLID FROM PS_EXTERNAL_SYSTEM A WHERE A.EXTERNAL_SYSTEM = 'SLC' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_EXTERNAL_SYSTEM B WHERE B.EXTERNAL_SYSTEM = A.EXTERNAL_SYSTEM AND B.EXTERNAL_SYSTEM_ID = A.EXTERNAL_SYSTEM_ID AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXTERNAL_SYSTEM_ID Character(20) VARCHAR2(20) NOT NULL Student Support Nbr
2 EXTERNAL_SYSTEM Character(3) VARCHAR2(3) NOT NULL External System

Prompt Table: SCC_EXT_SYS_PER

3 EFFDT Date(10) DATE NOT NULL Effective Date
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH