LexBuild

Delete an Existing Record

Description:
  • Delete an existing record from LEXICON (mark the lastAction to delete, not delete from database table).
  • User, Manager, Administrator

Logic Details:

StateDatabase tableSet LastActionDescriptions
Select
  • LEX_RECORD
  • LEX_RECORD_TEMP
  • INFL_VARS
  • INFL_VARS_TEMP
  •  Select an existing record through Close Match or LexAccess
    Delete  Delete record
    SubmitLEX_RECORD_TEMP check if the record with specified EUI is pending (exist in LEX_RECORD_TEMP)
    SubmitLEX_RECORD4 (Pending)update record with specified Eui
    SubmitLEX_RECORD_TEMP3 (Delete)insert record into LEX_RECORD_TEMP
    SubmitINFL_VARS_TEMP insert inflVars records (from INFL_VARS) into INFL_VARS_TEMP
    ApproveLEX_RECORD3update this record in LEX_RECORD
    ApproveLEX_RECORD_TEMP delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 3
    ApproveINFL_VARS_TEMP delete inflVars records from INFL_VARS_TEMP with specified Eui
    DenyLEX_RECORD2update record with Eui and lastAction = 4
    DenyLEX_RECORD_TEMP delete record in LEX_RECORD_TEMP with Eui and lastAction = 3
    DenyINFL_VARS_TEMP delete inflVars records from INFL_VARS_TEMP with specified Eui
    ViewLEX_RECORD_TEMP select all records in LEX_RECORD_TEMP with lastAction = 3