Delete an Existing Record
Description:Logic Details:
State | Database table | Set LastAction | Descriptions | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Select | | Select an existing record through Close Match or LexAccess
| Delete | | | Delete record
| Submit | LEX_RECORD_TEMP | | check if the record with specified EUI is pending (exist in LEX_RECORD_TEMP)
| Submit | LEX_RECORD | 4 (Pending) | update record with specified Eui
| Submit | LEX_RECORD_TEMP | 3 (Delete) | insert record into LEX_RECORD_TEMP
| Submit | INFL_VARS_TEMP | | insert inflVars records (from INFL_VARS) into INFL_VARS_TEMP
| Approve | LEX_RECORD | 3 | update this record in LEX_RECORD
| Approve | LEX_RECORD_TEMP | | delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 3
| Approve | INFL_VARS_TEMP | | delete inflVars records from INFL_VARS_TEMP with specified Eui
| Deny | LEX_RECORD | 2 | update record with Eui and lastAction = 4
| Deny | LEX_RECORD_TEMP | | delete record in LEX_RECORD_TEMP with Eui and lastAction = 3
| Deny | INFL_VARS_TEMP | | delete inflVars records from INFL_VARS_TEMP with specified Eui
| View | LEX_RECORD_TEMP | | select all records in LEX_RECORD_TEMP with lastAction = 3
| |