{"tables":{"account":{"description":"Client accounts and companies working with Talan Group. Contains business information, financial data, and relationship details.","columns":{"Id":"text","Name":{"type":"text","description":"Company or client name"},"RecordTypeId":{"type":"text","description":"Type classification ID for the account"},"CreatedById":"text","LastModifiedById":"text","DR01__Percent_Complete__c":{"type":"double precision","description":"Project completion percentage for this client"},"Account_Owner_Full_Name__c":{"type":"text","description":"Full name of the account manager/owner"},"Top_parent__c":{"type":"text","description":"Top-level parent account in hierarchy"},"Sum_Opportunities__c":{"type":"double precision","description":"Total value of all opportunities for this client"},"account_hierarchy_level":{"type":"integer","description":"Level in account hierarchy (1=top level)"},"annual_revenue":"numeric(15,2)","total_contract_value":"numeric(15,2)","last_activity_amount":"numeric(10,2)","total_margin":"numeric(15,2)","account_type":"text","account_status":"text","industry":"text","client_tier":{"type":"text","description":"Client importance level: Premium, Standard, Basic"},"number_of_employees":"integer","active_projects_count":"integer"},"referenced_by":[{"table":"kimbleone__performanceanalysis__c","column":"KimbleOne__Account__c","references_column":"Id"}]},"kimbleone__deliveryelement__c":{"description":"Delivery elements representing work packages, missions, services, or projects delivered to clients.","columns":{"Business_Unit__c":{"type":"text","description":"Business unit responsible for this delivery element"},"CreatedById":"text","CurrencyIsoCode":"text","Element__c":{"type":"text","description":"Element type or category"},"Id":"text","KC_License__c":{"type":"boolean","description":"Whether this element requires a license"},"KimbleOne__ActualUsage__c":{"type":"double precision","description":"Actual time/resources used"},"KimbleOne__BaselineContractCost__c":"double precision","Name":"text"},"foreign_keys":[{"column":"Business_Unit__c","references_table":"kimbleone__businessunit__c","references_column":"id","constraint_name":"fk_delivery_businessunit"}],"referenced_by":[{"table":"kimbleone__timeentry__c","column":"KimbleOne__DeliveryElement__c","references_column":"Id"}]},"kimbleone__resource__c":{"description":"Human resources (employees, consultants, contractors) working at Talan Group.","columns":{"Id":"text","Name":"text","OwnerId":"text","CreatedById":"text","LastModifiedById":"text","KimbleOne__StandardCost__c":{"type":"numeric","description":"Daily cost rate of this consultant on Talan (PRJ - Prix de Revient Journalier)"},"KimbleOne__StandardRevenue__c":{"type":"numeric","description":"Daily billing rate that Talan charges her clients for this consultant (TJM - Taux Journalier Moyen)"},"KC_Pole_Resource_BUSec__c":{"type":"text","description":"Pole name the resource is assigned to"},"Domain":{"type":"text","description":"Domain name of the resource"},"KimbleOne__BusinessUnit__c":{"type":"text","description":"ID of the Business unit"},"CurrencyIsoCode":"text","KimbleOne__StandardRevenueCurrencyISOCode__c":{"type":"text","description":"Currency code for revenue"},"KimbleOne__ResourceType__c":{"type":"text","description":"Resource type: Employee, Contractor, etc."},"KimbleOne__FirstName__c":"text","KimbleOne__LastName__c":"text","KC_Email__c":"text","KimbleOne__User__c":{"type":"text","description":"User account ID"},"KC_Employee_ID__c":{"type":"text","description":"Employee ID number"}},"foreign_keys":[{"column":"KimbleOne__BusinessUnit__c","references_table":"kimbleone__businessunit__c","references_column":"id","constraint_name":"fk_resource_businessunit"}],"referenced_by":[{"table":"kimbleone__performanceanalysis__c","column":"KimbleOne__Resource__c","references_column":"Id"}]},"kimbleone__timeentry__c":{"description":"Individual time entries from CRA (Compte Rendu d'Activité) - each record represents time spent on a specific task/project.","columns":{"Id":"text","Name":"text","CurrencyIsoCode":"text","CreatedById":"text","LastModifiedById":"text","KimbleOne__ActivityAssignment__c":{"type":"text","description":"Assignment linking resource to specific project/activity"},"KimbleOne__ActivityAssignmentRate__c":{"type":"text","description":"Billing rate used for this assignment"},"KimbleOne__DeliveryElement__c":{"type":"text","description":"Delivery element this time is charged to"},"KimbleOne__EntryCost__c":{"type":"numeric","description":"Cost to company for this time entry"},"KimbleOne__EntryRevenue__c":{"type":"numeric","description":"Revenue generated by this time entry"},"KimbleOne__Timesheet__c":{"type":"text","description":"Timesheet containing this entry"},"KC_Nature_CRA__c":{"type":"text","description":"Nature of work: Projet (billable), Formation, Congés, etc."},"KimbleOne__EntryUnitsInHours__c":{"type":"numeric","description":"Time entered in hours"},"standardized_entry_units":{"type":"double precision","description":"Standardized time in hours (8.0 = full day)"}},"foreign_keys":[{"column":"KimbleOne__Resource__c","references_table":"kimbleone__resource__c","references_column":"Id","constraint_name":"fk_timeentry_resource"},{"column":"KimbleOne__DeliveryElement__c","references_table":"kimbleone__deliveryelement__c","references_column":"Id","constraint_name":"fk_timeentry_delivery"}],"referenced_by":[]},"kimbleone__performanceanalysis__c":{"description":"Financial performance analysis table containing aggregated cost, revenue, and margin data for business analysis. Each record represents performance metrics for a specific combination of account, resource, time period, and business unit. This is the main table for financial reporting and performance tracking at Talan Group.","columns":{"Id":{"type":"text","description":"Unique identifier (Primary Key)"},"Name":{"type":"text","description":"Performance analysis record name/label"},"CurrencyIsoCode":{"type":"text","description":"Currency code (EUR, USD, etc.)"},"KimbleOne__Account__c":{"type":"text","description":"Client account ID (links to account table) - which client this performance data relates to"},"KimbleOne__Resource__c":{"type":"text","description":"Employee/resource ID (links to resource table) - which consultant/employee this data relates to"},"KimbleOne__BusinessUnit__c":{"type":"text","description":"Id of the Business Unit"},"KimbleOne__TimePeriod__c":{"type":"text","description":"ID of the Time period for analysis- when the performance occurred"},"KimbleOne__ActualRevenue__c":{"type":"numeric","description":"Actual revenue generated in this period (€) - real money earned from client"},"KimbleOne__ActualCost__c":{"type":"numeric","description":"Actual cost incurred in this period (€) - real cost to company (salaries, expenses)"},"KimbleOne__ActualMarginAmount__c":{"type":"numeric","description":"Actual profit margin (€) - ActualRevenue minus ActualCost"},"KC_Invoiced_Value__c":{"type":"numeric","description":"Amount invoiced to client (€) - money billed/invoiced (may differ from revenue)"},"KC_Actual_Client_Revenue__c":{"type":"numeric","description":"Revenue specifically from external clients (€) - excludes internal revenue"},"KC_Actual_Internal_Revenue__c":{"type":"numeric","description":"Revenue from internal projects/inter-company work (€)"},"KC_Actual_Cost_to_Talan__c":{"type":"numeric","description":"Total cost to Talan Group (€) - comprehensive cost including all overheads"},"KimbleOne__DeliveryElement__c":{"type":"text","description":"ID of the Project/mission - specific deliverable this performance relates to"},"KimbleOne__P1ForecastRevenue__c":{"type":"numeric","description":"P1 forecast revenue (€) - most likely revenue prediction"},"KimbleOne__P1ForecastCost__c":{"type":"numeric","description":"P1 forecast cost (€) - most likely cost prediction"}},"foreign_keys":[{"column":"KimbleOne__Account__c","references_table":"account","references_column":"Id","constraint_name":"fk_performance_account"},{"column":"KimbleOne__Resource__c","references_table":"kimbleone__resource__c","references_column":"Id","constraint_name":"fk_performance_resource"},{"column":"KimbleOne__BusinessUnit__c","references_table":"kimbleone__businessunit__c","references_column":"id","constraint_name":"fk_performance_businessunit"}],"referenced_by":[]},"kimbleone__businessunit__c":{"description":"Business units representing organizational divisions at Talan in a specific Region. Used for revenue calculations, resource management, and organizational hierarchy. This table enables business unit-based reporting and analysis for financial performance tracking.","columns":{"id":{"type":"text","description":"ID of the Business unit"},"name":{"type":"text","description":"Business unit name"},"currencyisocode":{"type":"text","description":"Currency code (EUR, USD, etc.) - default currency for this business unit"},"kimbleone__businessunitgroup__c":{"type":"text","description":"Reference to business unit group"},"kimbleone__businessunit__c":{"type":"text","description":"Parent business unit ID - enables hierarchical organization"},"kimbleone__invoicingbusinessunitname__c":{"type":"text","description":"Business unit name used for invoicing purposes"},"ownerid":{"type":"text","description":"Owner/manager of this business unit"},"createdbyid":{"type":"text","description":"User who created this record"},"lastmodifiedbyid":{"type":"text","description":"User who last modified this record"},"systemmodstamp":{"type":"timestamp without time zone","description":"System modification timestamp"}},"foreign_keys":[{"column":"kimbleone__businessunit__c","references_table":"kimbleone__businessunit__c","references_column":"id","constraint_name":"fk_businessunit_parent"}],"referenced_by":[{"table":"kimbleone__performanceanalysis__c","column":"KimbleOne__BusinessUnit__c","references_column":"id"},{"table":"kimbleone__deliveryelement__c","column":"Business_Unit__c","references_column":"id"},{"table":"kimbleone__resource__c","column":"KimbleOne__BusinessUnit__c","references_column":"id"}]},"kimbleone__timeperiod__c":{"description":"Table des périodes temporelles utilisées pour l’analyse de performance et la planification.","columns":{"Id":{"type":"text","description":"ID unique Salesforce de la période"},"KimbleOne__StartDate__c":{"type":"date","description":"Date de début de la période"},"KimbleOne__EndDate__c":{"type":"date","description":"Date de fin de la période"}},"referenced_by":[{"table":"kimbleone__performanceanalysis__c","column":"KimbleOne__TimePeriod__c","references_column":"Id"}]}},"description":"There are 7 tables in the Talan Group schema:\n\n### Table: account\nDescription: Client accounts and companies working with Talan Group. Contains business information, financial data, and relationship details.\nColumns (20):\n- Id (text)\n- Name (text): Company or client name\n- RecordTypeId (text): Type classification ID for the account\n- CreatedById (text)\n- LastModifiedById (text)\n- DR01__Percent_Complete__c (double precision): Project completion percentage for this client\n- Account_Owner_Full_Name__c (text): Full name of the account manager/owner\n- Top_parent__c (text): Top-level parent account in hierarchy\n- Sum_Opportunities__c (double precision): Total value of all opportunities for this client\n- account_hierarchy_level (integer): Level in account hierarchy (1=top level)\n- annual_revenue (numeric(15,2))\n- total_contract_value (numeric(15,2))\n- last_activity_amount (numeric(10,2))\n- total_margin (numeric(15,2))\n- account_type (text)\n- account_status (text)\n- industry (text)\n- client_tier (text): Client importance level: Premium, Standard, Basic\n- number_of_employees (integer)\n- active_projects_count (integer)\n\n### Table: kimbleone__deliveryelement__c\nDescription: Delivery elements representing work packages, missions, services, or projects delivered to clients.\nColumns (9):\n- Business_Unit__c (text): Business unit responsible for this delivery element\n- CreatedById (text)\n- CurrencyIsoCode (text)\n- Element__c (text): Element type or category\n- Id (text)\n- KC_License__c (boolean): Whether this element requires a license\n- KimbleOne__ActualUsage__c (double precision): Actual time/resources used\n- KimbleOne__BaselineContractCost__c (double precision)\n- Name (text)\n\n### Table: kimbleone__resource__c\nDescription: Human resources (employees, consultants, contractors) working at Talan Group.\nColumns (18):\n- Id (text)\n- Name (text)\n- OwnerId (text)\n- CreatedById (text)\n- LastModifiedById (text)\n- KimbleOne__StandardCost__c (numeric): Daily cost rate of this consultant on Talan (PRJ - Prix de Revient Journalier)\n- KimbleOne__StandardRevenue__c (numeric): Daily billing rate that Talan charges her clients for this consultant (TJM - Taux Journalier Moyen)\n- KC_Pole_Resource_BUSec__c (text): Pole name the resource is assigned to\n- Domain (text): Domain name of the resource\n- KimbleOne__BusinessUnit__c (text): ID of the Business unit\n- CurrencyIsoCode (text)\n- KimbleOne__StandardRevenueCurrencyISOCode__c (text): Currency code for revenue\n- KimbleOne__ResourceType__c (text): Resource type: Employee, Contractor, etc.\n- KimbleOne__FirstName__c (text)\n- KimbleOne__LastName__c (text)\n- KC_Email__c (text)\n- KimbleOne__User__c (text): User account ID\n- KC_Employee_ID__c (text): Employee ID number\n\n### Table: kimbleone__timeentry__c\nDescription: Individual time entries from CRA (Compte Rendu d'Activité) - each record represents time spent on a specific task/project.\nColumns (14):\n- Id (text)\n- Name (text)\n- CurrencyIsoCode (text)\n- CreatedById (text)\n- LastModifiedById (text)\n- KimbleOne__ActivityAssignment__c (text): Assignment linking resource to specific project/activity\n- KimbleOne__ActivityAssignmentRate__c (text): Billing rate used for this assignment\n- KimbleOne__DeliveryElement__c (text): Delivery element this time is charged to\n- KimbleOne__EntryCost__c (numeric): Cost to company for this time entry\n- KimbleOne__EntryRevenue__c (numeric): Revenue generated by this time entry\n- KimbleOne__Timesheet__c (text): Timesheet containing this entry\n- KC_Nature_CRA__c (text): Nature of work: Projet (billable), Formation, Congés, etc.\n- KimbleOne__EntryUnitsInHours__c (numeric): Time entered in hours\n- standardized_entry_units (double precision): Standardized time in hours (8.0 = full day)\n\n### Table: kimbleone__performanceanalysis__c\nDescription: Financial performance analysis table containing aggregated cost, revenue, and margin data for business analysis. Each record represents performance metrics for a specific combination of account, resource, time period, and business unit. This is the main table for financial reporting and performance tracking at Talan Group.\nColumns (17):\n- Id (text): Unique identifier (Primary Key)\n- Name (text): Performance analysis record name/label\n- CurrencyIsoCode (text): Currency code (EUR, USD, etc.)\n- KimbleOne__Account__c (text): Client account ID (links to account table) - which client this performance data relates to\n- KimbleOne__Resource__c (text): Employee/resource ID (links to resource table) - which consultant/employee this data relates to\n- KimbleOne__BusinessUnit__c (text): Id of the Business Unit\n- KimbleOne__TimePeriod__c (text): ID of the Time period for analysis- when the performance occurred\n- KimbleOne__ActualRevenue__c (numeric): Actual revenue generated in this period (€) - real money earned from client\n- KimbleOne__ActualCost__c (numeric): Actual cost incurred in this period (€) - real cost to company (salaries, expenses)\n- KimbleOne__ActualMarginAmount__c (numeric): Actual profit margin (€) - ActualRevenue minus ActualCost\n- KC_Invoiced_Value__c (numeric): Amount invoiced to client (€) - money billed/invoiced (may differ from revenue)\n- KC_Actual_Client_Revenue__c (numeric): Revenue specifically from external clients (€) - excludes internal revenue\n- KC_Actual_Internal_Revenue__c (numeric): Revenue from internal projects/inter-company work (€)\n- KC_Actual_Cost_to_Talan__c (numeric): Total cost to Talan Group (€) - comprehensive cost including all overheads\n- KimbleOne__DeliveryElement__c (text): ID of the Project/mission - specific deliverable this performance relates to\n- KimbleOne__P1ForecastRevenue__c (numeric): P1 forecast revenue (€) - most likely revenue prediction\n- KimbleOne__P1ForecastCost__c (numeric): P1 forecast cost (€) - most likely cost prediction\n\n### Table: kimbleone__businessunit__c\nDescription: Business units representing organizational divisions at Talan in a specific Region. Used for revenue calculations, resource management, and organizational hierarchy. This table enables business unit-based reporting and analysis for financial performance tracking.\nColumns (10):\n- id (text): ID of the Business unit\n- name (text): Business unit name\n- currencyisocode (text): Currency code (EUR, USD, etc.) - default currency for this business unit\n- kimbleone__businessunitgroup__c (text): Reference to business unit group\n- kimbleone__businessunit__c (text): Parent business unit ID - enables hierarchical organization\n- kimbleone__invoicingbusinessunitname__c (text): Business unit name used for invoicing purposes\n- ownerid (text): Owner/manager of this business unit\n- createdbyid (text): User who created this record\n- lastmodifiedbyid (text): User who last modified this record\n- systemmodstamp (timestamp without time zone): System modification timestamp\n\n### Table: kimbleone__timeperiod__c\nDescription: Table des périodes temporelles utilisées pour l’analyse de performance et la planification.\nColumns (3):\n- Id (text): ID unique Salesforce de la période\n- KimbleOne__StartDate__c (date): Date de début de la période\n- KimbleOne__EndDate__c (date): Date de fin de la période\n\n"}