Deleting the code (Change_Type: D): Delete
Description: This change type is used to update the End date.
Property mappings:Code set type Pega property Base File/Change File File property (Base file or Change file) Is mandatory (From files) Note CPT .Code Change File CPT_Code Yes Mandatory in both base and change files .ExpirationDate Change File Date_Terminated Yes Date_Terminated/Release_Date must be mandatory .Status Change File Release_Date Yes "End Date Updated as part of release"+Release_Date .Version NA No change in version in case of delete ICD10 Dx .Code Change File CODE Yes Mandatory in both base and change files .ExpirationDate Change File Date_Terminated Yes .Status Change File Release_Date Yes "End Date Updated as part of release"+Release_Date .Version NA No change in version in case of delete HCPCS .HCPC Change File HCPCS_CODE Yes Mandatory in both base and change files .ExpirationDate Change File Date_Terminated Yes .Status Change File Release_Date Yes "End Date Updated as part of release"+Release_Date .Version NA No change in version in case of delete
- Example: CPT
- Base file:
- Change file: Date_Terminated*
Note: In case of Change_Type: D, Date_Terminated is must. After importing: End Date of the latest version gets updated. (Latest record)
- Notes:
- Even though we get OLD_DESC, NEW_DESC from change file, while processing these details are not saved into code set record.
- In conclusion, we must have respective descriptions in base file for each unique code in change file. So, system will take descriptions from base file and dates from change file, put it together and save that record into the respective code set DB.
- Validations:
- Although, there are no validations in the system while processing, while importing the change file “.csv” file, dates are validated against the format (M/d/yyyy). We expect the data to be in line with this format. Refer given sample data as well.
- Release_Date importance: In case we don’t receive Original_Start or Revised_Start dates from change file, system will consider Release_Date as the effective date of the given code.
Previous topic Updating existing code (Change_Type: C and U) : Change or Unrecognized change Next topic Use case 5: Accessing audit trail, attachments, and notes