Mass Billable Charge Creation CSV Format (Fully Insured Individual)

The following table lists and describes the columns that should be available in the CSV file while creating multiple billable charges for the fully insured individual business at once through an upload request:

Sr. No. Column Name Description Mandatory (Yes or No)
1 Account Identifier Type Used to specify the account identifier type.
Note: You must specify an account identifier type which is already defined in the system.
Yes (Conditional)
Note: This data is required when the account ID and contract ID are not specified in the record.
2 Account Identifier Used to specify the account identifier.
Note: The system derives the account using the given account identifier type and account identifier combination when the account ID is either not specified or is invalid in the record.
Yes (Conditional)
Note: This data is required when the account ID and contract ID are not specified in the record.
3 Account ID Used to indicate the account for which you want to create the billable charge. Yes (Conditional)
Note: This data is required when the following conditions are met:
  • Account identifier type and account identifier are not specified in the record.

  • Contract ID is not specified in the record.

4 Health Plan Code Used to specify the health plan code.
Note:

You must specify a health plan code which is already defined in the system.

If the contract ID is not specified in the record, the system derives the health plan specific contract of the account.

Yes (Conditional)
Note: This data is required when the contract ID is not specified in the record.
5 Contract ID Used to indicate the contract against which you want to create the billable charge. Yes (Conditional)
Note: This data is required when you want to create the billable charge against a specific contract of the account.
6 Start Date Used to specify the start date of billable charge.
Note:

You must specify the date in the YYYY-MM-DD format.

The start date cannot be later than the end date.

Yes
7 End Date Used to specify the end date of billable charge.
Note:

You must specify the date in the YYYY-MM-DD format.

The end date cannot be earlier than the start date.

Yes
8 Charge Type Used to indicate the type of billable charge.
Note: You must specify a charge type which is already defined in the system.
No
9 Description On Bill Used to specify the summarized information about the charge that you want to print on the bill. Yes
10 Bill Period Used to indicate the bill period using which the system determines the intervals at which the recurring bill segments should be created for the billable charge.
Note:

You must specify a bill period which is already defined in the system.

If the bill period is specified in the record, the system, by default, sets the recurring flag to BP.

No
11 Bill After Used to specify the date after which the charge can be billed to the account.
Note: You must specify the date in the YYYY-MM-DD format.
No
12 Description on Bill1, Description on Bill2, ....., Description on Bill5 Used to specify the description for the pass-through charge line.
Note: You can specify maximum 5 pass-through charge lines in the record.
Yes (Conditional)
Note: This data is required while creating a pass-through billable charge.
13 Amount1, Amount2, ....., Amount5 Used to specify the charge amount.
Note: You must specify a number with decimal positions less than or equal to the decimal positions defined for the respective currency.
Yes (Conditional)
Note: This data is required while creating a pass-through billable charge.
14 Currency1, Currency2, ....., Currency5 Used to specify the currency in which the amount is charged.
Note:

You must specify a currency which is already defined in the system.

If you specify a currency other than the account's invoice currency, the system will do the currency conversion if the appropriate exchange rate is available in the system.

Yes (Conditional)
Note: This data is required while creating a pass-through billable charge.
15 Show On Bill1, Show on Bill2, ....., Show On Bill5 Used to indicate whether the charge should appear on the person's printed bill. The valid values are:
  • Y

  • N

Note: If you do not specify this column value, by default, it is set to Y.
No
16 Memo Only1, Memo Only2, ....., Memo Only5 Used to indicate whether the charge should not be included in the bill amount. The valid values are:
  • Y

  • N

Note: If you do not specify this column value, by default, it is set to N.
No
17 Appears in Summary1, Appears in Summary2, ....., Appears in Summary5 Used to indicate whether the charge should be included in the summary line. The valid values are:
  • Y

  • N

Note: If you do not specify this column value, by default, it is set to N.
No
18 Distribution Code1, Distribution Code2, ....., Distribution Code5 Used to specify the distribution code that indicates the GL account where the pass-through charge should be posted.
Note: You must specify a distribution code which is already defined in the system.
Yes (Conditional)
Note: This data is required when the memo only flag of the pass-through charge line is set to N.
47 Price Item Used to indicate the price item for which you want to create the billable charge.
Note: You must specify a price item which is already defined in the system.
Yes
48 Variance Parameter Variance parameter (i.e., TOU) based pricing is deprecated and no longer supported in ORMB. Therefore, you should keep this column blank in the CSV file. Not applicable
49 Price Item Parm Type1, Price Item Parm Type2, ....., Price Item Parm Type15 Used to indicate the price item parameter that you want to use along with the price item for determining the price item pricing.
Note:

This column value should not contain the Equal To (=) or Tilde (~) symbol.

You must specify the mandatory parameters of the price item when the billable charge start and end dates fall within the respective price item parameter date range.

You must specify a parameter which is associated with the price item in the given date range.

