SCC_PERSONL_NZL

(SQL Table)
Index Back

Personal Data - New Zealand

This is a sibling record for PERSONAL_DATA that contains the NZ specific personal data fields.

  • Parent record: PERSONAL_DATA
  • # 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