2013-03-21- 4678.400 -Spec-ROC rework implementation - Update User IDs in ROCET with ROC IDs #ROCETApplication

SPECIFICATIONS

ROC rework implementation -Update User IDs in ROCET with ROC IDs


Purpose

Update UserID column in ROCET with ROC IDs.

Admin Info

Purpose
 Update UserIDs in ROCET with ROC IDs
Requested By
 Bibin
Spec Created By
 Rajesh K
Spec Created Date
 03/21/2013
Spec QA by
 Rajesh K
Document Status
 Completed

References

Prior Tickets

N/A

Documents

N/A


Functional Requirement

In tblUserMst table , UserID column is taken as identity column value due to which it mismatches with ID in ROC.
Update to this table is required to match the UserID column depending on ADID between old and new ROC and if any addition records exists in ROCET, that should still exists.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Write a query to do following
  1. Take backup of existing records in ROCET into temp table
  2. truncate entries from ROCET user master table [tblUserMst]
  3. insert users from ROC to ROCET
  4. check for any addional records in temp table
    1. if any records exists, insert those records with default value [Identity column].

Test Plan

[List test scenarios/cases to be executed here]

Title
Module
Steps
Expected Result
1) Compare Rows
 DB Users Comparision
  1. Login to production DB
  2. Select ROC Users from tblUserMst with ADID,User_MST_ID columns
  3. Select ROCET Users from tblUserMst with ADID,User_MST_ID columns
  4. Compare the list and map on ADID
  1. Logs to production SQL
  2. returns all users in ROC.
  3. returns all users in ROCET.
  4. User User_MST_ID should match for all ADID in roc

Solution Details

[Provide complete technical details for configuration or programming here]

Issues