ETHNIC_GRP_CDPrompt Table: SSR_ETHGRP_NZVW
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: SSR_ETHNCTY_NZL
SSR_ETHNIC_MAP(SQL Table) |
Index Back |
|---|---|
Ethnicity Map New ZealandThis record maps the ethnicity codes defined by the New Zealand Ministry of Education to the base Peoplesoft ethnicity codes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ETHNIC_GRP_CD |
Character(8) | VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table: SSR_ETHGRP_NZVW |
| 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 | SSR_ETHNICITY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Ethnicity codes as defined by the New Zealand Ministry of Education
Prompt Table: SSR_ETHNCTY_NZL |