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 ...

• Data Warehouse - Data Dictionary

  Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...

• 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 do I change my password in FINET

  Steps to change your password: 1. Access the FINET Home page. 2. Click: Your name (my profile) on the top right 3. Click: Account Settings 4. Click: Password Management 5. Enter you current (old) password in the Current Password field. 5. Enter your ...