SSR_HM_COC_LTX

(SQL View)
 Index Back

Last Course on Campus Trans

Last Successful transaction of a HEIMS Course on Campus

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

# 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_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID