Skip to main content
This schema connects the relationship between individuals and businesses or sole proprietors.
All programs that have commercial customers are required to submit this file daily. Refer to Customer Files overview for more details.
Submit an empty file if there are no changes.
FieldDescriptionRequiredData Type
client_individual_idThe individual you want to link to the business or sole prop customer. This should be client_customer_id of customer_type =individual from Customer file. All individuals being linked to the business or sole prop customers must meet data requirements of authorized_signer.

See Data Requirements for Intended Roles for more details.
Requiredstring

If customer_type = business, we require all control_person and all applicable beneficial_owners under client_individual_id. At least one control person is required.
If customer_type = sole_prop, we require one sole_proprietor under client_individual_id.
client_business_idThe business customer you are linking individuals to. This should be client_customer_id of customer_type = business from Customer file. All sole prop customers must meet data requirements of account_holder.

See Data Requirements for Intended Roles for more details.
One of client_business_id or client_sole_prop_id is requiredstring
client_sole_prop_idThe sole_prop customer you are linking individuals to. This should be client_customer_id of customer_type = sole_prop from Customer file. All sole prop customers must meet data requirements of account_holderOne of client_business_id or client_sole_prop_id is requiredstring
statusStatus of associated beneficial owner/control person for business or sole proprietor of sole prop. This is used in the case there are individual relationships added or removed to businesses or sole proprietorships.

Possible values are active or deleted.
Required if customer_type = business, sole_propenum
active
deleted
relationship_typePossible values are beneficial_owner, control_person, sole_proprietorRequired if customer_type = business, sole_propenum:
beneficial_owner
control_person
sole_proprietor
relationship_established_atThe date the relationship was established. Applicable for beneficial owners and control persons.Optoinaldate
YYYY-MM-DD
ownership_percentagePercentage ownership. Applicable for beneficial owners only
sum of all beneficial ownership percentage should be 100 or below.
Optionalnumber
decimal(M, 2)
titleTitle of the Control Person. (e.g., CEO, Owner)Required if relationship_type = control_personstring
generated_atThe day this file is generated. This should always be the date the file is sent to Lead Bank.Requireddatetime
ISO8601
effective_atThe timestamp of when the related object(s) were polled to collect the information for this record.Requireddatetime
ISO8601