| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
Prompt Table:
CRSE_CATALOG
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
CRSE_OFFER_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Course Offering Nbr
|
| 4 |
SSR_CRSE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies the way the EFTS factor is calculated for the course.
A=Type A - Program EFTS
B=Type B - Hourly EFTS
|
| 5 |
SSR_NZSCED_DTL |
Character(6) |
VARCHAR2(6) NOT NULL |
The full six digit NZSCED detailed field of study code
Prompt Table:
SSR_NZSCED_VW
|
| 6 |
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
|
| 7 |
SSR_NQF_CREDIT |
Number(3,0) |
SMALLINT NOT NULL |
The credit value of the course on the National Qualification Framework.
|
| 8 |
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.
|
| 9 |
SSR_MAIN_PROGRAM |
Character(5) |
VARCHAR2(5) NOT NULL |
The main program that a course is associated with.
Prompt Table:
ACAD_PROG_TBL
|
| 10 |
SSR_CRSE_HOURS |
Number(4,0) |
SMALLINT NOT NULL |
Number of hours for the course. This is used to calculate the EFTS factor for type B courses.
|
| 11 |
SSR_CRSE_CLASIF |
Character(4) |
VARCHAR2(4) NOT NULL |
BBWW6YW - SDR ver 2.00 changes. It is course classification field.
Prompt Table:
SSR_CRSCLASF_VW
|
| 12 |
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_CLSF_FND_VW
|
| 13 |
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
Prompt Table:
PSXLATITEM
|
| 14 |
SSR_AVERGE_CRS_FEE |
Number(5,0) |
INTEGER NOT NULL |
Average Course Fee
|
| 15 |
SSR_ELEARN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
eLearning Status which is used to derive the INTERNET field on SDR Course Register File
Prompt Table:
SSR_ELEARN_TBL
|
| 16 |
SSR_FOREIGN_FEE |
Number(5,0) |
INTEGER NOT NULL |
Tuition Fee paid by Foreign Fee Paying Student for SDR (NZL)
|
| 17 |
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
Default Value: X
|
| 18 |
SSR_CCCOSTS_FEE |
Number(5,0) |
INTEGER NOT NULL |
Compulsory Course Costs for NZL SDR reporting.
Default Value: 0
|
| 19 |
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
Default Value: 2
|
| 20 |
SSR_EMB_LITERACY |
Character(1) |
VARCHAR2(1) NOT NULL |
SDR NZL Embedded Literacy
Y/N Table Edit
Default Value: N
|
| 21 |
SSR_VRF_NZL |
Number(6,4) |
DECIMAL(5,4) NOT NULL |
VRF
|