You can specify maximum 15 price item parameters in the record.

Yes (Conditional)
Note: This data is required when the price item parameter value is specified in the record.
50 Price Item Parm Value1, Price Item Parm Value2, ....., Price Item Parm Value15 Used to specify the parameter value.
Note: This column value should not contain the Equal To (=) or Tilde (~) symbol.
Yes (Conditional)
Note: This data is required when the price item parameter is specified in the record.
79 SQI1, SQI2, ....., SQI5 Used to indicate the service quantity identifier (SQI) using which you want to calculate the price item charge.
Note:

You must specify an SQI which is already defined in the system.

You can specify maximum 5 SQIs in the record.

Yes (Conditional)
Note: This data is required while creating an SQI based billable charge.
80 SQI Value1, SQI Value2, ....., SQI Value5 Used to specify the service quantity for which you want to create the charge.
Note: You can specify a number with a maximum precision 36 and maximum scale 18 (i.e., Number(36, 18)).
Yes (Conditional)
Note: This data is required while creating an SQI based billable charge.
89 Subscriber Identifier Type Used to specify the membership identifier type.
Note: You must specify a membership identifier type which is already defined in the system.
Yes (Conditional)
Note: This data is required when the characteristic type specified in the Membership ID Characteristic for Billable Charge option type of the C1-ASOBLLNG feature configuration is not available in the record.
90 Subscriber Identifier Used to specify the membership identifier.
Note:

Here, you must specify the main subscriber’s identifier. The system then derives the individual membership for which the billable charge should be created using either of the following combinations:

  • Subscriber Identifier Type and Subscriber Identifier

  • Membership Type, External Membership ID, Subscriber Identifier Type and Subscriber Identifier

Yes (Conditional)
Note: This data is required when the characteristic type specified in the Membership ID Characteristic for Billable Charge option type of the C1-ASOBLLNG feature configuration is not available in the record.
91 Membership Type Used to indicate the type of membership. The valid values are:
  • COBR - Used when the individual membership is a COBRA membership.

  • MDCR - Used when the individual membership is a Medicare membership.

  • RETR - Used when the individual membership is a retiree membership.

Note:

You must specify a membership type which is already defined in the MEMBERSHIP_​TYPE_​FLG lookup field.

The membership type is used along with other membership details, such as External Membership ID, Subscriber Identifier Type and Subscriber Identifier to derive the individual membership for which the billable charge should be created in the system.

No
92 External Membership ID Used to specify the external membership ID.
Note:

Here, you need to specify the membership ID which is maintained in the external source system.

If the subscriber identifier type, subscriber identifier, and membership type are not specified in the record but only the external membership ID is specified in the record, then you must ensure that the external membership ID is unique for the membership across the system.

No
93 Effective Date1, Effective Date2, ....., Effective Date20 Used to specify the date from when the characteristic is effective for the billable charge.
Note: You must specify the date in the YYYY-MM-DD format.
Yes (Conditional)
Note: This data is required when the characteristic type is specified in the record.
94 Char Type1, Char Type2, ....., Char Type20 Used to specify the characteristic type.
Note: You must specify a characteristic type where the characteristic entity is set to Billable Charge.
No
95 Char Val1, Char Val2, ....., Char Val20 Used to specify the value for the characteristic type. Yes (Conditional)
Note: This data is required when the characteristic type is specified in the record.
Note:
The CSV file should contain the columns in the above mentioned sequence. You can add five pass-through charge lines — each set containing Description on Bill, Amount, Currency, Show on Bill, Memo Only, Appears in Summary, and Distribution Code followed by the subsequent set (i.e., Description on Bill1, Amount1, Currency1, Show on Bill1, Memo Only1, Appears in Summary1, Distribution Code1, Description on Bill2, Amount2, Currency2, Show on Bill2, Memo Only2, Appears in Summary2, Distribution Code2, and so on). Similarly, you can add the following:
  • 15 sets of pricing parameters — each set containing Price Item Parameter and Price Item Parameter Value followed by the subsequent set (i.e., Price Item Parameter1, Price Item Parameter Value1, Price Item Parameter2, Price Item Parameter Value2, and so on).

  • 5 sets of SQ details — each set containing SQI and SQI Value followed by the subsequent set (i.e., SQI1, SQI Value1, SQI2, SQI Value2, and so on).

  • 20 sets of characteristics — each set containing Effective Date, Char Type and Char Value followed by the subsequent set (i.e., Effective Date1, Char Type1, Char Val1, Effective Date2, Char Type2, Char Val2, and so on).

You must specify either pass-through charge lines or SQI details in the record.

Before uploading the file, ensure that the column headers specified in the CSV file are mapped to the schema of the respective upload request business object through data mapping in the upload request type. Otherwise, erroneous results might occur. For more information, see Mapping Data and Configuring Filters for an Upload Request Type.