We have a teacher under a temporary contract replacing another teacher that is on leave.  Who do I put on the report?    

You will take the teacher that is on leave off of the report and place the teacher that is under a temporary contract on the report if they are also licensed.

We have a teacher that has 9 ½ years of experience.  How do we report the experience?  

Years of Experience can only be reported in full years.  You will have to report the teacher as 9 years of experience.  It takes 120 days to count as a year of experience.

We have a teacher that teaches every day of the week all year long but only teaches ½ days.  How do we report her time? 

You will report the teacher with 180 contract days for 50% of the time.

We have a teacher that teaches all day three days a week all year long.  We have school 36 weeks a year.  How do I report their time?    

You will report the teacher with 108 contract days (36 x 3) for 100% of the time.

For submission of the CE report you have asked each teacher to be rated for column S as HQT (choices 1-4).  But teachers are rated by the subject they teach, so each teacher might be rated HQ for one subject but not HQ for another.  As it is we are left to guess which the more appropriate response is.  It would be more appropriate to have the HQT on the CP report.

If the teacher is HQ in any area please report the teacher as being HQ.

We have several employees that we hold their contract and they teach in another school corporation.  How do we report their data?

You will report their CE record and the corporation where they teach will report the CP record.  The CP record will reflect the corporation number of the corporation that holds the contract and the school number where they are physically teaching.

Would we include special education teachers?

The data layout states: "Report the data for all certified employees of the corporation."   Enter "1" in Field 19 "Special Populations Employee" for employees who teach Special Education.

We have a part time first year teacher at one of our buildings, she teachers Title One, should she be included?     

If she is licensed and you have a contract with her then she should be put on the report.

Will there be or is there as in the past an excel spreadsheet on previous data sent for the CE/CP Report?  95% of our data is the same and we could upload this information into the STN sight and only make necessary changes instead of starting from scratch.

Current information is that last year's data will be available as a download in the usual Application Center formats. Excel worksheets formatted for CE/CP data will be available as an optional tool.  However; these worksheets will not be pre-loaded.

How do we go about getting EMPLOYEE ADMINISTRATION?  I have the corp. level login and password for our corporation, but when I go to data transfer and file type, I don't see a DOE CE/CP option so I can upload this report properly.  I need to help a staff member in our supt. office to do this. How do we upload this info?  It's sure not explained clearly to us.  Please help!

You must be a Corporate Maintenance User to assign Employee Administration permissions.  Under Administration > User Security > User Maintenance.  Once you have the Employee Administration assigned then you will find the CE/CP data under Administration > Retrieve Student Data > 2006-2007 > Certified Employee or Certified Position.

We are pretty close to having our CE/CP file ready to send.  I don’t see where we do that on the STN site.  I have checked to make sure I have Employee Administration on the User Maintenance Screen.  Am I looking in the wrong place?

Once you have the data updated you will send it under Data Transfer > File Transfer.

How do I resolve the CE warning:  xxxxxxxxx: License not found for SSN xxxxxxxxx?

Please verify that you are using the correct SSN for the employee.   If you are using the correct SSN contact Professional Standards Board (317-232-9010) and explain the issue to them to see what SSN they have on file for the employee.

We have an elementary counselor who completed 4 years of service as a non-certified social worker.  She has completed her degree and is now a licensed School Counselor, paid at 0 years' experience.  On the CE report I listed her as 0 years' experience, but did not code her as 1st year because this is her 5th year.  My failed record says "if total years of experience equals 0, First Year Teacher should equal 1".  Should I change her years' experience to 4 or code her as a 1st year?

Since you are not paying her for the 4 years of experience and have listed her years of experience as 0 then you will need to mark the first year column.

  "License not found for SSN ######## "
This teacher is in the Transition to Teaching Program and will not be licensed until this spring.  In the HQT column I have coded her as 3.  How can I code this so that I do not have an orange exclamation mark?

Since the teacher will not receive their license until spring they should not be reported since the qualifiers for this report are licensed and have a contract. 

I have resent both my DOE-CE and DOE-CP reports to correct some errors, and I am certain that both reports contain the correct SSN for a certain employee.  However when I download the Certified Employee Summary Report it states that this employee has a different SSN and that she has a "CE record with no CP record.  Since I just sent these corrections this morning perhaps it is simply a timing issue for the summary report to be updated.

The first CE file that was submitted on 10/02/2006 with transfer i.d. of 246304 contained the SSN in question.  You will need to go to the Input Form for the Certified Employee and delete the record from there as simply removing or changing a SSN in your file does not remove the record after it has been accepted.

I submitted my CE report and am getting a new warning:  xxxxxxxxx:  Supplemental Salary '50000' too high?

We have to have a cap on salaries to start checking for data entry errors.

Are we able to correct errors once we have submitted our reports or do we need to resubmit the entire file?  I see the input screen but I didn't know if that would be for someone not already reported.

You may send just your correction or send the entire file.  You may also make changed via the Input Form under Data Transfer.

The names do not display on the CP spreadsheet, I have already edited the CE data and do not want to start over. How can I get the names to appear?

Upon beginning the entry of the CE/CP data you must follow the instructions for importing the CE data to have the names appear on the CP data. If you did not follow the instructions below is a shortcut to re-establish the connection between the tables.

Quick Fix if Names are not showing on the CP sheet.

(Process: Move the SSNs to Word for safekeeping while you clean out the cells and restore the original Text formatting. Then bring the raw SSNs back in as raw data.)

1. Go to CE sheet and unprotect it (Tools > Protection > Unprotect Sheet)
2. Select the data in the SSN column (from row 1 down to the end of your data) and copy it (Edit > Copy)
3. Open Word and paste data into Word (Edit > Paste).
4. Go back to Excel. While your data is still highlighted, clear out the cells (Edit > Clear > All)
5. Click on the "B" above your SSN column to select it.
6. Reformat Column B "SSN" as Text (Format > Cells > "Number" Tab; under "Category", select "Text" then click "OK").
7. Go back to Word and copy your data (Edit > Copy).
8. Return to Excel and paste data in as text (Edit > Paste Special > Paste [as] Text)
9. Check your CP sheet; names should be displayed.

IMPORTANT MESSAGE FOR NONPUBLIC SCHOOLS
DOE-CE/CP: If you are a nonpublic school reporting your DOE-CE data and the DOE-CP data and you did not download the 06-07 data you will need to use your school number in the corporation field on the DOE-CP. If not, you will get the error:
XXXXXXXXX: A matching certified employee record with a SSN of 'XXXXXXXXX' and a corp/school of 'XXXX' was not found.
Separating CE data form CP worksheet in the DOE-provided Excel spreadsheet