This page (revision-82) was last changed on 26-Nov-2021 10:22 by jaiken

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
82 26-Nov-2021 10:22 33 KB jaiken to previous
81 26-Nov-2021 10:22 33 KB jaiken to previous | to last WORK FLOW IN OPEN ENROLLMENT ==> WORKFLOW IN OPEN ENROLLMENT

Page References

Incoming links Outgoing links
WORKFLOW IN OPEN ENROLLMENT
WORKFLOW IN OPEN ENROLLMENT

Version management

Difference between version and

At line 3 changed 2 lines
!!!USING WORKFLOW WITH OPEN ENROLLMENT
Workflow may be used in accordance with Open Enrollment to help make the process flow more fluidly and less cumbersome for the Benefit Administrator.
!!!USING WORK FLOW WITH OPEN ENROLLMENT
At line 5 added 3 lines
Work flow may be used in accordance with Open Enrollment to help make the process flow more fluidly and less cumbersome for the Benefit Administrator.
At line 9 changed one line
\\
At line 11 changed 2 lines
!!Suitable Workflow in Open Enrollment
The following are example workflows that may be used to help ease the flow of the Open Enrollment process.
!!!Suitable Workflow in Open Enrollment
At line 14 changed one line
!Notification of a Life / Work Event
The following are example workflows that may be used to help ease the flow of the Open Enrollment process.
!!Notification of a Life / Work Event
At line 17 changed one line
;Step 1 - Define Workflow Action in IMWA:
;[Step 1 - Define Workflow Action in IMWA|]
At line 22 added one line
At line 29 added 3 lines
\\
;[Step 2 – Define User Calc in IMUC|]
The second step requires a user calc to be created to send the email to the Administrator.
At line 26 changed 4 lines
;Step 2 – Define UserCalc in IMUC:
The second step requires a UserCalc to be created to send the email to the Administrator.
;[User Calc|USER_CALC_CODE]:It is suggested to prefix the UserCalc code with WF_OE to easily identify the workflow UserCalcs for Open Enrollment.
;[Description|DESCRIPTION]:Should state what the UserCalc is meant for.
;[User Calc|USER_CALC_CODE]:It is suggested to prefix the user calc code with WF_OE to easily identify the workflow user calcs for Open Enrollment.
;[Description|DESCRIPTION]:Should state what the user calc is meant for.
At line 31 changed 2 lines
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the UserCalc must have a status of “In Production”. UserCalcs are published in [IMUCA].
;[User Calc Type |USER_CALC_TYPE]:All workflow UserCalcs must have the type set to ‘Calculation’.
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the user calc must have a status of “In Production”. User calcs are published in [IMUCA].
;[User Calc Type |USER_CALC_TYPE]:All workflow user calcs must have the type set to ‘Calculation’.
At line 40 added 2 lines
At line 41 changed 5 lines
*Line 10: This line checks to see if an insert into the table has been done.
*Line 15: This line checks to see if the Open Enrollment Type is 02 (Life / Work Event).
*Line 20: This line calls the workflow action (OE NEW L/W EVENT) which was defined in the first step and will send the email notice to employee 42032.
*Line 99999: This line will indicate the end of the UserCalc.
\\
Line 10: This line checks to see if an insert into the table has been done.
Line 15: This line checks to see if the Open Enrollment Type is 02 (Life / Work Event).
Line 20: This line calls the workflow action (OE NEW L/W EVENT) which was defined in the first step and will send the email notice to employee 42032.
Line 99999: This line will indicate the end of the usercalc.
At line 57 added one line
At line 50 changed one line
;Step 1 - Define Workflow Action in IMWA:
;[Step 1 - Define Workflow Action in IMWA|]
At line 64 added one line
At line 57 changed one line
;[Message|MEDIA_NAME]:If Email was specified for Type, the From email address must be specified. If Message was specified the field must be left blank.
;[Message|MEDIA_NAME]:If Email was specified for Type, the From email address must be specified. If Message was specified the field must be left blank
\\
;[Step 2 – Define User Calc in IMUC|]
The second step requires a user calc to be created to send the email to the Administrator.
At line 59 changed 4 lines
;Step 2 – Define User Calc in IMUC:
The second step requires a UserCalc to be created to send the email to the Administrator.
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the UserCalc code with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For example, WF_OE_PROOF_REQ.
;[Description|DESCRIPTION]: This field should state what the UserCalc is meant for
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the user calc code with WF_OE to easily identify the workflow user calcs for Open Enrollment. For example, WF_OE_PROOF_REQ.
;[Description|DESCRIPTION]: This field should state what the user calc is meant for
At line 64 changed 2 lines
;[Status |USER_CALC_STATUS]: In order for the action to be processed the UserCalc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status |USER_CALC_STATUS]: In order for the action to be processed the user calc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation
At line 82 added one line
At line 74 changed 4 lines
*Line 10 : This field checks to see if an insert into the table has been done
*Line 20 : This field checks to see if the event requires proof
*Line 30: This field calls the workflow action defined in the first step (OE PROOF REQ) and will issue a message to the current identity logged into the application.
*Line 99999: This line will indicate the end of the UserCalc.
Line 10 : This field checks to see if an insert into the table has been done
Line 20 : This field checks to see if the event requires proof
Line 30: This field calls the workflow action defined in the first step (OE PROOF REQ) and will issue a message to the current identity logged into the application.
Line 99999: This line will indicate the end of the usercalc.
At line 79 changed one line
!Notification of a New Open Enrollment Period
!!Notification of a New Open Enrollment Period
At line 82 changed one line
;Step 1 - Define Workflow Action in IMWA:
;[Step 1 - Define Workflow Action in IMWA|]
At line 84 changed one line
;[Status |EVENT_STATUS]:This field must be set to 'In Production' in order for the action to be picked up in [IMUC]
;[Status |EVENT_STATUS]:This field must be set to In Production in order for the action to be picked up in [IMUC]
At line 89 changed 4 lines
;Step 2 – Define UserCalc in IMUC:
;[User Calc|USER_CALC_CODE]: It is suggested that the UserCalc code should prefixed with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For this example, it may called [WF_OE_NEW_PERIOD].
;[Description |DESCRIPTION]: This field should state what the UserCalc is meant for.
\\
;[Step 2 – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow user calcs for Open Enrollment. For this example, it may called WF_OE_NEW_PERIOD.
;[Description |DESCRIPTION]: This field should state what the user calc is meant for.
At line 94 changed 2 lines
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the UserCalc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the user calc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation.
At line 118 added one line
At line 103 changed 3 lines
*Line 10 : This line checks to see if an insert into the table has been done, if so proceed with the rest of the UserCalc if not exit.
*Line 20: This line calls the workflow action (OE NEW PERIOD) defined in the first step and will send the email to the employees.
*Line 99999: This line will indicate the end of the usercalc.
Line 10 : This line checks to see if an insert into the table has been done, if so proceed with the rest of the user calc if not exit.
Line 20: This line calls the workflow action (OE NEW PERIOD) defined in the first step and will send the email to the employees.
Line 99999: This line will indicate the end of the usercalc.
At line 107 changed one line
!Notification of Submission of Elections
!!Notification of Submission of Elections
At line 110 changed one line
;Step 1- Define Workflow Action in IMWA:
;[Step 1- Define Workflow Action in IMWA|]
At line 142 added 2 lines
\\
;[Step 2: – Define User Calc in IMUC|]
At line 118 changed 2 lines
;Step 2 – Define User Calc in IMUC:
;[User Calc|USER_CALC_CODE]: It is suggested that the UserCalc code should prefixed with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For this example WF_OE_EMAIL_SUB is used.
;[User Calc|USER_CALC_CODE]: It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow user calcs for Open Enrollment. For this example WF_OE_EMAIL_SUB is used.
At line 122 changed 2 lines
;[Status |USER_CALC_STATUS]: In order for the action to be processed the UserCalc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]:All workflow UserCalcs must have a type of 'Calculation'.
;[Status |USER_CALC_STATUS]: In order for the action to be processed the user calc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]:All workflow user calcs must have a type of Calculation.
At line 126 removed one line
There are two variables required for this workflow UserCalc.
At line 153 added 2 lines
There are two variables required for this work flow user calc.
At line 159 added one line
At line 142 removed 7 lines
*Line 10 : This line checks to see if an update has been done.
*Line 15 :This line sets a variable equal null to the old election stage.
*Line 16 :This line sets a variable equal null to the new election stage.
*Line 17: This line checks if the variable for old election stage does not equal the variable for the new election stage.
*Line 20: This line checks if the new election stage equals 10 (Submitted).
*Line 30: This line calls the workflow action defined in [IMWA] (OE SUBMITTED) and will email person code 42032.
*Line 99999: This will end the user calc.
At line 171 added 15 lines
Line 10 : This line checks to see if an update has been done.
Line 15 :This line sets a variable equal null to the old election stage.
Line 16 :This line sets a variable equal null to the new election stage.
Line 17: This line checks if the variable for old election stage does not equal the variable for the new election stage.
Line 20: This line checks if the new election stage equals 10 (Submitted).
Line 30: This line calls the workflow action defined in [IMWA] (OE SUBMITTED) and will email person code 42032.
Line 99999: This will end the user calc.
At line 151 changed one line
!Notification of Approved/Not Approved Elections
!!Notification of Approved/Not Approved Elections
At line 156 changed one line
;Step 1 - Define Workflow Action in IMWA – Action for Approved Elections:
;[Step 1- Define Workflow Action in IMWA – Action for Approved Elections|]
At line 163 changed 2 lines
;Step 2 - Define Workflow Action in IMWA – Action for Not Approved Elections:
\\
;[Step 2: Define Workflow Action in IMWA – Action for Not Approved Elections|]
At line 207 added one line
\\
At line 172 changed 6 lines
__Step 3 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]:It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For this example WF_OE_APR/NAPR is used.
;[Description |DESCRIPTION]: This field should state what the UserCalc is meant for.
;[Product |PRODUCT_CODE]: This field should be set to WF_BOEE.
;[Status |USER_CALC_STATUS]: In order for the action to be processed, the UserCalc must be published in [IMUCA].
;[User Calc Type |USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Step 3: – Define User Calc in IMUC|]
At line 211 added 6 lines
;[User Calc|USER_CALC_CODE]:It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow user calcs for Open Enrollment. For this example WF_OE_APR/NAPR is used.
;[Description |DESCRIPTION]: This field should state what the user calc is meant for.
;[Product |PRODUCT_CODE]: This field should be set to WF_BOEE.
;[Status |USER_CALC_STATUS]: In order for the action to be processed, the user calc must be published in [IMUCA].
;[User Calc Type |USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation.
\\
At line 180 changed one line
There are two variables required for this workflow UserCalc.
There are two variables required for this work flow user calc.
At line 226 added one line
At line 197 removed 8 lines
*Line 10: This line checks to see if an update has been done.
*Line 20: This line sets a variable equal null to the old election stage.
*Line 30: This line sets a variable equal null to the new election stage.
*Line 35: This line checks if the variable for old election stage does not equal the variable for the new election stage.
*Line 40: This line checks if the new election stage equals 50 (Approved).
*Line 50: This line calls the Approved workflow action defined in [IMWA].
*Line 60: This line checks if the new election stage equals 92 (Not Approved).
*Line 70: This line calls the Not Approved workflow action defined in [IMWA].
At line 239 added 17 lines
Line 10: This line checks to see if an update has been done.
Line 20: This line sets a variable equal null to the old election stage.
Line 30: This line sets a variable equal null to the new election stage.
Line 35: This line checks if the variable for old election stage does not equal the variable for the new election stage.
Line 40: This line checks if the new election stage equals 50 (Approved).
Line 50: This line calls the Approved workflow action defined in [IMWA].
Line 60: This line checks if the new election stage equals 92 (Not Approved).
Line 70: This line calls the Not Approved workflow action defined in [IMWA].
At line 212 changed 2 lines
!Scenario 1 – Employee Gets Married; the Married Date is Populated in IEPI:
__Step 1 – Define Workflow Action in IMWA__
!Scenario 1 – Employee gets married; the Married Date is populated in IEPI
;[Step 1 – Define Workflow Action in IMWA |]
At line 221 changed 3 lines
__Step 2 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]: It is suggested that the UserCalc code should prefixed with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For this example, it may called WF_OE_MARRIAGE.
;[Description |DESCRIPTION]: This field should state what the UserCalc is meant for.
;[Step 2 – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow user calcs for Open Enrollment. For this example, it may called WF_OE_MARRIAGE.
;[Description |DESCRIPTION]: This field should state what the user calc is meant for.
At line 225 changed 2 lines
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the UserCalc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the user calc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation.
At line 280 added one line
At line 282 added 2 lines
At line 235 changed 4 lines
*Line 10: This line checks to see if the old value for Married Date in [IEPI] does not equal 02-Jan-0001.
*Line 20:This line checks to see if the new value for Married Date in [IEPI] does not equal 02-Jan-0001.
*Line 30:This line calls the workflow action, CREATE MAR OE, that was defined in step 1 in [IMWA] which will cause an open enrollment for the marriage life event to be created.
*Line 99999: This will end the UserCalc.
Line 10: This line checks to see if the old value for Married Date in [IEPI] does not equal 02-Jan-0001.
At line 240 changed 2 lines
!Scenario 2 – An New Employee is Entered in Personality
__Step 1 - Define Workflow Action in IMWA__
Line 20:This line checks to see if the new value for Married Date in [IEPI] does not equal 02-Jan-0001.
Line 30:This line calls the work flow action, CREATE MAR OE, that was defined in step 1 in [IMWA] which will cause an open enrollment for the marriage life event to be created.
Line 99999: This will end the user calc.
!Scenario 2 – An new employee is entered in [{$applicationname}]
;[Step 1 - Define Workflow Action in IMWA|]
At line 243 changed one line
;[Status|EVENT_STATUS]:This field must set to 'In Production' in order for the action to be picked up in [IMUC].
;[Status|EVENT_STATUS]:This field must set to In Production in order for the action to be picked up in [IMUC].
At line 249 changed 3 lines
__Step 2 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]: It is suggested that the UserCalc code should prefixed with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For this example, it may called WF_OE_NEWHIRE.
;[Description |DESCRIPTION]: This field should state what the UserCalc is meant for.
;[Step 2: – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested that the user calc code should prefixed with WF_OE to easily identify the workflow user calcs for Open Enrollment. For this example, it may called WF_OE_NEWHIRE.
;[Description |DESCRIPTION]: This field should state what the user calc is meant for.
At line 253 changed 2 lines
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the UserCalc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status|USER_CALC_STATUS]: In order for the action to be processed, the user calc must be published in [IMUCA].
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation.
At line 318 added 2 lines
At line 262 changed 3 lines
*Line 10: This line checks to see if the custom function, NEWHIRE, equals True.
*Line 20: This line will call the workflow action defined in IMWA for the new hire.
\\
Line 10: This line checks to see if the custom function, NEWHIRE, equals True.
Line 20: This line will call the workflow action defined in IMWA for the new hire.
At line 272 changed one line
__Step 1 - Define Workflow Action in IMWA__
;[Step 1: Define Workflow Action in IMWA|]
At line 280 changed 3 lines
__Step 2 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the UserCalc code with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For example, WF_OE_STUD_2_OLD.
;[Description|DESCRIPTION]: This field should state what the UserCalc is meant for
;[Step 2: – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the user calc code with WF_OE to easily identify the workflow user calcs for Open Enrollment. For example, WF_OE_STUD_2_OLD.
;[Description|DESCRIPTION]: This field should state what the user calc is meant for
At line 284 changed 2 lines
;[Status |USER_CALC_STATUS]: In order for the action to be processed the UserCalc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status |USER_CALC_STATUS]: In order for the action to be processed the user calc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation
At line 355 added one line
At line 357 added 2 lines
At line 290 changed one line
|10|ACT|AC|OE STUDENT 2 OLD| LOG|$S|AS-OF-DATE|RT|42032|99999| |<<EID.FIRST_NAME>> <<EID.LAST_NAME>> student child recipient, <<ECT.FIRST_NAME>> <<ECT.LAST_NAME>> , is turning 25 next month. The student will surpass the maximum student age defined for the benefit.
|10|ACT|AC|OE STUDENT 2 OLD| LOG|$S|AS-OF-DATE|RT|42032|99999| |<<EID.FIRST_NAME>> <<EID.LAST_NAME>> student child recipient, <<ECT.FIRST_NAME>> <<ECT.LAST_NAME>> , is turning 25 next month. The Student will surpass the maximum student age defined for the benefit
At line 293 removed one line
*Line 10: This line calls the workflow action defined in [IMWA] (OE STUDENT 2 OLD) during the first step and will send an email to person code 42032.
At line 295 changed 2 lines
__Step 3 - Define Where Clause in IMWC or IMDAO__
Where Clauses are used in Personality to conditionally select data from a table. In the case of Pro Active WorkFlow, they are created to help the system filter data based on the specified criteria. This is done so that the [UserCalcs|USERCALC] do not have to be created with the conditions defined which helps ease the amount of work required by the back end processes. As a result, by the time the [UserCalc|USERCALC] is called the data has already been filtered down to the appropriate records.
Line 10: This line calls the workflow action defined in [IMWA] (OE STUDENT 2 OLD) during the first step and will send an email to person code 42032.
At line 366 added 4 lines
\\
;[Step 3: Define Where Clause in IMWC or IMDAO|]
Where Clauses are used in [{$applicationname}] to conditionally select data from a table. In the case of Pro Active Work Flow, they are created to help the system filter data based on the specified criteria. This is done so that the [user calcs|USERCALC] do not have to be created with the conditions defined which helps ease the amount of work required by the back end processes. As a result, by the time the [user calc|USERCALC] is called the data has already been filtered down to the appropriate records.
At line 376 added one line
At line 305 changed 2 lines
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the UserCalc. For this example, OE_STUDENT_2_OLD will be used.
;[Usage|WHERE_CLAUSE_USAGE]:The usage of the where clause is stated here. For this example, 'User Defined' must be selected.
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the user calc. For this example, OE_STUDENT_2_OLD will be used.
;[Usage|WHERE_CLAUSE_USAGE]:The usage of the where clause is stated here. For this example, User Defined must be selected.
At line 315 changed 2 lines
__Step 4 - Run UMPWF to Start the Pro-active Workflow__
The [UMPWF] function must be run to start the pro-active workflow. The idea behind the [UMPWF] is that the pro active workflow UserCalcs can be scheduled to run on a regular basis.
;[Step 4: Run UMPWF to Start the Pro-active Workflow|]
The [UMPWF] function must be run to start the pro-active work flow. The idea behind the [UMPWF] is that the pro active work flow user calculations can be scheduled to run on a regular basis.
At line 318 removed 4 lines
The [UMPWF] would be run with the following parameters:
|Product|WF_ECT
|UserCalc Code|WF_OE_STUD_2_OLD
|Where Clause|OE_STUDENT_2_OLD
At line 324 changed one line
__Step 1 - Define Workflow Action in IMWA__
;[Step 1: Define Workflow Action in IMWA|]
At line 332 changed 3 lines
__Step 2 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the UserCalc code with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For example, WF_OE_CHD_2_OLD.
;[Description|DESCRIPTION]: This field should state what the UserCalc is meant for
;[Step 2: – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the user calc code with WF_OE to easily identify the workflow user calcs for Open Enrollment. For example, WF_OE_CHD_2_OLD.
;[Description|DESCRIPTION]: This field should state what the user calc is meant for
At line 336 changed 2 lines
;[Status |USER_CALC_STATUS]: In order for the action to be processed the UserCalc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status |USER_CALC_STATUS]: In order for the action to be processed the user calc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation
At line 411 added one line
At line 413 added 2 lines
At line 345 changed one line
*Line 10: This line calls the workflow action defined in [IMWA] (OE STUDENT 2 OLD) during the first step and will send an email to person code 42032.
Line 10: This line calls the workflow action defined in [IMWA] (OE STUDENT 2 OLD) during the first step and will send an email to person code 42032.
At line 347 removed 2 lines
__Step 3 - Define Where Clause in IMWC__
Where Clauses are used in Personality to conditionally select data from a table. In the case of Pro Active workflow, they are created to help the system filter data based on the specified criteria. This is done so that the UserCalcs do not have to be created with the conditions defined which helps ease the amount of work required by the backend processes. As a result, by the time the UserCalc is called the data has already been filtered down to the appropriate records.
At line 423 added 5 lines
;[Step 3: Define Where Clause in IMWC|]
Where Clauses are used in ePersonality to conditionally select data from a table. In the case of Pro Active Work Flow, they are created to help the system filter data based on the specified criteria. This is done so that the user calcs do not have to be created with the conditions defined which helps ease the amount of work required by the backend processes. As a result, by the time the user calc is called the data has already been filtered down to the appropriate records.
At line 354 changed one line
This example first filters the data for [birth dates|BIRTH_DATE] that are not null.
This example first filters the data for [birth dates|BIRTH_DATES] that are not null.
At line 361 changed one line
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the UserCalc. For this example, OE_CHILD_2_OLD will be used.
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the user calc. For this example, OE_CHILD_2_OLD will be used.
At line 369 removed 3 lines
\\
__Step 4 - Run UMPWF to Start the Pro-active Workflow__
The [UMPWF] function must be run to start the pro-active workflow. The idea behind the [UMPWF] is that the pro active workflow UserCalcs can be scheduled to run on a regular basis.
At line 373 removed 4 lines
The [UMPWF] would be run with the following parameters:
|Product|WF_ECT
|UserCalc Code|WF_OE_CHD_2_OLD
|Where Clause|OE_CHILD_2_OLD
At line 449 added 4 lines
;[Step 4: Run UMPWF to Start the Pro-active Workflow|]
The [UMPWF] function must be run to start the pro-active work flow. The idea behind the [UMPWF] is that the pro active work flow user calculations can be scheduled to run on a regular basis.
At line 454 added one line
At line 382 changed one line
__Step 1 - Define Workflow Action in IMWA__
;[Step 1: Define Workflow Action in IMWA|]
At line 390 changed 3 lines
__Step 2 – Define User Calc in IMUC__
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the UserCalc code with WF_OE to easily identify the workflow UserCalcs for Open Enrollment. For example, WF_OE_REMINDER.
;[Description|DESCRIPTION]: This field should state what the UserCalc is meant for
;[Step 2: – Define User Calc in IMUC|]
;[User Calc|USER_CALC_CODE]: It is suggested to prefix the user calc code with WF_OE to easily identify the workflow user calcs for Open Enrollment. For example, WF_OE_REMINDER.
;[Description|DESCRIPTION]: This field should state what the user calc is meant for
At line 394 changed 2 lines
;[Status |USER_CALC_STATUS]: In order for the action to be processed the UserCalc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow UserCalcs must have a type of 'Calculation'.
;[Status |USER_CALC_STATUS]: In order for the action to be processed the user calc must be published in [IMUCA]
;[User Calc Type|USER_CALC_TYPE]: All workflow user calcs must have a type of Calculation
At line 477 added one line
At line 479 added 2 lines
At line 403 changed one line
*Line 10: This field calls the workflow action defined in [IMWA].
Line 10: This field calls the workflow action defined in [IMWA].
At line 405 changed 2 lines
__Step 3 - Define Where Clause in IMWC__
Where Clauses are used in Personality to conditionally select data from a table. In the case of Pro Active workflow, they are created to help the system filter data based on the specified criteria. This is done so that the UserCalcs do not have to be created with the conditions defined which helps ease the amount of work required by the backend processes. As a result, by the time the UserCalc is called the data has already been filtered down to the appropriate records.
;[Step 3: Define Where Clause in IMWC|]
Where Clauses are used in ePersonality to conditionally select data from a table. In the case of Pro Active Work Flow, they are created to help the system filter data based on the specified criteria. This is done so that the user calcs do not have to be created with the conditions defined which helps ease the amount of work required by the backend processes. As a result, by the time the user calc is called the data has already been filtered down to the appropriate records.
At line 410 changed one line
The where clause would filter through the open enrollment periods to locate those that are 'open' and whose close date is one week away from the as of date. The system will then filter through the open enrollment to locate employee open enrollments which are 'open' meaning they have not been submitted yet.
The where clause would filter through the open enrollment periods to locate those that are Open and whose close date is 1 week away from the as of date. The system will then filter through the open enrollment to locate employee open enrollments which are 'open' meaning they have not been submitted yet.
At line 413 changed one line
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the UserCalc. For this example, OE REMINDER will be used.
;[Where Clause|WHERE_CLAUSE_CODE]:This field holds the name of the user calc. For this example, OE REMINDER will be used.
At line 504 added one line
At line 422 removed 2 lines
__Step 4 - Run UMPWF to Start the Pro-active Workflow__
The [UMPWF] function must be run to start the pro-active workflow. The idea behind the [UMPWF] is that the pro active workflow user calculations can be scheduled to run on a regular basis.
At line 507 added 3 lines
;[Step 4: Run UMPWF to Start the Pro-active Workflow|]
The [UMPWF] function must be run to start the pro-active work flow. The idea behind the [UMPWF] is that the pro active work flow user calculations can be scheduled to run on a regular basis.
At line 427 changed one line
|UserCalc Code|WF_OE_REMINDER
|User Calc Code|WF_OE_REMINDER
At line 429 removed 4 lines
----
![Notes|Edit:Internal.WORK+FLOW+IN+OPEN+ENROLLMENT]
[{InsertPage page='Internal.WORK+FLOW+IN+OPEN+ENROLLMENT' default='Click to create a new notes page'}]
This page (revision-82) was last changed on 26-Nov-2021 10:22 by jaikenTop