PERS_CHKLST2_VW

(SQL View)
 Index Back

Person Checklist Update View 2

PERS_CHKLST2_VW is a sub view for rapid data entry in updating checklist status and status date for a person.

SELECT A.COMMON_ID , A.SEQ_3C , A.CHKLST_ITEM_CD , A.CHECKLIST_SEQ , B.CHECKLIST_CD , B.ADMIN_FUNCTION , C.SCC_CHECKLIST_TYPE , C.DESCR FROM PS_PERSON_CHK_ITEM A , PS_PERSON_CHECKLST B , PS_CS_CHKLST_TBL C WHERE A.COMMON_ID = B.COMMON_ID AND A.ITEM_STATUS NOT IN ('C','W') AND B.CHECKLIST_CD = C.CHECKLIST_CD AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CS_CHKLST_TBL X WHERE X.INSTITUTION = C.INSTITUTION AND X.CHECKLIST_CD = B.CHECKLIST_CD AND X.EFFDT <= %CurrentDateIn )

  • Related Language Record: PERSCHKLST2VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    3 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
    4 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
    5 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
    6 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    7 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
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description