> For the complete documentation index, see [llms.txt](https://dcyf.gitbook.io/cmshandbook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dcyf.gitbook.io/cmshandbook/upload-tool/step-by-step-instructions-for-uploading-data/upload-attendance-for-job-placements.md).

# Upload Attendance for Job Placements

{% stepper %}
{% step %}
**Ensure that Job Placements have been created in CMS.**
{% endstep %}

{% step %}
**Run the ‘Participant, Parent & Staff Extract’ from the CMS *****Data Extracts***** tab.**
{% endstep %}

{% step %}
**Run the ‘Activity Extract’ from the CMS *****Data Extracts***** tab.**
{% endstep %}

{% step %}
**Filter for “Job Placements” in the Activity Extract under the Activity Type column (Column F).**
{% endstep %}

{% step %}
**Download the ‘Job Placements Upload template’ from the *****Resources***** tab – *****Upload***** section.**
{% endstep %}

{% step %}
**Enter the following required information: Person IDs of the participants with job placements, Activity Instance IDs of the job placement activities, Start Dates, Expected End Dates, virtual/remote placement, Compensation, Subsidized/Unsubsidized, Work Hours, and Job Type.**

 You can pull Person IDs from the ‘Participant, Parent & Staff Extract’ and Activity Instance IDs from the ‘Activity Extract’. Column C, Placement ID, is populated only when you are making updates to attendance records. Please see below.
{% endstep %}

{% step %}
**(Optional) Populate column N.**
{% endstep %}

{% step %}
**Save the file to your computer.**
{% endstep %}

{% step %}
**Click on the *****Upload***** tab in the left-hand menu in CMS.**
{% endstep %}

{% step %}
**Click on the *****Choose File***** button in the Data Upload Tool.**
{% endstep %}

{% step %}
**Select the upload template file you would like to upload. This will upload the file to the Data Upload Tool.**
{% endstep %}

{% step %}
**Select the Job Placement Attendance Upload’ for *****Type***** in the Data Upload Tool.**
{% endstep %}

{% step %}
**Click on the *****Begin Upload***** button in the Data Upload Tool.**
{% endstep %}

{% step %}
**(If applicable) Review any error messages, make the appropriate changes and repeat steps 9-13.**
{% endstep %}
{% endstepper %}

## **Update attendance records in Job Placements**

You may need to update or change job placements you have uploaded. For example, you may need to enter Actual End Dates or other information about the placement that was left out of the original upload. Instead of making these changes manually (i.e. going into the job placement record in CMS and manually entering this information), you may use the Data Upload Tool.

{% stepper %}
{% step %}
**Run the ‘Placement Extract’ from the *****Data Extracts***** tab in CMS.**
{% endstep %}

{% step %}
**Download the ‘Job Placement Attendance Upload template’ from the *****Resources***** tab – *****Upload***** section.**
{% endstep %}

{% step %}
**Pull Placement ID for the job placement record(s) you would like to update from the ‘Placement Extract’.**
{% endstep %}

{% step %}
**Enter the Placement ID for the job placement record(s) you would like to update into the upload template.**
{% endstep %}

{% step %}
**Enter the information you would like to upload into the appropriate columns.**
{% endstep %}

{% step %}
**Save the file to your computer.**
{% endstep %}

{% step %}
**Repeat steps 9-14 above for Job Placements.**
{% endstep %}
{% endstepper %}