Return to Navigation

Loading the Student ID Table

This section discusses how to load the student data.

Page Name

Definition Name

Navigation

Usage

Student List

CAN_STDNT_LST

select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select Student List, then select Student List

All: Load student data to prepare for the extract process.

Access the Student List page (select Records and Enrollment, then select Government Reporting Canada, then select Suspense Tables, then select Student List, then select Student List).

Image: Student List page

This example illustrates the fields and controls on the Student List page. You can find definitions for the fields and controls later on this page.

Student List page

Each institution's business practices and interpretation of the published government rules result in different criteria for selecting students for reporting. To initiate the reporting process, you must populate (either manually or through a user-defined process) the PeopleSoft provided Student List component with the eligible students you want to report. The Student List component contains the fields listed below. You must populate each field for every row in this component; otherwise the reports extract process will exclude the row and the process may fail.

Field or Control

Definition
Institution

Enter the institution for which you want to report.
Report Type

Enter the report type you want to use.
Report Period

Enter the report period.
Student ID

Enter the student ID for the student you want to report.
Acad Career (academic career)

Enter the academic career you want to report for the student. You can insert an additional row to report multiple careers, programs, or plans.
Acad Program (academic program)

Enter the academic program you want to report for the student.
Acad Plan (academic plan)

Enter the academic plan you want to report for the student.
Select

Select this check box to identify a subset of students for whom you want to run the extract and flat file process. The extract process adds or replaces reporting data for these students. The system clears this check box after you run the extract process for this report. At runtime, you can specify to run the process for only those students who have the Select option selected.
Field Name

Enter a row for each field name that you need for this report. For example, STDNT_CAR_NBR. This is the key data referred to in the following Loading the Student Key Data subtopic.
Field Value

Enter a field value that corresponds to each field name value. The report extract process uses this data. For example, 0.

The system calculates elements for each row of the table. There is a one to one relationship between a row on the Student List page and a row on any one of the tables that enable you to view the information calculated by the extract program. If a student has more than one row on the Student List page, the system treats each row as if it is for a new student when retrieving the element values for the row.

Loading the Student Key Data

In addition to entering data in all of the header fields, different government reports require that you also enter various types of key data. Use the following table to determine which fields and corresponding field values you must populate before you run the extract process:

Field Name

Required by Report Type

ACAD_CAREER

ALL

ACAD_PROG

ALL

ACAD_PLAN

ALL

ACAD_SUB_PLAN

CIS

ADM_APPL_NBR

OUAC

AID_YEAR

CIS, PSIS

APPL_PROG_NBR

OUAC

EFFECTIVE_TERM

CIS, PSIS, MET, USISE

EFFSEQ

OUAC

SESSION_CODE

CIS, MET, OUAC, USISE

STDNT_CAR_NBR

ALL

STRM

ALL

Note: Enter the latest STRM value for the student for the applicable report type and report period. For example, if the report includes terms for Spring 99 and Fall 99, enter the term representing Fall 99 as the STRM value, assuming that the student was enrolled in both terms.