SSR_HM_FOE_LTQ

(SQL View)
 Index Back

Last FOE Transaction

Last Successful transaction of a HEIMS Course Field of Education

SELECT CRS.INSTITUTION , CRS.ACAD_PROG , CRS.ACAD_PLAN , CRS.SSR_PROVIDER_TYPE , CRS.SSR_TRANS_ID , CRS.SSR_SEQ_NBR , CRS.SSR_SEQ_NBR2 FROM PS_SSR_HM_FLDOFEDU CRS , PS_SSR_HM_FOE_LTX CRS_LST_TXN , PS_SSR_HM_UID_MAP UMAP WHERE CRS.INSTITUTION= CRS_LST_TXN.INSTITUTION AND CRS.ACAD_PROG = CRS_LST_TXN.ACAD_PROG AND CRS.ACAD_PLAN = CRS_LST_TXN.ACAD_PLAN AND CRS.SSR_PROVIDER_TYPE = CRS_LST_TXN.SSR_PROVIDER_TYPE AND CRS.SSR_TRANS_ID = CRS_LST_TXN.SSR_TRANS_ID AND UMAP.INSTITUTION= CRS_LST_TXN.INSTITUTION AND UMAP.ACAD_PROG = CRS_LST_TXN.ACAD_PROG AND UMAP.ACAD_PLAN = CRS_LST_TXN.ACAD_PLAN AND UMAP.SSR_PROVIDER_TYPE = CRS_LST_TXN.SSR_PROVIDER_TYPE AND UMAP.EFF_STATUS = 'A' AND UMAP.DELETE_FLAG = 'N' AND UMAP.SSR_MAP_ID = CRS.SSR_MAP_ID UNION SELECT CRS.INSTITUTION , CRS.ACAD_PROG , ' ' , CRS.SSR_PROVIDER_TYPE , CRS.SSR_TRANS_ID , CRS.SSR_SEQ_NBR ,CRS.SSR_SEQ_NBR2 FROM PS_SSR_HM_FLDOFEDU CRS , PS_SSR_HM_FOE_LTX CRS_LST_TXN , PS_SSR_HM_UID_MAP UMAP WHERE CRS.INSTITUTION= CRS_LST_TXN.INSTITUTION AND CRS.ACAD_PROG = CRS_LST_TXN.ACAD_PROG AND CRS.SSR_PROVIDER_TYPE = CRS_LST_TXN.SSR_PROVIDER_TYPE AND CRS.ACAD_PLAN = ' ' AND CRS.SSR_TRANS_ID = CRS_LST_TXN.SSR_TRANS_ID AND UMAP.INSTITUTION= CRS_LST_TXN.INSTITUTION AND UMAP.ACAD_PROG = CRS_LST_TXN.ACAD_PROG AND UMAP.SSR_PROVIDER_TYPE = CRS_LST_TXN.SSR_PROVIDER_TYPE AND UMAP.ACAD_PLAN =' ' AND UMAP.EFF_STATUS = 'A' AND UMAP.DELETE_FLAG = 'N' AND UMAP.SSR_MAP_ID = CRS.SSR_MAP_ID

# 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
6 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
7 SSR_SEQ_NBR2 Number(4,0) SMALLINT NOT NULL Sequence Number 2