SSR_ETHNICITY_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: SSR_ETHNCTY_NZL.DESCR
SSR_ETHNCTY_NZL(SQL Table) |
Index Back |
|---|---|
Ethnicity Codes (New Zealand)Ethnicity codes as defined by the New Zealand Ministry of Education. These are used in the Single Data Return (SDR) file provided by institutions to the Ministry of Education |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ETHNICITY_CODE |
Character(3) | VARCHAR2(3) NOT NULL | Ethnicity codes as defined by the New Zealand Ministry of Education |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SSR_ETHNCTY_NZL.DESCR |