SCC_USI_SRCH

(SQL View)
 Index Back

USI People Search View


SELECT A.OPRCLASS , A.EMPLID ,F.SCC_USI_SUB_DTTM ,d.NAME ,e.SEX ,A.BIRTHDATE ,A.BIRTHDATE_MSK ,A.CAMPUS_ID ,d.LAST_NAME_SRCH ,d.FIRST_NAME_SRCH ,d.NAME_DISPLAY FROM PS_PERSON_MSK_VW A , PS_HCR_PERSON_NM_I d , PS_HCR_PER_PDE_I e ,PS_SCC_USI_REQUEST F WHERE A.EMPLID = d.EMPLID AND A.EMPLID = e.EMPLID AND F.EMPLID = A.EMPLID AND e.EFFDT = ( SELECT MAX(e1.EFFDT) FROM PS_HCR_PER_PDE_I e1 WHERE e1.EMPLID=e.EMPLID AND e1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 SCC_USI_SUB_DTTM DateTime(26) TIMESTAMP Submit Date/Time
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
6 BIRTHDATE Date(10) DATE Date of Birth
7 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
8 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
11 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country