RIO Reporting - Postsecondary Student Information System (PSIS)

+ More

This guide outlines the steps required for an end user to configure and generate a PSIS report.

Postsecondary Student Information System (PSIS) is a reporting that is required by the Canadian government.

Prerequisites

The following managed packages must be installed in the Salesforce org:
- EDA
- RIO Education
- RIO Education - Reporting Engine (Generic)
  - Select the optional package: CA Reporting - PSIS
The permission set "REDU - PSIS Reporting" is assigned to the running user.

Procedures

From the Apps menu, select the ‘RIO Reporting Engine’ application.
Select the 'Reporting Exports' tab and choose the PSIS reporting record.
Review each of the fields on the record and update any fields as required. Alternatively, if a new report is required, simply click the ‘Clone’ button, modify the fields accordingly, and then click the ‘Save’ button.
- Make sure the status is saved as 'Draft'
Invoke the report generation by updating the status to 'Queue' and then clicking the ‘Save’ button.
1. The status will be updated to 'In Progress - Data Holder Generation'. Other than the RIO Reporting's default data holder generation process, the PSIS report will also run the "redu_SummariseAcademicYearTotalFee_EXE" which will summarise the total fees for the students per academic year in a custom object - Total Fee. These records will be used in the reporting files of SD and SP.
2. Once the report has been generated, the status field will be updated to ‘Completed’ and the PSIS report file(s) will be available from the ‘Notes & Attachments’ section.

Field Mapping

The following report file types are required for PSIS report. Refer to the official documentation here for details.

Institution Description (ID)
Institution Program (IP)
Institution Course (IC)
Student Description (SD)
Student Program (SP)
Student Course (SC)

//****************************** Internal ******************************

Refer to the field mapping spreadsheet for details.

https://docs.google.com/spreadsheets/d/1ocX7iWNcYKfI3T9-NmZRDJoGiDir4zxVKrdoL7TBs18/edit#gid=1567618139

****************************** Internal ******************************//

Institution Metadata

Institution Description (ID)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1005	RepstartDate	Start date of report cycle	<<	hed__Term__c (Term)	Start date of report cycle	rioedrept_RepstartDate__c	Formula (Date)
1025	Instit	Institution code	<<	hed__Term__c (Term)	Institution code	rioedrept_instit__c	Formula (Text)
1035	Period	Period code	<<	hed__Term__c (Term)	Period code	rioedrept_Period__c	Picklist
1036	Sub_period	Sub-period code	<<	hed__Term__c (Term)	Period code	rioedrept_Period__c	Picklist
1045	StartDate	Start date of period	<<	hed__Term__c (Term)	Start Date	Start Date	Date
1055	EndDate	End date of period	<<	hed__Term__c (Term)	End Date	End Date	Date
1065	WithDate	Last date for withdrawal	<<	hed__Term__c (Term)	Census Date	Census Date	Date
1100	ProvID	Provincial ID elements	<<	No data to be exported

Institution Program (IP)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
1025	Instit	Institution code	<<	Account	rioedrept_ProgInstit__c	rioedrept_ProgInstit__c	Formula (Text)
2000	ProgCode	Program code	<<	Account	Program Code	rio_ed__Program_Code__c	Text(20)
2010	CredenTyp	Credential type	<<	Account	Credential type	rioedrept_CredenTyp__c	Picklist
2011	JCredenTyp	Joint credential type	<<	Account	Joint credential type	rioedrept_JCredenTyp__c	Picklist
2015	ProgType	Program type	<<	Account	Program type	rioedrept_ProgType__c	Picklist
2016	JProgTyp	Joint program type	<<	Account	Joint program type	rioedrept_JProgTyp__c	Picklist
2020	ProgName	Program name	<<	Account	Name	name	Text(80)
2030	ProvProgCat	Provincial program category (MPHEC)	<<	Account	Provincial program category (MPHEC)	rioedrept_ProvProgCat__c	Picklist
2040	ProvProgFund	Provincial program funding code (MPHEC)	<<	Account	Provincial program funding code (MPHEC)	rioedrept_ProvProgFund__c	Picklist
2060	ProgHour	Program duration (in hours)	<<	Account	Program duration (in hours)	rioedrept_ProgHour__c	Number(5, 0)
2070	ProgDur	Program duration	<<	Account	Program duration	rioedrept_ProgDur__c	Number(4, 0)
2071	ProgDurUnit	Program duration units	<<	Account	Program duration units	rioedrept_ProgDurUnit__C	Picklist
2080	ProgCred	Credits needed to graduate	<<	Account	Credits needed to graduate	rioedrept_ProgCred__c	Number(6, 2)
2081	ProgCredUnit	Program credit units	<<	Account	Program credit units	rioedrept_ProgCredUnit__c	Picklist
2090			<<	No data to be exported
2100	ProgFullPart	Program delivered fulltime, part-time or both	<<	Account	Delivery mode	rioedrept_ProgFullPart__c	Picklist
2150	EdEntry	Educational entrance requirements	<<	Account	Educational entrance requirements	rioedrept_EdEntry__c	Picklist
2151	LegalEntry	Legal entrance requirements	<<	Account	Legal entrance requirements	rioedrept_LegalEntry__c	Picklist
2152	MedEntry	Medical or psychological entrance requirements	<<	Account	Medical entrance requirements	rioedrept_MedEntry__c	Picklist
2153	AptEntry	Aptitude or proficiency entrance requirements	<<	Account	Aptitude entrance requirements	rioedrept_AptEntry__c	Picklist
2154	ExpEntry	Related experience entrance requirements	<<	Account	Related experience entrance requirements	rioedrept_ExpEntry__c	Picklist
2155	OthEntry	Other program entrance requirements	<<	Account	Other program entrance requirements	rioedrept_OthEntry__c	Picklist
2210	ProgCont	Program delivered under contract	<<	Account	Program delivered under contract	rioedrept_ProgCont__c	Picklist
2220	ProgLimited	Program enrolment limits	<<	Account	Program enrolment limits	rioedrept_ProgLimited__c	Picklist
2225	ProgCap	Program capacity if limited	<<	Account	Program capacity if limited	rioedrept_ProgCap__c	Number(5, 0)
2300	ManPaidDur	Mandatory paid OJT duration	<<	Account	Mandatory paid OJT duration	rioedrept_ManPaidDur__c	Number(6, 2)
2301	ManPaidUnit	Mandatory paid OJT duration units	<<	Account	Mandatory paid OJT duration units	rioedrept_ManPaidUnit__c	Picklist
2310	OpPaidDur	Optional paid OJT duration	<<	Account	Optional paid OJT duration units	rioedrept_OpPaidDur__c	Number(6, 2)
2311	OpPaidUnit	Optional paid OJT duration units	<<	Account	Optional paid OJT duration units	rioedrept_OpPaidUnit__c	Picklist
2320	ManUnpaidDur	Mandatory unpaid OJT duration	<<	Account	Mandatory unpaid OJT duration	rioedrept_ManUnpaidDur__c	Number(6, 2)
2321	ManUnpaidUnit	Mandatory unpaid OJT duration units	<<	Account	Mandatory unpaid OJT duration units	rioedrept_ManUnpaidUnit__c	Picklist
2330	OpUnpaidDur	Optional unpaid OJT duration	<<	Account	Optional unpaid OJT duration	rioedrept_OpUnpaidDur__c	Number(6, 2)
2331	OpUnpaidUnit	Optional unpaid OJT duration units	<<	Account	Optional unpaid OJT duration units	rioedrept_OpUnpaidUnit__c	Picklist
2401		Element deleted	<<	No data to be exported
2402		Element deleted	<<	No data to be exported
2403	MPHEC_CIP1	First Classification of Instructional Program Code (MPHEC)	<<	Account	First CIP Codes (MPHEC)	rioedrept_MPHEC_CIP1__c	Text(6)
2404	MPHEC_CIP2	Second Classification of Instructional Program Code (MPHEC)	<<	No data to be exported
2400	ProvIP	Provincial IP elements	<<	No data to be exported

Institution Course (IC)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
1025	Instit	Institution code	<<	hed__Course__c (Course)	Institution code	rioedrept_Courinstit__c	Formula (Text)
3000	CourCode	Course code	<<	hed__Course__c (Course)	Course ID	hed__Course_ID__c	Text(255)
3020	CourName	Course name	<<	hed__Course__c (Course)	Course Name	Name	Text(80)
3040	CourCont	Course delivered under contract	<<	hed__Course__c (Course)	Course delivered under contract	rioedrept_CourCont__c	Picklist
3050	CourRetrain	Course intended as workplace retraining or skills upgrading	<<	hed__Course__c (Course)	Course intended as workplace retraining	rioedrept_CourRetrain__c	Picklist
3080	CourDur	Course duration	<<	hed__Course__c (Course)	Default Scheduled Duration	rio_ed__Default_Scheduled_Hours__c	Number(4, 2)
3081	CourDurUnit	Course duration units	<<	hed__Course__c (Course)	Default Scheduled Duration Unit	rio_ed__Default_Scheduled_Duration_Unit__c	Picklist
3090	CourCred	Course credits normally awarded	<<	hed__Course__c (Course)	Credit Points	rio_ed__Credit_Points__c	Number(3, 3)
3091	CourCredUnit	Course credit units	<<	hed__Course__c (Course)	Course credit units	rioedrept_CourCredUnit__c	Picklist
3110	LabDur	Laboratory duration	<<	hed__Course__c (Course)	Laboratory duration	rioedrept_LabDur__c	Number(6, 2)
3111	LabDurUnit	Laboratory duration units	<<	hed__Course__c (Course)	Laboratory duration units	rioedrept_LabDurUnit__c	Picklist
3140	CourOJTDur	Course OJT duration	<<	hed__Course__c (Course)	Course OJT duration	rioedrept_CourOJTDur__c	Number(6, 2)
3141	CourOJTUnit	Course OJT duration units	<<	hed__Course__c (Course)	Course OJT duration units	rioedrept_CourOJTUnit__c	Picklist
3160	ProvCourFund	Provincial course funding code	<<	hed__Course__c (Course)	Provincial course funding code	rioedrept_ProvCourFund__c	Picklist
3200	ProvIC	Provincial IC elements	<<	No data to be exported

