Return to Navigation

Reviewing Report Data

After you run the extract process, you can view and edit the results by navigating to online pages that display the extract report results. However, you cannot add a new row of information for a student. If you need to add a row of data, you must add another line in the CAN_STDNT_LST table with its associated key field values and rerun the extract report.

Page Name

Definition Name

Navigation

Usage

PSIS Institution Description

CAN_RPT_ESIS_ID

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Institution Description, then select PSIS Institution Description

PSIS: Review institution term data.

Institution Program 1

CAN_RPT_ESIS_IP

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Institution Program, then select Institution Program 1

PSIS: Review institution and program code data.

Institution Program 2

CAN_RPT_ESIS_IP3

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Institution Program, then select Institution Program 2

PSIS: Review additional institution and program code data.

PSIS Institution Course

CAN_RPT_ESIS_IC

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Institution Course, then select PSIS Institution Course

PSIS: Review additional institution and program code data.

Student Descr 1 (student description 1)

CAN_RPT_ESIS_SD

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Description, then select Student Descr 1

PSIS: Review descriptive data for a student.

Student Descr 2 (student description 2)

CAN_RPT_ESIS_SD2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Description, then select Student Descr 2

PSIS: Review additional descriptive data for a student.

Student Descr 3 (student description 3)

CAN_RPT_ESIS_SD1

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Description, then select Student Descr 3

PSIS: Review additional descriptive data for a student.

Student Descr 4 (student description 4)

CAN_RPT_ESIS_SD3

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Description, then select Student Descr 4

PSIS: Review additional descriptive data for a student.

Student Descr 5 (student description 5)

CAN_RPT_ESIS_SD6

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Description, then select Student Descr 5

PSIS: Review additional descriptive data for a student.

Student Program 1

CAN_RPT_ESIS_SP

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Program, then select Student Program 1

PSIS: Review program related data for a student.

Student Program 2

CAN_RPT_ESIS_SP2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Program, then select Student Program 2

PSIS: Review additional program related data for a student.

Student Program 3

CAN_RPT_ESIS_SP3

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Program, then select Student Program 3

PSIS: Review additional program related data for a student.

Student Program 4

CAN_RPT_ESIS_SP4

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Program, then select Student Program 4

PSIS: Review additional program related data for a student.

Student Course 1

CAN_RPT_ESIS_SC

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Course, then select Student Course 1

PSIS: Review course related data for a student.

Student Course 2

CAN_RPT_ESIS_SC2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Course, then select Student Course 2

PSIS: Review additional course related data for a student.

Student Course 3

CAN_RPT_ESIS_SC3

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Course, then select Student Course 3

PSIS: Review additional course related data for a student.

Student Trans Cred 1

CAN_RPT_ESIS_ST

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Transfer Credits, then select Student Trans Cred 1

PSIS: Review receiving institution transfer coursework for a student.

Student Trans Cred 2

CAN_RPT_ESIS_ST2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select PSIS Student Transfer Credits, then select Student Trans Cred 2

PSIS: Review external institution transfer coursework for a student.

USISE Elements 1

CAN_USISE

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select USISE Elements, then select USISE Elements 1

USISE: Review USISE elements data for a student.

USISE Elements 2

CAN_USISE_2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select USISE Elements, then select USISE Elements 2

USISE: Review additional USISE elements data for a student.

CIS Elements 1

CAN_CIS

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select CIS Elements, then select CIS Elements 1

CIS: Review CIS elements for a student.

CIS Elements 2

CAN_CIS2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select CIS Elements, then select CIS Elements 2

CIS: Review additional CIS elements for a student.

CIS Elements 3

CAN_CIS1

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select CIS Elements, then select CIS Elements 3

CIS: Review additional CIS elements for a student.

MET Elements 1

CAN_USMET

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select MET Elements, then select MET Elements 1

MET: Review MET elements for a student.

MET Elements 2

CAN_USMET_2

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select MET Elements, then select MET Elements 2

MET: Review additional MET elements for a student.

MET Elements 3

CAN_USMET1

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select MET Elements, then select MET Elements 3

MET: Review additional MET elements for a student.

OUAC Elements

CAN_OUAC

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select OUAC Elements, then select OUAC Elements

OUAC: Review OUAC Elements for a student.