rcmroi.prod__sobj_RCM_Analysis__c

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
OwnerId varchar(18) YES
IsDeleted tinyint(1) YES
Name varchar(45) YES
CreatedDate datetime(6) YES
CreatedById varchar(18) YES
LastModifiedDate datetime(6) YES
LastModifiedById varchar(18) YES
SystemModstamp datetime(6) YES
LastViewedDate datetime(6) YES
LastReferencedDate datetime(6) YES
ConnectionReceivedId varchar(0) YES
ConnectionSentId varchar(0) YES
practice_name__c varchar(32) YES
master_guid__c varchar(36) YES
specialty__c varchar(12) YES
num_billing_staff__c double YES
num_phys__c double YES
monthly_claim_volume__c double YES
annual_gross_collections__c double YES
avg_billing_staff_salary__c double YES
avg_billing_staff_fica__c double YES
avg_billing_staff_healthcare__c double YES
overhead__c double YES
software_rcm_fees__c double YES
azalea_collections_improvement__c double YES
azalea_rcm_rate__c double YES
sobj_Lead__c varchar(18) YES
first_name__c varchar(7) YES
last_name__c varchar(7) YES
email__c varchar(35) YES
zip__c double YES
sobj_Account__c varchar(18) YES
sobj_Contact__c varchar(18) YES
RCM_ROI_Analysis_Page__c varchar(211) 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
Name
TableColumn
aurora_standard.v_pa_invoice_entriesPayto_Name
aurora_standard.v_pa_journal_entriesFacility_Name
aurora_standard.v_pa_journal_entriesAccount_Name