Return to Navigation

Defining General Mapping Tables

To set up general mapping tables, use the Language Mapping component (CAN_RPT_TONGUE), Province Mapping component (CAN_RPT_PROV), Reporting Sequence Mapping component (CAN_RPT_SEQ), Term Group Mapping component (CAN_RPT_TERM_GRP), OUAC Applno Mapping component (CAN_RPT_APPLNO), Classification Mapping component (CAN_RPT_CM), Direct Mapping component (CAN_RPT_DM), Master Mapping component (CAN_RPT_MM), and the Separate Mapping component (CAN_RPT_SM).

This section discusses how to:

Page Name

Definition Name

Navigation

Usage

Language Mapping

CAN_RPT_TONGUE

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Language Mapping, then select Language Mapping

CIS, PSIS, MET, USISE: Map language codes.

Province Mapping

CAN_RPT_PROV

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Province Mapping, then select Province Mapping

CIS, MET, USISE: Review PeopleSoft delivered province codes.

Reporting Sequence Mapping

CAN_RPT_SEQ

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Reporting Sequence Mapping, then select Reporting Sequence Mapping

USISE (Optional): Define a record and reporting sequence for the USISE report type. Populate this page to limit your USIS Enrollment file to only one record per student from the CAN_STDNT_LST table.

Term Group Mapping

CAN_RPT_TERM_GRP

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Term Group Mapping, then select Term Group Mapping

ALL: For each report type, report period, and career, map the applicable terms and sessions that you want to report.

OUAC Applno Mapping (OUAC application number mapping)

CAN_RPT_APPLNO

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select OUAC Applno Mapping, then select OUAC Applno Mapping

OUAC: Review delivered OUAC application numbers.

Classification Mapping

CAN_RPT_CM

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Classification Mapping Table, then select Classification Mapping

PSIS: Define classification mapping values.

Direct Mapping

CAN_RPT_DM

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Direct Mapping Table, then select Direct Mapping

CIS, PSIS, USISE: Define direct mapping values.

Master Mapping

CAN_RPT_MM

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Master Mapping Table, then select Master Mapping

CIS, PSIS, USISE, OUAC: Define master mapping values.

Separate Mapping

CAN_RPT_SM

select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Separate Mapping Table, then select Separate Mapping

CIS, PSIS, OUAC, USISE: Define separate mapping values.

Access the Language Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Language Mapping, then select Language Mapping).

Field or Control

Definition
Language Code

Enter the PeopleSoft language code that you want to map.
CIS Tongue

Enter the corresponding CIS value for the language code. Map this field if your institution performs CIS reporting. This field prompts against the CAN_CIS_LANG record.
Tongue

Enter the corresponding USISE value for the language code. Map this field if your institution performs USISE or MET reporting.
PSIS Language

Enter the corresponding PSIS value for the language code. Map this field if your institution performs PSIS reporting. This field prompts against the CAN_GOV_LANG record.

Access the Province Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Province Mapping, then select Province Mapping).

Field or Control

Definition
Province

The PeopleSoft province value that you want to map.
Province Number

The province code as defined by Statistics Canada.

Access the Reporting Sequence Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Reporting Sequence Mapping, then select Reporting Sequence Mapping).

Field or Control

Definition
Record

Enter the PeopleSoft record name that determines reporting sequence for this report type. For example, STDNT_CAR_TERM.

Field Name

Enter the PeopleSoft field name that determines reporting sequence for this report type. For example, ACAD_CAREER.

Reporting Sequence

Enter the sequence or priority number that relates to the PeopleSoft value for the field you specify. At runtime, you specify which value that you want the system to select for processing in the event that the selection process finds multiple records for a student. For example, 05.

PeopleSoft Value

Enter the codes for the field name you specify. For example, GRAD.

Access the Term Group Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Term Group Mapping, then select Term Group Mapping).

Image: Term Group Mapping page

This example illustrates the fields and controls on the Term Group Mapping page. You can find definitions for the fields and controls later on this page.

Term Group Mapping page

Field or Control

Definition
Institution

Enter the reporting institution.
Report Type

Enter the report type.
Report Period

