OPRCLASSOPRIDCOMMON_IDPrompt Table: PEOPLE_SRCH
SEQ_3CDefault Value: %date
Prompt Table: ADM_FCN_PPL_VW
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
CHKLST_DTL_SRCH(SQL View) |
Index Back |
|---|---|
Personal Chklst Maint SrchCHKLST_SRCH finds checklists for a person. |
| SELECT DISTINCT b.oprclass , d.oprid , a.common_id , a.seq_3c , a.checklist_dttm , a.admin_function , a.checklist_cd , e.country , e.national_id_type , f.descrshort , e.national_id , e.national_id_msk , b.BIRTHDATE , b.BIRTHDATE_MSK , h.SEX , g.name , b.CAMPUS_ID , g.last_name_srch , g.first_name_srch FROM ps_person_checklst a , ps_person_msk_vw b , ps_cs_chklst_3cgrp c , ps_opr_grp_3c_tbl d , ps_pers_nid_msk_vw e , PS_NID_TYPE_TBL f , ps_hcr_person_nm_i g , ps_hcr_per_pde_i h WHERE b.oprclass = e.oprclass AND a.common_id = b.emplid AND a.institution = c.institution AND a.checklist_cd = c.checklist_cd AND c.institution = d.institution AND c.group_3c = d.group_3c AND d.inquiry_use_ind = 'Y' AND a.common_id = e.emplid AND f.country = e.country AND f.national_id_type = e.national_id_type AND a.common_id = g.emplid AND a.common_id = h.emplid AND h.effdt = ( SELECT MAX(e1.effdt) FROM ps_hcr_per_pde_i e1 WHERE e.emplid = e1.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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
Prompt Table: PEOPLE_SRCH |
| 4 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | CHECKLIST_DTTM | DateTime(26) | TIMESTAMP |
Checklist Date Time
Default Value: %date |
| 6 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FCN_PPL_VW |
| 7 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 8 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 9 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 10 | NID_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | NID Short Description |
| 11 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 12 | NATIONAL_ID_MSK | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 13 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 14 | BIRTHDATE_MSK | Character(10) | VARCHAR2(10) NOT NULL | Date of Birth |
| 15 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 16 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 17 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 18 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 19 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |