Technical Support

File Types

PAEA (Physician Assistant Education Association) Monitoring Suite Data Files

PAEA Suite of Dashboards for Physician Assistant Programs: What files do I need to send?

When to send

How to send

As soon as you have new files available.

For PACKRAT:

If you have a new class where only partial data (first test) is available, go ahead and send us both of the initial files. Then send us subsequent files as they become available.

You should be submitting your files through your Enflux BOX account.

Please remember:

Generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.
You should be sending all designated types of files for each year and/or test area.

PANCE

PACKRAT

EoC - End of Curriculum

EoR - End of Rotation

PANCE: Physician Assistant National Certifying Examination

For PANCE, You will upload two (2) files per year. "Program Performance Report by Class" and "Score Report." Both of these should be .xls files

Please use the following matrices to guide the upload of files to the PANCE folder in your Enflux BOX folder.
Enflux must receive the Roster spreadsheet and the ‘Program Performance Report by Class’ spreadsheet for each class year.
For these files, each class will have one Score Report, and one Program Performance Report by Class.

Refer to pages 20-23 in this link from the NCCPA for a detailed explanation of how to download these reports. https://www.nccpa.net/wp-content/uploads/2021/06/Program-Portal-User-Manual.pdf

Below is an example of what the file output should look like:

Performance Report 2020.xlsx

This report will have two tabs.

Sheet 1 contains this summary table containing the Class Overview

Sheet 2 contains three parts.

First the program identification information.

The program summary Table

and the PANCE Content Area Feedback

Score Report 2020.xlsx

This report will have 1 tab.

The report header will include:

Print date
Page count
Program Name (your university)
Program Number (your id number)
Class Name
Students (All Students)

Listed fields in the Score Report:

Class
Type, which may include First-Time Takers and Repeat Takers
Name
Exam Date
Result
Score
Organ System (14 areas)
Knowledge and Skills (8 areas)

Things we notice about the files

When sending PANCE files, please be sure of the following:

The Program Performance Report is by class. It will have four rows in the heading, the second of which will clearly state “Program Performance by Class.”
The Program Performance Report by Class has Sheet1 and Sheet2. Sheet1 contains descriptive text and the Class Overview table. Sheet2 contains the Program Summary Table and PANCE Content Area Feedback.
- - We have seen a couple of 2022 reports that have changes to this format. We’re not sure if they’re standard reports. Differences we’ve noticed include:
  - All three tables showing up on one worksheet
  - The label #NOT_SUPPORTED# between the text and the tables
  - No labels identifying First Time Exams and All Exams mean and s.d. Columns in the PANCE Content Area Feedback table. The columns exist but are not labeled properly.
Select All Students when sending the score report if you want to see the results for repeat takers as well as first time takers.
For both the Program Performance Report and the Score Report, you may send us updated files if you have students who need to repeat the exam. Upon receipt of the updates, we will update the dashboards to reflect the additional attempts.

Matrix to help you know that you have submitted all of your files in .xls format. You should be sending both types of files for each year

Year	Program Performance Report by Class	Score Report
2019	.xls	.xls
2020	.xls	.xls
2021	.xls	.xls
2022	.xls	.xls
(indicate your year)	.xls	.xls

PACKRAT: Physician Assistant Clinical Knowledge Rating and Assessment Tool

For PACKRAT, You will upload two (2) files per year. "Composite Score Report" and "Performance Report by Class"

Enflux must receive the PACKRAT Composite Score Report spreadsheet for each "class of" or "cohort." Additionally, we must receive a Performance Report by Class report in the form of an HTML file. Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.

If you have a new class where only partial data (first test) is available, go ahead and send us both of the initial files. Then send us subsequent files as they become available.

Below is a list of example files for a single year:

2019 Composite Score Report PACKRAT.xlsx

This file will have two tabs: Class Scores and Keys.

The file header identifies that it is PACKRAT Composite Score Report, Your Institution, and the Class of.

The listing will be by student name and provide:

Form Name
Exam Date
Score Released (True/False)
Raw Score
% Correct
% for each Specialty Area (1- 13; columns G through S)
% for each Task Area (A-G; columns T through Z)

2019 Performance Report by Class (PACKRAT).html

The .html file will contain two sections:

