System and method for prior period adjustment processing
A data processing method comprises: using an application server computer, receiving a workflow for single period processing, the workflow comprising steps for processing data items related to the period, processing the data items according to the workflow to generate an output, capturing, during processing, metadata about the output, storing the output, the workflow, the data items, and the metadata in a database, receiving a modification to one or more of the data items and storing the modification to result in modified data items, receiving, during an open period, a request to reprocess the period using the modified data items, wherein the open period is subsequent to the SPP, in response to the request, processing, according to the workflow and the metadata, the modified data items to generate modified output, determining a difference between the output and the modified output, carrying the difference over to the open period.
1. A data processing method comprising computer implemented steps of:
using an application server computer, receiving a workflow data for processing a period, wherein the workflow data comprises a plurality of steps for processing a plurality of data items related to the period;
processing the plurality of data items according to the workflow data to generate an output, wherein the period is closed after processing by locking data associated with the period;
capturing, during processing, metadata about the output;
storing the output, the workflow data, the plurality of data items, and the metadata in a database;
receiving a modification to one or more of the plurality of data items and storing the modification to result in a modified plurality of data items;
receiving, during an open period, a request to reprocess the period using the modified plurality of data items, wherein the open period is subsequent to the period associated with the modified plurality of data items;
in response to the request, processing, according to the workflow data and the metadata, the modified plurality of data items to generate modified output;
determining a difference between the output and the modified output;
carrying the difference over to the open period by storing the difference.
2. The method of claim 1 , wherein the workflow data comprises one or more process groups, each process group comprising one or more steps, and wherein the one or more process groups and the one or more steps are ordered.
3. The method of claim 1 , wherein processing the modified plurality of data items comprises:
generating a snapshot of the workflow data for the period and caching the snapshot for a duration of processing of the period;
deleting the cached snapshot after processing the period is completed.
4. The method of claim 1 , the plurality of steps further comprising an external process step comprising:
calling an external process;
waiting an amount of time for a response to the external process;
sending a notification when the amount of time is exceeded.
5. The method of claim 1 , further comprising:
displaying, for an individual, a difference in payment for the open period based upon a portion of the difference between the output and the modified output, wherein the difference is reflected in a subsequent paycheck for the individual.
6. The method of claim 5 , wherein the difference is displayed in aggregate and in detail.
7. The method of claim 1 , further comprising:
storing the modified output and the modified data items in the database as a second version.
8. The method of claim 1 , wherein the difference is associated with a particular SPP.
9. The method of claim 1 , wherein the metadata comprises data associated with holds and releases.
10. The method of claim 1 , further comprising:
displaying, at a tenant device while processing the modified plurality of data items, a different copy of the modified plurality of data items, wherein the different copy is modifiable.
11. A computer system comprising:
a production database storing tenant data that is associated with a plurality of different tenants of an application service provider;
one or more application server computers communicatively connected to the production database, the one or more application server computers comprising one or more processors and electronic digital memory storing one or more sequences of instructions which, when executed by the one or more processors, cause the one or more processors to perform:
receiving a workflow data for processing a period, wherein the workflow data comprises a plurality of steps for processing a plurality of data items related to the period;
processing the plurality of data items according to the workflow data to generate an output, wherein the period is closed after processing by locking data associated with the period;
capturing, during processing, metadata about the output;
storing the output, the workflow data, the plurality of data items, and the metadata in the production database;
receiving a modification to one or more of the plurality of data items and storing the modification to result in a modified plurality of data items;
receiving, during an open period, a request to reprocess the period using the modified plurality of data items, wherein the open period is subsequent to an as of period;
in response to the request, processing, according to the workflow data and the metadata, the modified plurality of data items to generate modified output;
determining a difference between the output and the modified output;
carrying the difference over to the open period by storing the difference.
12. The system of claim 11 , wherein the workflow data comprises one or more process groups, each process group comprising one or more steps, and wherein the one or more process groups and the one or more steps are ordered.
13. The system of claim 11 , wherein processing the modified plurality of data items comprises:
generating a snapshot of the workflow data for the period and caching the snapshot for a duration of processing of the period;
deleting the cached snapshot after processing the period is completed.
14. The system of claim 11 , the plurality of steps further comprising an external process step comprising:
calling an external process;
waiting an amount of time for a response to the external process;
sending a notification when the amount of time is exceeded.
15. The system of claim 11 , further comprising:
displaying, for an individual, a difference in payment for the open period based upon a portion of the difference between the output and the modified output, wherein the difference is reflected in a subsequent paycheck for the individual.
16. The system of claim 15 , wherein the difference is displayed in aggregate and in detail.
17. The system of claim 11 , further comprising:
storing the modified output and the modified data items in the database as a second version.
18. The system of claim 11 , wherein the difference is associated with a particular SPP.
19. The system of claim 11 , wherein the metadata comprises data associated with holds and releases.
20. The system of claim 11 , further comprising:
displaying, at a tenant device while processing the modified plurality of data items, a different copy of the modified plurality of data items, wherein the different copy is modifiable.