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:
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="is_dl_alert_kfsx@Mail.ColoState.EDU" 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>test@email.edu</h:emailAddress>
</h:record>
</hrmanifest>
Comments
0 comments
Please sign in to leave a comment.