Electronic Data Access (EDA) - JAM GPC Training Report

JAM GPC Training Report

JAM GPC Training Report

Reference Guide

Click this link to open the Reference Guide JAM GPC Training Report document (PDF)

Reference Guide

Table of Contents

EDA Role

Search Criteria

Sample Search Results

Exporting Search Results

EDA Roles	Roles with the ability to access JAM GPC Training Report in EDA Acquisition Sensitive Reporting Advanced Reporting EDA Executive Reporting User
Search Criteria	Log in to PIEE and select the EDA link. From the EDA Dashboard, select Reports from the Analytics section and click on JAM Reports from the drop down. Select the JAM GPC Training Report from the JAM Reports page. On the JAM GPC Training Report page, enter search criteria to retrieve desired data. Appointment Appointment Type Component Program Manager Appointment Certifying Officer Appointment Agency/Organization Program Coordinator Appointment Approving/Billing Official Appointment Oversight Agency/Organization Program Coordinator Appointment Cardholder Appointment Appointment Type Sub Filter All Micro-Purchase ETO Cardholder and Convenience Check Writer Contract Ordering Official Cardholder Misc. Payments Official Cardholder (SF-182 Training Payments) Micro-Purchase Cardholder Micro-Purchase Higher Education Cardholder Overseas Simplified Acquisition Cardholder Inter/Intra-Governmental Payment Officer Cardholder Micro-Purchase Convenience Check Writer Warranted Overseas ETO Cardholder Contract Payment Official Cardholder Appointment Status All Pending Appointing Authority Approval Active Draft Rejected by Appointing Authority Inactive Pending Appointee Approval Pending Supervisor Approval Deleted Rejected by Appointee Rejected by Supervisor Update Appointment Status Date [Range] Nominator Nominator Location Code Equal to Starts with Training Training Course Type All DoD Specified Component Specified Training Completion date [Range] Training Due Date [Range] Component List of Agencies Course Description (dropdown list of training courses) Show Only Current Training? (checkbox) Show Only Expired Training? (checkbox) Role Role Status All Archived Approver Rejected Inactive Pending Approval Deleted Active Activation Required User Organization Organization Type Organization Code Equal to Starts with Organizational Group Find Group (Organizational Group Selection for Appointee Organization (pop-up box) Include Subgroups (toggle) After the search criteria has been entered, select the Search button. Note: Recommended: Select ‘All’ from the Training Course Type dropdown to display and export results that include user data for both DoD- and Component-required courses. Select a specific Component to display and export results that exclude user data for DoD-required courses (e.g., CLG 0010 and CLG 006). Only data for additional courses specified by the Component will be returned.
Sample Search Results	JAM GPC Training Report Search Results will include the following fields: Service (DoD Component) Appointment First Name Appointment Workflow Status Date Training Other Course Component Appointment Last Name Training Type Course Type Appointment Type Training Description Organization Code Appointment Workflow Status Training Date Sample Search Results:
Exporting Search Results	Once the search results are returned, the Export Results button will allow the user to export search results in CSV format for import to a spreadsheet. Export Results Column Values: Appointment First Name Service (DoD Component) Role Status Organization Level Supervisor Email Address Direct User Email Address Direct User Group Training Description Training Frequency Training Provider Appointment Type (PIEE Role) Contract Ordering Official Cardholder Micro-Purchase Cardholder Micro-Purchase Higher Education Cardholder Warranted Overseas ETO Cardholder Appointment Last Name Home Organization Service/Org (DoD Organization Name) Supervisor First Name Direct User First Name Direct User Type Nominator Location Code Training Other Training Due Date Training Source Appointment Workflow Status Contract Payment Official Cardholder Micro-Purchase ETO Cardholder and Convenience Check Writer Misc. Payments Official Cardholder (SF-182 Training Payments) Course Component Appointment (Work Email Address) Role Location PIEE Group Path of Appointee Supervisor Last Name Direct User Last Name Direct User DoDAAC Training Code Training Date Training Hours Current Row Appointment Workflow Status Date Inter/Intra-Governmental Payment Official Cardholder Micro-Purchase Convenience Check Writer Overseas Simplified Acquisition Cardholder Course Type The CSV report can be save to computer and opened with Excel. Excel sample report: