Unique key constraint violated for data in fields change ID (A245)

• Related Articles

• QRG - Using Access to query data warehouse

  (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

• Requirements and Criteria for customized document ID numbers

  Requirements The default document ID length is 10 characters, but you can do as few as 5 and as many as 20. Here are the required criteria for custom document ID structures      1.)  The ID must start with the fiscal year      2.)  The ID must be at ...

• QRG - Using Excel to query data warehouse

  (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

• How can I search for Transaction ID's within a range?

  You can create a range of Transaction ID's in Excel and then paste them into the "Transaction ID" to search for a range. Go to Excel Create the list of transactions Go to a new (empty) cell and go to the Formulas tab, click "Insert Function (fx) type ...

• We need to do a legal name change for a vendor who is an employee. What documentation do we need.

  For a vendor who is an employee backup is needed showing the new last name and parties should insure the change has also been made with HR. Providing backup from the HR system is sufficient.