PEOPLE_CAR_SRCH(SQL View) |
Index Back |
|---|---|
People Career Search ViewView created for selecting EMPLID for transcript request for Chrono detail organization with future release based on grades or degree. The view will show EMPLIDs that have STDNT_CAR_TERM records for the specified career. |
| SELECT A.OPRCLASS ,B.ACAD_CAREER ,A.EMPLID ,A.NAME ,A.SEX ,A.BIRTHDATE ,A.BIRTHDATE_MSK ,A.CAMPUS_ID ,A.NATIONAL_ID ,A.NATIONAL_ID_MSK ,A.NID_COUNTRY ,A.NATIONAL_ID_TYPE ,A.NID_DESCRSHORT ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH FROM PS_PEOPLE_SRCH A , PS_STDNT_CAREER B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 2 | ACAD_CAREER_TS_HDR |
Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VETM=Veterinary Medicine Prompt Table: ACAD_CAR_TBL |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 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 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 10 | NATIONAL_ID_MSK | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 11 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 12 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 13 | NID_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | NID Short Description |
| 14 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 15 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |