Welcome Guest, Login


Quick Search

The PDI template file can generate client URNs. It can be downloaded from here.

About the functionality:

  • Opening the client table and pressing Ctrl-U will populate the cln_URN_base field with the correctly calculated base URN.
  • This value requires the exp_client table fields cln_first_name, cln_last_name, cln_dob, and cln_gender to be populated first.
  • Cln_gender must be populated with the gender codes that CAREWare uses:
    • 1 - Male
    • 2 - Female
    • 3 - Transgender Unk
    • 4 - Transgender MtF
    • 5 - Transgender FtM
    • 6 - Refused to Report
    • 9 - Unknown
  • This function does not populate the URN suffix, which is used at the 12th character in the full URN.
  • The cln_URN_base field is only designed to assist users in identifying clients and is not used by CAREWare while importing clients with the PDI process. A client's URN will always be calculated during the PDI import process.

Back to Frequently Asked Questions

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.