SSR_ENRQDTL_NZL

(SQL Table)
Index Back

Enrollment Req Detail - NZL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
2 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence
3 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
4 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.
5 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_FUNDING_CAT

6 SSR_CRSE_CLASIF Character(4) VARCHAR2(4) NOT NULL BBWW6YW - SDR ver 2.00 changes. It is course classification field.

Prompt Table: SSR_CRSE_CLASIF