Attachment_11_-_BCV_Process_and_Dataflow_Diagram.pdf
PDF 579 KB Posted
- Attached to
- Benefit Calculation Valuation
- Solicitation number
- PBGC01-RP-16-0011
- Issued by
-
Pension Benefit Guaranty Corporation
About this file
Attachment 11 - BCV Process Dataflow Diagram
View the file
Other files
Show all 36
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Legend
Sample Output (Statements, Worksheets, OFAs)
Data
Reports
Leo Metadata:
Data Services Global Settings/Preferences User Preferences Permission/Access Controls Additional Logging
Configuration Files
Retrieve Data (I, B Fields) Update O, B, P Fields Back to DB C/E Tables
Plan Rules Programming File
ATPBGC.xlam
Update Case DB
Yes
Go to VALTOOL to Finalize BSRS
BSRS/BET
Actuary programs plan formulas & rules into spreadsheets
No
Vx
Manual Process
Modify Vx, Sx or Px based on peer review feedback and then rerun Valuation
Processing.
Calculation Engine (Excel)
Finalized: Already determined final and ready for Software Closeout
Interest Rates and Mortality Factors
Reconcile with Genesis
Actuarial Functions Present Value Functions Social Security Functions
Lo ad
Files
Data Load
Electronic Load
Updates: DOB, DOD, SSN, etc.
Continue to Modify Plan Programming and Configuration Files ACT-ValTool and Design
Valuation Load, Miscellaneous Full
Load Files
Summary Documents (Plan, Conversion Factors, Manual BD Statements)
Database can be created in ValTool, however, is usually created from Leo.
Fields available for use
Sx/Px
Valuation Programming Closeout Processing
Database Building
Valuation Processing
Headquarters Network Drive
Case Files 123
Update Case Metadata
Case Files
Case Files...
Location #1 Location #2
Generate Location WinArchive
Copy Case Files to Location
Copy WinArchive DB to Locations
) G en erate O u tp u ts
Read to reconcile with Leo
Electronic Load
Manual Load
VT97.xlam
4) Exit Runtime & Delete BSRS Copy
Reads
Network Drive Network Drive
Vx
Px
Sx
Use Final Version of Case #
Value Case: Write Final Data to Case #
Plan Documents (Rules, Assets, PBGC
Limitations)
Case #
Vx
Sx/Px/ Cx
BSRS
Case #
Vx
Sx/Px/ Cx
BET
Case #
Vx
Sx/Px/ Cx
BSRS
Case #
Vx
Sx/Px/ Cx
BSRS
Case #
Vx
Sx/Px/ Cx
BSRS
Leo
Leo
Case 1
Case 2
Pre-Valuation / Post-Valuation Administration
Case #
Vx
Sx/Px/ Cx
BET
Case #
Vx
Sx/Px/ Cx
BSRS
) C o p y B
SR
S/B
ET &
Lau n ch R u n tim e
Using Finalized BSRS
Initial State
Intermediate State
Final State
BCV Process / Dataflow Diagram
1st Pay Load Customer Load
Yes
Create/Update Copy of latest Case Database
Read to Search / Write to Update Case Data and
Settings
Case #
Actuarial Case Report (Blue Book) w/ BSRS Program
Pre-Valuation: Make BET available to FBAs
Genesis
Genesis
Case # Temp
ADTF.accdb
Complete
Is Good?
Group
Continuous Process
ATPBGC
ACT.accdb
Metadata
Leo
Case #
Vx
Sx/Px/ Cx
BSRS
Documents to Archive
Case #
Vx
Sx/Px/ Cx
BSRS
Documents to Archive
Case #
Vx
Sx/Px/ Cx
BSRS
Documents to Archive
BCV Participant Data
Metadata
Sample Output (Statements, Worksheets, OFAs)
Recalculation Output (Statements, Worksheets, OFAs)
Statement Output (PCL Format)
Master WinArchive
Application
Outside BCV
WinArchive Location #1
WinArchive Location #2
WinArchive Location #2
WinArchive Location #2
Case Files 123
Case Files... Case Files...
Case Files 456
Output
Output
Calculate Retrieve Update Erase
Cx
OASD ToolOT
Leo Cases (Headquarters/Location, e.g. FBA)
ACT.accdb
Reports (Summary & Detail)
Fields available for use
ACT.accdb
ACT.accdb
Fields available for use
Fields available for use
* ATPBGC Add-In and NPVF Calculator are also used outside of the BCV Process.
AggMax ToolOT
Identify participants that fall within the aggregate limit
Documents to Archive
Software Closeout ToolOT
Reconciliation Perform SSN Match Updates CCI in C8 Table IPVFB Validations
Plan Download ToolOT
Produce Electronic Load File Containing GENOWN Information (Census, Valuation, Payment and Address)
Pre-Trusteeship Data ViewerOT
Search View Source Data
Spectrum eALG – CDI (Customer Document Importer)
IPVFB - Supplemental Benefit Extract
NPVF CalculatorOT
Calculate Table Factors
Manual Data Entry
Add / Update Case File(s)
Other Business Process
Documents to Archive
Reports
DOPT Listings
Reports
Access Controls Metadata
Plan Close
Case #
Plan Download
Metadata (User Access)
Genesis
U p d ates C
8 Tab les
Case # Temp
Review Process
Reads
Genesis
Conversion Project for OFA ToolOT
Updates Local Copy of Case Database
Looks at Genesis and Compares data
Plan ClosingOT
Validate/Reconcile Valuation Data between Genesis and Case Database
Reports
ATPBGC.xlam
Interest Rates and Mortality Factors
Actuarial Functions Present Value Functions Social Security Functions
ATPBGC
U se P lan D a tab ase
Updates
No
LeoOT
Search Load Data (Manual & Electronic) Update Data Reconcile with Genesis Create/Update Case Database Custom Input Screens Data Validation
Define Valuation Group Design Bulk Groups Design Statement Groups Program Plan Rules Value Group
ACT-ValTool
Test Valuation Programming and Output format (generate output)
ACT-Runtime
Design Benefit Statement Design Worksheet Design OFA Design Base Data Screen Design Custom Test
ACT-Design
Produce Benefit Statement
ADT
ACT-Runtime
ACT-Runtime
Run Bulk Calculation to Produce Sample Output
ACT-DRS
Generate Listings
ADT
Validate Case Database and Generate Reports
PACS & Batch PACS
Archive Access
1) Select Case, Group, Version and Configuration File
Archive Case Files Update Archived Case Files Maintain Standard Groups, Naming Conventions, and Case File Types
Assign Plan to Location Synchronize Data
Archive Utility
Produce Valuation Load Files
Produce Individual Recalculation
ACT-Runtime
Refund/Recoupment Calculation Generate Optional Form of
Annuity One-Time Payment Interest
Calculation
| ValuationProcessFlowDiagram_Combined.vsd |
| Page-1 |
File details come from the government source that posted it. Updated .