Add StateDPS field to the DB

[wjstarck]

A StateDPS field needs to be added to the DB, with a corresponding form field added to provider setup, so that we can add this data to our Rx using sheets. I don't know if the Rx sheet will automatically add this to the list of items under Edit Sheet Def > (Add new) Output Text > Field Name once it is added to the db, but if not it needs to be added to that list as well.

Currently we are adding the DPS number with a static text field which shows on noncontrolled Rx as well, but I don't know how picky Texas will be about that.

BTW, good job on sheets!

Thanks

[jordansparks]

Is the DEA field long enough to simply hold both numbers?

[wjstarck]

No, but that's a good workaround.

Our DPS numbers are 7 characters, and the field currently holds 5 more than the DEA number. I'm thinking 20 characters total should do it

DEA = 9 + 1 for a / + 2 for spaces and then 7 for the DPS number.

Then in sheets we could do something like

DEA #/ DPS #: BS1234567 / H012345