Student Metadata

Student Description (SD)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
1010	RepTyp	Report type	<<	rioedrept_Total_Fees__c (Total Fee)	Report type	rioedrept_contact__r.rioedrept_RepTyp__c	Formula (Text)
1025	Instit	Institution code	<<	rioedrept_Total_Fees__c (Total Fee)	Institution code	rioedrept_contact__r.rioedrept_StudInstit__c	Formula (Text)
4000	StudID	Institution's Student Identifier	<<	rioedrept_Total_Fees__c (Total Fee)	Student ID	rioedrept_contact__r.rio_ed__Student_ID__c	Text(100)
4010	TStudID	Type of Student I.D.	<<	rioedrept_Total_Fees__c (Total Fee)	Type of Student I.D.	rioedrept_contact__r.rioedrept_TStudID__c	Picklist
4020	SIN	Social Insurance Number	<<	rioedrept_Total_Fees__c (Total Fee)	Social Insurance Number	rioedrept_contact__r.redu_Social_Insurance_Number__c	Text (Encrypted)(9)
4030	PSIS_NSN	PSIS National Student Number	<<	rioedrept_Total_Fees__c (Total Fee)	PSIS National Student Number	rioedrept_contact__r.rioedrept_PSIS_NSN__c	Text(30)
4040	FirstName	First name	<<	rioedrept_Total_Fees__c (Total Fee)	First Name	rioedrept_contact__r.firstName	Text(40)
4041	MidName	Middle name(s) and/or initials	<<	rioedrept_Total_Fees__c (Total Fee)	Middle Name	rioedrept_contact__r.middleName	Text(40)
4042	Surname	Surname	<<	rioedrept_Total_Fees__c (Total Fee)	Last Name	rioedrept_contact__r.lastName	Text(40)
4050	PrevSurname	Previous surname	<<	rioedrept_Total_Fees__c (Total Fee)	Former Last Name	rioedrept_contact__r.hed__Former_Last_Name__c	Text(40)
4060	CurrPostal	Current postal/zip code	<<	rioedrept_Total_Fees__c (Total Fee)	Mailing Address	rioedrept_contact__r.MailingPostalCode	Text
4070	CurrCntry	Current country of residence	<<	rioedrept_Total_Fees__c (Total Fee)	Mailing Address	rioedrept_contact__r.MailingCountry	Text
4071	CurrCntryTxt	Current country of residence (Text)	<<	rioedrept_Total_Fees__c (Total Fee)	Mailing Address	rioedrept_contact__r.MailingCountry	Text
4080	CurrPhone	Current telephone number	<<	rioedrept_Total_Fees__c (Total Fee)	Phone	rioedrept_contact__r.Phone	Phone
4090	CurrEmail	Current e-mail address	<<	rioedrept_Total_Fees__c (Total Fee)	Email	rioedrept_contact__r.Email	Email
4100	PermLine1	Permanent address line 1	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherStreet	Text
4101	PermLine2	Permanent address line 2	<<	No data to be exported
4102	PermLine3	Permanent address line 3	<<	No data to be exported
4103	PermLine4	Permanent address line 4	<<	No data to be exported
4104	PermLine5	Permanent address line 5	<<	No data to be exported
4110	PermCity	City or town of permanent address	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherCity	Text
4120			<<	No data to be exported
4121			<<	No data to be exported
4130	PermProvUpdt	Province or state of permanent address (updated)	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherState	Text
4140	PermGeo	Geographic area of permanent address	<<	rioedrept_Total_Fees__c (Total Fee)	Geographic area of permanent address	rioedrept_contact__r.rioedrept_PermGeo__c	Text(35)
4150	PermCntry	Country of permanent address	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherCountry	Text
4151	PermCntryTxt	Country of the permanent address (text)	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherCountry	Text
4160	PermPostal	Postal or zip code of permanent address	<<	rioedrept_Total_Fees__c (Total Fee)	OtherAddress	rioedrept_contact__r.OtherPostalCode	Text
4180	PermPhone	Telephone number at permanent address	<<	rioedrept_Total_Fees__c (Total Fee)	Phone	rioedrept_contact__r.Phone	Phone
4200	SensRec	Sensitive record	<<	rioedrept_Total_Fees__c (Total Fee)	Sensitive record	rioedrept_contact__r.rioedrept_SensRec__c	Email
4210	Aboriginal	Indigenous identity	<<	rioedrept_Total_Fees__c (Total Fee)	Indigenous identity	rioedrept_contact__r.rioedrept_Aboriginal__c	Picklist
4215	Disab	Activity limitations	<<	rioedrept_Total_Fees__c (Total Fee)	Activity limitations	rioedrept_contact__r.rioedrept_Disab__c	Picklist
4220	ResStat	Residence status	<<	rioedrept_Total_Fees__c (Total Fee)	Residence status	rioedrept_contact__r.rioedrept_ResStat__c	Picklist
4230	Birth	Birth date	<<	rioedrept_Total_Fees__c (Total Fee)	Birthdate	rioedrept_contact__r.Birthdate	Date
4240	Gender	Gender	<<	rioedrept_Total_Fees__c (Total Fee)	Gender	rioedrept_contact__r.hed__Gender__c	Picklist
4250	Tongue	Mother tongue	<<	rioedrept_Total_Fees__c (Total Fee)	First Language	rioedrept_contact__r.redu_First_Language__c	Picklist
4260	ProvFundCitiz	Provincial funding classification by citizenship	<<	rioedrept_Total_Fees__c (Total Fee)	Provincial funding by citizenship	rioedrept_contact__r.rioedrept_ProvFundCitiz__c	Text(6)
4270	FeeCategory	Student tuition fee category	<<	rioedrept_Total_Fees__c (Total Fee)	Student tuition fee category	rioedrept_contact__r.rioedrept_FeeCategory__c	Picklist
4273	StudTuit	Tuition fees billed to student	<<	rioedrept_Total_Fees__c (Total Fee)	Tuition fees billed to Student	rioedrept_StudTuit__c	Number(7, 2)
4276	StudOtherFee	Other fees billed to student	<<	rioedrept_Total_Fees__c (Total Fee)	Other fees billed to student	rioedrept_StudOtherFee__c	Number(7, 2)
4280	Citiz	Country of citizenship	<<	rioedrept_Total_Fees__c (Total Fee)	Citizenship	rioedrept_contact__r.hed__Citizenship__c	Picklist
4281	CitizTxt	Country of citizenship (text)	<<	rioedrept_Total_Fees__c (Total Fee)	Citizenship	rioedrept_contact__r.hed__Citizenship__c	Picklist
4290	ImmStat	Immigration status of student	<<	rioedrept_Total_Fees__c (Total Fee)	Immigration status of student	rioedrept_contact__r.rioedrept_ImmStat__c	Picklist
4300	PrevCntry	Previous country	<<	rioedrept_Total_Fees__c (Total Fee)	Previous country	rioedrept_contact__r.rioedrept_PrevCntry__c	Picklist
4301	PrevCntryTxt	Previous country (text)	<<	rioedrept_Total_Fees__c (Total Fee)	Previous country	rioedrept_contact__r.rioedrept_PrevCntry__c	Picklist
4310	Outside	Student studying outside Canada	<<	rioedrept_Total_Fees__c (Total Fee)	Student studying outside Canada	rioedrept_contact__r.rioedrept_Outside__c	Picklist
4320	ElSecComp	Elementary/ secondary education	<<	rioedrept_Total_Fees__c (Total Fee)	Elementary/ secondary education	rioedrept_contact__r.rioedrept_ElSecComp__c	Picklist
4325	ElSecDate	Date last attended elementary/secondary school	<<	rioedrept_Total_Fees__c (Total Fee)	Date last attended elementary/secondary	rioedrept_contact__r.rioedrept_ElSecDate__c	Date
4330	ElSecCntry	Country where last attended elementary/ secondary school	<<	rioedrept_Total_Fees__c (Total Fee)	Country of elementary/secondary school	rioedrept_contact__r.rioedrept_ElSecCntry__c	Picklist
4331	ElSecCntryTxt	Country where last attended elementary/ secondary school (text)	<<	rioedrept_Total_Fees__c (Total Fee)	Country of elementary/secondary school	rioedrept_contact__r.rioedrept_ElSecCntry__c	Picklist
4332	ElSecProv	Province or state of elementary/secondary school last attended	<<	rioedrept_Total_Fees__c (Total Fee)	Province/state of elementary/secondary	rioedrept_contact__r.rioedrept_ElSecProv__c	Picklist
4335	ElSecInst	Institution code of Canadian elementary/ secondary school last attended	<<	rioedrept_Total_Fees__c (Total Fee)	Institution code of Canadian school	rioedrept_contact__r.rioedrept_ElSecInst__c	Picklist
4340	PrevEdAct	Previous educational activity	<<	rioedrept_Total_Fees__c (Total Fee)	Previous educational activity	rioedrept_contact__r.rioedrept_PrevEdAct__c	Picklist
4350	PrevCredenTyp	Previous post-secondary credential type	<<	rioedrept_Total_Fees__c (Total Fee)	Previous post-secondary credential type	rioedrept_contact__r.rioedrept_PrevCredenTyp__c	Picklist
4360	PrevLFS	Previous labour force activity	<<	No data to be exported
4370	PermProv1st	Permanent province of residence declared upon admission	<<	rioedrept_Total_Fees__c (Total Fee)	Permanent province of residence declared	rioedrept_contact__r.rioedrept_PermProv1st__c	Picklist
4402			<<	No data to be exported
4403			<<	No data to be exported
4404	MPHEC_Campus	Assigned Campus (MPHEC)	<<	rioedrept_Total_Fees__c (Total Fee)	Assigned Campus (MPHEC)	rioedrept_contact__r.rioedrept_MPHEC_Campus__c	Picklist
4405	ProvStudID	Provincial Student Identifier (MPHEC)	<<	rioedrept_Total_Fees__c (Total Fee)	Provincial Student Identifier (MPHEC)	rioedrept_contact__r.rioedrept_ProvStudID__c	Text(24)
4400	ProvSD	Provincial SD elements	<<	No data to be exported

Student Program (SP)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
5005			<<	No data to be exported
1025	Instit	Institution code	<<	rioedrept_Total_Fees__c (Total Fee)	Institution code	rioedrept_Program_Enrollment__r.rioedrept_PEInstit__c	Text
4000	StudID	Institution's Student Identifier	<<	rioedrept_Total_Fees__c (Total Fee)	Student ID	rioedrept_Program_Enrollment__r.hed__Contact__r.rio_ed__Student_ID__c	Text
2000	ProgCode	Student's program code	<<	rioedrept_Total_Fees__c (Total Fee)	Program Code	rioedrept_Program_Enrollment__r.hed__Account__r.rio_ed__Program_Code__c	Text
2010	CredenTyp	Credential type	<<	rioedrept_Total_Fees__c (Total Fee)		rioedrept_Program_Enrollment__r.hed__Account__r.rioedrept_CredenTyp__c
5010	ProgStart	Original start date in program	<<	rioedrept_Total_Fees__c (Total Fee)	Start Date	rioedrept_Program_Enrollment__r.hed__Start_Date__c	Formula (Date)
5015	Major1	First specialization or major field of study	<<	rioedrept_Total_Fees__c (Total Fee)	First specialization or major	rioedrept_Program_Enrollment__r.rioedrept_Major1__c	Text(10)
5016	Major2	Second specialization or major field of study	<<	rioedrept_Total_Fees__c (Total Fee)	Second specialization or major	rioedrept_Program_Enrollment__r.rioedrept_Major2__c	Text(10)
5017	Major3	Third specialization or major field of study	<<	rioedrept_Total_Fees__c (Total Fee)	Third specialization or major	rioedrept_Program_Enrollment__r.rioedrept_Major3__c	Text(10)
5020	ProvMajor	Provincial major field of study	<<	rioedrept_Total_Fees__c (Total Fee)	Provincial major field of study	rioedrept_Program_Enrollment__r.rioedrept_ProvMajor__c	Text(8)
5021	ProvJMajor	Provincial joint or second major field of study	<<	rioedrept_Total_Fees__c (Total Fee)	Provincial joint or second major	rioedrept_Program_Enrollment__r.rioedrept_ProvJMajor__c	Text(8)
5025	ProvStudProg	Student and program approved for funding by funding agency (MPHEC)	<<	rioedrept_Total_Fees__c (Total Fee)	Student and program approved for funding	rioedrept_Program_Enrollment__r.rioedrept_ProvStudProg__c	Picklist
5030	Credent	Credential	<<	rioedrept_Total_Fees__c (Total Fee)	Credential	rioedrept_Program_Enrollment__r.rioedrept_Credent__c	Formula (Text)
5040	Jcredent	Joint credential	<<	rioedrept_Total_Fees__c (Total Fee)	Joint credential	rioedrept_Program_Enrollment__r.rioedrept_Jcredent__c	Text(60)
5050	NormEnt	Met normal entrance requirements	<<	rioedrept_Total_Fees__c (Total Fee)	Met normal entrance requirements	rioedrept_Program_Enrollment__r.rioedrept_NormEnt__c	Picklist
5060	SpecInit	Special Initiative code	<<	rioedrept_Total_Fees__c (Total Fee)	Special Initiative code	rioedrept_Program_Enrollment__r.rioedrept_SpecInit__c	Text(6)
5070	Co_op	Co-op program indicator	<<	rioedrept_Total_Fees__c (Total Fee)	Co-op program indicator	rioedrept_Program_Enrollment__r.rioedrept_Co_op__c	Picklist
5073	ProgArtic	Articulated program indicator	<<	rioedrept_Total_Fees__c (Total Fee)	Articulated program indicator	rioedrept_Program_Enrollment__r.rioedrept_ProgArtic__c	Picklist
5076	ProgBroker	Brokered program indicator	<<	rioedrept_Total_Fees__c (Total Fee)	Brokered program indicator	rioedrept_Program_Enrollment__r.rioedrept_ProgBroker__c	Picklist
5079	ProgCollab	Collaborative program indicator	<<	rioedrept_Total_Fees__c (Total Fee)	Collaborative program indicator	rioedrept_Program_Enrollment__r.rioedrept_ProgCollab__c	Picklist
5083	GradStatJun1	Grad student registration status on June 1	<<	rioedrept_Total_Fees__c (Total Fee)	Grad student registration status on June	rioedrept_Program_Enrollment__r.rioedrept_GradStatJun1__c	Picklist
5084	GradStatAug1	Grad student registration status on August 1	<<	rioedrept_Total_Fees__c (Total Fee)	Grad student registration status on Aug	rioedrept_Program_Enrollment__r.rioedrept_GradStatAug1__C	Picklist
5085	RegStat	Student's registration status	<<	rioedrept_Total_Fees__c (Total Fee)	Student's registration status	rioedrept_Program_Enrollment__r.rioedrept_RegStat__c	Picklist
5086	GradStatApr1	Grad student registration status on April 1	<<	rioedrept_Total_Fees__c (Total Fee)	Grad student registration status on Apr	rioedrept_Program_Enrollment__r.rioedrept_GradStatApr1__c	Picklist
5090	ProgEnd	End date in program	<<	rioedrept_Total_Fees__c (Total Fee)	End Date	rioedrept_Program_Enrollment__r.hed__End_Date__c	Date
5100	ProgEndStat	Status in program at end of report cycle	<<	rioedrept_Total_Fees__c (Total Fee)	Status in program at end of report cycle	rioedrept_Program_Enrollment__r.rioedrept_ProgEndStat__C	Text
5120	GradDate	Convocation or graduation date	<<	rioedrept_Total_Fees__c (Total Fee)	Graduation Date	rioedrept_Program_Enrollment__r.rioedrept_Graduation_Date__c	Date
5140	Excel	Indicator of academic excellence	<<	rioedrept_Total_Fees__c (Total Fee)	Indicator of academic excellence	rioedrept_Program_Enrollment__r.rioedrept_Excel__c	Picklist
5150	ManPaid	Completed mandatory paid on-the-job training (OJT)	<<	rioedrept_Total_Fees__c (Total Fee)	Completed mandatory paid OJT	rioedrept_Program_Enrollment__r.rioedrept_ManPaid__c	Picklist
5160	OpPaid	Completed optional paid OJT	<<	rioedrept_Total_Fees__c (Total Fee)	Completed optional paid OJT	rioedrept_Program_Enrollment__r.rioedrept_OpPaid__c	Picklist
5170	ManUnpaid	Completed mandatory unpaid OJT	<<	rioedrept_Total_Fees__c (Total Fee)	Completed mandatory unpaid OJT	rioedrept_Program_Enrollment__r.rioedrept_ManUnpaid__c	Picklist
5180	OpUnpaid	Completed optional unpaid OJT	<<	rioedrept_Total_Fees__c (Total Fee)	Completed optional unpaid OJT	rioedrept_Program_Enrollment__r.rioedrept_OpUnpaid__c	Picklist
5190	ProgTuit	Tuition fees billed for program	<<	rioedrept_Total_Fees__c (Total Fee)	Tuition fees billed for program	rioedrept_ProgTuit__c	Number(7, 2)
5195	ProgOtherFee	Other compulsory fees billed for program	<<	rioedrept_Total_Fees__c (Total Fee)	Other compulsory fees billed for program	rioedrept_ProgOtherFee__c	Number(7, 2)
5200	ProgCostRec	Student took program on cost recovery	<<	rioedrept_Total_Fees__c (Total Fee)	Student took program on cost recovery	rioedrept_Program_Enrollment__r.rioedrept_ProgCostRec__c	Picklist
5210	Scholarship	Scholarship or bursary amount	<<	rioedrept_Total_Fees__c (Total Fee)	Scholarship	rioedrept_Program_Enrollment__r.rioedrept_Scholarship__c	Number(6, 2)
5220	TotTranCred	Total transfer credits	<<	rioedrept_Total_Fees__c (Total Fee)	Total transfer credits	rioedrept_Program_Enrollment__r.rioedrept_TotTranCred__C	Number(6, 2)
5230	TotCred	Cumulative credits for program	<<	rioedrept_Total_Fees__c (Total Fee)	Credits Earned	rioedrept_Program_Enrollment__r.hed__Credits_Earned__c	Number(3, 3)
5300	ProvSP	Provincial SP elements	<<	No data to be exported
5400	CIPCodeRep	Classification of Instructional Programs code reported	<<	No data to be exported

