SCC_PERS_CHKLST(SQL View) |
Index Back |
|---|---|
Person ChecklistPERSON_CHECKLST is used to create a list of requirements, communication, staff assignments, etc. relative to a person. There is one record in this table for each dated list. |
| SELECT DISTINCT a.OPRID , d.COMMON_ID , d.SEQ_3C , d.SA_ID_TYPE , d.CHECKLIST_DTTM , d.ADMIN_FUNCTION , d.CHECKLIST_CD , d.CHECKLIST_STATUS , d.STATUS_DT , d.STATUS_CHANGE_ID , d.DUE_DT , d.CURRENCY_CD , d.DUE_AMT , d.DEPTID , d.RESPONSIBLE_ID , d.INSTITUTION , d.TRACKING_SEQ , d.ORG_CONTACT , d.CONTACT_NAME , d.VAR_DATA_SEQ , b.SCC_CHECKLIST_TYPE FROM ps_opr_grp_3c_tbl a , PS_CS_CHKLST_TBL b , ps_cs_chklst_3cgrp c , ps_person_checklst d , ps_person_chk_item e 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 AND d.SA_ID_TYPE = 'P' AND d.COMMON_ID = e.COMMON_ID AND d.SEQ_3C = e.SEQ_3C AND e.ITEM_STATUS IN ('A', 'I', 'N', 'O', 'R', 'S', 'T') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SEQ_3C |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 5 | CHECKLIST_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Checklist Date Time |
| 6 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: %EDITTABLE15 |
| 7 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table: CHKLST_SCTY_VW |
| 8 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated |
| 9 | STATUS_DT | Date(10) | DATE | Status Date |
| 10 | STATUS_CHANGE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Status Change ID
Prompt Table: PEOPLE_SRCH |
| 11 | DUE_DT | Date(10) | DATE | Due Date |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | DUE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Due Amount |
| 14 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 15 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table: PEOPLE_SRCH |
| 16 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 17 | TRACKING_SEQ | Number(3,0) | SMALLINT NOT NULL | Tracking Sequence |
| 18 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 19 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 20 | VAR_DATA_SEQ | Number(4,0) | SMALLINT NOT NULL | Variable Data Sequence Number |
| 21 | 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 |