BILL_ACADINF_VW

(SQL View)
 Index Back

Bill Header Academic Info View


SELECT A.BUSINESS_UNIT , A.INVOICE_ID , A.EMPLID , A.ACAD_CAREER , A.ACAD_PROG_PRIMARY , A.ACAD_LEVEL_PROJ , A.ACAD_PLAN , A.TUITION_RES , B.DESCR , B.DESCRSHORT , D.DESCR , D.DESCRSHORT , E.XLATLONGNAME , E.XLATSHORTNAME , ' ' , ' ' FROM PS_BI_BILL_HEADER A , PS_ACAD_PROG_TBL B , PS_BUS_UNIT_TBL_SF C , PS_ACAD_PLAN_TBL D , PS_BIAXLATTABLE_VW E WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACAD_PROG_TBL WHERE B.INSTITUTION = INSTITUTION AND B.ACAD_PROG = ACAD_PROG AND EFFDT <= %CurrentDateIn) AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.INSTITUTION = C.INSTITUTION AND A.ACAD_PROG_PRIMARY = B.ACAD_PROG AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACAD_PLAN_TBL WHERE D.INSTITUTION = INSTITUTION AND D.ACAD_PLAN = ACAD_PLAN AND EFFDT <= %CurrentDateIn) AND D.INSTITUTION = C.INSTITUTION AND D.ACAD_PLAN = A.ACAD_PLAN AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BIAXLATTABLE_VW WHERE E.FIELDNAME = FIELDNAME AND E.FIELDVALUE = FIELDVALUE AND EFFDT <= %CurrentDateIn) AND E.FIELDNAME = 'ACADEMIC_LEVEL' AND E.FIELDVALUE = A.ACAD_LEVEL_PROJ

  • Related Language Record: BILLACADINFVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 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
    5 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    6 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
    7 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    8 TUITION_RES Character(5) VARCHAR2(5) NOT NULL Tuition Residency
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    11 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    12 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
    13 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    14 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Descr Short 2
    15 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    16 DESCRSHORT3 Character(10) VARCHAR2(10) NOT NULL Descr Short