CHRS Knowledge Base

Delete Activity Cheat Sheet

Updated on

The purpose of this document is to assist campuses with Benefits related issues.

AG Page Status Codes:
1 – Assigned
2 – In Progress
4 – Completed

Expand or collapse content Delete AG - Age-Out LTE with BAS Event

AG Template: EF_L1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: Not equal to Void
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS and BASPARTIC.EVENT_DT for EE
Days: equal/ greater than 31
Delete Reason and Issue Reason Report Message: Age Out with BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event not Finalized (generally Prepared) and AG not deleted

Expand or collapse content Delete AG - Age-Out DRP with BAS Event

AG Template: EF_E1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: Not equal to Void
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS and BASPARTIC.EVENT_DT for EE
Days: equal/ greater than 2
Delete Reason and Issue Reason Report Message: Age Out with BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event not Finalized (generally Prepared) and AG not deleted

Expand or collapse content Delete AG - Age-Out ADP, BIR, DIV, DGC, DLC, EGC, ELC, MAR, PCR with BAS Event

AG Template: EF_A2FL, EF_B4FL, EF_C1FL, EF_D3FL, EF_G1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: Not equal to Void
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS and BASPARTIC.EVENT_DT for EE
Days: equal/ greater than 61
Delete Reason and Issue Reason Report Message: Age Out with BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event not Finalized (generally Prepared) and AG not deleted

Expand or collapse content Delete AG - Age-Out LTE - No BAS Event

AG Template: EF_L1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS for EE
Days: equal/ greater than 31
Delete Reason and Issue Reason Report Message: Age Out without BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event Finalized and AG not completed - also check if something in BAS_ACTIVITY (if %SqlRows= 0 on process log means nothing found in BAS_ACTIVITY)

Expand or collapse content Delete AG - Age-Out DRP - No BAS Event

AG Template: EF_E1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS for EE
Days: equal/ greater than 2
Delete Reason and Issue Reason Report Message: Age Out without BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event Finalized and AG not completed - also check if something in BAS_ACTIVITY (if %SqlRows= 0 on process log means nothing found in BAS_ACTIVITY)

Expand or collapse content Delete AG - Age-Out ADP, BIR, DIV, DGC, DLC, EGC, ELC, MAR, PCR - No BAS Event

AG Template: EF_A2FL, EF_B4FL, EF_C1FL, EF_D3FL, EF_G1FL, EF_M4FL, EF_P1FL, EF_V1FL, EF_X1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS for EE
Days: equal/ greater than 61
Delete Reason and Issue Reason Report Message: Age Out without BAS Event
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event Finalized and AG not completed - also check if something in BAS_ACTIVITY (if %SqlRows= 0 on process log means nothing found in BAS_ACTIVITY)BAS event Finalized and AG not completed - also check if something in BAS_ACTIVITY (if %SqlRows= 0 on process log means nothing found in BAS_ACTIVITY)

Expand or collapse content Delete AG - Age-Out LTE - No BAS Event

AG Template: EF_L1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS; BAS_ACTIVITY. BAS_ACTION and EVENT_DT for EE
Days: equal/ greater than 31
Delete Reason and Issue Reason Report Message: Age Out with BAS ACTION
Delete AG process deletes BAS event: Yes from BAS_ACTIVITY
Update Allow in ESS Flag: N/A
Scenario Description: Scenario occurs if age out occurs before PSPBARUN prepares BAS _ACTION

Expand or collapse content Delete AG - Age-Out DRP - No BAS Event

AG Template: EF_E1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS; BAS_ACTIVITY. BAS_ACTION and EVENT_DT for EE
Days: equal/ greater than 2
Delete Reason and Issue Reason Report Message: Age Out with BAS ACTION
Delete AG process deletes BAS event: Yes from BAS_ACTIVITY
Update Allow in ESS Flag: N/A
Scenario Description: Scenario occurs if age out occurs before PSPBARUN prepares BAS _ACTION

Expand or collapse content Delete AG - Age-Out ADP, BIR, DIV, DGC, DLC, EGC, ELC, MAR, PCR - No BAS Event

AG Template: EF_A2FL, EF_B4FL, EF_C1FL, EF_D3FL, EF_G1FL, EF_M4FL, EF_P1FL, EF_V1FL, EF_X1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: W3EB_LE_STATE92. ACTION_DT_SS; BAS_ACTIVITY. BAS_ACTION and EVENT_DT for EE
Days: equal/ greater than 61
Delete Reason and Issue Reason Report Message: Age Out with BAS ACTION
Delete AG process deletes BAS event: Yes from BAS_ACTIVITY
Update Allow in ESS Flag: N/A
Scenario Description: Scenario occurs if age out occurs before PSPBARUN prepares BAS _ACTION

