Basis of Cost / MAC Pricing - Load

Basis of Cost / MAC Pricing load is similar to any other load process like Criteria Load / Eligibility / Accums load process

• Create & Activate a Data Management job configuration (This is one time process)
• Prepare the Pricing file, follow the standard file name format
• Open the S3 bucket and place the file in the correct input file.
• Then initiate the load process by choosing 'Run/Load Now' option from Data Management

Data Management Job Configuration

• Navigate to Administration -> Data Management
• To create the Job Configuration, Click on Add icon
• Select the Job Type as Basis of Costs and then click Next

• Enter the data in the job configuration. Save and activate it

Prepare the Pricing file

Refer to this documentation for preparing the Basis of Cost Price load file 

Place the file in S3 Path

• The input file path will be available in the job configuration. Follow this path and place the file in the correct folder. Make sure the file naming is followed correctly. 

• Once the file is uploaded, in a few mins the file will get STAGED if the file naming format is correct. If there are any issues, then you may see the file state as NON-MATCHED. The file status can be viewed by navigating Administration / Data Management. Choose the ellipsis icon of the Basis of cost job configuration and choose View Input Files option

Initiate the load process

• Once you see your uploaded file state as STAGED. Now in the same job configuration, choose the Run/Load Now option
• Once you initiate the load process, you can track the job status by choosing the View Job Execution Details
• Once the job status is Success, You should be able to view the job stats. This shows you Total number of records, successfully loaded and failed ones

Note

• You can process multiple files together. Just stage all the basis of cost files that needs to be loaded into the system. Wait for the files to get STAGED, then initiate the load job
• These jobs are per PBM. So if you want to run the pricing file in a different PBM, make sure you have created a job configuration in that PBM and follow the same steps as above.

How to view the failed records from the pricing load

• An error file is created for every job execution, containing all the records that were not processed. The file path is shared in the job notification email

• The error file contains the following fields

Field Name	Description
Error_Record_Number	Error Record Number Sequence
Job Execution ID	This is the unique ID of the job execution
File ID	Unique ID of the input file
File Name	Name of the file
Line_Number	This is the line number in the input file
Record_Text	Actual input data
Detail_Error	Error description

    

Sample Error file content

• Validation Error

Field	Scenario	Error Description
Action Code	When an invalid action code is provided in the input file	Invalid value for Action Code - <InputValue> is not a valid value for Action Code. Valid values are: A,C,D,T,R
Item Type	When an invalid item type is provided in the input file	<InputValue> is not a valid value for Item Type. Valid values are: NDC11,NDC9,GPI14
Basis of Cost code	When basis of code is not provided	Invalid value for Basis of Cost Code - Basis of Cost Code must be provided
Item ID	When Item ID is not provided	Invalid value for Item ID - Item ID must be provided
Unit Price	When Unit Price is not provided	Invalid value for Unit Price - Unit Price must be provided
Unit Price	When Unit Price is invalid	Invalid value for Unit Price - Unit Price must be numeric
Effective Start Date	When effective start date is invalid	Invalid value for Effective Start Date - Effective Start Date is not in the correct format. It should be in the format:yyyyMMdd
Effective End Date	When effective end date is invalid	Invalid value for Effective End Date - Effective End Date is not in the correct format. It should be in the format:yyyyMMdd