SSMT: Users / Providers
The User / Provider spreadsheet is used with the SSMT tool to load and manager user accounts in the TouchWorks application. This is based on version 11.0.1.
Column Listing and description
===Title=== - It allows you to store the persons title. This is usually left blank with the exception of physician account, which is where you'd place "Dr.".
- Stored in Works.dbo.Person_Other.TitleName
User_Provider LastName FirstName Middle OrgName Email User_Inactive Provider_Inactive Username Password DefaultSiteName Profession EmployeeNumber OwnerShipAuthority Force_PW_Change PHB System Reg_System Framework_DB Finalization Authority Electronic_Workflow Provider_Code Provider_Mnemonic CME_Pilot_Number VOrdering_Authority Credentials PrimSpecialty SecSpecialty DEA_Number DEA_Exp_Date Billing_Provider Scheduling_Provider Secure_Schedule PCP DontGenerate_SendChargeTasks Show_Optional_Clinical_Msgs DEA_II DEA_III DEA_IV DEA_V RX_Supervision StateLicense1 LicenseNumber1 LicExpDate1 StateLicense2 LicenseNumber2 LicExpDate2 StateLicense3 LicenseNumber3 LicExpDate3 Outbound_Dictate_ID RecordingFormat Transcribe Difficulty AlternateLicense UPIN Def CC Method NPI WorkPlace Def Clinical Desktop View IDXMLogin IDXMPassword Practice_Department PaIPreferredCommMethod LinkWithExistingProvider