SSR_NZSCED_BROADCDPrompt Table: SSR_NZSCED_NAR
EFFDTSSR_NZSCED_NAR_CDPrompt Table: SSR_NZSCED_NAR
SSR_NZSCED_DTL_CDLANGUAGE_CDSSR_NZSCDDET_LN(SQL Table) |
Index Back |
|---|---|
NZSCED Detail Rel LangRelated Language Record for NZSCED Detailed Field of Study Table. |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |