CHKLST_ITEM_VW2

(SQL View)
Index Back

SELECT A.CHKLST_ITEM_CD , A.DESCRLONG FROM PS_SCC_CKLSITM_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_CKLSITM_TBL A1 WHERE A1.CHKLST_ITEM_CD = A.CHKLST_ITEM_CD AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: CHKLSTITMVW2LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
    2 DESCRLONG Long Character CLOB Long Description