AccountHistory

-1 rows


Description

Labels: Account History | Account History

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id id 18 null

Label: Account History ID

IsDeleted boolean 0 null

Label: Deleted

AccountId reference 18 null
Account.Id FakeFK196C

Label: Account ID
Referenced: Histories (cascade delete)

CreatedById reference 18 null

Label: Created By ID

CreatedDate datetime 0 null

Label: Created Date

Field picklist 255 null

Label: Changed Field
Picklist: Beds__c | Departments__c | PTLA_Account_Category__c | accountMerged | Name | TextName | AccountNumber | Owner | RecordType | Site | AccountSource | PTLA_Account_Status__c | Account_Type__c | PTLA_Advanced_primary_stroke_Center__c | PTLA_Advisory_Board__c | PTLA_Advisory_Board_Flag__c | PTLA_Advisory_Board_Specify__c | PTLA_Andexxa_Advocacy_Level__c | AHA__c | P_Alternate_Email__c | PTLA_Alternate_Name__c | NET_AMA_Do_Not_Contact__c | PTLA_Andexanet_Speaker__c | PTLA_Andexanet_Speaker_Flag__c | PTLA_Andexxa_Authorization_Date__c | PTLA_Authorized_to_Purchase__c | PTLA_Interest_In_buying_Andexxa__c | PTLA_Andexxa_KOL_Mapping_Project__c | AndexXa_Launch__c | Andexxanet_Dossier_Sent__c | PTLA_Andexxa_Order_Report_Opt_Out__c | PTLA_Andexxa_Status__c | Andexxa_HCO_Target__c | PTLA_ANNEXA_4_Investigator__c | PTLA_ANNEXA_I_Investigator__c | PTLA_Annual_Discharge__c | AnnualRevenue | PTLA_AC_R_Author__c | PTLA_AC_RP_Speaker__c | PTLA_APEX_Investigator__c | P_Approved_Email_Status__c | PersonAssistantName | PersonAssistantPhone | PTLA_ATS_Trauma_Level_2017__c | Average_Order_Time_Days__c | Dossier_Sent__c | PTLA_Betrixaban_Speaker__c | PTLA_Betrixaban_Speaker_Flag__c | Betrixiban_Target__c | PTLA_Bevyxxa_KOL_Mapping_Project__c | BillingAddress | BillingCity | BillingCountry | BillingGeocodeAccuracy | BillingLatitude | BillingLongitude | BillingState | BillingStreet | BillingPostalCode | PersonBirthdate | PTLA_Bleed_Discharges_2014__c | PTLA_BRAVO_Investigator__c | PTLA_Campaign_Summary__c | PTLA_CMS_Certification__c | P_Comprehensive_Stroke_Center__c | PTLA_Comprehensive_Stroke_Center_2018__c | PTLA_Conference_Congress_Attendee__c | pharmalite__Consent_Last_Modified_By__c | pharmalite__Consent_Last_Modified_Date__c | pharmalite__Consent_Method__c | pharmalite__Consent_Options__c | PTLA_Consignment_Eligible__c | PTLA_Consignment_End_Date__c | PTLA_Consignment_On_Site__c | PTLA_Consignment_Start_Date__c | PTLA_ComOps_Country__c | created | accountCreatedFromLead | Credentials__c | Current_Qtr_Area__c | Current_QTR_Region__c | Current_Qtr_Territory__c | Jigsaw | PTLA_DCR_New_Account__c | PTLA_DCR_Notes__c | PTLA_DCR_Sync_Status__c | PTLA_DCR_Sync_Status_Details__c | Decile__c | PersonDepartment | PTLA_Andexxa_Department__c | Description | PersonDoNotCall | gsdm__Email__c | PersonEmail | pharmalite__Email__c | PersonEmailBouncedDate | PersonEmailBouncedReason | PersonHasOptedOutOfEmail | NumberOfEmployees | IsExcludedFromRealign | PTLA_Expected_Frequency_of_Contact__c | PTLA_External_Id__c | Fax | PersonHasOptedOutOfFax | feedEvent | FirstName | Focus_Account__c | PTLA_FOP__c | PTLA_Formulary_Account__c | P_Global_KOL__c | PTLA_Guideline_Committee_Member__c | PTLA_Guideline_Committee_Member_specify__c | PTLA_HCO_HQ_Email_Opt_Out__c | HCO_Type__c | HCP_Type__c | HIN__c | HMO__c | PersonHomePhone | IDN_Name__c | IDN__c | IDN_Parent_Name__c | IDN_Parent__c | PTLA_IIS_Investigator__c | PersonIndividual | individualMerged | Industry | Is_Formulary_Sponsor__c | PTLA_Is_Focus_HCP__c | PTLA_Is_Quarterly_Full_Account__c | PTLA_ISR_Investigator__c | PTLA_Last_Call_Date__c | LastName | PTLA_Andexxa_Latest_Speaker_Attendance__c | accountUpdatedByLead | personAccountUpdatedByLead | PersonLeadSource | Legacy_SFDC_Id__c | Legacy_SFDC_JSON__c | Legacy_Network_External_Id__c | PTLA_LexisNexis_Specialty__c | PTLA_Local_KOL__c | PTLA_Lockwood_Tier_1_Project__c | PersonMailingAddress | PersonMailingCity | PersonMailingCountry | PersonMailingGeocodeAccuracy | PersonMailingLatitude | PersonMailingLongitude | PersonMailingState | PersonMailingStreet | PersonMailingPostalCode | PTLA_Mariner_PI__c | ME__c | PTLA_Medical_Degree__c | PTLA_Medical_Degree_2__c | MiddleName | PersonMobilePhone | PTLA_App_Account__c | PTLA_MSL_Project__c | PTLA_MSL_Territory__c | P_National_KOL__c | PTLA_Sales_Key_Opinion_Leader__c | PTLA_A_Next_Appointment_Date__c | PTLA_No_Limited_Access__c | PTLA_No_Access__c | PTLA_No_Access_without_Contract__c | PTLA_Non_Affiliated__c | NPI__c | PTLA_Other__c | PersonOtherAddress | PersonOtherCity | PersonOtherCountry | PersonOtherGeocodeAccuracy | PersonOtherLatitude | PersonOtherLongitude | PersonOtherPhone | PersonOtherState | PersonOtherStreet | PersonOtherPostalCode | P_Overall_potential__c | ownerAccepted | ownerAssignment | Ownership | Parent | PDRP_Opt_Out__c | PDRP_Opt_Out_Date__c | Phone | PTLA_Place_of_Employment__c | P_Primary_Address_line1__c | P_Primary_Address_line2__c | P_Primary_City__c | PTLA_Primary_DEA__c | PTLA_Primary_GPO_Name__c | PTLA_Primary_GPO__c | pharmalite__Primary_Parent__c | pharmalite__Specialty_1__c | PTLA_Specialty_1__c | Specialty_1__c | P_Primary_State__c | Primary_Zip__c | P_Priority_HCP_Betrixiban__c | P_Priority_Institution__c | PTLA_Profiles__c | PTLA_MDM_Id__c | PTLA_MDM_URI__c | PTLA_Medical_Degree_3__c | Rating | PTLA_Readmission_Rate__c | locked | unlocked | Regional_Strategy__c | PTLA_Andexxa_Role_in_ADX__c | PTLA_Territory__c | Salutation | PTLA_Specialty_2__c | Specialty_2__c | PTLA_Segment__c | ShippingAddress | ShippingCity | ShippingCountry | ShippingGeocodeAccuracy | ShippingLatitude | ShippingLongitude | ShippingState | ShippingStreet | ShippingPostalCode | Sic | SicDesc | PTLA_Society_Leadership__c | PTLA_Society_Leadership_Specify__c | Speaker__c | PTLA_Specialty_Distributor__c | PTLA_Primary_State__c | PTLA_Steeprock_KOL__c | Suffix | TickerSymbol | Tier__c | PersonTitle | Top_150_Andexxanet__c | PTLA_Total_Calls__c | P_Trauma_Center_Tier__c | Type | PTLA_Type_of_Practice__c | Use_Primary_Address__c | Website

OldValue anyType 255 null

Label: Old Value

NewValue anyType 255 null

Label: New Value

Indexes

Constraint Name Type Sort Column(s)
FakeIndex8 Must be unique Asc Id

Relationships