Hello, I need some help to validate oracle code which is implemented in the database. I am validating in SAS. Here is the business logics which I have to tested 1)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'. If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN. 2) Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'. If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN. 3)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'. If there is a value in the 'replaced TCN number' field, then fetch the row where the TCN matches that value, up the chain, until the original TCN is found. 4)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'. If the original TCN is not found, the default value of <NULL> will be assigned. I appreciate all the help. Thank You
... View more