000029434 - Query to retrieve information about calculated fields from the database

Select M.module_name as 'Application Name', L.level_name as 'Level Name',
FD.field_name as 'Field Name', FT.field_type_name as 'Field Type',
c.calc_order as 'Calculation order', c.formula as 'Formula', c.enforce_calc as 'Always Calculate',
c.is_handle_error as 'Display novalue/specific error',
CEV.numeric_value as 'Specific error value_Numeric', CEV.select_value_id as 'Specific error value_list',
Cev.string_value as 'Specific error value_text', CEV.date_value as 'Specific error value_Date' 
from tblIVFieldDef FD
join tblLevel L on L.level_id=FD.level_id
join tblModule M on M.module_id=L.module_id
join tblIVFieldType FT on FT.field_type_id=FD.field_type_id
join tblCalc C on C.field_id=FD.field_id
full outer join tblCalcErrorValue CEV on FD.field_id=CEV.field_id order by module_name,level_name,calc_order