RA_SRCHADTYP_VW

(SQL View)
 Index Back

Admit Type View

View is used as search prompt for profile field definition.

SELECT A.ADMIT_TYPE , A.DESCR , B.DESCR , C.DESCR FROM PS_ADMIT_TYPE_TBL A , PS_ACAD_CAR_TBL B ,PS_INSTITUTION_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND (A.ACAD_CAREER = B.ACAD_CAREER OR A.ACAD_CAREER = ' ') AND A.INSTITUTION=C.INSTITUTION AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_ACAD_CAR_TBL BB WHERE B.INSTITUTION = BB.INSTITUTION AND B.ACAD_CAREER=BB.ACAD_CAREER AND BB.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_INSTITUTION_TBL CC WHERE C.INSTITUTION = CC.INSTITUTION AND CC.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_SRCHADTY_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.

    Prompt Table: ADMIT_TYPE_TBL

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Career
    4 DESCR30 Character(30) VARCHAR2(30) NOT NULL Institution