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 and any active Groups, Roles and Delegations Active To Date is set to the day the job is run. Following are the exceptions to inactivation when a record doesn't exist in the file:
- 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.