Student Admin - Automated Student Prerequisites Uploads
1.
<span>[Knowledge Base](index.html)</span>
</div>
# <span id="title-text"> Knowledge Base : Student Admin - Automated Student Prerequisites Uploads </span>
</div>
<div id="content" class="view">
<div class="page-metadata">
Created by <span class="author"> user-b1fcb</span>, last modified by <span class="editor"> Erik Graham</span> on Sep 23, 2022
</div>
<div id="main-content" class="wiki-content group">
**Placing Agency Related Guide (PARG)****
Summary:** <span style="letter-spacing: 0px;">
This step by step guide explains how to perform an upload or mass update of prerequisites for Students (e.g. CPR, First Aid, CRC) by direct upload of an Excel file to HSPnet. This data may also be entered directly into a student profile, or via the enrollment worksheet. Please see: [Student Admin - Prerequisite Tab - entry of Certifications, etc](https://kb.hspcanada.net/x/KoWk)etc, for more information about those two methods.</span>**<span
To watch the process, go to this 13 minute video that was part of a webinar: [ Student Admin - Automated Student Prerequisites Uploads Video](https://kb.hspcanada.net/x/44O3AQ)</span>****<spanVideo
Background:
Student prerequisites of the following types, corresponding to specific sections of the student profile, are available for automated upload:</span><span
Click one to get to the correct codes to use:</span>-
The upload of student prerequisites requires the student record to already exist in the system. A separate enrollment upload may be performed for adding student records, as explained in [ Automated Student Uploads](https://kb.hspcanada.net/x/FIWJ) Uploads reference guide.
To upload multiple types of prerequisites, separate spreadsheets need to be prepared, matching the format expected for each of the data fields for that prerequisites. Some prerequisites, such as orientations, certifications, or site prerequisites may have several entries applicable for the same student (e.g. a student who has completed multiple certifications). In this case, multiple entries in the upload spreadsheet may be present for that student.**
**Important - When preparing your excel lists they need to be per Program (eg; BScN) as you will need to acknowledge which program the students are in before the upload.**<div
Use the**the Prerequisites Upload**Upload template matching the specific type of prerequisite you wish to upload. You can not request a custom template for prerequisites, only use the ones listed.
For each type of prerequisite, you can download a sample of the template by clicking the blue link on the right.

For each upload template, column headers indicate the value required for upload. You will need to enter these values in the corresponding column. In each case, columns A, B, and C are mandatory to identify the student record.
Things to remember:
-
If you leave a field blank, that will NOT erase data (overwrite) current data in the database for that student.
- eg: You are changing the CertStatus, but you do not want to change the Cert Number. You can leave the cert number blank and it will not be overwritten.
- eg: You are changing the CertStatus, but you do not want to change the Cert Number. You can leave the cert number blank and it will not be overwritten.
-
If you DO want a field to be erased to blank, place the word NULL in the field. When you do the upload, the system will recognize NULL and erase that field. *** NULL does not work on the database code fields listed next.
Important - Certain fields for each prerequisite type need to be identified by a database code:
- OrientContent
OtherFormsType- Cert
- CertStatus
- CRCStatus
RespMaskSizeRespMaskSolutionUsedOccHealthReqStatusSitePreRequirementsSitePreReqCompliance
You can find the correct codes for each prerequisite type in the Appendix at the bottom of this guide.
Remember: You can have multiple prerequisites of the same type for one student on the same upload. Enter multiple lines with the same student information in columns A, B, and C.

Upload the spreadsheet
- Click the **Upload Student File **link in the Student Maintenance screen
- Select the template from the Upload Template drop-down list
- The top line of the Excel spreadsheet should match the template you choose
- In this sample the Excel spreadsheet needs to have the “header row” in row 1 (Last Name, First Name, etc.) and student data starting in row 2
- Column A on the Excel spreadsheet is Last Name; Column B is first name; Column C is Student Number, etc.
Do not have blank lines above or below the header row: Student data should start on line 2 of the spreadsheet.
3. Click Choose File to select the Excel file from your computer
4. Mark the This upload Files contains Students who have submitted a Consent form authorizing their personal information to be added to HSPnet for their education program of xxxx check-box
5. Click Upload file

The Upload Validation Screen opens
If all is well, and you see the **Process Upload **button, make sure that you do the following:
- Click the Update contact information for existing students
- Then click Process Upload
If the Process Upload button does not appear the upload cannot proceed until corrections are made. See the Automated Student upload video for instructions on corrections to the validation screen.
The student records will be updated with prerequisites information.

Appendix
This Appendix lists the correct codes to use for the purpose of populating the each of the Prerequisites fields.
Other fields in the upload template not specified below are either free-form text entry fields, or should contain simply a YES/NO value.
Dates
Format example
M/D/Y
Nov 28/17 or 11/28/17
Orientation Provider
AgencyShortName or
AgencyShortName/SiteShortName
FHA or
FHA/DeltaHosp
FluVac19-20
COVID-19
Other Forms Agency/Dept
AgencyShortName or
AgencyShortName/SiteShortName
FHA or
FHA/DeltaHosp
Learner Placement COVID-19 Precautions
StdDeclare
Certification Status Codes
Description
Pend
Pending
Active
Active
Other
Other - see file
Certification Codes
Description
AAM
(AB)Alberta Association of Midwives
AccessStand
(ON)Accessibility Standards for Customer Service
ACLS
Advanced Cardiac Life Support
ACMDTT
(AB)Alberta College of Medical Diagnostic & Therapeutic Technologists
ACOT
(AB)Alberta College of Occupational Therapists
ACP
(AB)Alberta College of Pharmacists
ADSA
(AB)Alberta Diagnostic Sonographer Association
AdultAbuseReg
(MB)Adult Abuse Registry
AODA
(ON)AODA - Working Together
ASIST
Applied Suicide Intervention Skills Training
BLSC
(NS)Basic Lifesaving Certificate
CAMRT
(AB)Canadian Association of Medical Radiation Technologists
CARNA
(AB)College and Association of Registered Nurses of Alberta
ChildAbuse
(NS)Child Abuse Registry
ChildAbuseReg
(MB)Child Abuse Registry
CLPNA
(AB)College of Licensed Practical Nurses of Alberta
CMA
(AB)College of Midwives of Alberta
CMLTA
(AB)College of Medical Laboratory Technologists of Alberta
CMQ
(QC)Collège des médecins du Québec
CNO/RN
(ON)College of Nurses of Ontario - Registered Nurse Certification
CNO/RPN
(ON)College of Nurses of Ontario - Registered Practical Nurse
CoopWork
(ON)Coop Work Permit
CPR
CPR - Level not specified
CPR-C
CPR - Level "C" Non-Healthcare Provider
CPR-HCP/BLS
CPR - Level "Health Care Provider"/Basic Life Support (BLS)
CDSBC (BC)College of Dental Surgeons of BCCPSA
(AB)College of Physicians and Surgeons of AB
CPSBC
(BC)College of Physicians and Surgeons of BC
CPSM
(MB)College of Physicians and Surgeons of MB
CPSNL
(NS)College of Physicians & Surgeons of NL
CPSNS
(NS)College of Physicians & Surgeons of NS
CPSO
(ON)College of Physicians and Surgeons of ON
CPSS
(SK)College of Physicians and Surgeons of SK
CRPNA
(AB)College of Registered Psychiatric Nurses of Alberta
CSDMS
(AB)Canadian Society of Diagnostic Sonographers
EMS/Midwifery
(AB)Provincial EMS/Midwifery Collaboration Project
FASD
(SK) FASD For the Frontline -Fetal Alcohol Spectrum Disorder
FireSafety
(BC)Fire Safety - Code Red
FirstAid
First Aid
FoodSafe
(BC)Food Safe Cert
GentPersApp
(ON)Gentle Persuasive Approach
Glucometer
Glucometer
H1N1
Influenza Pandemic: Online Course
HealthSafety
(ON)Health and Safety Awareness Training - ON Ministry of Labour
InjuryPrev
Injury Prevention
IPACCoreComp
(ON)IPAC Core Competencies - Public Health Ontario
IVCert
IV Certification
LPNAssoc
LPN Association
NCVI
Non-Violent Crisis Intervention Certificate
NonViolence
(MB)Non-Violent Crisis Intervention
NRP
Neonatal Resuscitation Program
NSHospInfo
(NS)Nova Scotia Hospital Information System
OccHealth
(NS)Occupational Health And Safety
Omnicell
(NS)Omnicell
OthRNAssoc
Other Provincial RN Association
PACA
(AB)Physiotherapy Alberta College & Association
PART-Basic
Professional Assault Response Training - Basic
PART-Intermediate Professional Assault Response Training - Intermediate PART-Advanced Professional Assault Response Training - Advanced PART-Trainer Professional Assault Response Training - TrainerPedsALS
(AB)Pediatric Advanced Life Support
PHIA
(NS)Personal Health Information Act
PHIACert
(MB)PHIA Certification
ProvHandHygiene
(BC)Provincial Hand Hygiene Basics - PICNet
RDPNAssoc
(BC)RDPN Association
RNAssocAB
RN Association - AB
RNAssocBC
RN Association - BC
RNAssocMB
RN Association - MB
RNAssocNB
RN Association - NB
RNAssocNL
RN Association - NL
RNAssocNS
RN Association - NS
RNAssocNT
RN Association - NT
RNAssocNU
RN Association - NU
RNAssocON
RN Association - ON
RNAssocPE
RN Association - PE
RNAssocQC
RN Association - QC
RNAssocSK
RN Association - SK
RNAssocYT
RN Association - YT
SCP
(SK)Saskatchewan College of Paramedics
ViolencePrev
Violence Prevention
W.A.V.E.
(SK)Workplace Assessment & Violence Education
WHMIS
Workplace Hazardous Materials Information System
CRC Status Codes
Description
Unknown
Unknown
ReceivedOK
Received - Clear Record
PosFollow
Positive - Followup needed
PosOK
Positive - OK to proceed
Signed
Respiratory Mask Size Codes
Sweet
Unknown
Occupational Health Requirements Status
YES
Site Prerequisite Codes
No
OTHER Other <div class="greybox" align="left">

[image2018-11-19_10-40-28.png](attachments/7569515/7569511.png) (image/png)

[image2018-11-19_10-50-1.png](attachments/7569515/7569512.png) (image/png)

[image2018-11-19_10-59-54.png](attachments/7569515/7569513.png) (image/png)

[image2018-11-19_11-20-57.png](attachments/7569515/7569514.png) (image/png)

[image2018-12-5_10-58-21.png](attachments/7569515/7569591.png) (image/png)

[image2018-12-5_10-58-40.png](attachments/7569515/7569593.png) (image/png)

[image2018-12-5_10-58-52.png](attachments/7569515/7569594.png) (image/png)

[image2018-12-5_10-59-1.png](attachments/7569515/7569595.png) (image/png)

[preq3a.png](attachments/7569515/33364678.png) (image/png)

[preq1.PNG](attachments/7569515/33364679.png) (image/png)

[preq2.PNG](attachments/7569515/33364680.png) (image/png)

[preq4a.png](attachments/7569515/33364681.png) (image/png)
</div>
</div>
</div> </div>
<div id="footer" role="contentinfo">
<section class="footer-body">
Document generated by Confluence on Nov 03, 2023 15:05
<div id="footer-logo">[Atlassian](https://www.atlassian.com/)</div>
</section>
</div>
</div>



