rcmroi.test__sobj_Account

Field Type Null Default Key Extra Comment
master_id int(11) NO 0
master_guid varchar(36) NO
master_opid varchar(36) NO
master_enabled tinyint(1) YES 1
master_status varchar(1) YES
master_created datetime YES CURRENT_TIMESTAMP
master_modified datetime NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
master_expires datetime YES
Id varchar(18) NO
IsDeleted tinyint(1) YES
MasterRecordId varchar(0) YES
Name varchar(251) YES
Type varchar(20) YES
RecordTypeId varchar(18) YES
ParentId varchar(18) YES
BillingStreet varchar(93) YES
BillingCity varchar(33) YES
BillingState varchar(12) YES
BillingPostalCode varchar(13) YES
BillingCountry varchar(13) YES
BillingLatitude double YES
BillingLongitude double YES
BillingGeocodeAccuracy varchar(0) YES
BillingAddress varchar(240) YES
ShippingStreet varchar(77) YES
ShippingCity varchar(19) YES
ShippingState varchar(10) YES
ShippingPostalCode varchar(12) YES
ShippingCountry varchar(13) YES
ShippingLatitude double YES
ShippingLongitude double YES
ShippingGeocodeAccuracy varchar(0) YES
ShippingAddress varchar(228) YES
Phone varchar(40) YES
Fax varchar(32) YES
Website varchar(208) YES
PhotoUrl varchar(41) YES
AnnualRevenue double YES
NumberOfEmployees int(11) YES
Description text YES
Rating varchar(9) YES
OwnerId varchar(18) YES
CreatedDate datetime(6) YES
CreatedById varchar(18) YES
LastModifiedDate datetime(6) YES
LastModifiedById varchar(18) YES
SystemModstamp datetime(6) YES
LastActivityDate datetime(6) YES
LastViewedDate datetime(6) YES
LastReferencedDate datetime(6) YES
JigsawCompanyId varchar(0) YES
AccountSource varchar(32) YES
ConnectionReceivedId varchar(0) YES
ConnectionSentId varchar(0) YES
Systems_being_evaluated__c varchar(88) YES
Current_System__c varchar(89) YES
Additional_Account_Info__c varchar(43) YES
of_offices__c double YES
of_physicians__c double YES
Client_ID__c double YES
Office_Hours__c varchar(51) YES
E_mail__c varchar(43) YES
VAR_Type__c varchar(29) YES
Product_Service_Type__c varchar(43) YES
Azalea_Health_Products__c varchar(34) YES
Type_of_Account__c varchar(28) YES
Lead_Source__c varchar(17) YES
Specific_Lead_Source__c varchar(92) YES
Other_Specialties__c varchar(84) YES
X800_Phone__c varchar(18) YES
New_vs_Existing_TEST__c varchar(8) YES
SFSSDupeCatcher__Override_DupeCatcher__c tinyint(1) YES
LMD_Salesforce_ID__c varchar(15) YES
of_Licenses__c double YES
LID__LinkedIn_Company_Id__c varchar(0) YES
X3rd_party_Direct_Cost__c double YES
Account_Category__c varchar(25) YES
Actual_Go_Live_Date__c datetime(6) YES
Administrator__c varchar(30) YES
X3rd_Party_Products__c varchar(93) YES
Annual_Recurring_Revenue__c double YES
sMD_OwnerID__c varchar(35) YES
of_mid_levels__c double YES
Account_Phone__c varchar(40) YES
Reference_Account__c tinyint(1) YES
Specific_Account_Source__c varchar(229) YES
Legal_Business_Name__c varchar(93) YES
Volume_Based_Product_Purchased__c varchar(86) YES
Account_in_Myrna_once_Client__c varchar(14) YES
Monthly_Revenue__c double YES
Reason_for_Termination__c varchar(33) YES
Churn_Comments__c text YES
Termination_Date__c datetime(6) YES
Contract_Renewal_Date__c datetime(6) YES
Account_ID__c varchar(15) YES
Contract_Execution_Date__c datetime(6) YES
Client_Satisfaction__c varchar(8) YES
Conferences_Attended__c varchar(162) YES
Key_Account__c tinyint(1) YES
Total_Opps_Created__c double YES
Total_Open_Opps__c double YES
Total_Won_Opps__c double YES
Lifetime_Revenue__c double YES
Won__c double YES
Owner_Active__c varchar(3) YES
TMP__c varchar(8) YES
TMP_Other_Details__c varchar(58) YES
MRR_Target__c varchar(8) YES
Existing_Contract_Terminated__c varchar(3) YES
Buying_Timeline__c varchar(12) YES
Estimated_MRR__c double YES
Account_Status__c varchar(10) YES
Customer_Category__c varchar(29) YES
Partner_Organization__c varchar(18) YES
Partner_Opportunity_Total__c double YES
Total_Practice_Size__c double YES
Last_Close_Date__c datetime(6) YES
First_Close_Date__c datetime(6) YES
Rural_ZIP__c tinyint(1) YES
Current_PM__c varchar(123) YES
Outpatient_EHR__c varchar(96) YES
Part_Time_Provider__c double YES
Tax_ID__c varchar(13) YES
Practice_NPI__c varchar(11) YES
Acquisition_Status__c varchar(20) YES
LOI_Date__c datetime(6) YES
LOI_on_File__c tinyint(1) YES
NDA_on_File__c tinyint(1) YES
NDA_Date__c datetime(6) YES
Record_Type_ID__c varchar(15) YES
Alert_Notes__c varchar(100) YES
BAA_Status__c varchar(8) YES
Backdoor_Phone__c varchar(39) YES
AM_Last_Contact__c datetime(6) YES
AM_Next_Call__c datetime(6) YES
Gross_Margin__c double YES
AM_Main_Contact__c varchar(18) YES
AM_Notes__c text YES
RCM_Coordinator__c varchar(18) YES
Migration_Date__c datetime(6) YES
Last_Myrna_Data_Change__c datetime(6) YES
Account_Tier__c varchar(6) YES
Myrna_Products__c text YES
Alert__c varchar(109) YES
Backup_Service__c varchar(18) YES
Billing_Company_Solution__c varchar(54) YES
Billing_Frequency__c varchar(9) YES
Billing_Service__c varchar(14) YES
Billing_Type__c varchar(12) YES
Bill_Live_Date__c datetime(6) YES
Import2_ID_Account_18__c varchar(18) YES
Cancel_Category__c varchar(15) YES
Cancel_Date__c datetime(6) YES
Canceled__c double YES
Account_Type__c varchar(21) YES
Cancel_Reason__c varchar(254) YES
Clearinghouse_LMD__c varchar(8) YES
Clearinghouse_Detail__c varchar(115) YES
CodeCorrect_Enabled__c tinyint(1) YES
CodeCorrect_Lic__c double YES
Conversion_All_or_Phased__c varchar(53) YES
Cosmetic_vs_Recon__c varchar(10) YES
Direct_Address_Configured__c tinyint(1) YES
Direct_Connect_Claims__c tinyint(1) YES
Direct_Connect_ERA_Enabled__c tinyint(1) YES
Edition__c varchar(15) YES
Eligibility_Enabled__c tinyint(1) YES
EMR_Implementation_Rep__c varchar(16) YES
EMR_Implementation_Status__c varchar(29) YES
EMR_Imp_Status_Date__c datetime(6) YES
EMR_Imp_Status_Detail__c varchar(239) YES
eRx_Enabled__c tinyint(1) YES
eRx_Monthly__c double YES
Original_Contract_Execution_Date__c datetime(6) YES
eStatements__c tinyint(1) YES
Existing_PMS__c varchar(3) YES
Go_Live_Date__c datetime(6) YES
GreenFlag_Enabled__c tinyint(1) YES
Guarantee_Expiration__c datetime(6) YES
Guarantee_Terms__c varchar(69) YES
If_specialty_other_what__c varchar(42) YES
Implementation_Detail__c varchar(50) YES
Implementation_Fee__c double YES
Imp_Meeting_Complete__c datetime(6) YES
Ingenix_200_clms_Lic__c double YES
Ingenix_Claims_Provider_Lic__c double YES
of_Staff__c double YES
RenaissanceOrgID__c varchar(8) YES
Billing_Address_Geolocation__Latitude__s double YES
Billing_Address_Geolocation__Longitude__s double YES
Billing_Address_Geolocation__c varchar(48) YES
Customer_Map_Type__c varchar(8) YES
Reference_Contact_Lookup__c varchar(18) YES
LMD_Conversion_Status__c varchar(18) YES
MACRA__c varchar(6) YES
MIPS__c varchar(6) YES
Active_Accounts_14_days__c double YES
Current_Monthly_Spend__c double YES
Annual_Revenue__c double YES
Last_Activity_Date__c datetime(6) YES
Current_Support_Model__c varchar(9) YES
Incumbent_System__c varchar(7) YES
Licensed_Bed_Count__c double YES
LTC_System__c varchar(0) YES
MU_Stage_Completed__c varchar(4) YES
MU_Year_Completed__c varchar(1) YES
ImplementationRep__c varchar(16) YES
ImplementationStatusDate__c datetime(6) YES
ImplementationStatus__c varchar(12) YES
Number_of_Clinics__c double YES
Ingenix_ERA_Lic__c double YES
Ingenix_Eligibillity_Lic__c double YES
Insight_Lic__c double YES
Number_of_Providers_at_Each_Clinic__c varchar(13) YES
PBT_Prospect__c tinyint(1) YES
PBT_Stage__c varchar(7) YES
Renewal_Date__c datetime(6) YES
Services_Provided__c varchar(55) YES
Type_of_Clinics__c varchar(62) YES
texcellency__DHC_ID_Holder__c double YES
Lab_Requests__c varchar(195) YES
Lab_Status__c varchar(19) YES
MU_Program__c varchar(14) YES
Meaningful_Use__c varchar(9) YES
Money_Back_Guarantee__c tinyint(1) YES
MonthlyFee__c double YES
NB_Pro_Lic__c double YES
OfficeManager__c varchar(20) YES
PMSCompanySolution__c varchar(63) YES
Patient_Portal_URL__c varchar(60) YES
PotentialofPhysicians__c double YES
Practice_Sign_In__c varchar(22) YES
texcellency__DefHC_Address1__c varchar(33) YES
Re_assigned_Implementation_Rep__c varchar(16) YES
Read_only__c tinyint(1) YES
Reference_Contact__c varchar(41) YES
Reference_Last_Used__c datetime(6) YES
Reference_Notes__c varchar(116) YES
Reference_OK_Date__c datetime(6) YES
Reference_of_Times_Used__c double YES
SpecialArrangements__c varchar(249) YES
SupportLevel__c varchar(15) YES
TalkSoft_Enabled__c tinyint(1) YES
TranscriptionCompanySolution__c varchar(42) YES
TranscriptionService__c varchar(14) YES
Virtuoso_Practice_ID__c varchar(4) YES
Want_EMR_Upgrade__c tinyint(1) YES
Want_Out_Of_System__c varchar(165) YES
eRx_License__c double YES
ofLocations__c double YES
texcellency__DefHC_Address__c varchar(57) YES
texcellency__DefHC_AffiliationsACO__c text YES
Net_Monthly_Revenue__c double YES
Longevity__c double YES
eRx_Status__c varchar(18) YES
At_Risk_Date__c datetime(6) YES
No_Fly_Date__c datetime(6) YES
Churn_Letter_Received__c datetime(6) YES
Churn_Letter_Sent__c datetime(6) YES
Churning_Date__c datetime(6) YES
Contract_Collections_Date__c datetime(6) YES
Legal_Date__c datetime(6) YES
Follow_up_Notes__c text YES
Finance_Notes__c text YES
At_Risk_Notes__c text YES
RCM_Rate__c double YES
RCM_Minimum__c double YES
Term_Length_Months__c double YES
Myrna_Name__c varchar(40) YES
Myrna_Type__c varchar(4) YES
Myrna_Mnemonic__c varchar(6) YES
Migration_Company__c varchar(0) YES
Import2_ID_Account__c varchar(18) YES
AM_Last_Account_Review__c datetime(6) YES
texcellency__DefHC_AffiliationsGPO__c text YES
texcellency__DefHC_AvgDailyCensus__c double YES
texcellency__DefHC_AvgLengthOfStay__c double YES
texcellency__DefHC_CashOnHand__c double YES
texcellency__DefHC_DateCreated__c datetime(6) YES
texcellency__DefHC_DaysCashOnHand__c double YES
texcellency__DefHC_EMR_Vendor_Ambulatory__c varchar(98) YES
texcellency__DefHC_EMR_Vendor_Inpatient__c varchar(112) YES
texcellency__DefHC_FinancialDataDate__c datetime(6) YES
texcellency__DefHC_FirmType__c varchar(13) YES
texcellency__DefHC_HIEAffiliations__c text YES
texcellency__DefHC_HQCity__c varchar(22) YES
texcellency__DefHC_HospitalID__c double YES
texcellency__DefHC_Hospital_Name__c varchar(150) YES
texcellency__DefHC_Hospital_Profile__c varchar(39) YES
texcellency__DefHC_Hospital_Type__c varchar(30) YES
texcellency__DefHC_MeaningfulUseStatus__c varchar(49) YES
texcellency__DefHC_MedicareProviderNumber__c varchar(17) YES
texcellency__DefHC_NetMedicareRevenue__c double YES
texcellency__DefHC_NetPatientRev__c double YES
texcellency__DefHC_NetworkID__c double YES
texcellency__DefHC_Network_Name__c varchar(130) YES
texcellency__DefHC_NumAffiliatedPhysicians__c double YES
texcellency__DefHC_NumBeds__c double YES
texcellency__DefHC_NumDischarges__c double YES
texcellency__DefHC_NumEmployees__c double YES
texcellency__DefHC_NumHospitalsInNetwork__c double YES
texcellency__DefHC_NumMedicareBeds__c double YES
texcellency__DefHC_NumOperatingRooms__c double YES
texcellency__DefHC_OperatingIncome__c double YES
texcellency__DefHC_OptOutofSync__c tinyint(1) YES
texcellency__DefHC_OwnershipStatus__c varchar(32) YES
texcellency__DefHC_Parent_NetworkID__c double YES
texcellency__DefHC_Parent_Network_Name__c varchar(139) YES
texcellency__DefHC_PayorMixPctMedicaid__c double YES
texcellency__DefHC_PayorMixPctMedicare__c double YES
texcellency__DefHC_PayorMixPctPrivateSelf__c double YES
texcellency__DefHC_Phone__c varchar(14) YES
texcellency__DefHC_State__c varchar(11) YES
texcellency__DefHC_SyncTime__c datetime(6) YES
texcellency__DefHC_TotalMedicareCharges__c double YES
texcellency__DefHC_Website__c varchar(187) YES
texcellency__DefHC_ZipCode__c varchar(5) YES
Current_PIH_Products__c varchar(88) YES
Date_of_SAL__c datetime(6) YES
Date_of_SQL__c datetime(6) YES
Date_of_MQL__c datetime(6) YES
Actively_Participating__c tinyint(1) YES
DQL_Reason__c varchar(26) YES
Lead_Qualification_Owner__c varchar(18) YES
Participation_Requirement__c varchar(24) YES
Advanced_APM__c tinyint(1) YES
X2019_2017_PY_Adjustment__c varchar(0) YES
MIPS_APM__c tinyint(1) YES
MIPS_Next_Steps__c text YES
Hospital_Owned_or_Independent__c varchar(14) YES
APM_Details__c varchar(138) YES
Current_List_Import__c varchar(0) YES
UserIQ_Account_Last_Active__c datetime(6) YES
dupcheck__dc3DisableDuplicateCheck__c tinyint(1) YES
dupcheck__dc3Index__c varchar(0) YES
CMS_Programs_Addl_Notes__c varchar(177) YES
UserIQ_Account_Avg_Acti_Per_Session__c double YES
Medicaid_MU_Participation__c varchar(0) YES
Date_of_DQL__c datetime(6) YES
UserIQ_Account_Avg_Time_Per_Session__c double YES
X2017_MIPS_Attestation_Status__c varchar(30) YES
UserIQ_Account_Active_Users__c double YES
QPP_Support_Client__c varchar(3) YES
Clearinghouse__c varchar(17) YES
UserIQ_Account_Percent_Active_Users__c double YES
UserIQ_Account_Inactive_Users__c double YES
UserIQ_Account_Actions_By_Day__c double YES
UserIQ_Account_Actions_By_Week__c double YES
UserIQ_Account_Actions_By_Month__c double YES
UserIQ_Account_Activity_Trend_Week__c varchar(46) YES
UserIQ_Account_Activity_Trend_Month__c varchar(182) YES
UserIQ_Account_NPS_Composite__c double YES
UserIQ_Account_NPS_Responses__c double YES
UserIQ_Account_NPS_Completion__c double YES
UserIQ_Account_NPS_Promoters__c double YES
UserIQ_Account_NPS_Passives__c double YES
UserIQ_Account_NPS_Detractors__c double YES
UserIQ_Account_Link__c varchar(49) YES
UserIQ_Account_IQ_Overall_Score__c double YES
UserIQ_Account_Segments__c varchar(26) YES
Primary_Specialty__c varchar(36) YES
OwnerID__c varchar(15) YES
UserIQ_Account_Last_Synced_Outbound__c datetime(6) YES
Myrna_Main_Product__c varchar(4) YES
Client_ID_Text__c varchar(6) YES
Client_Age_years__c double YES
Account_Tier_Calculated__c varchar(6) YES
AM_Rating__c varchar(31) YES
AM_Rating_Timestamp__c datetime(6) YES
Box_Link__c varchar(51) YES
Count__c double YES
VAR_Partner_Projected_Revenue_Total__c double YES
engagio__EngagedPeople__c double YES
engagio__EngagementMinutesLast3Months__c double YES
engagio__EngagementMinutesLast7Days__c double YES
engagio__FirstEngagementDate__c datetime(6) YES
engagio__MQADate__c datetime(6) YES
engagio__NumberOfPeople__c double YES
engagio__Status__c varchar(16) YES
engagio__WebVisitsLast3Months__c double YES
Account_ID_Long__c varchar(18) YES

