SSR_HM_COCF_VW(SQL View) |
Index Back |
|---|---|
Course on Campus Fees ViewList of all Courses on Campus fees to be posted to HEIMS. |
| SELECT CRFEE.INSTITUTION , CRFEE.ACAD_PROG , CRFEE.ACAD_PLAN , CRFEE.LOCATION , CRFEE.EFFDT , CRFEE.CRSE_FEE_EFFDT , CRFEE.SSR_CRSE_FEE_TYPE , CRFEE.SSR_IND_CSP_AMT , CRFEE.SSR_IND_TUI_FEE FROM PS_SSR_HM_COC_VW CRCM , PS_SSR_HEIMS_CR_FE CRFEE WHERE CRCM.INSTITUTION = CRFEE.INSTITUTION AND CRCM.ACAD_PROG = CRFEE.ACAD_PROG AND CRCM.ACAD_PLAN = CRFEE.ACAD_PLAN AND CRCM.LOCATION = CRFEE.LOCATION AND CRCM.EFFDT = CRFEE.EFFDT AND (CRFEE.CRSE_FEE_EFFDT = ( SELECT MAX(CRSE_FEE_EFFDT) FROM PS_SSR_HEIMS_CR_FE CRFEE2 WHERE CRFEE2.INSTITUTION = CRFEE.INSTITUTION AND CRFEE2.ACAD_PROG = CRFEE.ACAD_PROG AND CRFEE2.ACAD_PLAN = CRFEE.ACAD_PLAN AND CRFEE2.LOCATION = CRFEE.LOCATION AND CRFEE2.EFFDT = CRFEE.EFFDT AND CRFEE2.CRSE_FEE_EFFDT <= %CurrentDateIn) OR CRFEE.CRSE_FEE_EFFDT > %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: ACAD_PROG_TBL |
| 3 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table: ACAD_PLAN_TBL |
| 4 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location
Prompt Table: SSR_HEIMS_LOCVW |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | CRSE_FEE_EFFDT | Date(10) | DATE | Effective Date |
| 7 | SSR_CRSE_FEE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Course Fee Type (HEIMS)
0=Does not apply 1=CSP Only 2=Domestic Fee-paying only 3=CSP and Domestic Fee-paying |
| 8 | SSR_IND_CSP_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Indicative CSP Amount (HEIMS) |
| 9 | SSR_IND_TUI_FEE | Number(12,2) | DECIMAL(11,2) NOT NULL | Indicative Tuition Fee (HEIMS) |