PERS_CHKLST_VW(SQL View) |
Index Back |
|---|---|
Person Checklist Prmpt ViewSummary view of all checklists about a person. This view is linked with Oprid so that the summary can be limited to only the 3C Groups that the operator is authorized to see. |
| SELECT DISTINCT a.OPRID , d.COMMON_ID , d.SEQ_3C , a.ENTRY_USE_IND , d.CHECKLIST_DTTM , d.ADMIN_FUNCTION , d.CHECKLIST_CD , b.SCC_CHECKLIST_TYPE , d.CHECKLIST_STATUS , d.STATUS_DT , d.STATUS_CHANGE_ID , d.DUE_DT , d.CURRENCY_CD , d.DEPTID , d.RESPONSIBLE_ID , d.INSTITUTION , d.VAR_DATA_SEQ , d.SA_ID_TYPE FROM ps_opr_grp_3c_tbl a , PS_CS_CHKLST_TBL b , ps_cs_chklst_3cgrp c , ps_person_checklst d WHERE a.institution = b.institution AND a.group_3c = c.group_3c AND a.inquiry_use_ind = 'Y' AND b.institution = c.institution AND b.institution = d.institution AND c.checklist_cd = b.checklist_cd AND b.effdt = ( SELECT MAX(effdt) FROM PS_CS_CHKLST_TBL x WHERE x.institution = b.institution AND x.checklist_cd = b.checklist_cd AND x.effdt <= %CurrentDateIn) AND b.eff_status = 'A' AND d.checklist_cd = c.checklist_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | ENTRY_USE_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Update Indicator
Y/N Table Edit Default Value: N |
| 5 | CHECKLIST_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Checklist Date Time |
| 6 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 7 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Code |
| 8 | SCC_CHECKLIST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Checklist Type.
ADC=Condition List CML=Communication List HIR=Hiring MED=Medical OTH=Other PRM=Promise RQL=Requirements List SAL=Staff Assignment List TER=Termination TRN=Training XFR=Transfer |
| 9 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |
| 10 | STATUS_DT | Date(10) | DATE | Status Date |
| 11 | STATUS_CHANGE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Status Change ID
Prompt Table: PEOPLE_SRCH |
| 12 | DUE_DT | Date(10) | DATE | Due Date |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 15 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL | Responsible ID |
| 16 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 17 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 18 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |