hrLoadJob

Overview

The hrLoadJob processes .xml and .done files dropped into the staging/sys/hrLoad directory in order to update the Person table based on data from an institution's HR system. 

• If a record exists for the first time in the file, a new Person record is added. 
• If a record exists for an existing Person, the Person record is updated. 
• If a record no longer exists for an existing Person, the Person record is inactivated, with the following exceptions: 
  • Person records with Affiliation Type = AFLT,
  • Person records with Entity Type Code = SYSTEM, such as, kfs, kr and admin, 
  • Person records included in parameter PRINCIPAL_NAMES

Reports

Directory	Name	Description
reports/sys	hrLoadJob_<dateTimestamp>.txt	Reports on the number of:  XML Records processed Inserted Principal count Updated Principal count Inactivate Principal count Unchanged Principal count  Any errors in processing - usually when there is a mismatch on principal name and ID in the file and the Person table.  Inserted + Updated + Inactivated = XML Record - Errors
report/sys	hrLoadJob_<dateTimestamp>.log	Reports on the number of records processed and any errors encountered.

XML File Format

The XML schema (.xsd) is available online at https://github.com/KualiCo/ce-tech-docs/blob/master/v3_0/hrmanifest.xsd

An example XML file follows:

<?xml version='1.0' encoding='UTF-8'?>
<hrmanifest xmlns="https://github.com/KualiCo/ce-tech-docs/tree/master/v3_0" schemaVersion="3.0" statusEmailRecipient="[e-mail]" recordCount="20594">
  <h:record xmlns:h="https://github.com/KualiCo/ce-tech-docs/tree/master/v3_0" entityId="KFS3776" principalId="6162502038" principalName="khuntley" active="true">
    <h:affiliationType>STAFF</h:affiliationType>
    <h:campus>BL</h:campus>
    <h:employeeStatus>A</h:employeeStatus>
    <h:employeeType>P</h:employeeType>
    <h:baseSalaryAmount>0.01</h:baseSalaryAmount>
    <h:primaryDepartment>UA-VPIT</h:primaryDepartment>
    <h:employeeId>0000202278</h:employeeId>
    <h:addressLine1>East Peltason Dr</h:addressLine1>
    <h:city>Irvine</h:city>
    <h:stateOrProvince>CA</h:stateOrProvince>
    <h:postalCode>92697</h:postalCode>
    <h:country>US</h:country>
    <h:firstName>Keisha</h:firstName>
    <h:lastName>Huntley</h:lastName>
    <h:phoneNumber>800-555-1212</h:phoneNumber>
    <h:emailAddress>[e-mail]</h:emailAddress>
  </h:record>
</hrmanifest>