CK Record Layout
In the CK record:
The FTE, Hours Per Day, Amount/Rate, and Special Ed FTE fields are multiplied by 100 to preserve two decimal places.
The EMIS Employee ID field can contain either the State Staff ID or the Employee Number, depending on whether Use Employee ID is selected on the Staff Information tab of the EMIS Data Export page.
Assignment Area 1 is exported as "000000" if null.
Multiple CK records can exist per employee (one for each position held).
For more information about the CK record layout, refer to Section 3.4 of the EMIS Manual.
The following table lists the numbers, names, descriptions, positions, lengths, and data source or valid values for the CK record.
Number | Name | Description | Position | Length | Data Source or Valid Values |
|---|---|---|---|---|---|
Not applicable | filler | Leave blank | 1-8 | 8 | spaces |
CK010 | Sort Type | Identifies the record type. | 9-10 | 2 | The valid value is CK and is system-generated. |
Not applicable | filler | Leave blank | 11 | 1 | spaces |
CK020 | Fiscal year | The reporting fiscal year. | 12-15 | 4 | Retrieved from the Staff Fiscal Year field on the EMIS Profile page. |
CK030 | Reporting Period | The reporting period of the fiscal year. | 16 | 1 | Valid values:
Retrieved from the Staff Reporting Period field on the EMIS Profile page. |
CK040 | District IRN | The six-digit state-assigned Information Retrieval Number (IRN). | 17-22 | 6 | Retrieved from the District IRN field on the EMIS Profile page. |
CK050 | Employee ID | The EMIS employee number. | 23-31 | 9 | Retrieved from the Employee Number field on the Employee Information page when Use Employee ID is selected on the Staff Information tab of the EMIS Data Export page. Retrieved from the Staff State ID field on the Personnel tab of the Employee Information page when Use Employee ID is not selected on the Staff Information tab of the EMIS Data Export page. |
CK060 | Position code | The code associated with the employee's position assignment. | 32-34 | 3 | Retrieved from the EMIS Position field on the EMIS Position Information page. |
CK070 | Position status | The employee's current employment relationship with the school board in that particular position. | 35 | 1 | Valid values:
Retrieved from the Position Status field on the EMIS Position Information page. |
CK080 | Position start date | The date the staff member began work in this position. | 36-43 | 8 | Retrieved from the Start Date field on the EMIS Position Information page. |
CK090 | Building IRN | The state-assigned six-digit Information Retrieval Number (IRN) of the building. | 44-49 | 6 | Retrieved from the Building IRN field on the EMIS Position Information page. |
CK100 | Position FTE | The full-time equivalency of the position expressed as a percentage. | 50-52 | 3 | Retrieved from the Position FTE field on the EMIS Position Information page. The final calculated value is FTE × 100 (e.g., 1.00 FTE = 100). |
CK120 | Fund Source Percent 1 | The percentage of funding for Fund Source 1. | 53-55 | 3 | The valid values are 1 – 100. Fund Source percentages must add up to 100. Retrieved from the Percent field (first row) in the Funding Information section of the EMIS Positions page. |
CK130 | Position Fund Source 1 | The fund source for the assignment. | 56 | 1 | Valid values:
Retrieved from the EMIS Fund field (first row) in the Funding Information section of the EMIS Positions page. |
CK120 | Fund Source Percent 2 | The percentage of funding for Fund Source 2. | 57-59 | 3 | The valid values are 1 – 100. Fund Source percentages must add up to 100. Retrieved from the Percent field (second row) in the Funding Information section of the EMIS Positions page. |
CK130 | Position Fund Source 2 | The fund source for the assignment. | 60 | 1 | Valid values:
Retrieved from the EMIS Fund field (second row) in the Funding Information section of the EMIS Positions page. |
CK120 | Fund Source Percent 3 | The percentage of funding for Fund Source 3. | 61-63 | 3 | The valid values are 1 – 100. Fund Source percentages must add up to 100. Retrieved from the Percent field (third row) in the Funding Information section of the EMIS Positions page. |
CK130 | Position Fund Source 3 | The fund source for the assignment. | 64 | 1 | Valid values:
Retrieved from the EMIS Fund field (third row) in the Funding Information section of the EMIS Positions page. |
CK140 | Position type | The type of employment with the school board. | 65 | 1 | Valid values:
Retrieved from the Position Type field on the EMIS Position Information page. |
CK150 | Type of Appointment | The classification of the staff member's position. | 66 | 1 | Valid values:
Retrieved from the Type of Appointment field on the EMIS Position Information page. |
CK160 | Length of Work Day | The total hours worked during a normal day, excluding lunch. | 67-70 | 4 | Retrieved from the Length of Work Day (Hours) field on the EMIS Position Information page. The final calculated value is Hours per day × 100 (e.g., 7.50 hours = 0750). |
CK170 | Scheduled Work Days | The total number of days the staff member is scheduled to work in the position during the year. | 72-73 | 2 | Retrieved from the Scheduled Work Days field on the EMIS Position Information page. |
CK180 | Pay Type | The type of contract pay. | 74 | 1 | Valid values:
Retrieved from the Contracted Pay Type field on the EMIS Position Information page. |
CK190 | Pay Amount/Rate | The pay rate for the position. Depending on the Contracted Pay Type field, this amount may be an hourly rate or an annual salary amount. | 75-82 | 8 | Retrieved from the Contracted Pay Amount/Rate field on the EMIS Position Information page. The final calculated value is Salary or hourly rate × 100. |
Not applicable | filler | Leave blank | 83-86 | 4 | spaces |
CK220 | Assignment Area | The six-digit code that specifies and defines the position. | 87-92 | 6 | Retrieved from the Assignment Area field on the EMIS Position Information page. |
Not applicable | filler | Leave blank | 93-104 | 12 | spaces |
CK230 | Position Separation Reason | The reason the staff member left the position. | 105 | 1 | Valid values:
Retrieved from the Separation Reason field on the EMIS Position Information page. |
Not applicable | filler | Leave blank | 106 | 1 | spaces |
CK250 | Local Contract Code | The unique number assigned by the school district that distinguishes among multiple contracts for a staff member within the same position code. | 107-109 | 3 | Retrieved from the Contract Code field on the EMIS Position Information page. |
Not applicable | filler | Leave blank | 110-114 | 5 | spaces |
CK290 | Qualified Paraprofessional | Indicates if the staff member is a qualified paraprofessional under the No Child Left Behind Act. | 115 | 1 | Valid values:
Retrieved from the Qualified Paraprofessional field on the EMIS Position Information page. |
CK300 | Position Separation date | The last date of employment of the staff member for the specific position. | 116-123 | 8 | Retrieved from the Separation Date field on the EMIS Position Information page. |
CK310 | Special Ed FTE | The total number of days the staff member is scheduled to work in the position during the year. | 124-126 | 3 | Retrieved from the Special Education FTE field on the EMIS Position Information page. The final calculated value is Special education FTE × 100. |