Summary with comparison to National Scores
Content Area Feedback
1. Task Areas
2. Specialties

Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.

Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending all types of files for each year

Class Year	Performance Report by Class*		Composite Score Report
2019	.html	.html	.xlsx
2020	.html	.html	.xlsx
2021	.html	.html	.xlsx
2022	.html	.html	.xlsx
(indicate your year)	.html	.html	.xlsx

*Performance Report by Class: One (1) .html file per class and exam. In most cases you will send more than one file. Example: Class of 2020 - PACKRAT 024; Class of 2022 - PACKRAT 025

PA EoC: End of Course

Enflux must receive the Composite Score Report in a spreadsheet and the Performance Report by Class in HTML format.

Below is a list of example files for a single year:

Composite Score Report EOC2020.xlsx - one row for each student in the cohort/class

This file will have two tabs: Class Scores and Keys.

The file header identifies that it is the End of Curriculum Composite Score Report, Your Institution, and the Class of.

The listing will be by student name and provide:

Form Name
Exam Date
Score Released (True/False)
Student Score
Scale Score for each Content Categories (1- 13; columns F through R)
Scale Score for each Task Area (A-G; columns S through Y)
Scale Score for EPAs (1-4; columns Z through AC)
Scale Score for Setting (A-D; columns AD through AG)
Scale Score for Life Course (1-3; columns AH through AJ)
Scale Score for Bloom’s Taxonomy (A-C; columns AK through AM)

Performance Report by Class EOC 2020.html - summary data for the "class" and "all programs"

The .html file will contain three sections:

Summary with comparison to National Scores
Class of Performance Levels
Class of Summaries for
1. Content Categories
2. Tasks
3. Entrustable Professional Activity
4. Key Dimension: Setting
5. Key Dimension: Life Course
6. Key Dimension: Bloom’s Taxonomy

Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.

Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending both types of files for each year

Year	Composite Score Report	Program Performance Report by Class
2019	.html	.xlsx
2020	.html	.xlsx
2021	.html	.xlsx
2022	.html	.xlsx
(indicate your year)	.html	.xlsx

PA EoR: End of Rotation

Enflux must receive one Composite Score Report spreadsheet file per rotation. Additionally, we must receive one Performance Report HTML file per rotation.

Below is a list of example files for a single year:

Excel files have one row for each student in the cohort/class

2021 CompositeScoreReport Emergency Medicine EOR.xlsx
2021 CompositeScoreReport Family Medicine EOR.xlsx
2021 CompositeScoreReport General Surgery EOR.xls
2021 CompositeScoreReport Internal Medicine EOR.xlsx
2021 CompositeScoreReport Pediatrics EOR.xls
2021 CompositeScoreReport Psychiatry EOR.xlsx
2021 CompositeScoreReport Women’s Health EOR.xlsx

The files each contain two tabs:

Class Scores post
Keys post

HTML:

2021 Performance Emergency Medicine EOR.html
2021 Performance Family Medicine EOR.html
2021 Performance General Surgery EOR.html
2021 Performance Internal Medicine EOR.html
2021 Performance Pediatrics EOR.html
2021 Performance Psychiatry EOR.html
2021 Performance Women’s Health.html

These .html files will have two sections:

Summary of scores
Class of scores for:

Content Categories
Tasks

Please generate the HTML files directly from the PAEA portal. We are unable to process files originally saved as PDF and converted to HTML.

Matrix to help you know that you have submitted all of your files in .xls and .html format. You should be sending both types of files for all areas for each year

Composite Score Report.xls

	Class Year
	2023	2022	2021	2020	2019
Emergency Medicine	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
Family Medicine	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
General Surgery	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
Internal Medicine	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
Pediatrics	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
Psychiatry	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx
Women’s Health	.xlsx	.xlsx	.xlsx	.xlsx	.xlsx

Performance Report.html

	Class Year
	2023	2022	2021	2020	2019
Emergency Medicine	.html	.html	.html	.html	.html
Family Medicine	.html	.html	.html	.html	.html
General Surgery	.html	.html	.html	.html	.html
Internal Medicine	.html	.html	.html	.html	.html
Pediatrics	.html	.html	.html	.html	.html
Psychiatry	.html	.html	.html	.html	.html
Women’s Health	.html	.html	.html	.html	.html