search

bcgov / moh-phlat

Repository for the PHLAT registries data loading application
Apache License 2.0
2 stars 0 forks source link

Added Conditional statuses list for change on record level #51

Closed ptugger closed 7 months ago

ptugger commented 7 months ago

Adding a status list for changing row status based on conditions.

The following ROWSTATUS may be set to ‘DO NOT LOAD’ or 'ON_HOLD', by the User:

‘ON_HOLD’
‘DO NOT LOAD’ 
‘VALID’,
‘INVALID’,
‘WARNING’,
‘POTENTIAL DUPLICATE’.
--------------------------------------------------------------------------

The following ROWSTATUS may be set to ‘INITIAL', by the User:

‘ON_HOLD’
‘DO NOT LOAD’ 
(Then the record must be automatically re-validated by the system).

----------------------------------------------------------------------------

A ROWSTATUS of WARNING may be user overridden and set to either:

‘VALID’,
‘DO NOT LOAD’,
‘ON HOLD’ 
‘POTENTIAL DUPLICATE’ **
Note: In order for the record to be loaded into PLR, the ROWSTATUS must be changed from WARNING to VALID.

Note: This is the only ROWSTATUS the User can change to VALID.

See BC-21207

----------------------------------------------------------------------------------------

A ROWSTATUS of 'POTENTIAL DUPLICATE’ may be resolved by the user. 

The user must review the records in the potential duplicate set and decide if there are belong to the same entity, in which case they need to change the rROWSTATUS of the survivor to ‘Valid’ and the ROWSTATUS of the non-survivor to ‘'DO NOT LOAD'.  If the user decides they are not the same entity, the user must change both records in the duplicate set to ROWSTATUS ‘Valid’ so that both records will load.