References

Local Column References
master_id
TableColumn
HSPI_Bastrop.charge_master_codescharge_master_id
HSPI_CURES2015_B1.charge_master_codescharge_master_id
HSPI_Central_Hospital.charge_master_codescharge_master_id
HSPI_Dewitt.charge_master_codescharge_master_id
HSPI_Fulton.charge_master_codescharge_master_id
HSPI_Inferno.charge_master_codescharge_master_id
HSPI_MU2015_E1.charge_master_codescharge_master_id
HSPI_MU2015_G2.charge_master_codescharge_master_id
HSPI_MU2015_G9.charge_master_codescharge_master_id
HSPI_Ness.charge_master_codescharge_master_id
HSPI_Sandbox.charge_master_codescharge_master_id
HSPI_Summit_General.charge_master_codescharge_master_id
HSPI_United_Physicians.charge_master_codescharge_master_id
MPI.charge_master_codescharge_master_id
Description
TableColumn
aurora_standard.v_pa_invoice_entriesInvoice_Description
aurora_standard.v_pa_journal_entriesOriginal_Journal_Description
aurora_standard.v_pa_journal_entriesDocument_Description
Name
TableColumn
aurora_standard.v_pa_invoice_entriesPayto_Name
aurora_standard.v_pa_journal_entriesFacility_Name
aurora_standard.v_pa_journal_entriesAccount_Name
Phone
TableColumn
aurora_standard.v_pa_invoice_entriesPayto_Phone
Type
TableColumn
aurora_standard.v_pa_journal_entriesPosting_Type
Lead_Source__c
TableColumn
rcmroi.dev__sobj_AccountSpecific_Lead_Source__c
rcmroi.dev__sobj_ContactSpecific_Lead_Source__c
rcmroi.dev__sobj_LeadLMD_Lead_Source__c
rcmroi.dev__sobj_LeadSpecific_Lead_Source__c
rcmroi.prod__sobj_AccountSpecific_Lead_Source__c
rcmroi.prod__sobj_ContactSpecific_Lead_Source__c
rcmroi.prod__sobj_LeadLMD_Lead_Source__c
rcmroi.prod__sobj_LeadSpecific_Lead_Source__c
rcmroi.test__sobj_ContactSpecific_Lead_Source__c
rcmroi.test__sobj_LeadLMD_Lead_Source__c
rcmroi.test__sobj_LeadSpecific_Lead_Source__c
Go_Live_Date__c
TableColumn
rcmroi.dev__sobj_AccountActual_Go_Live_Date__c
rcmroi.prod__sobj_AccountActual_Go_Live_Date__c
OwnerID__c
TableColumn
rcmroi.dev__sobj_AccountsMD_OwnerID__c
rcmroi.prod__sobj_AccountsMD_OwnerID__c
Renewal_Date__c
TableColumn
rcmroi.dev__sobj_AccountContract_Renewal_Date__c
rcmroi.prod__sobj_AccountContract_Renewal_Date__c
Contract_Execution_Date__c
TableColumn
rcmroi.dev__sobj_AccountOriginal_Contract_Execution_Date__c
rcmroi.prod__sobj_AccountOriginal_Contract_Execution_Date__c
Count__c
TableColumn
rcmroi.dev__sobj_AccountLicensed_Bed_Count__c
rcmroi.prod__sobj_AccountLicensed_Bed_Count__c
Monthly_Revenue__c
TableColumn
rcmroi.dev__sobj_AccountNet_Monthly_Revenue__c
rcmroi.prod__sobj_AccountNet_Monthly_Revenue__c
Edition__c
TableColumn
rcmroi.dev__sobj_ContactiPad_Account_Edition__c
rcmroi.prod__sobj_ContactiPad_Account_Edition__c
rcmroi.test__sobj_ContactiPad_Account_Edition__c
Administrator__c
TableColumn
rcmroi.dev__sobj_ContactPractice_Administrator__c
rcmroi.prod__sobj_ContactPractice_Administrator__c
rcmroi.test__sobj_ContactPractice_Administrator__c
AM_Main_Contact__c
TableColumn
rcmroi.dev__sobj_ContactParent_Account_AM_Main_Contact__c
rcmroi.prod__sobj_ContactParent_Account_AM_Main_Contact__c
rcmroi.test__sobj_ContactParent_Account_AM_Main_Contact__c
Annual_Revenue__c
TableColumn
rcmroi.dev__sobj_Leadengagio__Matched_Account_Annual_Revenue__c
rcmroi.prod__sobj_Leadengagio__Matched_Account_Annual_Revenue__c
rcmroi.test__sobj_Leadengagio__Matched_Account_Annual_Revenue__c
Account_Type__c
TableColumn
rcmroi.dev__sobj_Leadengagio__Matched_Account_Type__c
rcmroi.prod__sobj_Leadengagio__Matched_Account_Type__c
rcmroi.test__sobj_Leadengagio__Matched_Account_Type__c