Deleting Group Codes

Steps For Deleting Group Codes

• The requester will submit a case through FogBugz.  The main requesters will be Lillian or Seth.

• The requester must decide if this is a delete for HQ_Abbr or TAMS_Abbr group code and assign to the appropriate person.

• Deleting a Group Code for HQ_Abbr 
  • We should only have to delete this group code from DBO_CLASSIFICATIONDATA.Hq_tams_group table.
  • This can be done on in the Line Editor Application on Classification Launch.
  • Make sure no parts exist for the HQ_Abbr and group code via DOG.
  • Select HQ_Abbr, click 'Active HQ' check box to unselect group code as active.
  • Here is a screenshot of where to remove group code:
    • Screen Shot of Line Editor (Deleting Group Code for Hq_Abbr).docx
  • This delete will be handled by Class Clerk, Lillian Boayue.

• Deleting a Group Code for TAMS_Abbr
  • We should only have to delete from DBO_CLASSIFICATIONDATA.Tams_group table​.
  • A function or procedure will process this delete.
  • This delete will be handled by developer, Hazel Womack.

• Manual Steps Currently done for Deleting a Group Code for TAMS_Abbr and Hq_Abbr
  1. ​Check DBO_CLASSIFICATIONDATA.Part_Master table to see if any parts for that group code exist, if so, let the requester know that parts exist and they need to move them to a new group code before you can delete the old group code.
  • Example:
    • SELECT * from DBO_CLASSIFICATIONDATA.Part_Master where hq_abbr = 'RBP' and group_code=305;

             2.  Get TAMS_Abbr and Parent_HQ_Abbr from DBO_CLASSIFICATIONDATA.Hq_line Table 

• Example:
  • SELECT * FROM DBO_CLASSIFICATIONDATA.Hq_Line where hq_abbr='RBP'

            3.  Get group_id from DBO_CLASSIFICATIONDATA.Tams_Group Table

• Based on our Weekly Update Meeting, you may not need group_id but only tams_abbr for delete, this will have to be tested.
• Example:
  • ​SELECT * from DBO_CLASSIFICATIONDATA.Tams_group where tams_abbr ='UP' AND group_code = 305;
  • NOT SHOWING UP IN TABLE MAYBE BECAUSE UNDER DIFFERENT PARENT ABBR OR NOT THERE    

            4. Check records from DBO_CLASSIFICATIONDATA.Hq_Tams_Group Table

• Based on our Weekly Update Meeting, this step will no longer be needed.
• Example:
  • ​SELECT * from DBO_CLASSIFICATIONDATA.Hq_Tams_Group where GROUP_ID = 2648 AND PARENT_HQ_ABBR = 'RBP';

  5. Validation that no HQ versions of the group code exist.  If any exists, please notify requester to have them inactivate the HQ version so that the delete can proceed.                   

• Validation that no HQ versions of the group code exist.  If any exists, please notify requester to have them inactivate the HQ version so that the delete can proceed.
• HQ versions of group code are selected as inactive in Line Editor 
• Example:
  • Example:
    • ​SELECT * from DBO_CLASSIFICATIONDATA.Hq_Tams_Group where GROUP_ID = 2648 AND PARENT_HQ_ABBR = 'RBP';

• Based on our Weekly Update Meeting, you may not need group_id but only tams_abbr for delete, this will have to be tested.
•  Example:
  • DELETE FROM DBO_CLASSIFICATIONDATA.Tams_group
       WHERE group_id = 2648;   
     COMMIT;