Work Assignment

Person ID 

Certificate Record - Teaching Certificate Number 

Teaching Certificate Defined from User Specific Parameters Profile – Field “Teaching Certificate Type/Class/Code” 

Birth Date 

HR Demographics – Birth Date 

Last Name 

HR Demographics – Last Name 

First Name 

HR Demographics – First Name 

Middle Name 

HR Demographics - Middle Name 

Email 

HR Demographics – Email with domain from HR Master Profile if email does not already contain domain 

Gender 

HR Demographics – Gender 

Aboriginal Status 

HR Demographics – Ethnic Code. 

If blank, extract will report code 02 (choose not to declare) 

Phone Number 

HR Demographics – Phone 1 and 2. 

Process will define Phone 1 as Type of “Home” and Phone 2 as Type of “Mobile” 

Process will define formats of both phone numbers as ‘NA’ (North America). 

Work Site Identifier 

Assignment Location > Translation Table 

Contract Identifier 

Builds a Contract Identifier based on the employee no, and contract type (10001_01_01) and iteration of that contract type in the case of multiple contracts.  

Examples: 

Suzy Q. (employee 12345) has 2 assignments:  

• 0.5 Permanent (perm translated to 01 contract type) 

• 0.5 Temporary (temp translated to 02 contract type) 

Identifiers would look like 12345_01_01 and 12345_02_01 

Johnny B. (employee 67890) has 2 assignments:  

• 0.5 Temporary (temp translated to 02 contract type) 

• 0.5 Temporary (temp translated to 02 contract type) 

Identifiers would look like 67890_02_01 and 67890_02_02 

Percent Time Employed 

Location FTE 

Start Date 

Start date is set as either the as of assignment start date from prompt or the assignment start date if it occurs after the asof assignment start date prompted value. 

End Date 

The date when employment ended / separation occurred. 

K12 Teacher Time 

If Assigned Position User Defined Field “Time Allotment” starts with K12TEACH, a tag of <K12TeacherTime> is printed with an attribute based on the User Defined Position Code 2 Field 02. 

HR Setup & Maintenance > Setup Tables > User Defined Position Code 2 > Inquire > select applicable Time Allotment code, then the 2nd User Pos2 Database Field is what is used as the attribute. 

For example, if the position had a Time Allotment of K12TEACH01, that code has 01 in the 2nd User Pos2 Database Field. 

The resulting tag would be <K12TeacherTime code=“01”> 

From there, if the teacher time code is NOT 01, 03, 05, 06, or 08, the extract prints the same amount as time employed. For example, if the time employed was 100, it would print: <K12TeacherTime code=”04”>100</K12TeacherTime> 

If the teacher time type code is 01, 03, 05, 06, 07, or 08, Prep Time is factored in and the K12TeacherTime is the time employed minus calculated prep time. 

Prep Time (Auto-Generation of Code 02) 

From the location code on the assignment, look at location user defined field (should be labelled as Prep Time). 

• Multiply the prep time percentage by the Percent Time Worked.  

• Example: Percent Time worked is 100, location prep time is 3. Teacher Time Code of 01, 03, 05, 06, 07, or 08 would be 97 and another K12TeacherTime Code of 02 would be generated with a percent time of 3: 

<K12TeacherTime Code =“01”>97</K12TeacherTime> 

<K12TeacherTime Code =“02”>3</K12TeacherTime> 

These numbers are rounded up and always expressed as a whole number. 

Admin Time 

If position code user defined field “Time Allotment” starts with ADMIN, this tag is printed with the attribute code defined from the 2nd User Pos2 Database Field. 

Data within the tag is the percent time worked. For example: 

<AdminTime Code=“09”>100</AdminTime>