Identify Replacement Code Procedures in BAR.BCH
Posted by craigvillacorta on 090404
I have a report built in BAR.BCH.transaction.items. The challenge was to figure out if the item.procedure was a charge explosion (Replacement Code) or if it was a regular charge. At the transaction.item level, the only way I could see the procedure was associated to a replacement code was in the @item.comment field.
For example, if procedure “456″ was a replacement code/charge explosion triggered from procedure “123″, the @item.comment field would have the following:
456|FROM 123
Hence, you could use string extraction like so:
@item.comment#”1 “
The above code would output: 123
