OPRCLASSEMPLIDF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
PEOPLE_SRCH(SQL View) |
Index Back |
|---|---|
People Search ViewCommon view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code. |
| SELECT A.OPRCLASS ,A.EMPLID ,N.NAME_TYPE ,NT.NAME_TYPE_DESCR ,N.NAME ,E.SEX ,A.BIRTHDATE ,A.BIRTHDATE_MSK ,A.CAMPUS_ID ,B.NATIONAL_ID ,B.NATIONAL_ID_MSK ,B.COUNTRY ,B.NATIONAL_ID_TYPE ,B.NID_DESCRSHORT ,N.LAST_NAME_SRCH ,N.FIRST_NAME_SRCH ,N.NAME_DISPLAY FROM PS_PERSON_MSK_VW A , PS_PERS_NID_MSK_VW B , PS_HCR_PER_PDE_I E , PS_NAMES N , PS_NAME_TYPE_TBL NT , PS_INSTALLATION_CC I WHERE B.OPRCLASS = A.OPRCLASS AND B.EMPLID = A.EMPLID AND E.EMPLID = B.EMPLID AND %EffdtCheck(HCR_PER_PDE_I E2, E, %CurrentDateIn) AND N.EMPLID = E.EMPLID AND %EffdtCheck(NAMES N2, N, %CurrentDateIn) AND N.EFF_STATUS = 'A' AND ( ( I.SCC_PREF_NM_SRCH = 'Y' AND N.NAME_TYPE IN ('PRI','PRF') ) OR ( I.SCC_PREF_NM_SRCH = 'N' AND N.NAME_TYPE = 'PRI' ) ) AND NT.NAME_TYPE = N.NAME_TYPE |
| # | 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 |
| 3 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Type of Name |
| 4 | NAME_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Name Type |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 7 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 8 | BIRTHDATE_MSK | Character(10) | VARCHAR2(10) NOT NULL | Date of Birth |
| 9 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 10 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 11 | NATIONAL_ID_MSK | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 12 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 13 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 14 | NID_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | NID Short Description |
| 15 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 16 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 17 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |