SSR_HM_COCF_LTX

(SQL View)
 Index Back

Last Course on Campus Trans

Last Successful transaction of a HEIMS Course on Campus Fees

SELECT COCF.INSTITUTION , COCF.ACAD_PROG , COCF.ACAD_PLAN , COCF.LOCATION , COCF.CRSE_FEE_EFFDT , MAX(COCF.SSR_TRANS_ID) FROM PS_SSR_HM_CRSE_FEE COCF , PS_SSR_HM_UID_MAP MAP WHERE COCF.INSTITUTION= MAP.INSTITUTION AND COCF.ACAD_PROG = MAP.ACAD_PROG AND COCF.ACAD_PLAN = MAP.ACAD_PLAN AND COCF.LOCATION = MAP.LOCATION AND COCF.SSR_PROVIDER_TYPE = MAP.SSR_PROVIDER_TYPE AND MAP.DELETE_FLAG = 'N' AND MAP.EFF_STATUS = 'A' AND MAP.RECNAME = 'SSR_HM_CRSE_FEE' AND COCF.SSR_PROVIDER_TYPE ='HEP' AND COCF.IB_RESTMETHOD NOT LIKE 'DELETE' AND COCF.SSR_MAP_ID <> 0 GROUP BY COCF.INSTITUTION , COCF.ACAD_PROG , COCF.ACAD_PLAN, COCF.LOCATION , COCF.CRSE_FEE_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
5 CRSE_FEE_EFFDT Date(10) DATE Effective Date
6 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID