| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 3 |
ROWS_RETRIEVED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Rows Retrieved
|
| 4 |
SAA_ROW_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
This field is a row counter used by academic advisement.
|
| 5 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 6 |
SCC_AUS_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Australia Features
|
| 7 |
SCC_NZL_ENR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable New Zealand Features
|
| 8 |
SCC_NZL_NZQA |
Character(1) |
VARCHAR2(1) NOT NULL |
NZQA
|
| 9 |
SCC_HE_USED_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Higher Education
|
| 10 |
SAD_SL_PARTICIPANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Studielink Participant
|
| 11 |
SAD_ATTEND_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode of Attendance
1=Internal Mode of Attendance
2=External Mode of Attendance
3=Multi-modal Mode of Attendance
4=Completed Course through OUA
5=Submission of Original Work
6=Employer based
7=Completed Course except in OUA
|
| 12 |
SSR_COHORT_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Cohort Year
|
| 13 |
SSR_DEEWR_FUND_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Funding Source
|
| 14 |
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
|