> ## Documentation Index > Fetch the complete documentation index at: https://docs.ldgr.app/llms.txt > Use this file to discover all available pages before exploring further. # Glossary ## data\_map.claim The cumulative latest claim-level data as of the provided `valuation_date`. | Column | Type | Definition | | --------------------- | ------------- | ----------------------------------------------------------------------------------- | | claim\_id | bigint | The unique identifier for a claim. | | policy\_group\_id | bigint | The unique identifier for the policy group that the policy belongs to. | | policy\_id | bigint | The unique identifier for the policy that the claim belongs to. | | tpa\_id | bigint | The unique identifier for a TPA (third party administrator) that handles the claim. | | external\_policy\_id | string | The identifier assigned by the insurer for the policy. | | external\_claim\_id | string | The identifier assigned by the insurer for the claim. | | loss\_occurence\_date | date | The date the loss occurred. | | claim\_opened\_date | date | The date the claim was opened. | | claim\_reported\_date | date | The date the claim was reported. | | claim\_closed\_date | date | The date the claim was closed. | | source\_record\_date | date | The date of the BDX file supplied by the cedant. | | is\_derived | boolean | Whether the data is derived by us or supplied by the cedant. | | epistemic\_rank | string | The epistemic rank of the claim (currently just "bordereau"). | | loss\_taxonomy | map | Loss category. | | loss\_metrics | map | Loss amount by category | | claim\_status | string | The status of the claim (open/closed). | | claim\_coverages | array | The coverage amount by category. | | currency | string | The currency the claim is denominated in. | | claim\_limit | decimal(17,2) | The limit allowed by policy. | | claim\_deductible | decimal(17,2) | Deductible amount. | | catastrophe\_code | string | The catastrophe code for the claim. | | claim\_metadata | map | Metadata about the claim. | | other\_data | array | Misc. data field. | | valuation\_date | timestamp | Same as `source_record_date` unless the cedant provides another value. | | is\_latest | boolean | Whether the data is from the latest BDX file. | ## data\_map.collateral\_terms A pointer to collateral terms math stored in a Python or Excel file. | Column | Type | Definition | | ------------------------------ | ------ | ----------------------------------------------- | | collateral\_terms\_id | bigint | The unique identifier for the collateral terms. | | collateral\_terms\_scheme | string | The name of the collateral terms scheme. | | collateral\_terms\_description | string | The description of the collateral terms scheme. | | collateral\_deal\_model | string | The name of the collateral deal model. | ## data\_map.company Information about legal entities. | Column | Type | Definition | | --------------------- | ------ | ------------------------------------------------------------------ | | company\_id | bigint | The unique identifier of the company. | | organization\_id | bigint | The unique identifier of the organization the company belongs to. | | address\_id | bigint | The unique identifier of the address the company is registered at. | | legal\_name | string | The legal name of the company. | | website | string | The website URL of the company. | | linkedin | string | The linkedin URL of the company. | | email | string | The email address of the company. | | year\_founded | int | The year the company was founded. | | legal\_id | array | The legal ID of the company (e.g. EIN). | | legal\_status | string | The legal status of the company (e.g. Active/Inactive). | | legal\_type | string | The legal type of the company (e.g. LLC/Corporation). | | description | string | A description of the company. | | employee\_size | string | The size of the company (e.g. 100-500 employees). | | public\_stock\_ticker | string | The public stock ticker of the company. | | operating\_geography | string | The geographic region the company operates in. | ## data\_map.company\_managing\_general\_agent Additional basic information on legal entities that are MGAs or MGUs. | Column | Type | Definition | | ----------------------- | ------ | ------------------------------------------------- | | company\_id | bigint | The unique identifier for the company. | | employees\_management | int | The number of employees on the management team. | | employees\_underwriting | int | The number of employees on the underwriting team. | | employees\_actuarial | int | The number of employees on the actuarial team. | | employees\_claims | int | The number of employees on the claims team. | | employees\_other | int | The number of employees on other teams. | | product\_lines | array | The product lines the company insures. | ## data\_map.contract Metadata describing a signed legal agreement. | Column | Type | Definition | | ---------------------- | ------ | ---------------------------------------------------------------------------- | | contract\_id | bigint | The unique identifier of the contract (auto increment). | | ledger\_contract\_id | bigint | The unique identifier of the contract in the ledger system (assigned by us). | | name | string | The name of the contract. | | type | string | The type of the contract (e.g. Reinsurance) | | status | string | The status of the contract (e.g. Active/Inactive). | | version | string | The version of the contract. | | signature\_date | date | The date the contract was signed. | | effective\_date | date | The date the contract became effective. | | description | string | A description of the contract. | | description\_amendment | string | A description of the contract amendment (if applicable). | | signatories | array | The signatories of the contract. | | contract\_wording\_id | bigint | The unique identifier of the contract wording. | | contract\_file\_id | string | The unique identifier of the contract file. | ## data\_map.contract\_amendments A link between an original contract and any amended contracts. | Column | Type | Definition | | ---------------------------- | ------ | ----------------------------------------------------- | | contract\_amendments\_id | bigint | The unique identifier for an amendment to a contract. | | contract\_being\_amended\_id | bigint | The unique identifier for the contract being amended. | | contract\_amendment\_id | bigint | The amendment to the contract is itself a contract | | amendment\_number | int | The number of the amendment to the contract. | | amendment\_type | string | The type of amendment to the contract. | | amendment\_effective\_date | date | The date the amendment became effective. | ## data\_map.contract\_interest\_liabilities Information about interest & liablities agreements of reinsurance contracts. | Column | Type | Definition | | ----------------------------------- | ------ | ------------------------------------------------------------- | | contract\_interest\_liabilities\_id | bigint | The unique identifier for an interest & liablities agreement. | | contract\_reinsurance\_id | bigint | The unique identifier for a reinsurance contract. | | contract\_id | bigint | The unique identifier for a signed legal agreement. | | reinsurer\_id | bigint | The unique identifier for the reinsurance company | ## data\_map.contract\_page\_text The plain text of a contract grouped by page. | Column | Type | Definition | | ----------------- | ------ | --------------------------------------------------- | | contract\_id | string | The unique identifier of the contract. | | google\_drive\_id | string | The unique identifier of the Google Drive document. | | filename | string | The name of the file. | | filetype | string | The type of the file (mostly PDF). | | fullname | string | The full name of the contract | | pagenum | bigint | The page number of the contract | | text | string | The text of the contract page | ## data\_map.contract\_reinsurance Identifies all contracts that relate to a reinsurance transaction including all brokers, ceding insurers, and reinsurers. | Column | Type | Definition | | --------------------------- | ------- | -------------------------------------------------------------- | | contract\_reinsurance\_id | bigint | The unique identifier for a reinsurance contract. | | reinsurance\_active\_status | boolean | Whether the reinsurance contract is active or not. | | master\_contract\_id | bigint | The unique identifier for the master contract. | | schedule\_contract\_id | bigint | The unique identifier for the schedule contract. | | standalone\_contract\_id | bigint | The unique identifier for the standalone contract. | | trust\_contract\_id | bigint | The unique identifier for the trust contract. | | broker\_contract\_id | bigint | The unique identifier for the broker contract. | | multiple\_keyterms | boolean | Whether the reinsurance contract has multiple keyterms or not. | | reinsurers | array | The unique company identifier of all reinsurers | | cedants | array | The unique company identifier of all cedants | | brokers | array | The unique company identifier of all brokers | ## data\_map.contract\_reinsurance\_binder All documents associated with a single reinsurance transaction. | Column | Type | Definition | | --------------------------------- | ------- | --------------------------------------------------------- | | contract\_reinsurance\_binder\_id | bigint | The unique identifier of the contract reinsurance binder. | | reinsurance\_binder\_name | string | The name of the binder. | | ceding\_insurer | string | The ceding insurer. | | reinsurer | string | The reinsurer. | | reinsurance\_contracts | array | Reinsurance contracts associated with the binder. | | novation\_contracts | array | Novation contracts associated with the binder. | | trust\_contracts | array | Trust contracts associated with the binder. | | broker\_contracts | array | Broker contracts associated with the binder. | | investor\_contracts | array | Investor contracts associated with the binder. | | ima\_contracts | array | IMA contracts associated with the binder. | | side\_letter\_contracts | array | Side letter contracts associated with the binder. | | multiple\_keyterms | boolean | Whether the binder has multiple keyterms. | ## data\_map.contract\_reinsurance\_keyterms Identifies the key terms for reinsurance contracts. | Column | Type | Definition | | ------------------------------------------ | ------ | ---------- | | contract\_reinsurance\_keyterms\_id | bigint | None | | contract\_reinsurance\_binder\_id | bigint | None | | reinsurance\_transaction\_name | string | None | | reinsurance\_type | string | None | | reinsurance\_form | string | None | | quota\_share\_percent | double | None | | subject\_business | string | None | | policy\_group\_id | array | None | | policy\_group\_name | string | None | | product\_line | string | None | | risk\_period\_start | date | None | | risk\_period\_end | date | None | | policy\_max\_limits | array | None | | coverage\_type | string | None | | coverage\_layers\_basis | string | None | | coverage\_layers\_amounts | array | None | | reinsurance\_premium\_basis | string | None | | reinsurance\_premium | double | None | | premium\_remittance\_basis | string | None | | ceding\_commission\_basis | string | None | | min\_ceding\_commission | double | None | | profit\_commission\_basis | string | None | | profit\_commission\_start\_date | date | None | | ramp\_up\_period\_end\_date | date | None | | profit\_commission\_amounts | array | None | | provisional\_profit\_commission | double | None | | premium\_maxium | double | None | | aggregate\_limit\_basis | string | None | | aggregate\_limit | double | None | | occurrence\_limit\_basis | string | None | | occurrence\_limit | double | None | | FET\_rate | double | None | | collateral\_initial | double | None | | claims\_fund\_initial | double | None | | claims\_fund\_minimum | double | None | | claims\_fund\_maximum | double | None | | commutation\_date | date | None | | bdx\_reporting\_period | string | None | | collateral\_reporting\_period | string | None | | bdx\_reporting\_lag | int | None | | remittance\_lag | int | None | | collateral\_reporting\_lag | int | None | | collateral\_deposit\_lag | int | None | | premium\_expected | double | None | | collateral\_terms\_id | string | None | | Foreign\_Currency\_to\_USD\_Exchange\_Rate | double | None | ## data\_map.contract\_reinsurancetrust\_keyterms Terms describing the trust account associated with a reinsurance transaction. | Column | Type | Definition | | ---------------------------------------- | ------ | ------------------------------------------- | | reinsurance\_transaction\_name | string | The reinsurance transaction name. | | contract\_reinsurance\_binder\_id | int | The contract reinsurance binder ID. | | reinsurance\_binder\_name | string | The reinsurance binder name. | | ceding\_insurer | string | The ceding insurer. | | reinsurer | string | The reinsurer. | | trustee | string | The trustee. | | trust\_account\_number | string | The trust account number. | | principal\_account\_numbers | array | The principal account numbers. | | income\_account\_numbers | array | The income account numbers. | | contract\_reinsurancetrust\_keyterms\_id | bigint | The contract reinsurance trust keyterms ID. | ## data\_map.contract\_securitiesbroker\_keyterms Terms describing the securities broker account associated with a reinsurance transaction. | Column | Type | Definition | | ---------------------------------------- | ------ | ------------------------------------------- | | reinsurance\_transaction\_name | string | The reinsurance transaction name. | | reinsurance\_binder\_name | string | The reinsurance binder name. | | ceding\_insurer | string | The ceding insurer. | | reinsurer | string | None | | securities\_broker | string | The securities broker. | | brokerage\_fee\_basis | string | The brokerage fee basis. | | brokerage\_fee | double | The brokerage fee. | | percent\_paid\_at\_closing | double | The percent paid at closing. | | factoring\_discount\_rate | double | The factoring discount rate. | | payment\_timing | string | The payment timing. | | contract\_securitiesbroker\_keyterms\_id | bigint | The contract securities broker keyterms ID. | ## data\_map.contract\_text The plain text of a contract. | Column | Type | Definition | | ----------------- | ------ | ---------- | | contract\_id | string | None | | google\_drive\_id | string | None | | filename | string | None | | filetype | string | None | | fullname | string | None | | text | string | None | ## data\_map.contract\_trust Information about trust accounts. | Column | Type | Definition | | -------------------------------- | ------ | --------------------------------------------------------- | | contract\_trust\_id | bigint | The unique identifier for the contract trust. | | contract\_id | bigint | The unique identifier for the contract. | | contract\_reinsurance\_id | bigint | The unique identifier for the reinsurance contract. | | bank\_id | bigint | The unique identifier for the bank. | | trustee\_id | bigint | The unique identifier for the trustee company. | | bank\_trust\_account\_number | string | The bank trust account number (alphanumeric). | | bank\_income\_account\_number | string | The bank income account number (alphanumeric). | | method\_access\_account | string | The method of accessing the account e.g. email, SSO, etc. | | account\_login\_credential\_name | string | The account login credential name in 1Password. | ## data\_map.contract\_wording Information on the wording of each clause of a contract. | Column | Type | Definition | | --------------------- | ------ | ----------------------------------------------- | | contract\_wording\_id | bigint | The unique identifier for the contract wording. | | contract\_id | bigint | The unique identifier for the contract. | | clause\_number | string | The clause number in the contract. | | clause\_title | string | The clause title in the contract. | | clause\_text | string | The clause text in the contract. | ## data\_map.file Information regarding the storage of all documents. | Column | Type | Definition | | ------------ | ------ | ------------------------------------------------ | | file\_id | bigint | The unique identifier for the file. | | status | string | The status of the file (failed, completed, etc) | | description | string | The description of the file. | | file\_type | string | The type of the file (e.g. contract, bordereaux) | | file\_format | string | The format of the file (e.g. pdf) | | file\_name | string | The name of the file | | file\_path | string | The path of the file | | sensitivity | string | The sensitivity of the file (e.g. confidential) | | metadata | map | Any metadata associated with the file | ## data\_map.offering Information related to the advertisement/marketing of a reinsurance transaction. | Column | Type | Definition | | --------------------- | ------- | ------------------------------------------------------------------------ | | offering\_id | bigint | The unique identifier for the offering. | | name | string | The name of the offering. | | description | string | The description of the offering. | | status | string | The status of the offering (draft, live, closing, contracted, inactive). | | offering\_type | string | The type of the offering (primary, secondary). | | approved | boolean | Whether the offering has been approved. | | risk\_underwriter\_id | bigint | The unique identifier for the risk underwriting company. | | multiple\_keyterms | boolean | Whether the offering has multiple key terms. | ## data\_map.offering\_keyterms Information about the key terms for an offering. | Column | Type | Definition | | --------------------------- | ------------- | ---------------------------------------------------------------------------------------- | | offering\_keyterms\_id | bigint | The unique identifier of the offering key terms. | | offering\_id | bigint | The unique identifier of the offering. | | cedant\_ids | array | The unique identifier(s) of the cedant(s). | | reinsurance\_type | string | The type of reinsurance (treaty/facultative). | | reinsurance\_form | string | The form of reinsurance (quota-share, excess-of-loss, surpluss-share, aggregate-excess). | | quota\_share\_percent | double | The premium percentage shared with the reinsurer. | | subject\_business | string | Description of the line of business being insured. | | policy\_group\_id | bigint | The unique identifier of the policy group. | | product\_line | string | The product line of the offering (e.g. commercial-auto). | | risk\_period\_start | date | The start date of the risk period. | | risk\_period\_end | date | The end date of the risk period. | | policy\_max\_limits | array | The maximum claim limit for each policy group. | | coverage\_type | string | The type of coverage (risk-attaching or loss-occuring). | | coverage\_layers\_basis | string | The basis for the coverage layers (amount, percent-of-gross/net-premium). | | coverage\_layers\_amounts | array | The amount of each coverage layer (attachment, exhaustion, placedpercent). | | reinsurance\_premium\_basis | string | Basis for the reinsurance premium (amount, percent-of-gross/net-premium). | | reinsurance\_premium | double | The reinsurance premium percentage. | | ceding\_commission\_basis | string | Basis for ceding commission (amount, percent-of-gross/net-premium). | | min\_ceding\_commission | double | The minimum ceding commission percentage. | | profit\_commission\_basis | string | Basis for profit commission (amount, percent-of-gross/net-premium). | | profit\_commission\_amounts | array | The amount of each profit commission layer (attachment/exhaustion/profitsharing). | | premium\_maximum | decimal(17,2) | None | | aggregate\_limit\_basis | string | Basis for the aggregate limit (amount, percent-of-gross/net-premium). | | aggregate\_limit | double | The aggregate limit percentage. | | occurrence\_limit\_basis | string | Basis for the occurrence limit (amount, percent-of-gross/net-premium). | | occurrence\_limit | decimal(17,2) | The occurrence limit amount. | | collateral\_terms\_id | bigint | The collateral terms unique identifier. | ## data\_map.person Information on specific people (for example, key employees) within a company. | Column | Type | Definition | | -------------------- | ------ | ------------------------------------------------------------------- | | person\_id | bigint | The unique identifier of the person. | | company\_id | bigint | The unique identifier of the company the person is affiliated with. | | fullname | string | The full name of the person. | | email | string | The email address of the person. | | firstname | string | The first name of the person. | | lastname | string | The last name of the person. | | title | string | The title of the person. | | description | string | A description of the person or their role. | | industry\_experience | int | The number of years of industry experience the person has. | | tenure | int | The number of years the person has been with the company. | | linkedin | string | The linkedin URL of the person. | ## data\_map.policy The cumulative latest policy-level data as of the provided `valuation_date`. | Column | Type | Definition | | ------------------------------ | ------------- | -------------------------------------------------------------- | | policy\_id | bigint | The unique identifier of the policy. | | insurer\_id | bigint | The unique identifier of the insurer company. | | policy\_group\_id | bigint | The unique identifier of the policy group. | | external\_policy\_id | string | The policy identifier provided by the insurer. | | policy\_effective\_date | date | The date the policy became effective. | | policy\_expiration\_date | date | The date the policy expires. | | policy\_cancellation\_date | date | The date the policy was cancelled. | | source\_record\_date | date | Date of the bordereaux file supplied by the cedant. | | jurisdiction\_country | string | The country the policy was issued in. | | jurisdiction\_province | string | The province or state was issued in. | | coverage\_types | array | The types of coverage under the policy. | | deductibles | array | The deductibles for each coverage. | | coverages | array | The amount of each coverage. | | policy\_limit\_individual | array | The individual limit for each coverage. | | policy\_limit\_occurance | array | The occurrence limit for each coverage. | | policy\_limit\_aggregate | array | The aggregate limit for each coverage. | | premium\_collection\_frequency | string | The frequency of premium collection (e.g. monthly, quarterly). | | named\_insured | string | The name of the named insured. | | additional\_insured | array | The names of any additional insured. | | premium\_written | decimal(17,2) | The premium written under the policy. | | premium\_earned | decimal(17,2) | The premium earned under the policy. | | premium\_collected | decimal(17,2) | The premium collected under the policy. | | base\_rate | double | The base rate for the policy. | | manual\_rate | double | The manual rate for the policy. | | base\_premium | decimal(17,2) | The base premium for the policy. | | manual\_premium | decimal(17,2) | The manual premium for the policy. | | exposures | array | The exposure amount for each coverage | | risk\_factors | array | The risk factors for the policy. | | details | map | Any policy-specific fields | | other\_data | array | Any other data fields | | valuation\_date | timestamp | Date the amounts were computed. | | is\_latest | boolean | None | ## bordereaux.silver\_policy\_snapshot Premium as of a specific date. | Column | Type | Definition | | ------------------------------- | ------------- | ---------------------------------------------------------------------------------------------- | | policy\_snapshot\_id | bigint | The unique identifier for the policy snapshot. | | policy\_group\_id | bigint | The unique identifier for the policy group that the policy belongs to. | | contract\_risk\_period\_id | bigint | The unique identifier for the contract risk period that the policy belongs to. | | external\_policy\_id | string | The identifier assigned by the insurer for the policy. | | source\_record\_date | date | The date of the BDX file supplied by the cedant. | | policy\_effective\_date | date | The date the policy begins coverage. | | policy\_expiration\_date | date | The date the policy expires. | | policy\_cancellation\_date | date | The date the policy was cancelled if any. | | earn\_start\_date | date | The date the policy begins earnings. | | earn\_stop\_date | date | The date the policy stops earnings. | | cedant\_treaty\_year | string | The treaty year the policy covers as supplied by the cedant. | | written\_country | string | The country the policy is written in. | | written\_province | string | The state or province the policy is written in. | | policy\_limit | decimal(17,2) | The total claims limit of the policy. | | policy\_deductible | decimal(17,2) | The deductible paid by the holder of the policy. | | policy\_details | map | Details specific to this policy and/or cedant (e.g. insured party). | | policy\_derived\_details | map | Details derived from the policy and/or cedant (e.g. line of business). | | epistemic\_rank | string | The epistemic rank of the policy. | | is\_policy\_event\_date | boolean | Indicates whether the policy event date is the same as the source record date (usually false). | | metadata | map | Metadata associated with the premium BDX file itself. | | created\_at | timestamp | The date the record was created in the database. | | updated\_at | timestamp | The date the record was last updated in the database. | | is\_latest | boolean | Indicates whether the record is the latest version of the premium file. | | run\_key | string | The unique identifier for the run of the premium BDX file. | | policy\_effective\_date\_raw | date | The date the policy begins coverage if different from the file date. | | policy\_expiration\_date\_raw | date | The date the policy expires if different from the file date. | | policy\_cancellation\_date\_raw | date | The date the policy was cancelled if any if different from the file date. | | source\_record\_date\_raw | date | The date the record was received if different from the file. | | # Clustering Information | | | | # col\_name | data\_type | comment | ## bordereaux.silver\_claim\_snapshot Claims as of a specific date. | Column | Type | Definition | | ---------------------------- | ------------- | ------------------------------------------------------------------------------------------------ | | claim\_snapshot\_id | bigint | The unique identifier for a claim. | | policy\_group\_id | bigint | The unique identifier for the policy group that the claim belongs to. | | external\_claim\_id | string | The identifier assigned by the insurer for the claim. | | external\_policy\_id | string | The identifier assigned by the insurer for the policy. | | source\_record\_date | date | The date of the BDX file supplied by the cedant. | | cedant\_accounting\_date | date | The date the claim was accounted for by the cedant. | | policy\_effective\_date | date | The date the policy begins coverage. | | cedant\_treaty\_year | string | The treaty year reported by the cedant. | | currency | string | The currency the claim is denominated in. | | claims\_handler | string | The name of the claims handler if specified. | | jurisdiction\_country | string | The country the claim was filed in. | | jurisdiction\_province | string | The state or province the claim was filed in. | | claim\_details | map | Details specific to this type of claim and/or cedant | | claim\_derived\_details | map | Details inferred by either the BDX file or the policy, including losses, reserves, and expenses. | | claim\_limit | decimal(17,2) | The limit of claims under the policy. | | claim\_deductible | decimal(17,2) | The deductible paid by the insured. | | source\_record\_date\_raw | date | The date of the claim supplied by the cedant if overridden by an overlay (for debugging only). | | policy\_effective\_date\_raw | date | The date the policy begins coverage if overridden by an overlay (for debugging only). | | epistemic\_rank | string | The data source of the claim (currently just "bordereau"). | | metadata | map | Metadata about the BDX file itself. | | is\_latest | boolean | Whether this is the latest version of the claim file. | | created\_at | timestamp | The date the record was created in the database. | | updated\_at | timestamp | The date the record was last updated in the database. | | contract\_risk\_period\_id | bigint | The unique identifier for the contract risk period that the claim belongs to. | | run\_key | string | The unique identifier for the ingest job run (for debugging only) | | # Clustering Information | | | | # col\_name | data\_type | comment | ## bordereaux.gold\_contract\_compliance Premium and Loss data as reconciled with the reinsurance contract. | Column | Type | Definition | | ---------------------------------- | ------------- | --------------------------------------------------------------------------------------------------- | | primary\_tag | string | Human readable combination of cedant and coverage type (e.g. "company.category-coverage"). | | component\_tag | string | Sub-tag, possibly the same as the primary tag. | | cedant\_treaty\_year | string | The treaty year the policy covers as supplied by the cedant. | | risk\_period\_start | date | The start date of the risk period covered by the poicy. | | epistemic\_rank | string | The data source of the record (currently just "bordereau"). | | evaluation\_date | date | The most recent date a BDX file was supplied by the cedant. | | premium\_written | decimal(38,2) | The total value of premium written on this program. | | premium\_cedant\_earned | decimal(38,2) | The total earned premium reported by the cedant. | | premium\_cedant\_collected | decimal(38,2) | The total paid premium reported by the cedant. | | ibnr\_cedant\_load | decimal(38,2) | The incurred but not reported estimate by the cedant. | | reported\_loss | double | The total loss reported by the cedant. | | uncapped\_reported\_loss | decimal(38,2) | The total loss reported by the cedant ignoring policy limits. | | over\_cap\_reported\_loss | double | The difference between the uncapped loss and the reported loss. | | count\_capped\_reported\_loss | bigint | The number of capped claims. | | capped\_reported\_loss\_claim\_ids | array | Array of ids of capped claims. | | paid\_loss | double | Total amount paid out on the policy. | | uncapped\_paid\_loss | decimal(38,2) | Total amount paid out on the policy ignoring policy limits. | | over\_cap\_paid\_loss | double | The difference between the uncapped paid loss and the paid loss. | | count\_capped\_paid\_loss | bigint | The number of capped claims. | | capped\_paid\_loss\_claim\_ids | array | Array of ids of capped claims. | | premium\_written\_source | string | The type of BDX file supplied for the premium written (currently "aggregate" or "policy\_claim"). | | premium\_cedant\_earned\_source | string | The type of BDX file supplied for the premium earned (currently "aggregate" or "policy\_claim"). | | premium\_cedant\_collected\_source | string | The type of BDX file supplied for the premium collected (currently "aggregate" or "policy\_claim"). | | ibnr\_cedant\_load\_source | string | The type of BDX file supplied for the IBNR cedant load (currently "aggregate" or "policy\_claim"). | | reported\_loss\_source | string | The type of BDX file supplied for the reported loss (currently "aggregate" or "policy\_claim"). | | paid\_loss\_source | string | The type of BDX file supplied for the paid loss (currently "aggregate" or "policy\_claim"). | | occurrence\_limit | int | The limit per claim under the policy. | | claim\_count | bigint | The total number of claims under the policy. | ## bordereaux.gold\_cedant\_loss\_pick The loss ratio predicted ("picked") by the cedant. | Column | Type | Definition | | -------------------------- | ------ | ------------------------------------------------------------------------------ | | policy\_group\_id | bigint | The unique identifier of the policy group | | source\_record\_date | date | The date of the BDX file supplied by the cedant. | | contract\_risk\_period\_id | bigint | The unique identifier for the contract risk period that the policy belongs to. | | cedant\_loss\_pick | double | The projected loss ratio by the cedant for the policy and risk period. |