SSR_NZSCED_BROADCDPrompt Table: SSR_NZSCED_BRD
EFFDTDefault Value: SSR_NZSCED_BRD.EFFDT
Prompt Table: SSR_NZSCED_BRD
SSR_NZSCED_NAR_CDSSR_NZSCED_NAR(SQL Table) |
Index Back |
|---|---|
NZSCED Narrow 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_BRD |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: SSR_NZSCED_BRD.EFFDT Prompt Table: SSR_NZSCED_BRD |
| 3 | SSR_NZSCED_NAR_CD |
Character(2) | VARCHAR2(2) NOT NULL | NZSCED Narrow Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |