Dataset Fields A-Z

This is a list of all fields that exist within the Mydex API.

If you can't see the field that you are looking for, you can reach us on our support channels, or just send an email to support@mydex.org


Datasets

Try typing into the fields below to filter a column to show matching rows :

Display Name Data Set Field Name Data Type Field Description Field Example
Date Created Assurance Log assurance_created int The timestamp of the created Assurance record.
Data Used Assurance Log assurance_data_used varchar The actual data used to gain the assurance level.
IDP Assurance Log assurance_idp varchar The IDP of the assurance record.
Assurance Level Assurance Log assurance_level int The level of assurance.
Matching Datasets Assurance Log assurance_matching_datasets varchar The matching datasets used for the assurance level.
PID Assurance Log assurance_pid varchar The PID of the record (GOV.UK Assurance).
Assurance Log ID Assurance Log id serial The primary identifier for Assurance record.
Assurance Log Instance Assurance Log instance int The instance this transaction relates to.
Assurance Log Source Assurance Log source varchar The source of the data - user or connection.
Account Name Bank Account field_ba_account_name text The members account name Mr Joe Bloggs
Account Number Bank Account field_ba_account_number text The members account number 12345678
Bank Name Bank Account field_ba_bank_name text The name of the members bank HSBC
Branch Bank Account field_ba_branch text The members branch name Watford
Branch Address Country Bank Account field_ba_branch_country text The bank country England
Branch Address County Bank Account field_ba_branch_county text The bank county Essex
Branch Address PostCode Bank Account field_ba_branch_postcode text The bank postcode NB1 1AZ
Branch Address Street Bank Account field_ba_branch_street text The bank street name and building name/ number 1 High Street
Branch Address Telephone Bank Account field_ba_branch_telephone text The bank telephone number (44) 01234 123456
Branch Address Town Bank Account field_ba_branch_town text The bank town Watford
Current Balance Bank Account field_ba_current_balance currency The current balance on the account 23.45
Date From Bank Account field_ba_date_from date The date the member opened the account 29222
Date To Bank Account field_ba_date_to date The date the member closed the account 29222
Overdraft Limit Bank Account field_ba_overdraft_limit currency The overdraft limit on the account 200
Sort Code Bank Account field_ba_sort_code text The sort code on the members account xx-xx-xx
Type Bank Account field_ba_type text The type of bank account held by the member Savings
Transactions Date Bank Account Transactions ba_transaction_date date The date of the transaction 29222
Transactions Description Bank Account Transactions ba_transaction_description text The transaction description Salary
Transactions Transaction Type Bank Account Transactions ba_transaction_type text The type of transaction Direct Debit
Transactions Value Bank Account Transactions ba_transaction_value currency The value of the transaction 111.11
Currency Code Bank Account Transactions ba_transaction_value_currency_code text Currency code for the transaction GBP
Bank Account Transaction ID Bank Account Transactions id number The primary identifier for this record. 5
Bank Account Transaction Instance Bank Account Transactions instance number The instance this transaction relates to. 8
Bank Account Transaction Source Bank Account Transactions source text The source of the data - user or connection.
Bookmark Annotation Bookmarks bookmark_annotation text Any user annotations against the bookmark Great stuff.
Browser Bookmarks bookmark_browser varchar The browser this bookmark was captured on.
Bookmark Created Bookmarks bookmark_created date The date the bookmark was originally saved 1343844034
Bookmark Description Bookmarks bookmark_description text The description of tthe bookmark The Space is a digital arts service from Arts Council England and the BBC, bringing great theatre, concerts, opera, dance, film and more to every screen.
Device Name Bookmarks bookmark_device_name varchar The name of the device this bookmark was captured on.
Bookmark Media Duration Bookmarks bookmark_duration text If the media type is video, this stores the duration / length 0.458321759259259
Bookmark Media Height Bookmarks bookmark_height text If the media type is image or video, this stores the height of the asset 400px
Bookmark Media Type Bookmarks bookmark_media_type text The media type of the bookmark. One of ‘image’, ‘video’ and ‘page’ currently. page
Bookmark Modified Bookmarks bookmark_modified date The date the bookmark was last updated 1343844034
Tab Bookmarks bookmark_tab varchar The tab this bookmark was captured on.
Bookmark Tags Bookmarks bookmark_tags text The tags associated with the bookmark arts, media
Bookmark Title Bookmarks bookmark_title text The title of the bookmark. Usually grabbed from the page’s title. The Space
Bookmark URL Bookmarks bookmark_url text The url of the bookmark. Could be either a page URL, or a media path e.g. image / video / audio / file http://thespace.org/
Bookmark Media Width Bookmarks bookmark_width text If the media type is image or video, this stores the width of the asset 800px
Bookmark ID Bookmarks id number The primary identifier for this record. 5
Bookmark Instance Bookmarks instance number The instance this transaction relates to. 8
Bookmark Source Bookmarks source text The source of the data - user or connection.
Browser Browsing History browsing_history_browser varchar The browser this bookmark was captured on.
Device Name Browsing History browsing_history_device_name varchar The name of the device this bookmark was captured on.
Tab Browsing History browsing_history_tab varchar The tab this bookmark was captured on.
Browsing History Title Browsing History browsing_history_title text The title of the web page. The Space
Browsing History URL Browsing History browsing_history_url text The url used. http://thespace.org/
Browsing History Visit Date Browsing History browsing_history_visit_date date The date when the web page was visited. 1343844034
Browsing History ID Browsing History id number The primary identifier for this record. 5
Browsing History Instance Browsing History instance number The instance this transaction relates to. 8
Browsing History Source Browsing History source text The source of the data - user or connection.
About Me Community Profile field_cp_about_me
Community Roles Community Profile field_cp_community_roles
Community Membership Preferences Community Profile field_cp_com_membership_prefs
Display Name Community Profile field_cp_display_name
Website Community Profile field_cp_website
Credentials Instance Credentials instance int The instance this record relates to.
Credentials Source Credentials source varchar The source of the data - user or connection.
Transactions Date Credit Card cc_transaction_date date The date of the transaction 29222
Transactions Transaction Type Credit Card cc_transaction_type text The type of transaction
Account Name Credit Card field_cc_account_name text The members surname on the card Jones
Account Number Credit Card field_cc_account_number text The account number 12345678
Card Type Credit Card field_cc_card_type text The type of credit card VISA
Contact Address Country Credit Card field_cc_contact_country text The members contact country England
Contact Address County Credit Card field_cc_contact_county text The members contact county Essex
Contact Address PostCode Credit Card field_cc_contact_postcode text The members contact postcode NB1 1AZ
Contact Address Street Credit Card field_cc_contact_street text The member contact house number and street name 1 High Street
Contact Address Telephone Credit Card field_cc_contact_telephone text The members contact telephone number (44) 01234 123456
Contact Address Town Credit Card field_cc_contact_town text The members contact town Watford
Credit Limit Credit Card field_cc_credit_limit currency The credit limit 2000
Balance Credit Card field_cc_current_balance currency The current balance of the credit card 245.67
Date From Credit Card field_cc_date_from date The date the member opened the account 29222
Date To Credit Card field_cc_date_to date The date the member closed the account 29222
Supplier Credit Card field_cc_supplier text The credit card supplier HSBC
Transactions Description Credit Card Transactions cc_transaction_description text The transaction description Cash
Transactions Value Credit Card Transactions cc_transaction_value currency The value of the transaction 111.11
Currency Code Credit Card Transactions cc_transaction_value_currency_code text Currency code for the transaction GBP
Credit Card Transactions ID Credit Card Transactions id number The primary identifier for this record. 5
Credit Card Transactions Instance Credit Card Transactions instance number The instance this transaction relates to. 8
Credit Card Transactions Source Credit Card Transactions source text The source of the data - user or connection.
Developer Namespace Developer Namespace field_dn_serialised_json text Any serialised JSON value { "example" : "json", "data" : { "something" : "json" } }
App Name Device App Settings app_setting_app_name varchar The name of the app.
Device Name Device App Settings app_setting_device_name varchar The name of the Device.
Setting Name Device App Settings app_setting_name varchar The name of the variable.
Setting Type Device App Settings app_setting_type varchar The type of setting. Value, Boolean (yes/no, on/off), Range (0 100 45).
Setting Value Device App Settings app_setting_value varchar The value/status of the variable.
Device App Settings ID Device App Settings id serial The primary identifier for a device record.
Device App Settings Instance Device App Settings instance int Instance - only because the API expects an instance.
Device App Settings Source Device App Settings source varchar The source of the data - user or connection.
IMEI Device Record device_imei varchar The IMEI of the device.
MAC Address Device Record device_mac_address varchar The MAC Address of the device.
Model Number Device Record device_model_number varchar The model number of the device.
Name Device Record device_name varchar Device Name.
Phone Number Device Record device_phone_number varchar The phone number of the device.
Serial Number Device Record device_serial_number varchar The serial number of the device.
Software Version Number Device Record device_software_version_number varchar The software version number the device is running.
Type Device Record device_type varchar Device Type.
Device Record ID Device Record id serial The primary identifier for a device record.
Device Record Instance Device Record instance int The instance this device record relates to.
Device Record Source Device Record source varchar The source of the data - user or connection (uid or con_id).
Date Of Birth Driving Licence field_dl_dob date The members date of birth 29222
Expiry Alert Driving Licence field_dl_expiry_alert date
Groups Driving Licence field_dl_groups field_collection_table
Category Driving Licence field_dl_groups_category text
Date From Driving Licence field_dl_group_date_from date
Date To Driving Licence field_dl_group_date_to date
Issue Country Driving Licence field_dl_issue_country text United Kingdom
Issuing Authority Driving Licence field_dl_issuing_authority text The authority that issued the members driving licence DVLA
Licence Number Driving Licence field_dl_licence_number text The members driving licence number 888  8888 888
Other Names Driving Licence field_dl_other_names text The member's surname Jones
Place Of Birth Driving Licence field_dl_pob text The Country in which the member was born England
Surname Driving Licence field_dl_surname text The members surname Jones
Valid From Driving Licence field_dl_valid_from date The date from which the members driving dicence is Valid 29222
Valid To Driving Licence field_dl_valid_to date The expiry date of the members driving licence 29222
Address Country Education field_edu_country text The establishment country England
Address County Education field_edu_county text The establishment county Essex
Courses Education field_edu_courses field_collection_embed
Date Education field_edu_course_date date The date the member was awarded the qualification 29222
Level Education field_edu_course_level text The level of the course A Level
Mode Of Study Education field_edu_course_mode_of_study text The mode of study for the course Full Time
Name Education field_edu_course_name text The name of the course the member undertook Computer Science
Results Attained Education field_edu_course_results text The grades awarded Pass
Address DateFrom Education field_edu_date_from date The date the member started at the establishment 29222
Address DateTo Education field_edu_date_to date The date the member left the establishment 29222
Establishment Name Education field_edu_establishment_name text The name of the establishment Kings School
Address PostCode Education field_edu_postcode text The establishment postcode NB1 1AZ
Address Street Education field_edu_street text The establishment street name and building name/ number 1 High Street
Address Telephone Education field_edu_telephone text The establishment telephone number (44) 01234 123456
Address Town Education field_edu_town text The establishment town Watford
Type Education field_edu_type text The type of establishment School
Address URL Education field_edu_url text The establishment URL www.name.com
Employee ID Employer field_emp_employee_id text The member's employee ID
Employer Name Employer field_emp_employer_name text The name of the member's employer
End Date Employer field_emp_end_date date The member's end date of employment
Job Title Employer field_emp_job_title text The member's job title
Salary Employer field_emp_salary number The member's salary
Start Date Employer field_emp_start_date date The member's start date of employment
GP Details Country Health field_health_gp_country text The country of the member's GP
GP Details County Health field_health_gp_county text The county of the member's GP
GP Details Email Health field_health_gp_email text The email address of the member's GP
GP Details Fax Health field_health_gp_fax text The fax address of the member's GP
GP Details GP Name Health field_health_gp_name text The name of the member's GP
GP Details Postcode Health field_health_gp_postcode text The postcode of the member's GP
GP Details Street Health field_health_gp_street text The street address of the member's GP
GP Details Telephone Health field_health_gp_telephone text The telephone number of the member's GP
GP Details Town Health field_health_gp_town text The town of the member's GP
NHS Number Health field_health_nhs_number text The member's NHS number
Social Care ID Health field_health_social_care_id text The member's social care ID
Bedrooms Home field_home_bedrooms number The number of bedrooms in the member's home 3
Country Home field_home_country text The member's home country England
County Home field_home_county text The member's home county Essex
Date From Home field_home_date_from date The date the member moved in 29222
Date To Home field_home_date_to date The date the member moved out 29222
Habitable Rooms Home field_home_habitable_rooms number The number of habitable rooms in the member's home 5
National Property Gazetteer Reference Home field_home_nlpg text The National Property Gazetteer reference number
Number of Residents Home field_home_num_residents number The number of residents in the member's home 4
Landlord Address Country Home field_home_owner_country text The owner / landlord's country United Kingdom
Landlord Address County Home field_home_owner_county text The owner / landlord's county Anycounty
Email Address Home field_home_owner_email_address text email address for the owner / landlord landlord@ .....
Name Home field_home_owner_name text Name of the property owner / landlord I. M. Landlord
Landlord Address Post Code Home field_home_owner_postcode text The owner / landlord's post code AB12 3CD
Landlord Address Street Home field_home_owner_street text The owner / landlord's house number and street name 100 High Street
Telephone Number Home field_home_owner_telephone_no text Contact telephone number for the owner / landlord 07890 123456
Landlord Address Town Home field_home_owner_town text The owner / landlord's town Anytown
Post Code Home field_home_postcode text The member's home postcode NB1 1AZ
Property Type Home field_home_property_type text The type of property the member lives in Flat
Street Home field_home_street text The member home house number and street name 1 High Street
Tenancy Home field_home_tenancy text The type of tenancy Lodger
Town Home field_home_town text The member's home town Watford
Identity Protocol Settings ID Identity Protocol Settings id serial The primary identifier for Identity Service protocol.
Name Identity Protocol Settings identity_protocol varchar The name of the Identity protocol.
Email Setting Identity Protocol Settings identity_protocol_email_setting int The email preference for this protocol.
Email Setting Text Identity Protocol Settings identity_protocol_email_setting_text varchar This will either be an email address or message text.
ID Identity Protocol Settings identity_protocol_id varchar The ID used with this protocol.
Status Identity Protocol Settings identity_protocol_status int Whether Identity protocol is enabled.
Identity Protocol Settings Instance Identity Protocol Settings instance int The instance this transaction relates to.
Identity Protocol Settings Source Identity Protocol Settings source varchar The source of the data - user or connection.
Status Identity Services identity_service_status int Boolean indicating whether the Identity was successfully used.
Title Identity Services identity_service_title varchar The Identity Service Title.
Journey ID Journeys id number The primary identifier for this record. 5
Journey Instance Journeys instance number The instance this transaction relates to. 8
Transactions Date Journeys journey_date date Date of the journey
Transactions Derstination Journeys journey_destination text Journey destination
Transactions End Time Journeys journey_end_time time Journey end time
Transactions Origin Journeys journey_origin text Origin of journey
Transactions Start Time Journeys journey_start_time time Journey start time
Transactions Transaction Value Journeys journey_transaction_value number Journey transaction value
Journey Source Journeys source text The source of the data - user or connection.
Authority Name Local Authority field_la_authority_name text The name of the member's local authority East Herts Council
Council Tax Band Local Authority field_la_council_tax_band text The Council Tax band D
Council Address Country Local Authority field_la_country text The council country England
Council Address County Local Authority field_la_county text The council county Essex
Date From Local Authority field_la_date_from date The date the member moved into the area 29222
Date To Local Authority field_la_date_to date The date the member left the area 29222
Council Address eMail Local Authority field_la_email text The council email address name@council.gov
Council Address Fax Local Authority field_la_fax text The council fax number (44) 01234 123456
Council Address PostCode Local Authority field_la_postcode text The council postcode NB1 1AZ
Council Address Street Local Authority field_la_street text The council street name and building name/ number 1 High Street
Council Address Telephone Local Authority field_la_telephone text The council telephone number (44) 01234 123456
Council Address Town Local Authority field_la_town text The council town Watford
My Contact Details eMail Local Authority field_la_user_email text The members email address registered with the council name@emailprovider.com
My Contact Details Mobile Local Authority field_la_user_mobile text The members telephone number (44) 01234 123456
My Contact Details Telephone Local Authority field_la_user_telephone text The members telephone number (44) 01234 123456
Location Data ID Location Data id serial The primary identifier for a location data record.
Location Data Instance Location Data instance int The instance this location data record relates to.
Address Line 1 Location Data location_data_address1 varchar The address line 1.
Address Line 2 Location Data location_data_address2 varchar The address line 2.
App Name Location Data location_data_app_name varchar The app name creating the location data record.
Country Location Data location_data_country varchar The address country.
County Location Data location_data_county varchar The address county.
Device Name Location Data location_data_device_name varchar The device name creating the location data record.
Latitude Location Data location_data_latitude numeric The latitude of the location.
Longitude Location Data location_data_longitude numeric The longitude of the location.
Postcode Location Data location_data_postcode varchar The address postcode.
Timestamp Location Data location_data_timestamp int The timestamp the location data was created.
Timezone Location Data location_data_timezone varchar The timezone the location data was created.
Town/City Location Data location_data_towncity varchar The address town/city.
Location Data Source Location Data source varchar The source of the data - user or connection (uid or con_id).
Card Number Loyalty Scheme field_ls_card_number
Country Loyalty Scheme field_ls_country
County Loyalty Scheme field_ls_county
Date of Birth Loyalty Scheme field_ls_dob Format: dd-mm-yyyy
Email Loyalty Scheme field_ls_email
Email Location Loyalty Scheme field_ls_email_location
Fax Loyalty Scheme field_ls_fax
Gender Loyalty Scheme field_ls_gender
Home Phone Number Loyalty Scheme field_ls_home_phone_number
Mobile Phone Number Loyalty Scheme field_ls_mobile_phone_number
Name Loyalty Scheme field_ls_name
Name on Card Loyalty Scheme field_ls_name_on_card
Postcode Loyalty Scheme field_ls_postcode
Preferred Number Loyalty Scheme field_ls_preferred_number
Street Loyalty Scheme field_ls_street
Town Loyalty Scheme field_ls_town
Work Phone Number Loyalty Scheme field_ls_work_phone_number
Loyalty Scheme ID Loyalty Scheme id number The primary identifier for this record. 5
Loyalty Scheme Instance Loyalty Scheme instance number The instance this transaction relates to. 8
Transactions Date Loyalty Scheme ls_date date Date of the transaction
Transactions Description Loyalty Scheme ls_description text Description of the transaction Sainsbury's - Horsham
Transactions Monetary Value Loyalty Scheme ls_monetary_value currency Monetary velaue of the transaction
Transactions Currency Code Loyalty Scheme ls_monetary_value_currency_code text Currency code for the transaction GBP
Transactions Points Value Loyalty Scheme ls_points_value number Points value for the transaction
Loyalty Scheme Source Loyalty Scheme source text The source of the data - user or connection.
Name National Insurance field_ni_name text The member's surname Jones
Number National Insurance field_ni_number text A member's NI Number XX XXXXX X
Notepad Content Notepad field_notepad_content text
Notepad Last Updated Notepad field_notepad_last_updated date
Code Passport field_pp_code text
Date Of Expiry Passport field_pp_date_expiry date The expiry date of the members passport 29222
Date Of Issue Passport field_pp_date_issue date The date from which the members passport is Valid 29222
Date Of Birth Passport field_pp_dob date The members date of birth 29222
Expiry Alert Passport field_pp_expiry_alert date
Given Names Passport field_pp_given_names text The member's first name Catherine
Issuing Authority Passport field_pp_issuing_authority text The authority that issued the members passport UKBA
Nationality Passport field_pp_nationality text The members nationality British
Number Passport field_pp_number text The members passport number 123456789
Place Of Birth Passport field_pp_place_of_birth text The city in which the member was born Manchester
Sex Passport field_pp_sex text The gender of the member Female
Surname Passport field_pp_surname text The members surname Jones
Type Passport field_pp_type text
Email Address Personal details field_personal_email_address text The member's primary email address katherinetsmithy@gmail.com
Family Name Personal details field_personal_faname text The member's surname Jones
First Name Personal details field_personal_fname text The member's first name Catherine
Gender Personal details field_personal_gender text The member's gender Female
Home Phone Personal details field_personal_home_phone text The member's home telephone number 01234 123456
Maiden Name Personal details field_personal_maname text The member's surname Jones
Marital Status Personal details field_personal_marital_status text The member's marital status Married
Middle Name Personal details field_personal_mname text The middle name of the member Anne
Mobile Phone Personal details field_personal_mobile_phone text The member's mobile telephone number 07654 321098
Nickname Personal details field_personal_nickname text The member's first name Catherine
No of Children Personal details field_personal_number_children number The number of children the member has 2
Suffix Personal details field_personal_suffix text The member's surname Jones
Title Personal details field_personal_title text The member's preferred prefix title Mr
Work Phone Personal details field_personal_work_phone text The member's work telephone number (44) 1357 246802
Country Place of Birth field_birth_country text The Country in which the member was born England
Date Of Birth Place of Birth field_birth_dob date The member's date of birth 29222
Nationality Place of Birth field_birth_nationality text The member's nationality British
Town Place of Birth field_birth_town text The town in which the member was born Manchester
Telephone Calls ID Telephone Calls and SMS id number The primary identifier for this record. 5
Telephone Calls Instance Telephone Calls and SMS instance number The instance this transaction relates to. 8
Telephone Calls Source Telephone Calls and SMS source text The source of the data - user or connection.
Telecoms Transactions Charge Type Telephone Calls and SMS utility_tel_call_charge_type text The charge type Included
Telecoms Transactions Cost Telephone Calls and SMS utility_tel_call_cost currency The cost of the transaction/ call 122.22
Currency Code Telephone Calls and SMS utility_tel_call_currency_code text Currency code for the transaction GBP
Telecoms Transactions Date Telephone Calls and SMS utility_tel_call_date date The date of the transaction 29222
Telecoms Transactions Duration Telephone Calls and SMS utility_tel_call_duration time The duration of the call 0.050138888888889
Incoming/Outgoing Telephone Calls and SMS utility_tel_call_incoming_outgoing varchar Is this record an incoming or outgoing call/sms.
Telecoms Transactions Number Called Telephone Calls and SMS utility_tel_call_number_called text The telephone number called in the transaction (44) 01234 123456
Telecoms Transactions Transaction Type Telephone Calls and SMS utility_tel_call_type text The type of transaction Call or SMS
Card Number Travel Card field_tr_card_number text The member's travel card number
Card Type Travel Card field_tr_card_type text The member's travel card type
Current Balance Travel Card field_tr_current_balance number Current balance of the member's travel card
County TV Licence field_tv_licence_county text The members home county Essex
TV Licence Fee TV Licence field_tv_licence_fee number The TV licence fee
Licence Holder's Name TV Licence field_tv_licence_holders_name text The name of licence holder Catherine Jones
TV Licence Number TV Licence field_tv_licence_number text The TV licence number
Payment Frequency TV Licence field_tv_licence_payment_freq text The TV licence payment frequency
Payment Method TV Licence field_tv_licence_payment_method text The TV licence payment method
Post Code TV Licence field_tv_licence_post_code text The members home postcode NB1 1AZ
Street TV Licence field_tv_licence_street text The member home house number and street name 1 High Street
Town TV Licence field_tv_licence_town text The members home town Watford
TV Licence Type TV Licence field_tv_licence_type text The TV licence type
Valid Until TV Licence field_tv_licence_valid_until date The expiration date of the TV licence
Tariff Utility field_utility_tariff text Tariff or plan basis for consumption
Tel Number Utility field_utility_tel_number text The members telephone number (44) 01234 123456
Account Name Utility Account Details field_utility_account_name text The members surname Jones
Account Type Utility Account Details field_utility_account_type text The type of utility account held by the member Pay as you go
Billing Address Country Utility Account Details field_utility_billing_country text The members home country England
Billing Address County Utility Account Details field_utility_billing_county text The members home county Essex
Billing Address PostCode Utility Account Details field_utility_billing_postcode text The members home postcode NB1 1AZ
Billing Address Street Utility Account Details field_utility_billing_street text The member home house number and street name 1 High Street
Billing Address Town Utility Account Details field_utility_billing_town text The members home town Watford
Contact Address Country Utility Account Details field_utility_contact_country text The utility company country England
Contact Address County Utility Account Details field_utility_contact_county text The utility company county Essex
Contact Address eMail Utility Account Details field_utility_contact_email text The utility company email address name@utilityprovider.com
Contact Address Fax Utility Account Details field_utility_contact_fax text The utility company fax number (44) 01234 123456
Contact Address Contact Name Utility Account Details field_utility_contact_name text The name of the contact at the utility company Fred Bloggs
Contact Address PostCode Utility Account Details field_utility_contact_postcode text The utility company postcode NB1 1AZ
Contact Address Street Utility Account Details field_utility_contact_street text The utility company street name and building name/ number 1 High Street
Contact Address Telephone Utility Account Details field_utility_contact_telephone text The utility company telephone number (44) 01234 123456
Contact Address Town Utility Account Details field_utility_contact_town text The utility company town Watford
Customer No Utility Account Details field_utility_customer_num text The members customer account number for the utility supply 12345678
Date From Utility Account Details field_utility_date_from date The date supply commenced 29222
Date To Utility Account Details field_utility_date_to date The date supply ceased 29222
Payment Method Utility Account Details field_utility_payment_method text The payment method used by the member Direct Debit
Service Utility Account Details field_utility_service text The utility service supplied to the member Gas
Supplied Address Country Utility Account Details field_utility_supplied_country text The members home country England
Supplied Address County Utility Account Details field_utility_supplied_county text The members home county Essex
Supplied Address PostCode Utility Account Details field_utility_supplied_postcode text The members home postcode NB1 1AZ
Supplied Address Street Utility Account Details field_utility_supplied_street text The member supplied house number and street name 1 High Street
Supplied Address Town Utility Account Details field_utility_supplied_town text The members home town Watford
Supplier Name Utility Account Details field_utility_supplier_name text The utility service supplier British Gas
Utility Billing ID Utility Billing Records id number The primary identifier for this record. 5
Utility Billing Instance Utility Billing Records instance number The instance this transaction relates to. 8
Utility Billing Source Utility Billing Records source text The source of the data - user or connection.
Utility Transactions Billing Period End Utility Billing Records utility_billing_end date The end of the billing period
Utility Transactions Billing Period Start Utility Billing Records utility_billing_start date The start of the billing period
Utility Transactions Cost Utility Billing Records utility_billing_total currency The cost of the transaction/ call 122.22
Currency Code Utility Billing Records utility_billing_total_currency_code text Currency code for the transaction GBP
Data Usage ID Utility Data Usage id number The primary identifier for this record. 5
Data Usage Instance Utility Data Usage instance number The instance this transaction relates to. 8
Data Usage Source Utility Data Usage source text The source of the data - user or connection.
Data Transactions Charge Type Utility Data Usage utility_data_usage_charge_type text The charge type Included
Data Transactions Cost Utility Data Usage utility_data_usage_cost currency The cost 12.45
Currency Code Utility Data Usage utility_data_usage_currency_code text Currency code for the transaction GBP
Data Transactions Data Used Utility Data Usage utility_data_usage_data_used number Amonut of data used 2MB
Data Transactions Date Utility Data Usage utility_data_usage_date date The date of the transaction 41254
Meter Reading ID Utility Meter Reading id number The primary identifier for this record. 5
Utility Meter Reading Instance Utility Meter Reading instance number The instance this transaction relates to. 8
Utility Meter Reading Source Utility Meter Reading source text The source of the data - user or connection.
Utility Transactions Meter Reading Utility Meter Reading utility_reading number The value of the meter reading
Utility Transactions Meter Read Date Utility Meter Reading utility_reading_date date The date on which the meter was read
Utility Transactions Estimated Utility Meter Reading utility_reading_estimated varchar Boolean indicating whether the meter reading is estimated. Y/N
Utility Transactions Read By Utility Meter Reading utility_reading_read_by varchar How the meter was read Auto
Meter Reading Type Utility Meter Reading utility_reading_type varchar The type of meter reading (helps to distinguish on mixed bills).
Utility Transactions Metering Unit Utility Meter Reading utility_reading_unit text The units read by the meter kWh
Variables ID Variables id serial ID - So the API can return multiple variables at once.
Variables Instance Variables instance int Instance - only because the API expects an instance.
Name Variables var_name varchar The name of the variable.
Value Variables var_value blob The value of the variable stored serialized in a blob.
Body Type Vehicle field_ve_body_type text Vehicle body type
Colour Vehicle field_ve_colour text Vehicle body colour
Contact Address Country Vehicle field_ve_contact_country text The members contact country England
Contact Address County Vehicle field_ve_contact_county text The members contact county Essex
Contact Address PostCode Vehicle field_ve_contact_postcode text The members contact postcode NB1 1AZ
Contact Address Street Vehicle field_ve_contact_street text The member contact house number and street name 1 High Street
Contact Address Town Vehicle field_ve_contact_town text The members contact town Watford
Cylinder Capacity Vehicle field_ve_cylinder_capacity text Cylinder capacity
Date of First Registration Vehicle field_ve_date_first_registration date Date of vehicle's first registration
V5C Document Reference Number Vehicle field_ve_document_ref_number text Vehicle document reference number
Engine Number Vehicle field_ve_engine_number text Engine number
Make Vehicle field_ve_make text Vehicle make
Model/Type Vehicle field_ve_model_type text Model/type
Registered Keeper Vehicle field_ve_registered_keeper text The registered keeper of the vehicle
Registration Mark Vehicle field_ve_registration_mark text Registration number
Taxation Class Vehicle field_ve_taxation_class text The vehicle's taxation class
Type of Fuel Vehicle field_ve_type_of_fuel text Fuel type
Vehicle Mileage Vehicle field_ve_vehicle_mileage number The vehicle's mileage
VIN/Chassis/Frame No Vehicle field_ve_vin_chassis_frame_no text Vehicle identification no. (VIN)
Wheel Plan Vehicle field_ve_wheel_plan text Wheel plan
CRB CRB Number Voluntary field_vol_crb_number text The member's CRB number
CRB Date of Expiry Voluntary field_vol_date_of_expiry date The expiration date of the CRB
CRB Expiry Alert Voluntary field_vol_expiry_alert date The expiration alert date of the CRB
Host Organisation Voluntary field_vol_host_organisation text The host organisation name
ID Number Voluntary field_vol_id_number text The member's ID number
Notes Voluntary field_vol_notes text Additional notes
Contact Address Country Voluntary field_vol_organisation_country text The contact address country
Contact Address County Voluntary field_vol_organisation_county text The contact address county
Organisation Name Voluntary field_vol_organisation_name text The name of the organisation
Contact Address Postcode Voluntary field_vol_organisation_postcode text The contact address postcode
Contact Address Street Voluntary field_vol_organisation_street text The contact address street
Contact Address Town Voluntary field_vol_organisation_town text The contact address town
Place of Activity Voluntary field_vol_place_of_activity text The volunteering place of activity
Volunteering Pathway Voluntary field_vol_volunteering_pathway text Volunteering pathway
Volunteer Hours Voluntary field_vol_volunteer_hours text The member's volunteering hours
Volunteer Role Voluntary field_vol_volunteer_role text The member's volunteer role