STDNTTBADJVWLNG

(SQL View)
 Index Back

Max Effdt Vw of Stdnt Trm Bdgt

STDNTTBADJVWLNG is the related language recordfor the record STDNT_TB_ADJ_VW

SELECT DISTINCT a.EMPLID , a.INSTITUTION , a.AID_YEAR , d.AWARD_PERIOD , a.ACAD_CAREER , a.STRM , a.EFFDT , a.EFFSEQ ,A.LANGUAGE_CD , a.DESCRSHORT FROM PS_STDNTTERMBDGLNG a , PS_STDNT_CR_TERM D , PS_AID_YR_CAR_TERM E WHERE a.EFFDT = ( SELECT MAX(b.EFFDT) FROM PS_STDNTTERMBDGLNG b WHERE b.EMPLID = a.EMPLID AND b.institution = a.institution AND b.AID_YEAR = a.AID_YEAR AND b.ACAD_CAREER = a.ACAD_CAREER AND b.STRM = a.STRM AND b.EFFDT <= %CurrentDateIn) AND a.EFFSEQ = ( SELECT MAX(c.EFFSEQ) FROM PS_STDNTTERMBDGLNG c WHERE c.EMPLID = a.EMPLID AND c.institution = a.institution AND c.AID_YEAR = a.AID_YEAR AND c.ACAD_CAREER = a.ACAD_CAREER AND c.STRM = a.STRM AND c.EFFDT = a.EFFDT) AND A.INSTITUTION = D.INSTITUTION AND A.EMPLID = D.EMPLID AND A.AID_YEAR = D.AID_YEAR AND A.ACAD_CAREER = D.ACAD_CAREER AND A.STRM = D.STRM AND D.INSTITUTION = E.INSTITUTION AND D.AID_YEAR = E.AID_YEAR AND D.STRM = E.STRM AND D.AWARD_PERIOD = E.AWARD_PERIOD

  • Related Language Record for STDNT_TB_ADJ_VW

  • Parent record: STDNT_CR_TERM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    5 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: STDNT_CAREER

    6 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    7 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BUDGET_GRP_TBL.DESCR