SSR_DEGREE_NZL

(SQL Table)
 Index Back

Degree - New Zealand

This is a sibling table of DEGREE_TBL used to isolate the New Zealand specific degree data.

  • Parent record: DEGREE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SSR_NZVCC_QUALFCTN Character(3) VARCHAR2(3) NOT NULL This field defines the New Zealand Vice Chancellors' Committee (NZVCC) qualification degree code.

    Prompt Table: SSR_NZVCC_DEGR
    Set Control Field: SSR_NZVCC_QUALFCTN

    4 SSR_PROSPECTUS_CD Character(6) VARCHAR2(6) NOT NULL The code that identifies a program or qualification on the New Zealand Ministry of Education Prospectus Database.
    5 SSR_RPT_TO_MOE Character(1) VARCHAR2(1) NOT NULL BBWW6YW - SDR ver 2.0 . This field indicates if a degree is reported to NZL MOE or not.

    Y/N Table Edit

    Default Value: Y

    6 SSR_QUAL_AWD_CD Character(2) VARCHAR2(2) NOT NULL Qualification Award Category
    01=Higher Doctorate
    10=PhD and Other Doctorates
    11=Masters
    12=Bachelors with Honours
    13=Post Graduate Diplomas
    14=Post Graduate Certificates
    20=Bachelors
    21=Grad Diploma/Cert
    25=Cert of Proficiency (Degree)
    31=National Diploma Level 5-7
    32=New Zealand Diploma
    33=Diploma/Cert issued by TEO
    35=New Zealand Certificate
    36=National/TEO/New Zealand Lev 4
    37=Cert of Proficiency (Diploma)
    40=Professional Assoc Diploma
    41=National/New Zealand Level 1-3
    46=Certificate issued by TEO
    60=Licence
    90=Personal Interest/Professional
    96=STAR
    97=Programmes of study (Contract)
    98=Programmes of study (Unit)
    99=Community Ed Programmes