FCT_ASIC516_BROKER_EVENT_DASHBOARD_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | AGGREGATOR_NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 2 | I_CODE | CHARACTER VARYING(6) | 6 |
| 3 | A_CODE | CHARACTER(7) | 7 |
| 4 | BROKER_NAME | CHARACTER VARYING(511) | 511 |
| 5 | BROKER_BUSINESS_NAME | CHARACTER VARYING(100) | 100 |
| 6 | BROKER_GIVEN_NAMES | CHARACTER VARYING(255) | 255 |
| 7 | BROKER_SURNAME | CHARACTER VARYING(255) | 255 |
| 8 | BROKER_STATE | CHARACTER VARYING(3) | 3 |
| 9 | UNIQUE_IDENTIFIER | CHARACTER VARYING(255) | 255 |
| 10 | LICENSE_TYPE | NATIONAL CHARACTER VARYING(15) | 15 |
| 11 | STATUS_CHANGE | CHARACTER VARYING(50) | 50 |
| 12 | SUSPENDED_DATE | TIMESTAMP | 8 |
| 13 | BLACKLISTED_DATE | TIMESTAMP | 8 |
| 14 | SUSPENDED_COUNT | INTEGER | 4 |
| 15 | BLACKLISTED_COUNT | INTEGER | 4 |
| 16 | DATA_REFRESH_TIMESTAMP | TIMESTAMP | 8 |