I am needing to create a way to dual validate by two different users for each process in a narcotics tracking module we are including in our next software version. I will highlight the processes and am looking for advice, ideas or suggestions.
When new vials of a narcotic is ordered, it needs to be approved/validated by two different personnel approved to do so. When it is delivered, it needs to be validated again by two different personnel, and when the narcotic is either administered, expired or submitted to the local DEA personnel to be destroyed it again needs to be validated by two personnel.
My thought is to include a new field in the security tables called "PIN" which will be a 4-20 character password to serve as an electronic signature password. I realize there is no perfect way for this and passwords/PIN numbers CAN be discovered, but if the person enters their name from a dropdown and enters the correct PIN number then that is about as close as i we can get to confirming the users identity. Now that is for one person for a particular action, i still need to have another person do the same thing, select their name and enter their PIN for that action.
So when the delivery arrives, i would use my PIN and who ever else is approved to validate the delivery would enter their PIN. So now i need to somehow document that the delivery process has been dual validated. I am trying to wrap my mind around how to accomplish this, but would like to get input from others who may have already crossed this bridge.
I was thinking, probably wrong, but i would include 1 logical field and 2 char fields for each process that needs dual validation. the two char fields would be for the users PIN, or their name, which would be validated before saving and once there has been two correct validations, the logical field would be set to .t. so it would show that validation is completed.
When new vials of a narcotic is ordered, it needs to be approved/validated by two different personnel approved to do so. When it is delivered, it needs to be validated again by two different personnel, and when the narcotic is either administered, expired or submitted to the local DEA personnel to be destroyed it again needs to be validated by two personnel.
My thought is to include a new field in the security tables called "PIN" which will be a 4-20 character password to serve as an electronic signature password. I realize there is no perfect way for this and passwords/PIN numbers CAN be discovered, but if the person enters their name from a dropdown and enters the correct PIN number then that is about as close as i we can get to confirming the users identity. Now that is for one person for a particular action, i still need to have another person do the same thing, select their name and enter their PIN for that action.
So when the delivery arrives, i would use my PIN and who ever else is approved to validate the delivery would enter their PIN. So now i need to somehow document that the delivery process has been dual validated. I am trying to wrap my mind around how to accomplish this, but would like to get input from others who may have already crossed this bridge.
I was thinking, probably wrong, but i would include 1 logical field and 2 char fields for each process that needs dual validation. the two char fields would be for the users PIN, or their name, which would be validated before saving and once there has been two correct validations, the logical field would be set to .t. so it would show that validation is completed.
Comment