Enter a reporting period for the report type.
Academic Career

Enter the academic career that you want to include for the reporting period.
Term

Enter the term for the career and report period.
Session

Enter the institution session for the term and report period.

The following fields are available for entry if you specify a report type of CIS.

Field or Control

Definition
CIS Session

Enter the appropriate CIS session value for the term and session you specify.

The following fields are available for entry if you specify a report type of PSIS.

Field or Control

Definition
Report Type

Select the report in which you want to include the term and session data. Values are:

Prelim Report (preliminary report): Select to include the term and session data in the Preliminary Report and the Final Report.

Final Report: Select to include the term and session data in the Final Report only.

Withdrawal Date

Enter the last date in the term and session that a student can withdraw from a course without academic penalty.

The following fields are available for entry if you specify a report type of USISE or MET.

Field or Control

Definition
Seshun Value (session value)

Enter the appropriate USIS Enrolment Seshun value for the term and session specified.

Access the OUAC Applno page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select OUAC Applno Mapping, then select OUAC Applno Mapping).

Field or Control

Definition
OUAC Appl Nbr (OUAC application number)

Enter the two-digit OUAC application number (APPLNO).
OUAC APPLN (OUAC application number)

Enter the converted one digit application number (CNVAPL).

Access the Classification Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Classification Mapping Table, then select Classification Mapping).

Image: Classification Mapping page

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

Classification Mapping page

Values for the Record, Field Name, and Selection Field fields are delivered and defined for all applicable elements for PSUNV. Set up the same values for your institution if you perform PSIS reporting.

Field or Control

Definition
Record

Enter the PeopleSoft record name that the system uses to report the specified element.
Field Name

Enter the PeopleSoft field name that the system uses to report the specified element. The system prompt table displays all valid fields for the record, but does not edit your input against the list. This enables you to enter a field name that is in a subrecord.
Selection Field

Enter the PeopleSoft selection field that applies to the element. This field must be on the record you specify. This field may be the same as or different from the Field Name value.
Selection Field Value

Enter the PeopleSoft selection field values that relate to the selection field that you want to report. You can enter more than one value.

Access the Direct Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Direct Mapping Table, then select Direct Mapping).

Values for the Record, Field Name, and Selection Field fields are delivered and defined for all applicable elements for PSUNV. Set up the same values for your institution if you perform PSIS reporting.

Field or Control

Definition
Record

Enter the PeopleSoft record name that the system uses to report the specified element.
Field Name

Enter the PeopleSoft field name that the system uses to report the specified element. The prompt table displays all valid fields for the record, but will not edit your input against the list. This enables you to enter a field name that is in a subrecord.

Access the Master Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Master Mapping Table, then select Master Mapping).

Values for the Record, Field Name, and Selection Field fields are delivered and defined for all applicable elements for PSUNV. Set up the same values for the report types that are applicable to your institution.

Field or Control

Definition
Record

Enter the PeopleSoft record name that the system uses to report the specified element.
Field Name

Enter the PeopleSoft field name that the system uses to report the specified element. The prompt table displays all valid fields for the record, but will not edit your input against the list. This enables you to enter a field name that is in a subrecord.
PeopleSoft Value

Enter the delivered or user-defined values for the field name.
Government Value

Enter the government code that corresponds to the PeopleSoft value.

Access the Separate Mapping page (select Records and Enrollment, then select Government Reporting Canada, then select Mapping, then select Separate Mapping Table, then select Separate Mapping).

Values for the Record, Field Name, and Selection Field fields are delivered and defined for all applicable elements for PSUNV. Set up the same values for the report types that are applicable to your institution.

Field or Control

Definition
Record

Enter the PeopleSoft record name that the system uses to report the specified element.
Field Name

Enter the PeopleSoft field name that the system uses to report the specified element. The prompt table displays all valid fields for the record, but will not edit your input against the list. This enables you to enter a field name that is in a subrecord.
Gov't Record (government record)

Enter the PeopleSoft record that houses the translate codes.
Gov't Field Name (government field name)

Enter the PeopleSoft field that contains the government codes that correspond to the values in the field name.