SSF_ITEMGRP_VW

(SQL View)
 Index Back

Prompt Table Item Type group

Used as Prompt Table to populate Item Type Group in new Run Control Page

SELECT SETID , ITEM_TYPE_GROUP , DESCR FROM PS_ITEM_GROUP_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_GROUP_TBL B WHERE A.SETID = B.SETID AND A.ITEM_TYPE_GROUP = B.ITEM_TYPE_GROUP AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: ITEM_GRP_V_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_OPRVW

    2 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description