SSR_HM_COCF_LTQ

(SQL View)
Index Back

Last Course Campus Transaction

Last Successful transaction of a HEIMS Course on Campus Fees

SELECT COCF.INSTITUTION , COCF.ACAD_PROG , COCF.ACAD_PLAN , COCF.LOCATION , COCF.CRSE_CMP_EFFDT , COCF.CRSE_FEE_EFFDT , COCF.SSR_TRANS_ID , COCF.SSR_SEQ_NBR , COCF.SSR_SEQ_NBR2 FROM PS_SSR_HM_CRSE_FEE COCF , PS_SSR_HM_COCF_LTX LST_TXN WHERE COCF.INSTITUTION= LST_TXN.INSTITUTION AND COCF.ACAD_PROG = LST_TXN.ACAD_PROG AND COCF.ACAD_PLAN = LST_TXN.ACAD_PLAN AND COCF.LOCATION = LST_TXN.LOCATION AND COCF.CRSE_FEE_EFFDT = LST_TXN.CRSE_FEE_EFFDT AND COCF.SSR_TRANS_ID = LST_TXN.SSR_TRANS_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 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
5 CRSE_CMP_EFFDT Date(10) DATE Effective Date
6 CRSE_FEE_EFFDT Date(10) DATE Effective Date
7 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID
8 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
9 SSR_SEQ_NBR2 Number(4,0) SMALLINT NOT NULL Sequence Number 2