CHKLST_ITEM_VW3

(SQL View)
 Index Back

CHKLST_ITEM_TBL Effective Date

Effective dated view of CHKLST_ITEM_TBL

SELECT A.CHKLST_ITEM_CD , A.DL_LINK_ID , A.DESCR FROM PS_CHKLST_ITEM_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CHKLST_ITEM_TBL A1 WHERE A1.CHKLST_ITEM_CD = A.CHKLST_ITEM_CD AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: CHKLSTITMVW3LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
    2 DL_LINK_ID Character(30) VARCHAR2(30) NOT NULL Dynamic Link
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description