SSMT: Users / Providers

Description

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 optional, but can hold titles such as Dr., Mrs., Mr.

    Storage Location:  Works.dbo.Person_Other.TitleName 
    Data Type:  VarChar(20)
    Possible Values:  Free Text

• User_Provider - This allows you to specify the type of user you want to create. User means that you are creating a standard user account. User/Provider means that you are creating a User that is also a provider. This is typically defined as any user that is scheduable or billable. A provider will allow you to establish a provider account that will nto need to log into the system. This is typically something such as an non-human resouce such as a Lab Schedule.

    Possible Values - User, User/Provider, Provider

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