SSR_HM_SIC_LTX

(SQL View)
Index Back

Last Course SIC Transaction

Last Successful transaction of a HEIMS Special Interest Course

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

# 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 SSR_PROVIDER_TYPE Character(4) VARCHAR2(4) NOT NULL Provider Type
HEP=Higher Education Provider
NA=Not Applicable
TAC=Tertiary Admission Centre
VET=Vocational Education&Training
5 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID