Additional Angle Field Mappings

Residency Status

Field location: Drivers / Finance tab.

Angle Finance field name: visaStatus

Residency Status field mapped to visaStatus. Below are accepted values by Angle Finance.

Accepted Values

visaStatus

Citizen

Permanent Resident

Other

Mappings

Catch-e Residency Status options mapped to Angle Finance:

Residency Status	Angle - visaStatus
null	Other
Citizen	Citizen
Non Resident	Other
Permanent Resident	Other
Visa	Other

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Mapping

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'residency_status' order by tif.table_name, tif.field_name, tift.field_value;

Title

Field location: Drivers / Contact page.

Angle Finance field name: title

Catch-e Salutation field equivalent to Angle Finance Title field. Below are accepted values by Angle Finance.

Accepted Values

title

Mrs

Miss

Sir (not in Catch-e)

Lady (not in Catch-e)

Prof

Reverend

Mappings

Catch-e Salutation options mapped to Angle Finance:

Salutation	Angle - title	Notes
Dr	Dr
Miss	Miss
Mr	Mr
Mrs	Mrs
Ms	Ms
Prof	Prof
Rev	Reverend
Mx	N/A	Will result in failed application
null	N/A	Will result in failed application
Capt	N/A	Will result in failed application

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Mapping (7 Records)

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'salutation' order by tif.table_name, tif.field_name, tift.field_value;

Salutation Count by Mapping

select count(d.driver_id) as drivers, d.salutation, st1.interface_value from fm_drivers as d left join (select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'salutation') as st1 on st1.field_value = d.salutation group by d.salutation order by d.salutation, st1.interface_value;

Mapping Framework

Application sent to Angle Finance must contain data in format their system accepts.

Example: Insurer Name in Catch-e stored as 'ABC Insurance', but Angle requires sent as 'ABC'. Done by mapping system fields to required JSON fields, or using tables to translate system field values into required JSON field values.

Tables populated with default entries based on information provided by Angle Finance at API development.

Translation Mappings

Two tables used to create translation mappings:

[qt_interface_fields] - lists each system table and field requiring translation with matching Angle field
[qt_interface_field_translations] - lists each eligible translation

qt_interface_fields Table

Table stores Angle field_name definition and maps to Catch-e [table]field_name data extracted from. Updates require development. Content shown below accurate at API deployment time.

Interface Type	Interface Field Name	Table Name	Field Name	Translations
angle	industry	fm_client_industries	client_industry_code	1
angle	gender	fm_drivers	gender	4
angle	relationshipStatus	fm_drivers	marital_status	8
angle	visaStatus	fm_drivers	residency_status	5
angle	residentialStatus	fm_drivers	residential_status	6
angle	title	fm_drivers	salutation	7
angle	employmentType	fm_driver_employment_types	driver_employment_type_code	5
angle	occupationType	fm_driver_occupation_codes	driver_occupation_code	1
angle	insurerName	fm_suppliers	supplier_code	20
angle	entityType	gb_corporate_types	corporate_code	16
angle	fuelType	qt_fuel_type_translations	fuel_type_code	10
angle	ESTFEENL	qt_quotes	establishment_fee	0
angle	assetCondition	qt_quotes	new_used	3
angle	ORIGFEE	qt_quotes	originator_fee	0

qt_interface_field_translations Table

Needs populated for each field included in [qt_interface_fields]. Some translations client specific and set up based on existing client data.

Select each interface_field_name in list above to see mapping set up between Catch-e and Angle Finance current at API development time.

Mapping Updates assist if changes required to existing setup.

Useful Queries

Interface Fields and Translation Count

select tif.interface_type, tif.interface_field_name, tif.table_name, tif.field_name, count(tift.interface_field_translation_id) as translations from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id and tift.status_flag = 'active' where tif.interface_type = 'angle' group by tif.table_name, tif.field_name, tif.interface_field_name order by tif.table_name, tif.field_name, tif.interface_field_name;

Angle Interface Asset Condition Mappings

select tif.interface_type, tif.interface_field_name, tift.interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'assetCondition';

Occupation Type

Field location: Drivers / Finances page.

Angle Finance field name: occupationType

Occupation Type field mapped to occupationType. Below are accepted values by Angle Finance.

Accepted Values

occupationType

Clerical

Executive

Office Staff

Other

Professional

Retired

Trade

Mappings

Suggested Occupation Type mapping. 50+ Catch-e occupations mapped to 7 Angle Finance categories:

Occupation Type	Angle - occupationType	Occupation Type	Angle - occupationType
null **	Other	Store/Trans Operator	Other
Apprentice	Trade	Supervisor	Trade
Armed Forces N/O	Other	Surveyor	Professional
Armed Forces - Officer	Other	Teacher - Primary/Nursery	Other
Accountant - Own Practice	Professional	Teacher - Secondary	Other
Accountant - Employment Ind.	Professional	Teacher - Tertiary	Other
Accountant - Employed Own Prac	Professional	Semi-Skilled Tradesperson	Trade
Barrister	Professional	Truck Owner Driver	Trade
Beautician/Barber	Other	Unskilled Labourer	Trade
CSF Above Segment	Other	Medical Pract. - Self Employed	Professional
CSF Below Segment	Other	Jeweller - Employed	Other
Clerical - Public Services	Clerical	Dentist	Professional
Clerical - Non-Government	Clerical	Builder	Trade
Director/Coy Sec - Private Coy	Executive	Veterinarian	Professional
Director/Coy Sec - Public Coy	Executive	Courier	Other
Computer Operator	Professional	Student	Other
Computer Prog/Analyst	Professional	Taxi Driver	Trade
Consultant	Professional	Civil Forces	Other
Tradesmen/Craftsman	Trade	Govt/Public Service	Other
Driver/Courier	Other	Social Security	Other
Qualified Engineer	Professional	Houseperson	Other
Entertainer	Other
Foreman	Trade
Public Service Grade 4+	Other
Inspector	Other
Instructor	Other
Jeweller - Self Employed	Professional
Manager (Junior)	Office Staff
Manager (Senior)	Executive
Medical Practioner (Employed)	Professional
Medical Technician	Professional
Nurse/Medical Worker/Orderly	Other
Nursing Sister	Other
Pilot	Professional
Proprietor 5 Years+	Professional
Proprietor Less than 5 Years	Professional
Radio/Radar Operator	Other
Real Estate Agent	Professional
Restaurant/Hotel Staff	Other
Salesperson	Professional
Scientist/Researcher	Other
Secretarial	Other
Semi-Skilled Labourer	Professional
Senior Civil Servant	Other
Shop Assistant	Trade
Shop Owner	Office Staff
Solicitor	Professional

** If no other mapping matches, null mapping record applied.

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Occupation Type Values

select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'occupationType' GROUP BY tift.interface_value;

Occupation Type List with Mappings

select proper(doc.description) as occupation_type, st1.interface_value, st1.interface_field_name, st1.interface_type, st1.table_name, st1.field_name, st1.field_value from fm_driver_occupation_codes as doc left join (select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'occupationType') as st1 on st1.field_value = doc.driver_occupation_code order by doc.description;

Residential Status

Field location: Drivers / Finances tab.

Angle Finance field name: residentialStatus

Residential Status field mapped to residentialStatus. Below are accepted values by Angle Finance.

Accepted Values

residentialStatus

FullyOwned

Buying

RentingEmployerProvided

LivingWithParents

BoardingOther

Mappings

Catch-e Residential Status options mapped to Angle Finance:

Residential Status	Angle - residentialStatus
Board	BoardingOther
Buying	Buying
Live with Parents	LivingWithParents
Own	FullyOwned
Rent	Unspecified
NULL	Unspecified

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Angle Mapping

select tif.table_name, tif.field_name, tift.field_value, tif.interface_field_name, tift.interface_value from qt_interface_fields as tif left join qt_interface_field_translations as tift on tift.interface_field_id = tif.interface_field_id where tif.interface_type = 'angle' and tift.status_flag = 'active' and tif.field_name = 'residential_status' order by tif.table_name, tif.field_name, tift.field_value;

Financial Circumstances

Driver Income and Expense and Driver Assets and Liabilities field mappings for financialCircumstances section of application JSON.

Income and Expense Fields

Screen Name	Type	Description	JSON Frequency	JSON Description	JSON Type
Current Salary	Num	Gross Annual Income	Annual	Current Salary	Base Salary and Wages
Annual Gross Income	Num	Gross Annual Income	Annual	Annual Gross Income	Base Salary and Wages
Annual Spouse Gross Income	Num	Monthly Net Income	Annual	Annual Spouse Gross Income	Spousal Income
Monthly Net Income	Num	Income details	Monthly	Monthly Net Income	Base Salary and Wages
Monthly Spouse Net Income	Num	Monthly Spouse Net Income	Monthly	Monthly Spouse Net Income	Spousal Income
Monthly Rental Income	Num	Rental Income	Monthly	Monthly Rental Income	Rental Income
Monthly Government Benefits	Num	Monthly Government Benefits received	Monthly	Monthly Government Benefits	Government Benefits / Pensions
Monthly Superannuation Income	Num	Monthly Superannuation Income	Monthly	Monthly Superannuation Income	Interest or Dividend
Monthly Investment Income	Num	Monthly Investment Income	Monthly	Monthly Investment Income	Investment Income
Monthly Other Income	Num	Other Income per month	Monthly	Monthly Other Income	Other Income
Mortgage	Num	Monthly Mortgage	Monthly	Mortgage	Investment Income
Rent	Num	Monthly Rent	Monthly	Rent	Investment Income
Household	Num	Monthly Household	Monthly	Household	Investment Income
Credit Cards	Num	Monthly Credit Card	Monthly	Credit Cards	Investment Income
Private Education / Childcare	Num	Monthly Private Education/Childcare	Monthly	Private Education / Childcare	Education and Childcare
Vehicle	Num	Monthly Vehicle	Monthly	Vehicle	Car and Transport
Other	Num	Other Monthly	Monthly	Other	Other Expenses

Assets and Liabilities Fields

Assets

Screen Name	Type	Description	JSON Frequency	JSON Description	JSON Type
Cash in Bank	Num	Cash in Bank	Monthly	Cash in Bank	Other
Resident Property	Num	Resident Property	Monthly	Resident Property	House
Investment Property	Num	Investment Property	Monthly	Investment Property	Other
Recreational Investments	Num	Recreational Investment	Monthly	Recreational Investments	Other
Motor Vehicles	Num	Motor Vehicle	Monthly	Motor Vehicles	Car
Furniture	Num	Furniture	Monthly	Furniture	Other
Superannuation	Num	Superannuation	Monthly	Superannuation	Other
Shares	Num	Share details	Monthly	Shares	Other
Plant and Equipment	Num	Plant and Equipment	Monthly	Plant and Equipment	Other

Liabilities

Screen Name	Type	Description	JSON Frequency	JSON Description	JSON Type
Overdraft	Num	Monthly Overdraft repayments	Monthly	Overdraft	Overdraft
Mortgages	Num	Monthly Residential Mortgage repayments	Monthly	Mortgages	Home Loan
Investment Mortgages	Num	Monthly Property Investment repayments	Monthly	Investment Mortgages	Other
Recreational Asset Loans	Num	Monthly Recreational Asset repayments	Monthly	Recreational Asset Loans	Personal Loan
Investment Loan	Num	Monthly Investment Loan repayments	Monthly	Investment Loan	Other
Personal Loan	Num	Monthly Personal Loan repayments	Monthly	Personal Loan	Personal Loan
Margin Loan	Num	Margin Loan repayments	Monthly	Margin Loan	Other
Motor Vehicle Loan	Num	Motor Vehicle repayments	Monthly	Motor Vehicle Loan	Automotive Loan
Plant and Equipment Loan	Num	Plant and Equipment repayments	Monthly	Plant and Equipment Loan	Other
Credit Card Limit	Num	Monthly Credit Card repayments	Monthly	Credit Card Limit	Credit Card
Debt Agreement	Num	Debt repayments	Monthly	Debt Agreement	Other
Tax Debt	Num	Tax Debt repayments	Monthly	Tax Debt	Other

Insurer Name

Field location: Quotes / Lease tab in Comprehensive Insurance Profile window.

Angle Finance field name: insurerName

Catch-e Supplier Code mapped to Angle Finance Insurer Name. Contact Catch-e with list of Supplier Codes to map as not all may apply.

Accepted Values

insurerName

AAI Limited (APIA)

AAMI

Allianz

Auto & General Services Pty Ltd

Bingle

Budget Direct

CGU

Coles

Elders Insurance

Eric Insurance

Hollard Insurance

Huddle

IAG

Insurance House Pty Ltd

NRMA

Open Insurance

Other

Pacific International

ProRisk

QBE

RAA

RAC

RACQ

RACV

SGIC

SGIO

Shannons

Suncorp

Toyota Insurance

Vero

Woolworths

Youi

Zurich Motor

Mapping Updates

If Angle modify list by adding field name options or removing existing values, refer Mapping Updates process pages.

Useful Queries

Insurer Name Values

select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'insurerName' ORDER BY tift.interface_value;

Insurers List with Mappings

select s.supplier_code, s.supplier_type, st1.interface_value, st1.interface_field_name, st1.interface_type, st1.table_name, st1.field_name, st1.field_value from fm_suppliers as s left join (select tif.interface_type, tif.interface_field_name, interface_value, tif.table_name, tif.field_name, tift.field_value from qt_interface_field_translations as tift inner join qt_interface_fields as tif on tif.interface_field_id = tift.interface_field_id and tif.interface_type = 'angle' and tif.interface_field_name = 'insurerName') as st1 on st1.field_value = s.supplier_code where s.supplier_type = 'insurer' order by st1.interface_value desc;

Set-up Queries for Catch-e Staff

Update Mapping Records

START TRANSACTION; update qt_interface_field_translations set field_value = 'Code 1' where interface_field_translation_id = UUID1; update qt_interface_field_translations set field_value = 'Code 2' where interface_field_translation_id = UUID2; COMMIT;

Insert Mapping Records

select * from qt_interface_fields where interface_type = 'angle' and interface_field_name = 'insurerName'; start transaction; select @interface_field_id := interface_field_id from qt_interface_fields where interface_type = 'angle' and interface_field_name = 'insurerName'; INSERT into qt_interface_field_translations (interface_field_translation_id, interface_field_id, field_value, interface_value) VALUES (uuid_short, @interface_field_id, 'supplier_code1', 'insurerName1'); INSERT into qt_interface_field_translations (interface_field_translation_id, interface_field_id, field_value, interface_value) VALUES (uuid_short, @interface_field_id, 'supplier_code2', 'insurerName2'); commit;

Notes

[qt_interface_fields] defines mapping structure and links Catch-e fields to Angle interface field names
[qt_interface_field_translations] contains actual translation values for each mapping
Some translations have zero translation records (like ESTFEENL, ORIGFEE) as they map directly without translation
Translations count indicates number of field value mappings configured for each interface field
Failed application results when mapped value not accepted by Angle Finance (e.g., Mx, null, Capt for title field)
Client specific mappings may differ from default mappings based on business requirements
Financial Circumstances covers Driver Income/Expense and Driver Assets/Liabilities mappings
Insurer Name requires contact with Catch-e for custom mapping setup