SSR_ACD_PRG_NZL (SQL Table)	Index Back
Academic Program - NZ This is a sibling table of ACAD_PROG_TBL used to store the New Zealand specific academic program details.

SSR_ACD_PRG_NZL

(SQL Table)

Academic Program - NZ

This is a sibling table of ACAD_PROG_TBL used to store the New Zealand specific academic program details.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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_PROG_TYPE_CODE Character(3) VARCHAR2(3) NOT NULL This field is used to different program types. The amount of detail provided by an instittution to the New Zealand Ministry of Education in the Single Data Return (SDR) is controlled by this field (amongst others).
COM=Community Education
CPI=Cert of Personal Interest
NOR=Normal
Default Value: NOR

6 SSR_WINZ_FUND Character(1) VARCHAR2(1) NOT NULL WINZ Funding
A=Allowance Only
B=Loans and Allowances
L=Loans Only
N=Not Funded
Default Value: B

7 SSR_CRSE_CLASIF Character(4) VARCHAR2(4) NOT NULL BBWW6YW - SDR ver 2.00 changes. It is course classification field.
Prompt Table: SSR_CRSCLASF_VW

8 SSR_FUNDING_CODE Character(2) VARCHAR2(2) NOT NULL Code defined by the New Zealand Ministry of Education to identify courses that are funded at the same level.
Prompt Table: SSR_CLSF_FND_VW

9 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

10 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
01=No Formal Education
02=Elementary School Completed
03=Some High School
04=High School Graduate
05=Terminal Occupation Prog DNC
06=Terminal Occupation Program
07=Some College - Less than 1 Yr
08=One Year College
09=Two Years College
10=Associate Degree
11=Three Years College
12=Four Years College
13=Bachelor Degree
14=Post Bachelors
15=First Professional
16=Post-first Professional
17=Master's Degree
18=Post Master's
19=Sixth-year Degree
20=Post-sixth Year
21=Doctorate Degree
22=Post-Doctorate
A=University - Advanced
T=Trade School
U=University

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
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_PROG_TYPE_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field is used to different program types. The amount of detail provided by an instittution to the New Zealand Ministry of Education in the Single Data Return (SDR) is controlled by this field (amongst others). COM=Community Education CPI=Cert of Personal Interest NOR=Normal Default Value: NOR
6	SSR_WINZ_FUND	Character(1)	VARCHAR2(1) NOT NULL	WINZ Funding A=Allowance Only B=Loans and Allowances L=Loans Only N=Not Funded Default Value: B
7	SSR_CRSE_CLASIF	Character(4)	VARCHAR2(4) NOT NULL	BBWW6YW - SDR ver 2.00 changes. It is course classification field. Prompt Table: SSR_CRSCLASF_VW
8	SSR_FUNDING_CODE	Character(2)	VARCHAR2(2) NOT NULL	Code defined by the New Zealand Ministry of Education to identify courses that are funded at the same level. Prompt Table: SSR_CLSF_FND_VW
9	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
10	EDUCATION_LVL	Character(2)	VARCHAR2(2) NOT NULL	Education Level 01=No Formal Education 02=Elementary School Completed 03=Some High School 04=High School Graduate 05=Terminal Occupation Prog DNC 06=Terminal Occupation Program 07=Some College - Less than 1 Yr 08=One Year College 09=Two Years College 10=Associate Degree 11=Three Years College 12=Four Years College 13=Bachelor Degree 14=Post Bachelors 15=First Professional 16=Post-first Professional 17=Master's Degree 18=Post Master's 19=Sixth-year Degree 20=Post-sixth Year 21=Doctorate Degree 22=Post-Doctorate A=University - Advanced T=Trade School U=University
11	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