United States Health Information Knowledgebase

 

Actuarial Value

BP003, Massachusetts

Versions: June 20, 2013 - v3.1 • October 1, 2014 - v4.0Compare Versions


Name:Actuarial Value
Data Element ID:BP003
Description:Actuarial value for the benefit plan
State:Massachusetts
Data Type:Decimal
Data Type Description:Numeric
Format:varchar[6]
Length:6
Column:3
Threshold:1
File:BP
Element Submission Guideline:Calculate using the Federal AV Calculator for the risk adjustment covered plan. Report the Actuarial Value of this plan as of the 15th of the month. Format to be used is 0.000. For example, an AV of 88.27689% should be reported as 0.8828.
Condition:All
Cat:A0
Downloads
 
Download as an MS Excel™ spreadsheet.
[Download Excel Reader Exit Disclaimer]
 

File Specification for Multiple versionsBenefit Plan Control Total File Submission - October 1, 2014 - v4.0

Data Element ID Data Element Description Type Format Length
Multiple versionsHD001 Type of File Defines the file type and data expected. Text char[2] 2
Multiple versionsHD002 Submitter Header Submitter / Carrier ID defined by CHIA Integer varchar[6] 6
Multiple versionsHD003 Period Beginning Date Header Period Start Date Date Period -Integer Int[6] CCYYMM 6
Multiple versionsHD004 Period Ending Date Header Period End Date Date Period -Integer Int[6] CCYYMM 6
Multiple versionsHD005 APCD Version Number Submission Guide Version Decimal - Numeric Char[3] 3
Multiple versionsHD006 Comments Header Carrier Comments Text varchar[80] 80
Multiple versionsBP001 Benefit Plan Contract ID Benefit Plan ID Text varchar[30] 30
Multiple versionsBP002 Benefit Plan Name Submitter defined benefit plan name Text varchar[70] 70
Multiple versionsBP003 Actuarial Value Actuarial value for the benefit plan Decimal varchar[6] 6
Multiple versionsBP004 Claim Type Qualifier Claim Type Identifier Code Lookup Table - Integer int[1] 1
Multiple versionsBP005 Monthly Claims Paid Number for the Benefit Plan Total Number of Claims Paid Quantity - Integer varchar[15] 15
Multiple versionsBP006 Monthly Net Dollars Paid for the Benefit Plan Total Paid Amount Integer varchar[15] 15
Multiple versionsBP007 Total Monthly Eligible Members by Benefit Plan ID Period Date Total Eligible Members Quantity - Integer varchar[15] 15
BP008 Benefit Plan Start Date Benefit Plan Start Date Full Date-Integer Int[8] CCYYMMDD 8
BP009 Benefit Plan End Date Benefit Plan End Date Full Date - Integer Int[8] CCYYMMDD 8
Multiple versionsTR001 Type of File Validates the file type defined in HD001. Text char[2] 2
Multiple versionsTR002 Submitter Trailer Submitter / Carrier ID defined by CHIA Integer varchar[6] 6
Multiple versionsTR003 Record Count Trailer Record Count Integer varchar[10] 10
Multiple versionsTR004 Date Processed Trailer Processed Date Integer Int[8] CCYYMMDD 8
Multiple versionsTR005 Period Beginning Date Trailer Period Start Date Date Period -Integer Int[6] CCYYMM 6
Multiple versionsTR006 Period Ending Date Trailer Period End Date Date Period -Integer Int[6] CCYYMM 6

Scroll To Top