INSTITUTIONPrompt Table: INSTITUTION_TBL
ACAD_PROGPrompt Table: ACAD_PROG_TBL
ACAD_PLANPrompt Table: ACAD_PLAN_TBL
LOCATIONPrompt Table: SSR_HEIMS_LOCVW
0=Does not apply
1=CSP Only
2=Domestic Fee-paying only
3=CSP and Domestic Fee-paying
SSR_HEIMS_CFVW(SQL View) |
Index Back |
|---|---|
Course FeeCourse Fee (HEIMS) |
| SELECT INSTITUTION , ACAD_PROG , ACAD_PLAN , LOCATION , CRSE_FEE_EFFDT , SSR_CRSE_FEE_TYPE , SSR_IND_CSP_AMT , SSR_IND_TUI_FEE , SSR_INTIND_TUI_FEE FROM %Table(SSR_HEIMS_CR_FE) A WHERE %EffdtCheck(SSR_HEIMS_CR_FE, A, %CURRENTDATEIN) AND CRSE_FEE_EFFDT = ( SELECT MAX(CRSE_FEE_EFFDT) FROM %Table(SSR_HEIMS_CR_FE) WHERE INSTITUTION = A.INSTITUTION AND ACAD_PROG=A.ACAD_PROG AND ACAD_PLAN=A.ACAD_PLAN AND LOCATION=A.LOCATION AND EFFDT=A.EFFDT) |
| # | 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 Code
Prompt Table: SSR_HEIMS_LOCVW |
| 5 | CRSE_FEE_EFFDT | Date(10) | DATE | Effective Date |
| 6 | 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 |
| 7 | SSR_IND_CSP_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Indicative CSP Amount (HEIMS) |
| 8 | SSR_IND_TUI_FEE | Number(12,2) | DECIMAL(11,2) NOT NULL | Indicative Tuition Fee (HEIMS) |
| 9 | SSR_INTIND_TUI_FEE | Number(12,2) | DECIMAL(11,2) NOT NULL | International Indicative Tuition Fee |