Overview
The organizationLoadJob updates the Organization table:
- Organizations that are included in the file, but are not in the Organization table, will be added.
- Organizations that are inactive and included in the file will be activated.
- Active organizations no longer included in the file will be inactivated.
NOTE: Business rules are not applied when processing the file. Requiredness is indicated in the table below based on required fields when creating the Organization via the application.
XML File Layout
Keep the following points in mind:
- The OrganizationLoad file must begin with the standard XML version line.
- The root (first) tag for Organization files must be the <organizationLoad> tag, and the file must contain only one <organizationLoad> tag. This tag also contains attributes that identify the schema the document adheres to:
- Following the <organizationLoad> tag is the <organization> tag, the <organization> tag can be repeated multiple times for each Organization that needs to be processed.
- Access a sample file here.
Name |
Required |
<?xml version="1.0" encoding="UTF-8"?> |
|
<organizationLoad xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://github.com/KualiCo/financials-schemas/tree/main/organizationLoad/v1 https://github.com/KualiCo/financials-schemas/tree/main/organizationLoad/v1/schema.xsd" xmlns="https://github.com/KualiCo/financials-schemas/tree/main/organizationLoad/v1"> |
|
<organization> |
|
<organizationCode> |
Yes |
<chartOfAccountsCode> |
Yes |
<organizationManagerUniversalId> |
Yes - Principal ID |
<organizationName> |
Yes |
<organizationDefaultAccountNumber> |
No- Required when Org Type is not in parameter ACCOUNT_NOT_REQUIRED |
<responsibilityCenterCode> |
Yes |
<organizationPhysicalCampusCode> |
Yes |
<organizationTypeCode> |
Yes |
<organizationLine1Address> |
Yes |
<organizationLine2Address> |
No |
<organizationCityName> |
Yes |
<organizationStateCode> |
Yes |
<organizationZipCode> |
Yes |
<organizationCountryCode> |
Yes |
<organizationBeginDate> |
Yes |
<organizationEndDate> |
No |
<reportsToChartOfAccountsCode> |
Yes |
<reportsToOrganizationCode> |
Yes |
<active> |
Yes - Y/N |
<organizationPlantAccountNumber> |
Yes |
<campusPlantAccountNumber> |
Yes |
<organizationPlantChartCode> |
Yes |
<campusPlantChartCode> |
Yes |
</organization> | |
</organizationLoad> |
Comments
0 comments
Please sign in to leave a comment.