Originator Broker
Originator Broker
Report type: originator_broker
About this export
- Only applicable to third party originator organization setups.
- Export of broker information.
- 1 row per broker UUID.
| Position | Field Name | Datatype | Mode | Date Added | Definition | Categorical Values | Format Notes | Misc. Notes |
|---|---|---|---|---|---|---|---|---|
| 1 | broker_id_value | STRING | NON_NULLABLE | NaT | Figure assigned UUID of broker | |||
| 2 | organization | STRING | NON_NULLABLE | NaT | ||||
| 3 | broker_name | STRING | NON_NULLABLE | NaT | ||||
| 4 | broker_nmls_no | STRING | NON_NULLABLE | NaT | ||||
| 5 | address_street_1 | STRING | NULLABLE | NaT | ||||
| 6 | address_street_2 | STRING | NULLABLE | 2025-08-25 | ||||
| 7 | address_street_3 | STRING | NULLABLE | 2025-08-25 | ||||
| 8 | address_city | STRING | NULLABLE | 2025-08-25 | ||||
| 9 | address_state | STRING | NULLABLE | 2025-08-25 | ||||
| 10 | address_zip | STRING | NULLABLE | 2025-08-25 | ||||
| 11 | address_type | STRING | NULLABLE | 2025-08-25 | ||||
| 12 | broker_phone_number | STRING | NULLABLE | 2025-08-25 | ||||
| 13 | broker_fax | STRING | NULLABLE | 2025-08-25 | ||||
| 14 | broker_email | STRING | NULLABLE | 2025-08-25 | ||||
| 15 | broker_website_url | STRING | NULLABLE | 2025-08-25 | ||||
| 16 | primary_contact_full_name | STRING | NULLABLE | 2025-08-25 | ||||
| 17 | primary_contact_email | STRING | NULLABLE | 2025-08-25 | ||||
| 18 | primary_contact_phone_number | STRING | NULLABLE | 2025-08-25 | ||||
| 19 | is_active | BOOLEAN | NULLABLE | 2025-08-25 | TRUE if broker is enabled in Lead Portal | |||
| 20 | updated_at_ts | TIMESTAMP | NULLABLE | 2025-08-25 | ||||
| 21 | created_at_ts | TIMESTAMP | NULLABLE | 2025-08-25 |