Student Course (SC)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
5005			<<	No data to be exported
1025	Instit	Institution code	<<	hed__Course_Enrollment__c	Institution code	rioedrept_CCInstit__c	Text
4000	StudID	Institution's Student Identifier	<<	hed__Course_Enrollment__c	Student ID	hed__Contact__r.rio_ed__Student_ID__c	Text
3000	CourCode	Student's course code	<<	hed__Course_Enrollment__c	Course Id	rio_ed__Plan_Requirement_Course__r.hed__Course__r.hed__Course_ID__c	Text
1035	CourPer	Period in which course was delivered to student	<<	hed__course_enrollment__C	Period code	rio_ed__PE_Pathway__r.rio_ed__Term__r.rioedrept_period__c	Text
1036	CourSubPer	Sub-period in which course was delivered to student	<<	hed__Course_Enrollment__c	Period code	rio_ed__PE_Pathway__r.rio_ed__Term__r.rioedrept_period__c	Text
6020	CourStart	Date student started course	<<	hed__Course_Enrollment__c	Start Date	rio_ed__Start_Date__c	Date
6021	CourEnd	Date student ended course	<<	hed__Course_Enrollment__c	End Date	rio_ed__End_Date__c	Date
6030	CourEndStat	Status in course at end of report cycle	<<	hed__Course_Enrollment__c	Status in course at end of report cycle	rioedrept_CourEndStat__c	Formula (Text)
6040	CourTuit	Tuition fees billed for course	<<	hed__Course_Enrollment__c	Fee Amount	rio_ed__Fee_Amount__c	Currency(16, 2)
6045	CourOtherFee	Other compulsory fees billed for course	<<	hed__Course_Enrollment__c	Other compulsory fees billed for course	rioedrept_CourOtherFee__c	Number(7, 2)
6050	CourCostRec	Student took course on cost recovery	<<	hed__Course_Enrollment__c	Student took course on cost recovery	rioedrept_CourCostRec__c	Picklist
6060	StudCourCred	Credits student would receive for course	<<	hed__Course_Enrollment__c	Credits Offered	rio_ed__Credits_Offered__c	Formula (Number)
6070	CourSec	Student's course section	<<	hed__Course_Enrollment__c	Student's course section	rioedrept_CourSec__c	Text(1)
6080	CourBroker	Brokered course indicator	<<	hed__Course_Enrollment__c	Brokered course indicator	rioedrept_CourBroker__C	Picklist
6100	DistEd	Student's course considered to be "distance education"	<<	hed__Course_Enrollment__c	Distance education	rioedrept_DistEd__c	Picklist
6110	Classroom	Course delivered to student by classroom instruction	<<	hed__Course_Enrollment__c	Course delivered via classroom	hed__Course_Offering__r.rioedrept_Classroom__c	Picklist
6120	Corresp	Course delivered to student by correspondence	<<	hed__Course_Enrollment__c	Course delivered via correspondence	hed__Course_Offering__r.rioedrept_Corresp__c	Picklist
6130	Internet	Course delivered to student by Internet	<<	hed__Course_Enrollment__c	Course delivered via Internet	hed__Course_Offering__r.rioedrept_Internet__c	Picklist
6140	VideoConf	Course delivered to student by video conferencing	<<	hed__Course_Enrollment__c	Course delivered via video conferencing	hed__Course_Offering__r.rioedrept_VideoConf__c	Picklist
6145	AudioConf	Course delivered to student audio conferencing	<<	hed__Course_Enrollment__c	Course delivered via audio conferencing	hed__Course_Offering__r.rioedrept_AudioConf__c	Picklist
6150	TV	Course delivered to student by television	<<	hed__Course_Enrollment__c	Course delivered via television	hed__Course_Offering__r.rioedrept_TV__c	Picklist
6160	Radio	Course delivered to student by radio	<<	hed__Course_Enrollment__c	Course delivered via radio	hed__Course_Offering__r.rioedrept_Radio__C	Picklist
6180	DelOther	Course delivered to student by some other method	<<	hed__Course_Enrollment__c	Course delivered via other method	hed__Course_Offering__r.rioedrept_DelOther__c	Picklist
6190	CourCanInst	PSIS Canadian institution where student received course instruction	<<	hed__Course_Enrollment__c	PSIS Canadian institution	rioedrept_CourCanInst__c	Formula (Text)
6195	CourInstText	Institution (text) where student received course instruction	<<	hed__Course_Enrollment__c	Institution where instruction received	rioedrept_CourInstText__c	Formula (Text)
6210	CourCampus	Instruction oncampus	<<	hed__Course_Enrollment__c	Instruction oncampus	rioedrept_CourCampus__c	Picklist
6220	CourStudRes	Instruction at student's home	<<	hed__Course_Enrollment__c	Instruction at student's home	rioedrept_CourStudRes__c	Picklist
6260	CourWork	Instruction at workplace	<<	hed__Course_Enrollment__c	Instruction at workplace	rioedrept_CourWork__c	Picklist
6270	CourOther	Instruction at another location	<<	hed__Course_Enrollment__c	Instruction at another location	rioedrept_CourOther__c	Picklist
6300	ProvSC	Provincial SC elements	<<

