GM_SP_FORM3_VW

(SQL View)
 Index Back

SPONSOR FORMS


SELECT DISTINCT A.SETID, A.FORM_ID, A.DESCRSHORT, A.DESCR FROM PS_GM_SP_FORM_DTL A WHERE A.EFFDT=(SELECT MAX(B.EFFDT) FROM PS_GM_SP_FORM_DTL B WHERE B.SETID=A.SETID AND B.FORM_ID=A.FORM_ID AND B.EFFDT<=%CURRENTDATEIN AND B.EFF_STATUS='A' )

  • Parent record: GM_SP_FORM_DT

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

    Prompt Table: SP_SETID_NONVW

    2 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

    Prompt Table: GM_SP_FORM_DTL

    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description