GM_IN_ADD_T_VW

(SQL View)
 Index Back

Institution Additional Types

primarily used in the forms info page

SELECT SETID , ADD_TYPE , DESCR20A , DESCR100 FROM PS_GM_INS_ADD_TYPE WHERE EFF_STATUS = 'A' AND EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_GM_INS_ADD_TYPE I WHERE I.SETID = SETID AND I.ADD_TYPE = ADD_TYPE AND I.EFF_STATUS = 'A' AND I.EFFDT <= %CurrentDateIn)

  • Related Language Record: GM_INS_A_TY_L_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ADD_TYPE Character(4) VARCHAR2(4) NOT NULL Additional Applicant Type
    3 DESCR20A Character(20) VARCHAR2(20) NOT NULL Short Description
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description