Student Transfer (ST)

Element Number	Mnemonic	Name	Mapped From	Object	Field Name	Field API Name	Type
1000	RepStartYear	Year of start of report cycle	<<	Reporting Export	Reporting Year	{!reportyear}	Picklist
1010			<<	No data to be exported
1025	Instit	Institution code		rio_ed__Transfer_Credit__c	School Code	rio_ed__Program_Enrollment__r.hed__Account__r.Parent.Parent.hed__School_Code__c	Text
4000	StudID	Institution's Student Identifier	<<	rio_ed__Transfer_Credit__c	Student Id	rio_ed__Contact__r.rio_ed__Student_ID__c	Text
7000	RecCode	Course or program code credit was granted toward at receiving institution	<<	rio_ed__Transfer_Credit__c	Course Id	rio_ed__Transfer_Course__r.rio_ed__Course_ID_s__c	Text
7010	RecCodeTyp	Type of code reported for receiving institution	<<	rio_ed__Transfer_Credit__c	Type of code reported for receiving inst	rioedrept_RecCodeTyp__c	Picklist
7020	RecDate	Date transfer credit granted	<<	rio_ed__Transfer_Credit__c	Start Date	rio_ed__Start_Date__c	Date
7040	TranPLA	Credit granted via Prior Learning Assessment	<<	rio_ed__Transfer_Credit__c	Credit granted via Prior Learning	rioedrept_TranPLA__c	Picklist
7050	TranCred	Transfer credits granted	<<	rio_ed__Transfer_Credit__c	Transfer credits granted	rioedrept_TranCred__c	Number(6, 2)
7060	TranCredTyp	Type of transfer credit	<<	rio_ed__Transfer_Credit__c	Type of transfer credit	rioedrept_TranCredTyp__c	Picklist
7065	SendCntryTxt	Country where course taken (text)	<<	rio_ed__Transfer_Credit__c	Country where course taken	rioedrept_SendCntry__c	Picklist
7066	SendCntry	Country where course taken	<<	rio_ed__Transfer_Credit__c	Country where course taken	rioedrept_SendCntry__c	Picklist
7070	SendInst	Sending institution code	<<	rio_ed__Transfer_Credit__c	Sending institution code	rioedrept_SendInst__c	Picklist
7080	SendInstName	Name of sending institution	<<	rio_ed__Transfer_Credit__c	Name of sending institution	rioedrept_SendInstName__c	Text(40)
7090	SendCode	Sending institution's course or program code	<<	rio_ed__Transfer_Credit__c	Transfer Course ID	rio_ed__Transfer_Course_ID__c	Formula (Text)
7100	SendCodeTyp	Type of code reported by sending institution	<<	rio_ed__Transfer_Credit__c	Type of code reported by sending inst.	rioedrept_SendCodeTyp__c	Picklist
7110	SendDate	Date completed course or program at sending institution	<<	rio_ed__Transfer_Credit__c	Completed Date	rio_ed__Completed_Date__c	Date
7200	ProvST	Provincial ST elements	<<	No data to be exported

psis

Contact Us