Division Order Uploads
Know before you go… Revenue Cycles only…WI/BI Interest Class owners
Any WI or BI Interest Class owner must have a direct correlation to a line in at least 1 burden group in use on the cycle
The From and To dates for the owner must match the From and To dates of the Burden Group owner
Cycle specific burden groups are preferred
If an owner exists more than once on a cycle, use the tag column to populate a sequence number to differentiate between the multiple lines
Break out the lines in the burden group to match the LOI lines using the same tag/sequence value
The DO From Date on the DO header tab will drive the LOI and BGI from dates unless populated on the actual LOI and BG tabs
It is best to utilize a DO Header date that matches the first date on the Lines of Interests being uploaded
ie. Stay away from doing a DO Header effective date of 1/1/1901 when the LOIs being on 10/1/2023
The To Date will be assumed as 12/31/9999 unless otherwise indicated
If using a combination of WI and BI interest class, all owners must have the same from date at the start of the interest class change. Meaning…
There is no issue if you use a combination and all owners have the same from/to dates
If loading effective dated, chain of title, ownership and there is a change in interest class on a random date, all lines of interest must share that same date as when the interest change occurred
Understanding Relationship of Data Between Tabs
Ultimately all sets of data across tabs are tied back to a DO Header (via DOImportID), however, there are cases where the tabs underneath the header tie to each other and those links must not be broken.
For example, DOCycles and LinesOfInterest
DOCycles live as a Header above the LinesOfInterest
The DOImportID, DOStage, DOProduct, DOOwnershipType and DOOwnershipDescription columns exist in both tabs
These Tabs and their assigned values are how the system relate owner(s) back to which lifecycle it lives under
Therefore, for any owners added onto a specific lifecycle, these column values should match between the two tabs
If for whatever reason they do not, it results in an error stating “Base Contract cannot be found”
ie. If on the DOCycles tab we use:
DOImportID = Test123
DOStage = STD
DOProduct = All
DOOwnershipType = JIB
DOOwnershipDescription = JIB
and then on the Lines of Interest we use:
DOImportID = Test123
DOStage = STD
DOProduct = All
DOOwnershipType = JIB
DOOwnershipDescription = JIB2
These Keys between the tabs would not match and result in the above error.
Additional Notes
RestrictFeestoWI on the DOHeader defaults to TRUE when blank. More often than not, this should be set to FALSE.
All DOs must have at least one JIB lifecycle = TRUE
System takes this into consideration for New, Inserts, and Replaces
ie. If you’re doing an Insert Upload, and the existing DO already has a JIB lifecycle = TRUE, then any JIB lifecycles added via the import cannot have the JIB flag set to TRUE
If you’re doing a Replace, one and only one lifecycle can have the JIB flag set to TRUE
In a Replace or Insert, the uploader does not allow the ability to change or add DO Assets or Legal Descriptions