| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCC_TEMP_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Temp Constituent ID
|
| 2 |
SCC_PRI_ACTIVITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Student's activity prior ro enroling at the institution
01=Secondary School Student
02=Unemployed or Beneficiary
03=Wage or Salary Worker
04=Self Employeed
05=University Student
06=Polytechnic Student
07=College of Education Student
09=Overseas
11=Private Training Establishment
12=Wananga Student
99=Other
|
| 3 |
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.
|
| 4 |
SCC_HIGH_SEC_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest secondary school qualification
00=No Secondary Qualification
01=School Certificate
02=Sixth Form Certificate
03=University Entrance
04=Higher School Certificate
05=Entrance Qual from Bursary
07=A or B Bursary
08=University Scholarship
09=Overseas Qualification
98=Other
99=Unknown
|
| 5 |
SSR_NZQA_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
NZQA Report Flag
Y/N Table Edit
Default Value: N
|
| 6 |
SCC_NSN |
Number(10,0) |
DECIMAL(10) NOT NULL |
National Student Number (NZL)
|
| 7 |
SCC_STDNT_STAT_NSI |
Character(1) |
VARCHAR2(1) NOT NULL |
NSI Record Status (NZL)
A=Active
I=Inactive
P=Partial
|
| 8 |
SCC_RESIDENTL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSI Residential Status
A=Australian Citizen
C=Citizen
O=Overseas
P=Permanent Resident
U=Unknown
|
| 9 |
SSR_NZQA_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
NZQA Paid
N=No
U=Not Applicable or Not Known
Y=Yes
|
| 10 |
SCC_NM_DOB_VERFCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Name/DOB Verification for NSI (NZL)
B=Birth Certificate
M=BDM
O=Other Primary ID
P=Passport
U=Unverified
|
| 11 |
SCC_NM_DOB_VERF_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Name/DOB Verified By for NSI (NZL)
|
| 12 |
SCC_RES_ST_VERFCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Residential Stat Verification for NSI (NZL)
B=Birth Certificate
M=BDM
O=Other Primary ID
P=Passport
U=Unverified
|
| 13 |
SCC_RES_ST_VERF_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Residential Status Verified By for NSI
|
| 14 |
SCC_PROC_ENABL_NSI |
Character(1) |
VARCHAR2(1) NOT NULL |
NSI Processing Enabled (NZL)
Y/N Table Edit
Default Value: N
|
| 15 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 16 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 17 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 18 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|