SQL Request Process

All SQL requests will need to be approved by the Workstream Lead after vetting a SQL is the best option for an update. SQL updates leave no audit trail of the change so before and after data needs to be documented and attached to the request along with the business approval. IT approval from Lisa Bussa or Lisa Kustura is also required.

Submit a Service Request in Freshworks
1. JDE E1 SQL Request

Requester – this should be a Business Analyst or Master Data resource
CC – you can enter the name of the person requesting the change
Request for someone else – check the box and enter the person’s name who is requesting the SQL in the Request For field
SQL Justification – enter a description of why a SQL is needed – SQL’s should be a last resort to fix an issue or data problem.
SQL Query – enter the SQL query logic
Table(s) Updated – enter the JDE table(s) that will be updated when the SQL is run
Business Owner – Enter the Business Lead that will need to approve this SQL run.
Environment(s) to be updated by SQL – Select the E1 enironment(s) the SQL will need to run in.
Priority – Select priority
Date SQL Need to be Run – enter the date the SQL needs to be run
Attach Files – attach a ‘Before’ file that shows the data prior to the data being run