BILLACADINFVWLN

(SQL View)
 Index Back

Bill Header Academic Info View

BILLACADINFVWLN is the language record view related to BILL_ACADINF_VW.

SELECT A.BUSINESS_UNIT , A.INVOICE_ID , B.LANGUAGE_CD , B.DESCR , B.DESCRSHORT , D.DESCR , D.DESCRSHORT , E.XLATLONGNAME , E.XLATSHORTNAME , ' ' , ' ' FROM PS_BI_BILL_HEADER A , PS_ACAD_PROG_LANG B , PS_BUS_UNIT_TBL_SF C , PS_ACAD_PLAN_LANG D , PS_BIAXLATABLEVWLN E WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACAD_PROG_LANG 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_LANG 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_BIAXLATABLEVWLN 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 for BILL_ACADINF_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    7 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
    8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    9 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Descr Short 2
    10 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    11 DESCRSHORT3 Character(10) VARCHAR2(10) NOT NULL Descr Short