Expand or collapse content Delete AG - Finalized OE BAS Event During OE Period

AG Template: ENROLLC
AG Welcome page: N/A
AG Benefits Enrollment page: 4
AG Dep/Ben Coverage page: N/A
AG eSignature page: 4
AG Summary page: 2,1,4
BAS Event Class Process Status: FE
BAS Event Class Event Status: C (Closed)
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Finalized OE event and Signed Activity Guide
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: Update to N
Scenario Description: BAS event Finalized and AG not completed

Expand or collapse content Delete AG - Finalized OE BAS Event AFTER OE Period

AG Template: ENROLLC
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: 2, 1, 4
BAS Event Class Process Status: FE
BAS Event Class Event Status: C (Closed)
BAS Election Source: N
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Finalized OE Event None Entered Election Source
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: BAS event Finalized and AG not completed

Expand or collapse content Delete AG - Voided OE BAS Event (note that the process checks for voided bas events first)

AG Template: ENROLLC
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: V (Void)
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Voided BAS Event
Delete AG process deletes BAS event: Yes from BAS_PARTIC, et al
Update Allow in ESS Flag: N/A
Scenario Description: BAS event voided and AG open

Expand or collapse content Delete AG - Voided ADP, BIR, DIV, DGC, DLC, DRP, EGC, ELC, LTE, MAR and PCR BAS Event (note that the process checks for voided bas events first)

AG Template: EF_A2FL, EF_B4FL, EF_C1FL, EF_D3FL, EF_G1FL, EF_M4FL, EF_P1FL, EF_V1FL, EF_X1FL, EF_L1FL and EF_E1FL
AG Welcome page: N/A
AG Benefits Enrollment page: N/A
AG Dep/Ben Coverage page: N/A
AG eSignature page: N/A
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: V (Void)
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Voided BAS Event
Delete AG process deletes BAS event: Yes from BAS_PARTIC, et al
Update Allow in ESS Flag: N/A
Scenario Description: BAS event voided and AG open

Expand or collapse content Issue AG - Missing eSIG OE

AG Template: ENROLLC
AG Welcome page: N/A
AG Benefits Enrollment page: 4
AG Dep/Ben Coverage page: N/A
AG eSignature page: 1,2
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Missing Electronic Signature
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: Submitted enrollment but esignature missing

Expand or collapse content Issue AG - Missing eSIG ADP, BIR, DIV, DGC, DLC, DRP, EGC, ELC, LTE, MAR and PCR BAS Event

AG Template: EF_A2FL, EF_B4FL, EF_C1FL, EF_D3FL, EF_G1FL, EF_M4FL, EF_P1FL, EF_V1FL, EF_X1FL
AG Welcome page: N/A
AG Benefits Enrollment page: 4
AG Dep/Ben Coverage page: N/A
AG eSignature page: 1,2
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Missing Electronic Signature
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: Submitted enrollment but esignature missing

Expand or collapse content Issue AG - Missing eSIG LTE BAS Event

AG Template: EF_L1FL
AG Welcome page: N/A
AG Benefits Enrollment page: 4
AG Dep/Ben Coverage page: N/A
AG eSignature page: 1,2
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Missing Electronic Signature
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: Submitted enrollment but esignature missing

Expand or collapse content Issue AG - Missing eSIG DRP BAS Event

AG Template: EF_E1FL
AG Welcome page: N/A
AG Benefits Enrollment page: 4
AG Dep/Ben Coverage page: N/A
AG eSignature page: 1,2
AG Summary page: N/A
BAS Event Class Process Status: N/A
BAS Event Class Event Status: N/A
BAS Election Source: N/A
Date Used: N/A
Days: N/A
Delete Reason and Issue Reason Report Message: Missing Electronic Signature
Delete AG process deletes BAS event: No
Update Allow in ESS Flag: N/A
Scenario Description: Submitted enrollment but esignature missing

End of Article

Previous Article (job aid) Action-Reason BAS Event-Ben EE Status Cheat Sheet (CHRSMP 1.0)
Next Article (job aid) Eligibility Config Fields Cheat Sheet
To request a new article or update: Contact Us