Please enable JavaScript.

Coggle requires JavaScript to display documents.

1. (Is there a SharePoint Table entry with the status "New"),…

- - - - Navigate to jnjvldqa2.appiancloud.com/database
        
        Log in via JnJ SSO
- - - - Run the query in .\SQL\ExportProductData.sql
        
        Click "Export" under "Query results operations"
        
        Click "Custom - display all possible options" under "Export Method"
        
        Select "CSV" in the "Format" dropdown
        
        Set "Character set of the file" to "utf-8"
        
        Put an empty string (aka delete everything) in the "Replace NULL with" setting under "Format-specific options"
        
        1 more item...
- - - - Select "CSV" in the "Format" dropdown
        
        Set "Character set of the file" to "utf-8"
        
        Put an empty string (aka delete everything) in the "Replace NULL with" setting under "Format-specific options"
        
        Enable "Put column names in the first row" under "Format-specific options"
        
        Click "Go" all the way at the bottom of the page
        
        Save the exported file as ReferenceMaster.csv in .\Reference
- - - - Check .\CombinedCSV to see if CombinedProduct.csv is generated. If it is not, go to the system exception flow.
- - - - Update the user-defined constants in the workflow with the values from the query obtained in the previous step. (PRODUCT, FRM, STER_METHOD, STER_METHOD_PRIOR, STER_SITE)
        
        Press Ctrl+R to run
        
        Open .\TransformationResults\Product_Transformation_Summary.xlsx and check for errors.
        
        If error, go to the business exception flow
- - - - Select product data load
        
        Upload the following CSVs:
        
        RIM_REF_PRODUCT
        
        RIM_REF_PRODUCT_FINAL_RELEASE_MANUFACTURER_NAME
        
        RIM_REF PRODUCT_STERILIZATION_METHOD
        
        RIM_REF_PRODUCT_STERILIZATION_METHOD_PRIOR_TO_USE
        
        RIM_REL_PRODUCT_STERILIZATION_SITE
        
        Submit the files for upload, click the OK button on the confirmation popup
- - - - Restart with a new job