SSR_NZSCED_BROADCDPrompt Table: SSR_NZSCED_NAR
EFFDTSSR_NZSCED_NAR_CDPrompt Table: SSR_NZSCED_NAR
SSR_NZSCED_DTL_CDPrompt Table: SSR_FUNDING_CAT
SSR_NZSCED_DET(SQL Table) |
Index Back |
|---|---|
NZSCED Detailed Field of Study |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_NZSCED_BROADCD |
Character(2) | VARCHAR2(2) NOT NULL |
NZSCED Broad Code
Prompt Table: SSR_NZSCED_NAR |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | SSR_NZSCED_NAR_CD |
Character(2) | VARCHAR2(2) NOT NULL |
NZSCED Narrow Code
Prompt Table: SSR_NZSCED_NAR |
| 4 | SSR_NZSCED_DTL_CD |
Character(2) | VARCHAR2(2) NOT NULL | NZSCED detailed field of study code |
| 5 | SSR_NZSCED_DTL | Character(6) | VARCHAR2(6) NOT NULL | The full six digit NZSCED detailed field of study code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | 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.
Prompt Table: SSR_FUNDING_CAT |