APP_FEE_ITEM_VW

(SQL View)
 Index Back

Application Fees Item


SELECT D.INSTITUTION ,A.BATCH_ID ,B.COMMON_ID ,B.COMMON_ID ,B.ACAD_CAREER ,B.STDNT_CAR_NBR ,B.ADM_APPL_NBR ,B.ACCOUNT_NBR ,B.ACCOUNT_TERM ,B.ITEM_TYPE ,C.DESCR ,E.DUE_DT ,E.LINE_AMT ,B.CURRENCY_CD FROM PS_APP_FEE_CALC A ,PS_ITEM_SF B ,PS_ITEM_LINE_SF E ,PS_ITEM_TYPE_TBL C ,PS_BUS_UNIT_TBL_SF D WHERE A.INSTITUTION = D.INSTITUTION AND A.EMPLID = B.COMMON_ID AND B.SA_ID_TYPE = 'P' AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.ITEM_TYPE = C.ITEM_TYPE AND C.ITEM_TYPE_CD = 'A' AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.RECNAME = 'ITEM_TYPE_TBL' AND E.SETCNTRLVALUE = D.INSTITUTION) AND C.EFFDT=( SELECT MAX(F.EFFDT) FROM PS_ITEM_TYPE_TBL F WHERE F.SETID = C.SETID AND F.ITEM_TYPE = C.ITEM_TYPE AND F.EFFDT <= %CurrentDateIn AND F.EFF_STATUS = 'A') AND B.BUSINESS_UNIT = E.BUSINESS_UNIT AND B.COMMON_ID = E.COMMON_ID AND B.SA_ID_TYPE = E.SA_ID_TYPE AND B.ITEM_NBR = E.ITEM_NBR

  • Related Language Record: APPFEEITEMVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    3 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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
    6 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    8 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    9 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    10 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 DUE_DT Date(10) DATE Due Date
    13 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code