!!!Manage Date Effective Gaps The UMDA_xxx functions are designed to address any gaps found in [date sensitive|DATE SENSITIVE] records. Each date effective table will have an UMDA_xxx function where xxx is the table alias for the table being addressed. In general, the UMDA_xxx functions will read through each chain of date effective records and will perform these actions: # If the first record found (in date order) is not effective as at the ''beginning of time'' (01-JAN-0001), then it will copy that first record, exactly as found, and create a new record effective the beginning of time and expiring the day before the first record found. #*__UMDA_EAS__ will create this new record with an [employment status|STATUS_CODE] of 'INACTIVE'. #*__UMDA_BEN__ will create this new record with an [enrolment status|ENROLLMENT_STATUS] of '00' - Not Enrolled. # If there is a gap found between one record's expiry and the next record's effective, the [EXPIRY] will be extended to be one day prior to the next record's [EFFECTIVE] date. # If it is found that the date sensitive chain does not extend to the ''end of time'' (31-DEC-3999), then the last record found will be extended to this date. The UMDA functions are designed to be executed during the conversion process, but may be used at any point without qualification. %%warning UMDA_BEN should not be run in a production environment. UMDA, especially UMDA_EAS, should not be run when there are open pays (especially UMDA_EAS).%% ---- ![Notes|Edit:Internal.UMDA] [{InsertPage page='Internal.UMDA' default='Click to create a new notes page'}]