SSR_INSTIT_NZL (SQL Table)	Index Back
Institution - NZ This is a sibling table of INSTITUTION_TBL used to store all the New Zealand specific institution data.

SSR_INSTIT_NZL

(SQL Table)

Institution - NZ

This is a sibling table of INSTITUTION_TBL used to store all the New Zealand specific institution data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 SSR_MOE_INST_ID Character(4) VARCHAR2(4) NOT NULL New Zealand Ministry of Education

4 SSR_EFTS_TRANS_A Number(8,6) DECIMAL(7,6) NOT NULL This translation factor is used to calculate the EFTS factor for type A courses.

5 SSR_EFTS_TRANS_B Number(7,5) DECIMAL(6,5) NOT NULL This translation factor is used to calculate the EFTS factor for type B courses.

6 SSR_ENRL_UNIT_STDS Character(1) VARCHAR2(1) NOT NULL Unit Standard Enrol
Y/N Table Edit
Default Value: N

7 SSR_NZVCC_INST_CD Character(1) VARCHAR2(1) NOT NULL Institution code as defined by the New Zealand Vice Chancellors Committee (eg "A" for University of Auckland).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	SSR_MOE_INST_ID	Character(4)	VARCHAR2(4) NOT NULL	New Zealand Ministry of Education
4	SSR_EFTS_TRANS_A	Number(8,6)	DECIMAL(7,6) NOT NULL	This translation factor is used to calculate the EFTS factor for type A courses.
5	SSR_EFTS_TRANS_B	Number(7,5)	DECIMAL(6,5) NOT NULL	This translation factor is used to calculate the EFTS factor for type B courses.
6	SSR_ENRL_UNIT_STDS	Character(1)	VARCHAR2(1) NOT NULL	Unit Standard Enrol Y/N Table Edit Default Value: N
7	SSR_NZVCC_INST_CD	Character(1)	VARCHAR2(1) NOT NULL	Institution code as defined by the New Zealand Vice Chancellors Committee (eg "A" for University of Auckland).