SCC_PERSONL_NZL(SQL Table) |
Index Back |
---|---|
Personal Data - New ZealandThis is a sibling record for PERSONAL_DATA that contains the NZ specific personal data fields. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | SCC_PRI_ACTIVITY | Character(2) | VARCHAR2(2) NOT NULL |
Student's activity prior ro enroling at the institution
01=Secondary School Student 02=Unemployed or Beneficiary 03=Wage or Salary Worker 04=Self Employeed 05=University Student 06=Polytechnic Student 07=College of Education Student 09=Overseas 11=Private Training Establishment 12=Wananga Student 99=Other |
3 | SSR_FRSTYR_FRML_ED | Character(4) | VARCHAR2(4) NOT NULL | The first year of formal education. Used in the Single Data return provided to the New Zealand Ministry of Education. |
4 | SCC_HIGH_SEC_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
Highest secondary school qualification
00=No Secondary Qualification 01=School Certificate 02=Sixth Form Certificate 03=University Entrance 04=Higher School Certificate 05=Entrance Qual from Bursary 07=A or B Bursary 08=University Scholarship 09=Overseas Qualification 98=Other 99=Unknown |
5 | SSR_NZQA_RPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
NZQA Report Flag
Y/N Table Edit Default Value: N |
6 | SCC_NSN | Number(10,0) | DECIMAL(10) NOT NULL | National Student Number (NZL) |
7 | SCC_STDNT_STAT_NSI | Character(1) | VARCHAR2(1) NOT NULL |
NSI Record Status (NZL)
A=Active I=Inactive P=Partial |
8 | SCC_RESIDENTL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
NSI Residential Status
A=Australian Citizen C=Citizen O=Overseas P=Permanent Resident U=Unknown |
9 | SSR_NZQA_PAID | Character(1) | VARCHAR2(1) NOT NULL |
NZQA Paid
N=No U=Not Applicable or Not Known Y=Yes |
10 | SCC_NM_DOB_VERFCTN | Character(1) | VARCHAR2(1) NOT NULL |
Name/DOB Verification for NSI (NZL)
B=Birth Certificate M=BDM O=Other Primary ID P=Passport U=Unverified |
11 | SCC_NM_DOB_VERF_BY | Character(4) | VARCHAR2(4) NOT NULL | Name/DOB Verified By for NSI (NZL) |
12 | SCC_RES_ST_VERFCTN | Character(1) | VARCHAR2(1) NOT NULL |
Residential Stat Verification for NSI (NZL)
B=Birth Certificate M=BDM O=Other Primary ID P=Passport U=Unverified |
13 | SCC_RES_ST_VERF_BY | Character(4) | VARCHAR2(4) NOT NULL | Residential Status Verified By for NSI |
14 | SCC_PROC_ENABL_NSI | Character(1) | VARCHAR2(1) NOT NULL |
NSI Processing Enabled (NZL)
Y/N Table Edit Default Value: N |