SSR_HM_CCF_VW(SQL View) |
Index Back |
|---|---|
Campus Course Fee view |
| SELECT CCF.INSTITUTION ,CCF.ACAD_PROG ,CCF.ACAD_PLAN ,CCF.LOCATION ,CCF.EFFDT ,CCF.CRSE_FEE_EFFDT ,CCF.SSR_CRSE_FEE_TYPE ,CCF.SSR_IND_CSP_AMT ,CCF.SSR_IND_TUI_FEE ,CCF.SSR_INTIND_TUI_FEE FROM PS_SSR_HEIMS_CR_FE CCF |
| # | 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_FROM |
Date(10) | DATE NOT NULL |
Effective Date From
Default Value: %date |
| 6 | CRSE_FEE_EFFDT |
Date(10) | DATE NOT NULL | 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) |
| 10 | SSR_INTIND_TUI_FEE | Number(12,2) | DECIMAL(11,2) NOT NULL | International Indicative Tuition Fee |