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:

  • Define mapping language codes.

  • Review delivered province codes.

  • Map Canadian reporting sequence.

  • Map terms and sessions to reporting periods.

  • Review delivered OUAC application numbers.

  • Define the classification mapping tables.

  • Define the direct mapping table.

  • Define the master mapping table.

  • Define the separate mapping table.

Page Name

Definition Name

Navigation

Usage

Language Mapping

CAN_RPT_TONGUE

Records and Enrollment > Government Reporting Canada > Mapping > Language Mapping > Language Mapping

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

Province Mapping

CAN_RPT_PROV

Records and Enrollment > Government Reporting Canada > Mapping > Province Mapping > Province Mapping

CIS, MET, USISE: Review Campus Solutions delivered province codes.

Reporting Sequence Mapping

CAN_RPT_SEQ

Records and Enrollment > Government Reporting Canada > Mapping > Reporting Sequence Mapping > 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

Records and Enrollment > Government Reporting Canada > Mapping > Term Group Mapping > 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

Records and Enrollment > Government Reporting Canada > Mapping > OUAC Applno Mapping > OUAC Applno Mapping

OUAC: Review delivered OUAC application numbers.

Classification Mapping

CAN_RPT_CM

Records and Enrollment > Government Reporting Canada > Mapping > Classification Mapping Table > Classification Mapping

PSIS: Define classification mapping values.

Direct Mapping

CAN_RPT_DM

Records and Enrollment > Government Reporting Canada > Mapping > Direct Mapping Table > Direct Mapping

CIS, PSIS, USISE: Define direct mapping values.

Master Mapping

CAN_RPT_MM

Records and Enrollment > Government Reporting Canada > Mapping > Master Mapping Table > Master Mapping

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

Separate Mapping

CAN_RPT_SM

Records and Enrollment > Government Reporting Canada > Mapping > Separate Mapping Table > Separate Mapping

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

Access the Language Mapping page (Records and Enrollment > Government Reporting Canada > Mapping > Language Mapping > Language Mapping).

Field or Control

Description

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 (Records and Enrollment > Government Reporting Canada > Mapping > Province Mapping > Province Mapping).

Field or Control

Description

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 (Records and Enrollment > Government Reporting Canada > Mapping > Reporting Sequence Mapping > Reporting Sequence Mapping).

Field or Control

Description

Record

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

Field Name

Enter the Campus Solutions 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 (Records and Enrollment > Government Reporting Canada > Mapping > Term Group Mapping > Term Group Mapping).

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

Description

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

Description

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

Description

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

Description

Seshun Value (session value)

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

Access the OUAC Applno page (Records and Enrollment > Government Reporting Canada > Mapping > OUAC Applno Mapping > OUAC Applno Mapping).

Field or Control

Description

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 (Records and Enrollment > Government Reporting Canada > Mapping > Classification Mapping Table > Classification Mapping).

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

Description

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 (Records and Enrollment > Government Reporting Canada > Mapping > Direct Mapping Table > 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

Description

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 does 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 (Records and Enrollment > Government Reporting Canada > Mapping > Master Mapping Table > 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

Description

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 does 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 (Records and Enrollment > Government Reporting Canada > Mapping > Separate Mapping Table > 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

Description

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 does 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 Campus Solutions field that contains the government codes that correspond to the values in the field name.