SSR_CRSE_CLASIFEFFDTSSR_FUNDING_CODEDefault Value: SSR_FUNDING_CAT.SSR_FUNDING_CODE
Prompt Table:
SSR_FUNDING_CAT
Set Control Field: DESCR
LANGUAGE_CDSSR_CLSFND_VWLN(SQL View) |
Index Back |
|---|---|
Valid funding for course classRelated Language view - prompt against course classification. |
| SELECT A.SSR_CRSE_CLASIF , A.EFFDT , A.SSR_FUNDING_CODE , B.LANGUAGE_CD , B.DESCR FROM PS_SSR_C_CLSF_FNDC A , PS_SSR_FUND_CAT_LN B WHERE A.SSR_FUNDING_CODE = B.SSR_FUNDING_CODE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SSR_FUND_CAT_LN B1 WHERE B1.SSR_FUNDING_CODE = B.SSR_FUNDING_CODE AND B1.LANGUAGE_CD = B.LANGUAGE_CD AND B1.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_CRSE_CLASIF |
Character(4) | VARCHAR2(4) NOT NULL | BBWW6YW - SDR ver 2.00 changes. It is course classification field. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | SSR_FUNDING_CODE |
Character(2) | VARCHAR2(2) NOT NULL |
Code defined by the New Zealand Ministry of Education to identify courses that are funded at the same level.
Default Value: SSR_FUNDING_CAT.SSR_FUNDING_CODE Prompt Table:
SSR_FUNDING_CAT
|
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |