SSR_SDR_EXTRACT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_EXTRACT_DATE	Date(10)	DATE	Extract Date work field for SDR extract.
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
3	SSR_SDR_FILE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Extract File Type work field for SDR extract.
4	SSR_MOE_INST_ID	Character(4)	VARCHAR2(4) NOT NULL	New Zealand Ministry of Education
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
7	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
8	SSR_STUDENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Student Type work field for SDR extract.
9	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	SSR_ETHNIC	Character(9)	VARCHAR2(9) NOT NULL	Ethnicity work field for SDR extract.
12	SSR_NAMEID	Character(5)	VARCHAR2(5) NOT NULL	Name work field for SDR extract.
13	SSR_PRIOR_A	Character(2)	VARCHAR2(2) NOT NULL	Prior Activity work field for SDR extract.
14	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.
15	SSR_S_SCHOOL	Character(4)	VARCHAR2(4) NOT NULL	Last School work field for SDR extract.
16	SSR_Y_SCHOOL	Character(4)	VARCHAR2(4) NOT NULL	Last Year at School work field for SDR extract.
17	SSR_SEC_QUAL	Character(2)	VARCHAR2(2) NOT NULL	Highest School Qualification work field for SDR extract.
18	SSR_CITIZEN	Character(3)	VARCHAR2(3) NOT NULL	Citizenship work field for SDR extract.
19	SSR_ASSIST	Character(2)	VARCHAR2(2) NOT NULL	Assistance Category work field for SDR extract.
20	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.
21	FINISH	Character(1)	VARCHAR2(1) NOT NULL	Finish
22	SSR_IWI	Character(12)	VARCHAR2(12) NOT NULL	SDR Iwi Affiliation
23	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.
24	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
25	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
26	SSR_CTITLE	Character(30)	VARCHAR2(30) NOT NULL	Course Title work field for SDR extract.
27	START_DT	Date(10)	DATE	Start Date
28	END_DT	Date(10)	DATE	end date
29	SSR_CRS_WTD	Date(10)	DATE	Withdrawal Date work field for SDR extract.
30	SSR_EXTRAMURAL	Character(1)	VARCHAR2(1) NOT NULL	Course Delivery Method. This field is used in the New Zealand Ministry of Education Single Data Return. 1=Intramural 2=Extramural in NZ 3=Extramural Overseas 4=Intramural Overseas
31	SSR_CRSE_SITE	Character(2)	VARCHAR2(2) NOT NULL	Course Site work field for SDR extract.
32	SAD_FUNDING_SRC	Character(2)	VARCHAR2(2) NOT NULL	The source of funding for a student's enrolment 01=Universal Tertiary Tuition All 02=Full Fee Foreign Student 03=Full Fee Domestic Student 04=MOE-Supplementary Grants 05=STAR Funded 06=Training Opportunities (WINZ) 07=Youth Training (Skill NZ) 08=Skills Enhancement (Skill NZ) 09=Prison Education 10=Ministry of Health 11=ITO Off Job Training (Skill NZ 12=Other Contracts 13=English for Migrants (SkillNZ) 14=Primary Pre-service Teacher Ed 15=Secondary Pre-service Teacher 16=Youth Action Training Prog 20=Min Foreign Affairs and Trade
33	SSR_STUDYRT	Character(1)	VARCHAR2(1) NOT NULL	Study Right work field for SDR extract.
34	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.
35	SSR_CLASS	Character(4)	VARCHAR2(4) NOT NULL	Course Classification work field for SDR extract.
36	SSR_NZSCED_DTL	Character(6)	VARCHAR2(6) NOT NULL	The full six digit NZSCED detailed field of study code
37	SSR_NQF_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	The level of the course on the New Zealand National Qualification Framework. 0=No Level Registered on NQF 1=Level 1 2=Level 2 3=Level 3 4=Level 4 5=Level 5 6=Level 6 7=Level 7 8=Level 8 9=Level 9
38	SSR_NQF_CREDIT	Number(3,0)	SMALLINT NOT NULL	The credit value of the course on the National Qualification Framework.
39	SSR_EFTS_FACTOR	Number(6,4)	DECIMAL(5,4) NOT NULL	The EFTS factor is the proportion of a full time years study that the course (or course enrolment) represents.
40	SSR_EFTS_MTH	Character(84)	VARCHAR2(84) NOT NULL	EFTS by Month work field for SDR extract.
41	SSR_STAGE	Character(2)	VARCHAR2(2) NOT NULL	BBWW6YW, SDR ver 2.0, made this field translate to support SDR changes. 01=First stage of programme 02=Second stage of programme 03=Third stage of programme 04=Fourth stage of programme
42	SSR_MAIN_1	Character(4)	VARCHAR2(4) NOT NULL	Main Subject One work field for SDR extract.
43	SSR_MAIN_2	Character(4)	VARCHAR2(4) NOT NULL	Main Subject Two work field for SDR extract.
44	SSR_MAIN_3	Character(4)	VARCHAR2(4) NOT NULL	Main Subject Three work field for SDR extract.
45	SSR_IRD_NBR	Character(9)	VARCHAR2(9) NOT NULL	This is the equivalent to the tax file no of Australia. This will uniquely identify the employee to the Inland Revenue Department of New Zealand. The 1st digit is always zero and the 9th digit is the check digit.
46	SSR_AVERGE_CRS_FEE	Number(5,0)	INTEGER NOT NULL	Average Course Fee
47	SSR_VIA_INTERNET	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate if a course is available in part or as a whole via the internet. For SDR Course Register. 1=No Access 2=Web-Supported 3=Web-Enhanced 4=Web-Based N=N N=N Y=Y Y=Y
48	SCC_NSN	Number(10,0)	DECIMAL(10) NOT NULL	National Student Number (NZL)
49	SSR_DIS_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Disability Services Accessed Indicator for the SDR Student File
50	SSR_FOREIGN_FEE	Number(5,0)	INTEGER NOT NULL	Tuition Fee paid by Foreign Fee Paying Student for SDR (NZL)
51	SSR_MAX_EXEMPT_FEE	Number(5,0)	INTEGER NOT NULL	Maximum Exempt Fees for SDR Reporting (NZL)
52	SSR_PBRF_ELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	Indicates if course is eligible for PBRF (Performance Based Research Fund) funding. Used in NZ and reported in the Course register file in SDR. C=Part-time Doctorate D=Doctorate L=Part-time Masters M=Masters X=Not PBRF Eligible
53	SSR_CCCOSTS_FEE	Number(5,0)	INTEGER NOT NULL	Compulsory Course Costs for NZL SDR reporting.
54	SSR_EXEMPT_IND	Character(1)	VARCHAR2(1) NOT NULL	Course Exemption from FCCM (Fee/Course Costs Maxima) for SDR reporting (NZL) 1=Granted Exemption from PCCM 2=No Exemption from FCCM
55	YR_REQ_MET	Number(4,0)	SMALLINT NOT NULL	Year Requirements Met
56	EMB_LIT_NUM	Character(1)	VARCHAR2(1) NOT NULL	Embedded Literacy and Numeracy
57	PBRF_CRS_COMP_YR	Number(8,0)	INTEGER NOT NULL	PBRF Course Completion Year
58	PERM_POST_CODE	Character(4)	VARCHAR2(4) NOT NULL	Permanent Post Code
59	TERM_POST_CODE	Character(4)	VARCHAR2(4) NOT NULL	Term Post Code
60	SSR_RESIDENCY_CODE	Character(1)	VARCHAR2(1) NOT NULL	Residency Code N=No Y=Yes
61	SSR_AUST_RESIDENCY	Character(1)	VARCHAR2(1) NOT NULL	Australian Residency for SDR - NZL N=No Y=Yes