PERSCHKLST2VWLN

(SQL View)
 Index Back

Person Checklist Update View 2

PERSCHKLST2VWLN is the language record related to PERS_CHKLST2_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.COMMON_ID , A.SEQ_3C , A.CHKLST_ITEM_CD , A.CHECKLIST_SEQ , B.CHECKLIST_CD , D.LANGUAGE_CD , D.DESCR FROM PS_PERSON_CHK_ITEM A , PS_PERSON_CHECKLST B , PS_CS_CHKLST_TBL C , PS_CS_CHKLST_LANG D 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 ) AND C.INSTITUTION = D.INSTITUTION AND C.CHECKLIST_CD = D.CHECKLIST_CD AND C.EFFDT = D.EFFDT

  • Related Language Record for PERS_CHKLST2_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description