Coro Deployment
Overview of data fields
Overview of data fields
Coro data is stored in two locations:
-
Customer’s CRM database and
-
Coro’s private database
The customer’s CRM is the master repository for all data -- if the customer chooses to terminate its contract with Coro, the customer will retain a complete copy of all account plan information in the customer’s CRM database, as of the date of contract termination. A select set of data fields are not available in the CRM database, as they are explicitly related to operating the Coro application (notifications, comments, global settings, EULA). The chart below summarizes the information available in each database
Coro retains a full copy of the database to ensure the proper functionality of the application. Coro safeguards this data in line with the standards expected of Bain & Company by its clients. See Security details for summary of Coro’s security policies and procedures.
|
Data fields stored in |
Data fields stored exclusively in Coro’s database |
|---|---|
|
Accounts |
Comments |
|
Users |
Notifications |
|
Account plan - Ambition |
Global settings |
|
Account plan - Insights |
EULA |
|
Account plan - Share of wallet |
|
|
Account plan - Sales plays |
|
|
Account plan - Relationship plays |
|
|
Account plan - Opportunities |
|
|
Account plan - Contacts |
|
Data fields stored inside CRM and Coro
Data fields stored inside CRM and Coro
|
Elements |
Data Type |
|
|
_hcmeta |
id |
integer |
|
_hcmeta |
hcver |
integer |
|
_hcmeta |
org_id |
character varying |
|
_hcmeta |
details |
text |
|
_sf_event_log |
id |
integer |
|
_sf_event_log |
table_name |
character varying |
|
_sf_event_log |
action |
character varying |
|
_sf_event_log |
synced_at |
timestamp with time zone |
|
_sf_event_log |
sf_timestamp |
timestamp with time zone |
|
_sf_event_log |
sfid |
character varying |
|
_sf_event_log |
record |
text |
|
_sf_event_log |
processed |
boolean |
|
_trigger_log |
id |
integer |
|
_trigger_log |
txid |
bigint |
|
_trigger_log |
created_at |
timestamp with time zone |
|
_trigger_log |
updated_at |
timestamp with time zone |
|
_trigger_log |
processed_at |
timestamp with time zone |
|
_trigger_log |
processed_tx |
bigint |
|
_trigger_log |
state |
character varying |
|
_trigger_log |
action |
character varying |
|
_trigger_log |
table_name |
character varying |
|
_trigger_log |
record_id |
integer |
|
_trigger_log |
sfid |
character varying |
|
_trigger_log |
old |
text |
|
_trigger_log |
values |
text |
|
_trigger_log |
sf_result |
integer |
|
_trigger_log |
sf_message |
text |
|
_trigger_log_archive |
id |
integer |
|
_trigger_log_archive |
txid |
bigint |
|
_trigger_log_archive |
created_at |
timestamp with time zone |
|
_trigger_log_archive |
updated_at |
timestamp with time zone |
|
_trigger_log_archive |
processed_at |
timestamp with time zone |
|
_trigger_log_archive |
processed_tx |
bigint |
|
_trigger_log_archive |
state |
character varying |
|
_trigger_log_archive |
action |
character varying |
|
_trigger_log_archive |
table_name |
character varying |
|
_trigger_log_archive |
record_id |
integer |
|
_trigger_log_archive |
sfid |
character varying |
|
_trigger_log_archive |
old |
text |
|
_trigger_log_archive |
values |
text |
|
_trigger_log_archive |
sf_result |
integer |
|
_trigger_log_archive |
sf_message |
text |
|
account |
parentid |
character varying |
|
account |
coro__pg_id__c |
character varying |
|
account |
name |
character varying |
|
account |
lastmodifieddate |
timestamp without time zone |
|
account |
phone |
character varying |
|
account |
ownerid |
character varying |
|
account |
isdeleted |
boolean |
|
account |
systemmodstamp |
timestamp without time zone |
|
account |
lastmodifiedbyid |
character varying |
|
account |
createddate |
timestamp without time zone |
|
account |
createdbyid |
character varying |
|
account |
type |
character varying |
|
account |
website |
character varying |
|
account |
industry |
character varying |
|
account |
sfid |
character varying |
|
account |
id |
integer |
|
account |
_hc_lastop |
character varying |
|
account |
_hc_err |
text |
|
accountcontactrelation |
accountid |
character varying |
|
accountcontactrelation |
enddate |
date |
|
accountcontactrelation |
lastmodifieddate |
timestamp without time zone |
|
accountcontactrelation |
isdeleted |
boolean |
|
accountcontactrelation |
systemmodstamp |
timestamp without time zone |
|
accountcontactrelation |
startdate |
date |
|
accountcontactrelation |
lastmodifiedbyid |
character varying |
|
accountcontactrelation |
createddate |
timestamp without time zone |
|
accountcontactrelation |
createdbyid |
character varying |
|
accountcontactrelation |
contactid |
character varying |
|
accountcontactrelation |
roles |
character varying |
|
accountcontactrelation |
sfid |
character varying |
|
accountcontactrelation |
id |
integer |
|
accountcontactrelation |
_hc_lastop |
character varying |
|
accountcontactrelation |
_hc_err |
text |
|
accountteammember |
userid |
character varying |
|
accountteammember |
accountid |
character varying |
|
accountteammember |
teammemberrole |
character varying |
|
accountteammember |
lastmodifieddate |
timestamp without time zone |
|
accountteammember |
isdeleted |
boolean |
|
accountteammember |
systemmodstamp |
timestamp without time zone |
|
accountteammember |
lastmodifiedbyid |
character varying |
|
accountteammember |
accountaccesslevel |
character varying |
|
accountteammember |
createddate |
timestamp without time zone |
|
accountteammember |
title |
character varying |
|
accountteammember |
sfid |
character varying |
|
accountteammember |
id |
integer |
|
accountteammember |
_hc_lastop |
character varying |
|
accountteammember |
_hc_err |
text |
|
contact |
lastname |
character varying |
|
contact |
accountid |
character varying |
|
contact |
coro__pgid__c |
character varying |
|
contact |
name |
character varying |
|
contact |
lastmodifieddate |
timestamp without time zone |
|
contact |
phone |
character varying |
|
contact |
isdeleted |
boolean |
|
contact |
systemmodstamp |
timestamp without time zone |
|
contact |
lastmodifiedbyid |
character varying |
|
contact |
createddate |
timestamp without time zone |
|
contact |
title |
character varying |
|
contact |
createdbyid |
character varying |
|
contact |
firstname |
character varying |
|
contact |
|
character varying |
|
contact |
sfid |
character varying |
|
contact |
id |
integer |
|
contact |
_hc_lastop |
character varying |
|
contact |
_hc_err |
text |
|
coro__account_plan__c |
coro__customer_satisfaction_score__c |
double precision |
|
coro__account_plan__c |
coro__primary_sales_manager__c |
character varying |
|
coro__account_plan__c |
coro__last_updated_date__c |
timestamp without time zone |
|
coro__account_plan__c |
coro__deleted_at__c |
timestamp without time zone |
|
coro__account_plan__c |
name |
character varying |
|
coro__account_plan__c |
coro__kick_off_date__c |
date |
|
coro__account_plan__c |
lastmodifieddate |
timestamp without time zone |
|
coro__account_plan__c |
ownerid |
character varying |
|
coro__account_plan__c |
coro__region__c |
character varying |
|
coro__account_plan__c |
isdeleted |
boolean |
|
coro__account_plan__c |
systemmodstamp |
timestamp without time zone |
|
coro__account_plan__c |
lastmodifiedbyid |
character varying |
|
coro__account_plan__c |
coro__pgid__c |
character varying |
|
coro__account_plan__c |
coro__status__c |
character varying |
|
coro__account_plan__c |
coro__primary_sales_rep__c |
character varying |
|
coro__account_plan__c |
createddate |
timestamp without time zone |
|
coro__account_plan__c |
coro__account__c |
character varying |
|
coro__account_plan__c |
createdbyid |
character varying |
|
coro__account_plan__c |
coro__priority_level__c |
double precision |
|
coro__account_plan__c |
coro__next_review_date__c |
date |
|
coro__account_plan__c |
coro__isinreview__c |
boolean |
|
coro__account_plan__c |
sfid |
character varying |
|
coro__account_plan__c |
id |
integer |
|
coro__account_plan__c |
_hc_lastop |
character varying |
|
coro__account_plan__c |
_hc_err |
text |
|
coro__account_plan__c |
coro__account__r__coro__pg_id__c |
character varying |
|
coro__account_plan_product_category__c |
coro__pgid__c |
character varying |
|
coro__account_plan_product_category__c |
name |
character varying |
|
coro__account_plan_product_category__c |
coro__product_category__c |
character varying |
|
coro__account_plan_product_category__c |
coro__product_category__r__coro__pgid__c |
character varying |
|
coro__account_plan_product_category__c |
lastmodifieddate |
timestamp without time zone |
|
coro__account_plan_product_category__c |
isdeleted |
boolean |
|
coro__account_plan_product_category__c |
coro__description__c |
text |
|
coro__account_plan_product_category__c |
systemmodstamp |
timestamp without time zone |
|
coro__account_plan_product_category__c |
lastmodifiedbyid |
character varying |
|
coro__account_plan_product_category__c |
createddate |
timestamp without time zone |
|
coro__account_plan_product_category__c |
coro__updatedby__c |
character varying |
|
coro__account_plan_product_category__c |
createdbyid |
character varying |
|
coro__account_plan_product_category__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__account_plan_product_category__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__account_plan_product_category__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__account_plan_product_category__c |
coro__account_plan__c |
character varying |
|
coro__account_plan_product_category__c |
sfid |
character varying |
|
coro__account_plan_product_category__c |
id |
integer |
|
coro__account_plan_product_category__c |
_hc_lastop |
character varying |
|
coro__account_plan_product_category__c |
_hc_err |
text |
|
coro__ambition__c |
coro__pgid__c |
character varying |
|
coro__ambition__c |
name |
character varying |
|
coro__ambition__c |
lastmodifieddate |
timestamp without time zone |
|
coro__ambition__c |
ownerid |
character varying |
|
coro__ambition__c |
isdeleted |
boolean |
|
coro__ambition__c |
systemmodstamp |
timestamp without time zone |
|
coro__ambition__c |
coro__customfieldupdatedby__c |
character varying |
|
coro__ambition__c |
lastmodifiedbyid |
character varying |
|
coro__ambition__c |
coro__objectivesupdatedby__c |
character varying |
|
coro__ambition__c |
coro__question__c |
character varying |
|
coro__ambition__c |
coro__healthcheckupdatedby__c |
character varying |
|
coro__ambition__c |
coro__customfieldupdatedat__c |
timestamp without time zone |
|
coro__ambition__c |
createddate |
timestamp without time zone |
|
coro__ambition__c |
coro__healthcheckupdatedat__c |
timestamp without time zone |
|
coro__ambition__c |
coro__strength_of_relationship__c |
double precision |
|
coro__ambition__c |
coro__objectivesupdatedat__c |
timestamp without time zone |
|
coro__ambition__c |
createdbyid |
character varying |
|
coro__ambition__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__ambition__c |
coro__answer__c |
character varying |
|
coro__ambition__c |
coro__statement__c |
character varying |
|
coro__ambition__c |
coro__state_description__c |
character varying |
|
coro__ambition__c |
coro__account_plan__c |
character varying |
|
coro__ambition__c |
sfid |
character varying |
|
coro__ambition__c |
id |
integer |
|
coro__ambition__c |
_hc_lastop |
character varying |
|
coro__ambition__c |
_hc_err |
text |
|
coro__category__c |
coro__parent_category__r__coro__pgid__c |
character varying |
|
coro__category__c |
coro__pgid__c |
character varying |
|
coro__category__c |
name |
character varying |
|
coro__category__c |
lastmodifieddate |
timestamp without time zone |
|
coro__category__c |
ownerid |
character varying |
|
coro__category__c |
isdeleted |
boolean |
|
coro__category__c |
systemmodstamp |
timestamp without time zone |
|
coro__category__c |
lastmodifiedbyid |
character varying |
|
coro__category__c |
createddate |
timestamp without time zone |
|
coro__category__c |
coro__parent_category__c |
character varying |
|
coro__category__c |
coro__updatedby__c |
character varying |
|
coro__category__c |
createdbyid |
character varying |
|
coro__category__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__category__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__category__c |
sfid |
character varying |
|
coro__category__c |
id |
integer |
|
coro__category__c |
_hc_lastop |
character varying |
|
coro__category__c |
_hc_err |
text |
|
coro__category__c |
coro__version__c |
double precision |
|
coro__competitor__c |
coro__added_by__c |
character varying |
|
coro__competitor__c |
coro__pgid__c |
character varying |
|
coro__competitor__c |
name |
character varying |
|
coro__competitor__c |
lastmodifieddate |
timestamp without time zone |
|
coro__competitor__c |
ownerid |
character varying |
|
coro__competitor__c |
isdeleted |
boolean |
|
coro__competitor__c |
systemmodstamp |
timestamp without time zone |
|
coro__competitor__c |
lastmodifiedbyid |
character varying |
|
coro__competitor__c |
createddate |
timestamp without time zone |
|
coro__competitor__c |
coro__updatedby__c |
character varying |
|
coro__competitor__c |
createdbyid |
character varying |
|
coro__competitor__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__competitor__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__competitor__c |
sfid |
character varying |
|
coro__competitor__c |
id |
integer |
|
coro__competitor__c |
_hc_lastop |
character varying |
|
coro__competitor__c |
_hc_err |
text |
|
coro__competitor_landscape__c |
coro__penetration__c |
character varying |
|
coro__competitor_landscape__c |
coro__pgid__c |
character varying |
|
coro__competitor_landscape__c |
coro__competitor__r__coro__pgid__c |
character varying |
|
coro__competitor_landscape__c |
name |
character varying |
|
coro__competitor_landscape__c |
coro__product_category__c |
character varying |
|
coro__competitor_landscape__c |
coro__trajectroy__c |
character varying |
|
coro__competitor_landscape__c |
coro__product_category__r__coro__pgid__c |
character varying |
|
coro__competitor_landscape__c |
lastmodifieddate |
timestamp without time zone |
|
coro__competitor_landscape__c |
coro__comment__c |
character varying |
|
coro__competitor_landscape__c |
coro__competitor__c |
character varying |
|
coro__competitor_landscape__c |
coro__rank__c |
double precision |
|
coro__competitor_landscape__c |
isdeleted |
boolean |
|
coro__competitor_landscape__c |
systemmodstamp |
timestamp without time zone |
|
coro__competitor_landscape__c |
lastmodifiedbyid |
character varying |
|
coro__competitor_landscape__c |
createddate |
timestamp without time zone |
|
coro__competitor_landscape__c |
coro__updatedby__c |
character varying |
|
coro__competitor_landscape__c |
createdbyid |
character varying |
|
coro__competitor_landscape__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__competitor_landscape__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__competitor_landscape__c |
coro__spent__c |
double precision |
|
coro__competitor_landscape__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__competitor_landscape__c |
coro__account_plan__c |
character varying |
|
coro__competitor_landscape__c |
sfid |
character varying |
|
coro__competitor_landscape__c |
id |
integer |
|
coro__competitor_landscape__c |
_hc_lastop |
character varying |
|
coro__competitor_landscape__c |
_hc_err |
text |
|
coro__financial_goal__c |
recordtypeid |
character varying |
|
coro__financial_goal__c |
coro__pgid__c |
character varying |
|
coro__financial_goal__c |
name |
character varying |
|
coro__financial_goal__c |
lastmodifieddate |
timestamp without time zone |
|
coro__financial_goal__c |
isdeleted |
boolean |
|
coro__financial_goal__c |
systemmodstamp |
timestamp without time zone |
|
coro__financial_goal__c |
lastmodifiedbyid |
character varying |
|
coro__financial_goal__c |
createddate |
timestamp without time zone |
|
coro__financial_goal__c |
coro__updatedby__c |
character varying |
|
coro__financial_goal__c |
createdbyid |
character varying |
|
coro__financial_goal__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__financial_goal__c |
coro__value__c |
double precision |
|
coro__financial_goal__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__financial_goal__c |
coro__category__c |
character varying |
|
coro__financial_goal__c |
coro__category__r__coro__pgid__c |
character varying |
|
coro__financial_goal__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__financial_goal__c |
coro__account_plan__c |
character varying |
|
coro__financial_goal__c |
sfid |
character varying |
|
coro__financial_goal__c |
id |
integer |
|
coro__financial_goal__c |
_hc_lastop |
character varying |
|
coro__financial_goal__c |
_hc_err |
text |
|
coro__financial_historical_value__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__financial_historical_value__c |
coro__category__c |
character varying |
|
coro__financial_historical_value__c |
recordtypeid |
character varying |
|
coro__financial_historical_value__c |
coro__year__c |
double precision |
|
coro__financial_historical_value__c |
coro__account_plan__c |
character varying |
|
coro__financial_historical_value__c |
name |
character varying |
|
coro__financial_historical_value__c |
lastmodifieddate |
timestamp without time zone |
|
coro__financial_historical_value__c |
isdeleted |
boolean |
|
coro__financial_historical_value__c |
systemmodstamp |
timestamp without time zone |
|
coro__financial_historical_value__c |
lastmodifiedbyid |
character varying |
|
coro__financial_historical_value__c |
coro__updatedby__c |
character varying |
|
coro__financial_historical_value__c |
coro__pgid__c |
character varying |
|
coro__financial_historical_value__c |
coro__value__c |
double precision |
|
coro__financial_historical_value__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__financial_historical_value__c |
createddate |
timestamp without time zone |
|
coro__financial_historical_value__c |
createdbyid |
character varying |
|
coro__financial_historical_value__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__financial_historical_value__c |
coro__category__r__coro__pgid__c |
character varying |
|
coro__financial_historical_value__c |
sfid |
character varying |
|
coro__financial_historical_value__c |
id |
integer |
|
coro__financial_historical_value__c |
_hc_lastop |
character varying |
|
coro__financial_historical_value__c |
_hc_err |
text |
|
coro__key_action__c |
coro__assigned_to__c |
character varying |
|
coro__key_action__c |
coro__isclosed__c |
boolean |
|
coro__key_action__c |
recordtypeid |
character varying |
|
coro__key_action__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__key_action__c |
coro__status__c |
character varying |
|
coro__key_action__c |
coro__relationship_play__r__coro__pgid__c |
character varying |
|
coro__key_action__c |
coro__pgid__c |
character varying |
|
coro__key_action__c |
name |
character varying |
|
coro__key_action__c |
coro__closed_date__c |
date |
|
coro__key_action__c |
lastmodifieddate |
timestamp without time zone |
|
coro__key_action__c |
coro__comment__c |
text |
|
coro__key_action__c |
ownerid |
character varying |
|
coro__key_action__c |
isdeleted |
boolean |
|
coro__key_action__c |
coro__description__c |
text |
|
coro__key_action__c |
systemmodstamp |
timestamp without time zone |
|
coro__key_action__c |
coro__target_date__c |
date |
|
coro__key_action__c |
lastmodifiedbyid |
character varying |
|
coro__key_action__c |
coro__relationship_play__c |
character varying |
|
coro__key_action__c |
coro__sales_play__c |
character varying |
|
coro__key_action__c |
createddate |
timestamp without time zone |
|
coro__key_action__c |
coro__updatedby__c |
character varying |
|
coro__key_action__c |
createdbyid |
character varying |
|
coro__key_action__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__key_action__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__key_action__c |
sfid |
character varying |
|
coro__key_action__c |
id |
integer |
|
coro__key_action__c |
_hc_lastop |
character varying |
|
coro__key_action__c |
_hc_err |
text |
|
coro__opportunity_pipeline__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__opportunity_pipeline__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__opportunity_pipeline__c |
coro__description__c |
text |
|
coro__opportunity_pipeline__c |
coro__link__c |
character varying |
|
coro__opportunity_pipeline__c |
name |
character varying |
|
coro__opportunity_pipeline__c |
lastmodifieddate |
timestamp without time zone |
|
coro__opportunity_pipeline__c |
isdeleted |
boolean |
|
coro__opportunity_pipeline__c |
coro__opportunity__c |
character varying |
|
coro__opportunity_pipeline__c |
systemmodstamp |
timestamp without time zone |
|
coro__opportunity_pipeline__c |
lastmodifiedbyid |
character varying |
|
coro__opportunity_pipeline__c |
coro__updatedby__c |
character varying |
|
coro__opportunity_pipeline__c |
coro__pgid__c |
character varying |
|
coro__opportunity_pipeline__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__opportunity_pipeline__c |
createddate |
timestamp without time zone |
|
coro__opportunity_pipeline__c |
createdbyid |
character varying |
|
coro__opportunity_pipeline__c |
coro__sales_play__c |
character varying |
|
coro__opportunity_pipeline__c |
sfid |
character varying |
|
coro__opportunity_pipeline__c |
id |
integer |
|
coro__opportunity_pipeline__c |
_hc_lastop |
character varying |
|
coro__opportunity_pipeline__c |
_hc_err |
text |
|
coro__pillar_required_contact__c |
recordtypeid |
character varying |
|
coro__pillar_required_contact__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__pillar_required_contact__c |
coro__relationship_play__r__coro__pgid__c |
character varying |
|
coro__pillar_required_contact__c |
coro__pgid__c |
character varying |
|
coro__pillar_required_contact__c |
coro__relationship_key_action__r__coro__pgid__c |
character varying |
|
coro__pillar_required_contact__c |
name |
character varying |
|
coro__pillar_required_contact__c |
lastmodifieddate |
timestamp without time zone |
|
coro__pillar_required_contact__c |
ownerid |
character varying |
|
coro__pillar_required_contact__c |
coro__relationship_key_action__c |
character varying |
|
coro__pillar_required_contact__c |
isdeleted |
boolean |
|
coro__pillar_required_contact__c |
systemmodstamp |
timestamp without time zone |
|
coro__pillar_required_contact__c |
lastmodifiedbyid |
character varying |
|
coro__pillar_required_contact__c |
coro__relationship_play__c |
character varying |
|
coro__pillar_required_contact__c |
coro__sales_play__c |
character varying |
|
coro__pillar_required_contact__c |
createddate |
timestamp without time zone |
|
coro__pillar_required_contact__c |
createdbyid |
character varying |
|
coro__pillar_required_contact__c |
sfid |
character varying |
|
coro__pillar_required_contact__c |
id |
integer |
|
coro__pillar_required_contact__c |
_hc_lastop |
character varying |
|
coro__pillar_required_contact__c |
_hc_err |
text |
|
coro__play_required_user__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__play_required_user__c |
recordtypeid |
character varying |
|
coro__play_required_user__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__play_required_user__c |
coro__relationship_play__c |
character varying |
|
coro__play_required_user__c |
name |
character varying |
|
coro__play_required_user__c |
isdeleted |
boolean |
|
coro__play_required_user__c |
systemmodstamp |
timestamp without time zone |
|
coro__play_required_user__c |
coro__updatedby__c |
character varying |
|
coro__play_required_user__c |
coro__pgid__c |
character varying |
|
coro__play_required_user__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__play_required_user__c |
createddate |
timestamp without time zone |
|
coro__play_required_user__c |
coro__user__c |
character varying |
|
coro__play_required_user__c |
coro__relationship_play__r__coro__pgid__c |
character varying |
|
coro__play_required_user__c |
coro__sales_play__c |
character varying |
|
coro__play_required_user__c |
sfid |
character varying |
|
coro__play_required_user__c |
id |
integer |
|
coro__play_required_user__c |
_hc_lastop |
character varying |
|
coro__play_required_user__c |
_hc_err |
text |
|
coro__power_base__c |
id |
integer |
|
coro__power_base__c |
coro__contact__c |
character varying |
|
coro__power_base__c |
coro__type__c |
character varying |
|
coro__power_base__c |
coro__account_plan__c |
character varying |
|
coro__power_base__c |
coro__decision_right__c |
character varying |
|
coro__power_base__c |
coro__powerbaseownerid__c |
character varying |
|
coro__power_base__c |
isdeleted |
boolean |
|
coro__power_base__c |
coro__account__c |
character varying |
|
coro__power_base__c |
coro__priority_level__c |
character varying |
|
coro__power_base__c |
coro__priority_topics__c |
character varying |
|
coro__power_base__c |
sfid |
character varying |
|
coro__power_base__c |
coro__pgid__c |
character varying |
|
coro__power_base__c |
coro__updatedat__c |
timestamp with time zone |
|
coro__power_base__c |
coro__updatedby__c |
character varying |
|
coro__relationship_play__c |
id |
integer |
|
coro__relationship_play__c |
coro__completed_date__c |
timestamp with time zone |
|
coro__relationship_play__c |
coro__iscompleted__c |
boolean |
|
coro__relationship_play__c |
coro__contact__c |
character varying |
|
coro__relationship_play__c |
coro__target_date__c |
timestamp with time zone |
|
coro__relationship_play__c |
coro__description__c |
text |
|
coro__relationship_play__c |
coro__account_plan__c |
character varying |
|
coro__relationship_play__c |
name |
character varying |
|
coro__relationship_play__c |
createddate |
timestamp with time zone |
|
coro__relationship_play__c |
sfid |
character varying |
|
coro__relationship_play__c |
coro__pgid__c |
character varying |
|
coro__relationship_play__c |
coro__updatedat__c |
timestamp with time zone |
|
coro__relationship_play__c |
coro__updatedby__c |
character varying |
|
coro__relationship_play__c |
coro__contact__r__coro__pgid__c |
character varying |
|
coro__relationship_play__c |
lastmodifieddate |
timestamp without time zone |
|
coro__relationship_play__c |
ownerid |
character varying |
|
coro__relationship_play__c |
isdeleted |
boolean |
|
coro__relationship_play__c |
systemmodstamp |
timestamp without time zone |
|
coro__relationship_play__c |
lastmodifiedbyid |
character varying |
|
coro__relationship_play__c |
createdbyid |
character varying |
|
coro__relationship_play__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__relationship_play__c |
coro__cadence__c |
character varying |
|
coro__relationship_play__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__relationship_play__c |
_hc_lastop |
character varying |
|
coro__relationship_play__c |
_hc_err |
text |
|
coro__sales_play__c |
coro__iscompletedsuccess__c |
boolean |
|
coro__sales_play__c |
coro__closed_date__c |
date |
|
coro__sales_play__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__sales_play__c |
coro__target_date__c |
date |
|
coro__sales_play__c |
coro__description__c |
character varying |
|
coro__sales_play__c |
coro__account_plan__c |
character varying |
|
coro__sales_play__c |
coro__amount__c |
double precision |
|
coro__sales_play__c |
name |
character varying |
|
coro__sales_play__c |
coro__rationale__c |
character varying |
|
coro__sales_play__c |
coro__isclosed__c |
boolean |
|
coro__sales_play__c |
lastmodifieddate |
timestamp without time zone |
|
coro__sales_play__c |
ownerid |
character varying |
|
coro__sales_play__c |
isdeleted |
boolean |
|
coro__sales_play__c |
systemmodstamp |
timestamp without time zone |
|
coro__sales_play__c |
lastmodifiedbyid |
character varying |
|
coro__sales_play__c |
coro__updatedby__c |
character varying |
|
coro__sales_play__c |
coro__pgid__c |
character varying |
|
coro__sales_play__c |
coro__status__c |
character varying |
|
coro__sales_play__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__sales_play__c |
createddate |
timestamp without time zone |
|
coro__sales_play__c |
createdbyid |
character varying |
|
coro__sales_play__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__sales_play__c |
coro__opportunity_link_date__c |
date |
|
coro__sales_play__c |
coro__must_win__c |
boolean |
|
coro__sales_play__c |
sfid |
character varying |
|
coro__sales_play__c |
id |
integer |
|
coro__sales_play__c |
_hc_lastop |
character varying |
|
coro__sales_play__c |
_hc_err |
text |
|
coro__sales_play_contact__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__sales_play_contact__c |
coro__pgid__c |
character varying |
|
coro__sales_play_contact__c |
name |
character varying |
|
coro__sales_play_contact__c |
coro__contact__c |
character varying |
|
coro__sales_play_contact__c |
coro__contact__r__coro__pgid__c |
character varying |
|
coro__sales_play_contact__c |
lastmodifieddate |
timestamp without time zone |
|
coro__sales_play_contact__c |
isdeleted |
boolean |
|
coro__sales_play_contact__c |
systemmodstamp |
timestamp without time zone |
|
coro__sales_play_contact__c |
lastmodifiedbyid |
character varying |
|
coro__sales_play_contact__c |
coro__sales_play__c |
character varying |
|
coro__sales_play_contact__c |
createddate |
timestamp without time zone |
|
coro__sales_play_contact__c |
createdbyid |
character varying |
|
coro__sales_play_contact__c |
sfid |
character varying |
|
coro__sales_play_contact__c |
id |
integer |
|
coro__sales_play_contact__c |
_hc_lastop |
character varying |
|
coro__sales_play_contact__c |
_hc_err |
text |
|
coro__sales_play_product_category__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__sales_play_product_category__c |
coro__category__c |
character varying |
|
coro__sales_play_product_category__c |
coro__sales_play__r__coro__pgid__c |
character varying |
|
coro__sales_play_product_category__c |
name |
character varying |
|
coro__sales_play_product_category__c |
lastmodifieddate |
timestamp without time zone |
|
coro__sales_play_product_category__c |
isdeleted |
boolean |
|
coro__sales_play_product_category__c |
systemmodstamp |
timestamp without time zone |
|
coro__sales_play_product_category__c |
lastmodifiedbyid |
character varying |
|
coro__sales_play_product_category__c |
coro__updatedby__c |
character varying |
|
coro__sales_play_product_category__c |
coro__pgid__c |
character varying |
|
coro__sales_play_product_category__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__sales_play_product_category__c |
createddate |
timestamp without time zone |
|
coro__sales_play_product_category__c |
createdbyid |
character varying |
|
coro__sales_play_product_category__c |
coro__sales_play__c |
character varying |
|
coro__sales_play_product_category__c |
coro__category__r__coro__pgid__c |
character varying |
|
coro__sales_play_product_category__c |
sfid |
character varying |
|
coro__sales_play_product_category__c |
id |
integer |
|
coro__sales_play_product_category__c |
_hc_lastop |
character varying |
|
coro__sales_play_product_category__c |
_hc_err |
text |
|
coro__share_of_wallet__c |
coro__share_of_wallet__c |
double precision |
|
coro__share_of_wallet__c |
coro__lastupdate__c |
timestamp without time zone |
|
coro__share_of_wallet__c |
coro__category__c |
character varying |
|
coro__share_of_wallet__c |
coro__account_plan__c |
character varying |
|
coro__share_of_wallet__c |
name |
character varying |
|
coro__share_of_wallet__c |
lastmodifieddate |
timestamp without time zone |
|
coro__share_of_wallet__c |
isdeleted |
boolean |
|
coro__share_of_wallet__c |
systemmodstamp |
timestamp without time zone |
|
coro__share_of_wallet__c |
lastmodifiedbyid |
character varying |
|
coro__share_of_wallet__c |
coro__updatedby__c |
character varying |
|
coro__share_of_wallet__c |
coro__pgid__c |
character varying |
|
coro__share_of_wallet__c |
coro__updatedat__c |
timestamp without time zone |
|
coro__share_of_wallet__c |
createddate |
timestamp without time zone |
|
coro__share_of_wallet__c |
createdbyid |
character varying |
|
coro__share_of_wallet__c |
coro__account_plan__r__coro__pgid__c |
character varying |
|
coro__share_of_wallet__c |
coro__category__r__coro__pgid__c |
character varying |
|
coro__share_of_wallet__c |
sfid |
character varying |
|
coro__share_of_wallet__c |
id |
integer |
|
coro__share_of_wallet__c |
_hc_lastop |
character varying |
|
coro__share_of_wallet__c |
_hc_err |
text |
|
opportunity |
closedate |
date |
|
opportunity |
accountid |
character varying |
|
opportunity |
stagename |
character varying |
|
opportunity |
name |
character varying |
|
opportunity |
iswon |
boolean |
|
opportunity |
coro__loss_reason__c |
character varying |
|
opportunity |
isdeleted |
boolean |
|
opportunity |
coro__discovery_completed__c |
boolean |
|
opportunity |
systemmodstamp |
timestamp without time zone |
|
opportunity |
probability |
double precision |
|
opportunity |
coro__budget_confirmed__c |
boolean |
|
opportunity |
createddate |
timestamp without time zone |
|
opportunity |
isclosed |
boolean |
|
opportunity |
amount |
double precision |
|
opportunity |
coro__updatedby__c |
character varying |
|
opportunity |
type |
character varying |
|
opportunity |
contactid |
character varying |
|
opportunity |
coro__lastupdate__c |
timestamp without time zone |
|
opportunity |
description |
text |
|
opportunity |
coro__updatedat__c |
timestamp without time zone |
|
opportunity |
coro__roi_analysis_completed__c |
boolean |
|
opportunity |
coro__account_plan__c |
character varying |
|
opportunity |
sfid |
character varying |
|
opportunity |
id |
integer |
|
opportunity |
_hc_lastop |
character varying |
|
opportunity |
_hc_err |
text |
|
recordtype |
createddate |
timestamp without time zone |
|
recordtype |
name |
character varying |
|
recordtype |
systemmodstamp |
timestamp without time zone |
|
recordtype |
developername |
character varying |
|
recordtype |
isactive |
boolean |
|
recordtype |
namespaceprefix |
character varying |
|
recordtype |
sobjecttype |
character varying |
|
recordtype |
sfid |
character varying |
|
recordtype |
id |
integer |
|
recordtype |
_hc_lastop |
character varying |
|
recordtype |
_hc_err |
text |
|
user |
lastname |
character varying |
|
user |
street |
character varying |
|
user |
aboutme |
character varying |
|
user |
companyname |
character varying |
|
user |
managerid |
character varying |
|
user |
coro__issalesop__c |
boolean |
|
user |
name |
character varying |
|
user |
mobilephone |
character varying |
|
user |
lastmodifieddate |
timestamp without time zone |
|
user |
isactive |
boolean |
|
user |
systemmodstamp |
timestamp without time zone |
|
user |
lastmodifiedbyid |
character varying |
|
user |
state |
character varying |
|
user |
username |
character varying |
|
user |
createddate |
timestamp without time zone |
|
user |
country |
character varying |
|
user |
title |
character varying |
|
user |
firstname |
character varying |
|
user |
|
character varying |
|
user |
fax |
character varying |
|
user |
sfid |
character varying |
|
user |
id |
integer |
|
user |
_hc_lastop |
character varying |
|
user |
_hc_err |
text |
Data fields stored exclusively in Coro
Data fields stored exclusively in Coro
|
Macro category |
Elements |
Data type |
|
comments |
id |
integer |
|
comments |
parent_id |
integer |
|
comments |
text |
character varying |
|
comments |
author_id |
character varying |
|
comments |
created_date |
timestamp with time zone |
|
comments |
page |
USER-DEFINED |
|
comments |
account_plan_id |
character varying |
|
comments |
unread_receivers |
text |
|
custom_users |
sales_play |
character varying |
|
custom_users |
relationship_play_id |
character varying |
|
custom_users |
power_base_id |
character varying |
|
custom_users |
name |
character varying |
|
custom_users |
id |
integer |
|
email_notifications |
id |
integer |
|
email_notifications |
connected_account_plan_id |
character varying |
|
email_notifications |
target_user_id |
character varying |
|
email_notifications |
arguments |
json |
|
email_notifications |
type |
integer |
|
email_notifications |
sended_at |
timestamp with time zone |
|
email_notifications |
created_at |
timestamp with time zone |
|
email_notifications |
updated_at |
timestamp with time zone |
|
eula_accept |
sf_id |
character varying |
|
eula_accept |
accept_date |
timestamp with time zone |
|
global_settings |
id |
integer |
|
global_settings |
account_currency |
character varying |
|
global_settings |
admin_email |
character varying |
|
global_settings |
cadence_p1 |
integer |
|
global_settings |
cadence_p2 |
integer |
|
global_settings |
pillar1_display_customer_satisfaction_score |
boolean |
|
global_settings |
pillar1_include_custom_field |
boolean |
|
global_settings |
pillar1_custom_field_title |
character varying |
|
global_settings |
pillar1_custom_field_question |
character varying |
|
global_settings |
pillar2_include_custom_field |
boolean |
|
global_settings |
pillar2_custom_field_title |
character varying |
|
global_settings |
pillar2_custom_field_question |
character varying |
|
global_settings |
pillar2_financials_title_1 |
character varying |
|
global_settings |
pillar2_financials_title_2 |
character varying |
|
global_settings |
pillar2_revenue |
character varying |
|
global_settings |
pillar2_margin |
character varying |
|
global_settings |
pillar2_share_of_wallet |
character varying |
|
global_settings |
pillar3_type_of_decision_matrix |
character varying |
|
notification_settings |
id |
integer |
|
notification_settings |
user_id |
character varying |
|
notification_settings |
push_notifications |
character varying |
|
notification_settings |
email_notifications |
character varying |
|
notification_settings |
created_at |
timestamp with time zone |
|
notification_settings |
updated_at |
timestamp with time zone |
|
notifications |
id |
integer |
|
notifications |
target_user_id |
character varying |
|
notifications |
arguments |
json |
|
notifications |
text |
text |
|
notifications |
connected_account_plan_id |
character varying |
|
notifications |
type |
integer |
|
notifications |
status |
character varying |
|
notifications |
created_at |
timestamp with time zone |
|
notifications |
updated_at |
timestamp with time zone |
|
reports_pdf |
id |
integer |
|
reports_pdf |
url |
character varying |
|
reports_pdf |
file_name |
character varying |
|
reports_pdf |
account_plan__id |
character varying |
|
reports_pdf |
account_plan__v |
character varying |
|
reports_pdf |
ownerid |
character varying |
|
reports_pdf |
createdAt |
timestamp with time zone |
|
reports_pdf |
updatedAt |
timestamp with time zone |
|
tokens |
token |
text |
|
tutorials |
id |
integer |
|
tutorials |
user_id |
character varying |
|
tutorials |
tutorial_type |
character varying |
|
tutorials |
created_date |
timestamp with time zone |