Financial Advisers Dataset - Current
Financial Advisers Dataset extract as at 09/05/2024 06:38
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| REGISTER_NAME | text | ||
| ADV_NAME | text | ||
| ADV_NUMBER | text | ||
| ADV_ROLE | text | ||
| ADV_SUB_TYPE | text | ||
| ADV_ROLE_STATUS | text | ||
| ADV_ABN | text | ||
| ADV_FIRST_PROVIDED_ADVICE | text | ||
| LICENCE_NAME | text | ||
| LICENCE_NUMBER | text | ||
| LICENCE_ABN | text | ||
| LICENCE_CONTROLLED_BY | text | ||
| ADV_START_DT | text | ||
| ADV_END_DT | text | ||
| ADV_CPD_FAILURE_YEAR | text | ||
| ADV_ADD_LOCAL | text | ||
| ADV_ADD_STATE | text | ||
| ADV_ADD_PCODE | text | ||
| ADV_ADD_COUNTRY | text | ||
| REP_APPOINTED_BY | text | ||
| REP_APPOINTED_NUM | text | ||
| REP_APPOINTED_ABN | text | ||
| ADV_DA_START_DT | text | ||
| ADV_DA_END_DT | text | ||
| ADV_DA_TYPE | text | ||
| FIN | text | ||
| FIN_CARBUNIT | text | ||
| FIN_DEPPAY_DPNONBAS | text | ||
| FIN_DEPPAY_DPNONCSH | text | ||
| FIN_DERIV | text | ||
| FIN_DERIV_DERWOOL | text | ||
| FIN_DERIV_DERELEC | text | ||
| FIN_DERIV_DERGRAIN | text | ||
| FIN_FOREXCH | text | ||
| FIN_GOVDEB | text | ||
| FIN_LIFEPROD_LIFEINV | text | ||
| FIN_LIFEPROD_LIFERISK | text | ||
| FIN_LIFEPROD_LIFERISK_LIFECONS | text | ||
| FIN_MINV_MIEXCLUDEIDPS | text | ||
| FIN_MINV_MIINCLUDEIDPS | text | ||
| FIN_MINV_MIIDPSONLY | text | ||
| FIN_MINV_MIOWN | text | ||
| FIN_MINV_MIHORSE | text | ||
| FIN_MINV_MITIME | text | ||
| FIN_MINV_IMIS | text | ||
| FIN_RSA | text | ||
| FIN_SECUR | text | ||
| FIN_SUPER | text | ||
| FIN_SUPER_SMSUPER | text | ||
| FIN_SUPER_SUPERHOLD | text | ||
| FIN_STDMARGLEND | text | ||
| FIN_NONSTDMARGLEND | text | ||
| FIN_AUSCARBCRDUNIT | text | ||
| FIN_ELIGINTREMSUNIT | text | ||
| FIN_MISFIN_MISMDA | text | ||
| FIN_MISFIN_MISFINRP | text | ||
| FIN_MISFIN_MISFINIP | text | ||
| FIN_FHSANONADIDUMMY | text | ||
| CLASSES_SECUR | text | ||
| CLASSES_SMIS | text | ||
| CLASSES_LIFEPROD_LIFERISK | text | ||
| CLASSES_SUPER | text | ||
| FIN_DERIV_LAWSECURITIES | text | ||
| FIN_DERIV_LAWFUTURE | text | ||
| FIN_MINV | text | ||
| FIN_SECURALL_SECURDEBENT | text | ||
| FIN_SECURALL | text | ||
| QUALIFICATIONS_AND_TRAINING | text | ||
| ADV_APPROVED_QUAL | text | ||
| MEMBERSHIPS | text | ||
| FURTHER_RESTRICTIONS | text | ||
| ABLE_TO_PROVIDE_TFAS | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | May 8, 2024 |
| Metadata last updated | May 8, 2024 |
| Metadata last updated | May 8, 2024 |
| Created | unknown |
| Format | XLSX |
| License | Creative Commons Attribution 3.0 Australia |
| Datastore active | True |
| Datastore contains all records of source file | False |
| Has views | True |
| Hash | 9a0c0a9d695b09f600cb938cee8b0a42 |
| Id | 85b96ed1-8e2a-4acc-a97f-90ade10a578a |
| Last modified | 09/05/2024 06:38 |
| Mimetype | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| Package id | f2b7c2c1-f4ef-4ae9-aba5-45c19e4d3038 |
| Position | 2 |
| Size | 9.7 MiB |
| State | active |
| Url type | upload |
| Zip extract | False |
| Media type | unknown |
| Size | unknown |
| Has views | True |
| ID | 85b96ed1-8e2a-4acc-a97f-90ade10a578a |
| On same domain | False |
| Package ID | f2b7c2c1-f4ef-4ae9-aba5-45c19e4d3038 |
| State | active |
| URL type | upload |