SAA_IN_SET_FLVW

(SQL View)
 Index Back

AA Fluid Option Setup View

AA Fluid Option Setup - Component Search View

SELECT S.INSTITUTION , I.DESCR FROM PS_SAA_IN_SETUP_FL S , PS_INSTITUTION_TBL I WHERE I.INSTITUTION = S.INSTITUTION AND I.EFFDT = ( SELECT MAX(I2.EFFDT) FROM PS_INSTITUTION_TBL I2 WHERE I2.INSTITUTION = I.INSTITUTION AND I2.EFFDT <= S.EFFDT) AND I.EFF_STATUS = 'A'

  • Related Language Record: SAA_IN_SET_FLLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description