SSR_HM_COCT_LTX

(SQL View)
 Index Back

Last Course on Campus Trans

Last Successful transaction of a HEIMS Course on Campus TAC code

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

# 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 SSR_TAC_OFFER_CODE Character(1) VARCHAR2(1) NOT NULL HEIMS TAC Offer Code
6 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID