SSR_NZSCED_VW(SQL View) |
Index Back |
---|---|
Prompt table for NZSCED Detail |
SELECT A.SSR_NZSCED_DTL , A.EFFDT , A.DESCR , A.SSR_NZSCED_BROADCD , A.SSR_NZSCED_NAR_CD , A.SSR_NZSCED_DTL_CD FROM PS_SSR_NZSCED_DET A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_NZSCED_DTL | Character(6) | VARCHAR2(6) NOT NULL | The full six digit NZSCED detailed field of study code |
2 | EFFDT | Date(10) | DATE | Effective Date |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | SSR_NZSCED_BROADCD | Character(2) | VARCHAR2(2) NOT NULL |
NZSCED Broad Code
Prompt Table: SSR_NZSCED_BRD |
5 | SSR_NZSCED_NAR_CD | Character(2) | VARCHAR2(2) NOT NULL |
NZSCED Narrow Code
Prompt Table: SSR_NZSCED_NAR |
6 | SSR_NZSCED_DTL_CD | Character(2) | VARCHAR2(2) NOT NULL | NZSCED detailed field of study code |