Quick Field Reference

In the 'drag/drop' space to the right of VBScript windows, you will note that various functions are listed for possible use in an uncertainty script. Many of these functions (LookupNumericField and LookupStringField ) reference various field names. A quick listing of these field names is given below, with an explanation of how each field is used in IndySoft:

Contributing Item Fields

LookupNumericField("UNCERTBUDGETLINEITEMS", "ITEM_SEQUENCE") - Contributing Item '#' field in grid on Contributing Item tab, Uncertainty Module

LookupStringField("UNCERTBUDGETLINEITEMS", "UNCERTAINTY_CONTRIBUTOR") - Contributing Item 'Contributor Name'

LookupStringField("UNCERTBUDGETLINEITEMS", "ITEM_IDENTIFIER") - Contributing Item 'Identifier'

LookupNumericField("UNCERTBUDGETLINEITEMS", "ESTIMATED_ERROR") - Contributing Item 'Estimated Error'

LookupStringField("UNCERTBUDGETLINEITEMS", "ITEM_TYPE") - Contributing Item 'Type'

LookupNumericField("UNCERTBUDGETLINEITEMS", "DEGREES_OF_FREEDOM") - Contributing Item 'Deg. of Freedom'

LookupStringField("UNCERTBUDGETLINEITEMS", "ITEM_DISTRIBUTION") - Contributing Item 'Distribution'

LookupNumericField("UNCERTBUDGETLINEITEMS", "ITEM_DIVISOR") - Contributing Item 'Divisor / Cov. Fact.'

LookupNumericField("UNCERTBUDGETLINEITEMS", "SENSITIVITY_COEFFICIENT") - Contributing Item 'Sensitivity Coeff.'

LookupNumericField("UNCERTBUDGETLINEITEMS", "STANDARD_UNCERTAINTY") - Contributing Item 'Standard Uncertainty'

Test Point Fields

LookupStringField("CALPNTS", "SEQ") - Event Calibration Results grid, '#'

LookupStringField("CALPNTS", "LINE_DESCRIPTION") - Event Calibration Results grid, 'Description'

LookupNumericField("CALPNTS", "LINE_STANDARD") - Event Calibration Results grid, 'Standard'

LookupNumericField("CALPNTS", "TOLERANCE1") - Event Calibration Results grid, 'Tolerance +'

LookupNumericField("CALPNTS", "TOLERANCE2") - Event Calibration Results grid, 'Tolerance -'

LookupNumericField("CALPNTS", "RESULT1") - Event Calibration Results grid, 'As Found'

LookupNumericField("CALPNTS", "RESULT2") - Event Calibration Results grid, 'As Left'

LookupStringField("CALPNTS", "VERDICT") - Event Calibration Results grid, 'Verdict' (shows as Red if failed, etc.)

LookupStringField("CALPNTS", "DESCRIPT1") - Event Calibration Results grid, 'Attribute 1'

LookupStringField("CALPNTS", "DESCRIPT2") - Event Calibration Results grid, 'Attribute 2'

LookupStringField("CALPNTS", "HAS_DESCRIPT") - Event Calibration Results grid, 'Has Description' -- SOOT flag field

LookupStringField("CALPNTS", "OUT_OF_TOL") - Event Calibration Results grid, 'Failed'

LookupStringField("CALPNTS", "ADJUSTED") - Event Calibration Results grid, 'Adjusted'

LookupStringField("CALPNTS", "ROV") - Event Calibration Results grid, 'R.O.V.'

LookupStringField("CALPNTS", "LIMITED") - Event Calibration Results grid, 'Limited Use'

LookupStringField("CALPNTS", "LINE_FORMULA") - Event Calibration Results grid, 'Formula'

LookupStringField("CALPNTS", "UNIT_MEASURE") - Event Calibration Results grid, 'Unit'

LookupNumericField("CALPNTS", "NUM_RESOLUTION") - Event Calibration Results grid, 'Res.'

LookupStringField("CALPNTS", "SPACE_AFTER") - Event Calibration Results grid, 'Space After'

LookupStringField("CALPNTS", "SN") - Event Calibration Results grid, 'Individual Serial Num.'

LookupStringField("CALPNTS", "GROUP_NAME") - Event Calibration Results grid, 'Group'

LookupStringField("CALPNTS", "MASTER_TYPE") - Event Calibration Results grid, 'Master Type'

LookupNumericField("CALPNTS", "TOLERANCE1_WARN") - Event Calibration Results grid, 'Tolerance + Warning'

LookupNumericField("CALPNTS", "TOLERANCE2_WARN") - Event Calibration Results grid, 'Tolerance - Warning'

LookupNumericField("CALPNTS", "UTOLERANCE1_WARN") - Event Calibration Results grid, 'Used Tolerance + Warning'

LookupNumericField("CALPNTS", "UTOLERANCE2_WARN") - Event Calibration Results grid, 'Used Tolerance - Warning'

LookupStringField("CALPNTS", "UNCERTAINTY_STUDY") - Event Calibration Results grid, 'Uncertainty Study'

LookupStringField("CALPNTS", "WIZARD_STEP") - Event Calibration Results grid, 'Wizard Step'

LookupNumericField("CALPNTS", "RESULT_TYPE") - Event Calibration Results grid, 'Result Res.'

LookupNumericField("CALPNTS", "TEST_UNCERTAINTY") - Event Calibration Results grid, 'Uncertainty As Found'

LookupNumericField("CALPNTS", "UNCERTAINTY_AS_LEFT") - Event Calibration Results grid, 'Uncertainty As Left'

LookupNumericField("CALPNTS", "TEST_ACCURACY") - Event Calibration Results grid, 'Accuracy'

LookupStringField("CALPNTS", "CUSTOM1") - Event Calibration Results grid, 'Custom 1'

LookupStringField("CALPNTS", "CUSTOM2") - Event Calibration Results grid, 'Custom 2'

LookupNumericField("CALPNTS", "TOLERANCE_TYPE") - Event Calibration Results grid, 'Tol. Type'

LookupStringField("CALPNTS", "TOLERANCE1_FORMULA") - Event Calibration Results grid, 'Tolerance + Formula'

LookupStringField("CALPNTS", "TOLERANCE2_FORMULA") - Event Calibration Results grid, 'Tolerance - Formula'

LookupStringField("CALPNTS", "UTOLERANCE1_FORMULA") - Event Calibration Results grid, 'Used Tol. + Formula'

LookupStringField("CALPNTS", "UTOLERANCE2_FORMULA") - Event Calibration Results grid, 'Used Tol. - Formula'

LookupStringField("CALPNTS", "LINE_STANDARD_FORMULA") - Event Calibration Results grid, 'Standard Formula'

LookupNumericField("CALPNTS", "EXTRA_NUM1") - Event Calibration Results grid, 'Extra Number 1'

LookupNumericField("CALPNTS", "EXTRA_NUM2") - Event Calibration Results grid, 'Extra Number 2'

LookupStringField("CALPNTS", "AS_FOUND_ALPHA") - Event Calibration Results grid, 'As Found (Text)'

LookupStringField("CALPNTS", "AS_LEFT_ALPHA") - Event Calibration Results grid, 'As Left (Text)'

LookupNumericField("CALPNTS", "AV_AS_FOUND") - Event Calibration Results grid, 'Applied Value As Found'

LookupNumericField("CALPNTS", "AV_AS_LEFT") - Event Calibration Results grid, 'Applied Value As Left'

LookupNumericField("CALPNTS", "AVG_PERCENT_TOL") - Event Calibration Results grid, 'Avg % of Tolerance'

LookupNumericField("CALPNTS", "EXTRA_NUM3") - Event Calibration Results grid, 'Extra Number 3'

LookupNumericField("CALPNTS", "EXTRA_NUM4") - Event Calibration Results grid, 'Extra Number 4'

LookupNumericField("CALPNTS", "EXTRA_NUM5") - Event Calibration Results grid, 'Extra Number 5'

LookupNumericField("CALPNTS", "PERCENT_TOL") - Event Calibration Results grid, '% of Tol'

LookupNumericField("CALPNTS", "AV_RES") - Event Calibration Results grid, 'Applied Value Res'

LookupNumericField("CALPNTS", "AV_RES_LCD") - Event Calibration Results grid, 'Applied Value Res. LCD'

LookupNumericField("CALPNTS", "NOM RES") - Event Calibration Results grid, 'Extra Num Res'

LookupNumericField("CALPNTS", "NOM_RES_LCD") - Event Calibration Results grid, 'Extra Num Res LCD'

LookupNumericField("CALPNTS", "NUM_RESOLUTION_LCD") - Event Calibration Results grid, 'Res'

LookupNumericField("CALPNTS", "RESULT_RES_LCD") - Event Calibration Results grid, 'Result Count By'

LookupNumericField("CALPNTS", "UNCERT_RES") - Event Calibration Results grid, 'Uncertainty Res'

LookupNumericField("CALPNTS", "UNCERT_RES_LCD") - Event Calibration Results grid, 'Uncertainty Res LCD'

LookupStringField("CALPNTS", "AV_UNIT_MEASURE") - Event Calibration Results grid, 'Applied Value UOM'

LookupStringField("CALPNTS", "CUSTOM_CHECKBOX") - Event Calibration Results grid, 'Custom Checkbox'

LookupStringField("CALPNTS", "CUSTOM3") - Event Calibration Results grid, 'Custom 3'

LookupStringField("CALPNTS", "CUSTOM4") - Event Calibration Results grid, 'Custom 4'

LookupStringField("CALPNTS", "CUSTOM5") - Event Calibration Results grid, 'Custom 5'

LookupStringField("CALPNTS", "NOM_UNIT_MEASURE") - Event Calibration Results grid, 'Extra Num UOM'

LookupStringField("CALPNTS", "TOL_DESCRIPTION") - Event Calibration Results grid, 'Tolerance Type'

LookupStringField("CALPNTS", "UNCERT_UNIT_MEASURE") - Event Calibration Results grid, 'Uncertainty UOM'

LookupNumericField("CALPNTS", "ENV_AF_TEMP") - Event Calibration Results grid, 'As Found Temp'

LookupStringField("CALPNTS", "ENV_AF_TEMP_TYPE") - Event Calibration Results grid, 'As Found Temp Type'

LookupNumericField("CALPNTS", "ENV_AF_RH") - Event Calibration Results grid, 'As Found Relative Humidity (RH)'

LookupNumericField("CALPNTS", "ENV_AF_BP") - Event Calibration Results grid, 'As Found Pressure'

LookupStringField("CALPNTS", "ENV_AF_BP_TYPE") - Event Calibration Results grid, 'As Found Pressure Type'

LookupNumericField("CALPNTS", "ENV_AL_TEMP") - Event Calibration Results grid, 'As Left Temp'

LookupStringField("CALPNTS", "ENV_AL_TEMP_TYPE") - Event Calibration Results grid, 'As Left Temp Type'

LookupNumericField("CALPNTS", "ENV_AL_RH") - Event Calibration Results grid, 'As Left Relative Humidity (RH)'

LookupNumericField("CALPNTS", "ENV_AL_BP") - Event Calibration Results grid, 'As Left Pressure'

LookupStringField("CALPNTS", "ENV_AL_BP_TYPE") - Event Calibration Results grid, 'As Left Pressure Type'

LookupNumericField("CALPNTS", "AF_EXTRANUM1") - Event Calibration Results grid, 'As Found Num 1'

LookupNumericField("CALPNTS", "AF_EXTRANUM2") - Event Calibration Results grid, 'As Found Num 2'

LookupNumericField("CALPNTS", "AF_EXTRANUM3") - Event Calibration Results grid, 'As Found Num 3'

LookupNumericField("CALPNTS", "AF_EXTRANUM4") - Event Calibration Results grid, 'As Found Num 4'

LookupNumericField("CALPNTS", "AF_EXTRANUM5") - Event Calibration Results grid, 'As Found Num 5'

LookupNumericField("CALPNTS", "AL_EXTRANUM1") - Event Calibration Results grid, 'As Left Num 1'

LookupNumericField("CALPNTS", "AL_EXTRANUM2") - Event Calibration Results grid, 'As Left Num 2'

LookupNumericField("CALPNTS", "AL_EXTRANUM3") - Event Calibration Results grid, 'As Left Num 3'

LookupNumericField("CALPNTS", "AL_EXTRANUM4") - Event Calibration Results grid, 'As Left Num 4'

LookupNumericField("CALPNTS", "AL_EXTRANUM5") - Event Calibration Results grid, 'As Left Num 5'

LookupStringField("CALPNTS", "AF_CUSTOMTEXT1") - Event Calibration Results grid, 'As Found Text 1'

LookupStringField("CALPNTS", "AF_CUSTOMTEXT2") - Event Calibration Results grid, 'As Found Text 2'

LookupStringField("CALPNTS", "AF_CUSTOMTEXT3") - Event Calibration Results grid, 'As Found Text 3'

LookupStringField("CALPNTS", "AL_CUSTOMTEXT1") - Event Calibration Results grid, 'As Left Text 1'

LookupStringField("CALPNTS", "AL_CUSTOMTEXT2") - Event Calibration Results grid, 'As Left Text 2'

LookupStringField("CALPNTS", "AL_CUSTOMTEXT3") - Event Calibration Results grid, 'As Left Text 3'

LookupStringField("CALPNTS", "AF_LAST_MODIFIED") - Event Calibration Results grid, 'As Found Last Modified'

LookupStringField("CALPNTS", "AL_LAST_MODIFIED") - Event Calibration Results grid, 'As Left Last Modified'

LookupNumericField("CALPNTS", "AF_LAST_MODIFIED_DATE") - Event Calibration Results grid, 'As Found Last Modified Date'

LookupNumericField("CALPNTS", "AL_LAST_MODIFIED_DATE") - Event Calibration Results grid, 'As Left Last Modified Date'

LookupNumericField("CALPNTS", "AF_TUR") - Event Calibration Results grid, 'As Found TUR'

LookupNumericField("CALPNTS", "AL_TUR") - Event Calibration Results grid, 'As Left TUR'

LookupStringField("CALPNTS", "AF_TUR_FORMULA") - Event Calibration Results grid, 'As Found TUR Formula'

LookupStringField("CALPNTS", "AL_TUR_FORMULA") - Event Calibration Results grid, 'As Left TUR Formula'

LookupNumericField("CALPNTS", "AL_STANDARD") - Event Calibration Results grid, 'Standard As Left'

LookupNumericField("CALPNTS", "AL_TOL_MINUS") - Event Calibration Results grid, 'Tolerance - (As Left)'

LookupNumericField("CALPNTS", "AL_TOL_PLUS") - Event Calibration Results grid, 'Tolerance + (As Left)'

LookupNumericField("CALPNTS", "AF_GB_TOL_MINUS") - Event Calibration Results grid, 'As Found Guardband -'

LookupNumericField("CALPNTS", "AF_GB_TOL_PLUS") - Event Calibration Results grid, 'As Found Guardband +'

LookupNumericField("CALPNTS", "AL_GB_TOL_MINUS") - Event Calibration Results grid, 'As Left Guardband -'

LookupNumericField("CALPNTS", "AL_GB_TOL_PLUS") - Event Calibration Results grid, 'As Left Guardband +'

LookupStringField("CALPNTS", "GB_TOL_MINUS_FORMULA") - Event Calibration Results grid, 'Guardband Formula -'

LookupStringField("CALPNTS", "GB_TOL_PLUS_FORMULA") - Event Calibration Results grid, 'Guardband Formula +'

LookupNumericField("CALPNTS", "FREQUENCY") - Event Calibration Results grid, 'Frequency'

LookupStringField("CALPNTS", "FREQUENCY_UOM") - Event Calibration Results grid, 'Frequency UOM'

LookupStringField("CALPNTS", "FREQUENCY_AS_TEXT") - Event Calibration Results grid, 'Frequency (Text)'

LookupNumericField("CALPNTS", "AF_TAR") - Event Calibration Results grid, 'As Found TAR'

LookupNumericField("CALPNTS", "AL_TAR") - Event Calibration Results grid, 'As Left TAR'

LookupStringField("CALPNTS", "AF_TAR_FORMULA") - Event Calibration Results grid, 'As Found TAR Formula'

LookupStringField("CALPNTS", "AL_TAR_FORMULA") - Event Calibration Results grid, 'As Left TAR Formula'

LookupStringField("CALPNTS", "TOL_DIRECTION") - Event Calibration Results grid, 'Tol. Direction'

LookupNumericField("CALPNTS", "GAGE_TOL") - Event Calibration Results grid, 'Tolerance Type Value'

LookupNumericField("CALPNTS", "GAGE_TOLA") - Event Calibration Results grid, 'Tolerance Type Value2'

LookupNumericField("CALPNTS", "FULL_SCALE") - Event Calibration Results grid, 'Tolerance Type Full Scale'

LookupNumericField("CALPNTS", "ERROR_ADJUSTMENT") - Event Calibration Results grid, 'Error Adjustment'

LookupStringField("CALPNTS", "OBSERVATION_ONLY") - Event Calibration Results grid, 'Observation Only'

LookupStringField("CALPNTS", "OBSERVATION_TEXT") - Event Calibration Results grid, 'Observation Text'

LookupNumericField("CALPNTS", "PFA") - Event Calibration Results grid, 'PFA'

LookupNumericField("CALPNTS", "DISPLAY1") - Event Calibration Results grid, 'Display 1'

LookupNumericField("CALPNTS", "DISPLAY2") - Event Calibration Results grid, 'Display 2'

LookupNumericField("CALPNTS", "DISPLAY3") - Event Calibration Results grid, 'Display 3'

LookupNumericField("CALPNTS", "FIXEDOFFSET") - Event Calibration Results grid, linked from Specs, 'Fixed Offset'

LookupNumericField("CALPNTS", "FIXEDOFFSETRES") - Event Calibration Results grid, linked from Specs, 'Fixed Offset Res'

LookupNumericField("CALPNTS", "READINGFACTORRES") - Event Calibration Results grid, linked from Specs, 'Reading Factor Res'

LookupStringField("CALPNTS", "READINGMP_TEXT") - Event Calibration Results grid, linked from Specs, 'Reading Multiplier'

LookupNumericField("CALPNTS", "READINGMP_FLOAT") - Event Calibration Results grid, linked from Specs, 'Of Reading Error'

LookupNumericField("CALPNTS", "RANGEVALUE") - Event Calibration Results grid, linked from Specs, 'Range Value'

LookupNumericField("CALPNTS", "RANGEVALUERES") - Event Calibration Results grid, linked from Specs, 'Range Value Res'

LookupStringField("CALPNTS", "RANGEMP_TEXT") - Event Calibration Results grid, linked from Specs, 'Range Multiplier'

LookupNumericField("CALPNTS", "RANGEMP_FLOAT") - Event Calibration Results grid, linked from Specs, 'Of Range Error'

LookupNumericField("CALPNTS", "SPANMIN") - Event Calibration Results grid, linked from Specs, 'Span Min'

LookupNumericField("CALPNTS", "SPANMAX") - Event Calibration Results grid, linked from Specs, 'Span Max'

LookupNumericField("CALPNTS", "SPANRES") - Event Calibration Results grid, linked from Specs, 'Span Res'

LookupNumericField("CALPNTS", "SPANFACTOR") - Event Calibration Results grid, linked from Specs, 'Span Factor'

LookupNumericField("CALPNTS", "SPANFACTORRES") - Event Calibration Results grid, linked from Specs, 'Span Factor Res'

LookupStringField("CALPNTS", "SPANMP_TEXT") - Event Calibration Results grid, linked from Specs, 'Span Multiplier'

LookupNumericField("CALPNTS", "SPANMP_FLOAT") - Event Calibration Results grid, linked from Specs, 'Of Span Error'

LookupStringField("CALPNTS", "LAYOUT_ID") - Event Calibration Results grid, 'Layout ID'

LookupStringField("CALPNTS", "GRID_SETTING_NAME") - Event Calibration Results grid, 'Grid Setting Name'

LookupStringField("CALPNTS", "GRIDEV_SETTING_NAME") - Event Calibration Results grid, 'Gridev Setting Name'

Event Fields

LookupStringField("EVENTS", "EVENT_DATE") - 'Date'

LookupNumericField("EVENTS", "EVENT_TIME") - 'Time'

LookupStringField("EVENTS", "EVENT_TYPE") - 'Event Type' (selected when event is launched from main screen menu)

LookupStringField("EVENTS", "CONTACT") - 'Vendor Contact'

LookupStringField("EVENTS", "USER_FNAME") - 'Entered By' (entered automatically by IndySoft)

LookupStringField("EVENTS", "DONE_BY_FNAME") - 'Employee'

LookupNumericField("EVENTS", "COST") - 'Cost'

LookupStringField("EVENTS", "GAGE_CONDITION") - 'Condition'

LookupStringField("EVENTS", "EVENT_RESULT") - 'Result'

LookupStringField("EVENTS", "VENDOR") - 'Vendor'

LookupStringField("EVENTS", "PO_NUMBER") - 'P.O. Number'

LookupNumericField("EVENTS", "EVENT_TEMP") - 'Temperature'

LookupStringField("EVENTS", "TEMP_TYPE") - 'Temp. Type' (F or C)

LookupNumericField("EVENTS", "RH") - 'Rel. Humidity'

LookupStringField("EVENTS", "EVENT_COMMENT") - 'Comments'

LookupStringField("EVENTS", "DEPARTMENT") - 'Department'

LookupStringField("EVENTS", "RETURN_DATE") - 'Expected Return'

LookupStringField("EVENTS", "PARTS") - 'Total Parts Ck'd'

LookupStringField("EVENTS", "CERT_TYPE") - 'Cert. Type'

LookupNumericField("EVENTS", "ACTUAL_TIME") - 'Total Time'

LookupStringField("EVENTS", "CUSTOM_FIELD1") - 'User Defined 1'

LookupStringField("EVENTS", "CUSTOM_FIELD2") - 'User Defined 2'

LookupStringField("EVENTS", "WO_NUMBER") - 'Work Order'

LookupStringField("EVENTS", "LOCATION") - 'Location (Crib)'

LookupStringField("EVENTS", "MACHINE") - 'Machine'

LookupStringField("EVENTS", "CUSTOM_FIELD3") - 'User Defined 3'

LookupStringField("EVENTS", "CUSTOM_FIELD4") - 'User Defined 4'

LookupStringField("EVENTS", "SUB_LOCATION") - 'Sub-Loc (Bin)'

LookupStringField("EVENTS", "WORKSTATION") - 'Workstation'

LookupStringField("EVENTS", "EVENT_STATUS") - 'Completed'

LookupStringField("EVENTS", "PARTOP_NUMBER") - 'Part/Operation #'

LookupStringField("EVENTS", "BP_TYPE") - 'BP Type'

LookupStringField("EVENTS", "BRANCH") - 'Branch'

LookupStringField("EVENTS", "CURRENT_STATUS") - 'Current Event Status'

LookupStringField("EVENTS", "CUSTOM_FIELD5") - 'User Defined 5'

LookupStringField("EVENTS", "CUSTOM_FIELD6") - 'User Defined 6'

LookupStringField("EVENTS", "CUSTOM_FIELD7") - 'User Defined 7'

LookupStringField("EVENTS", "CUSTOM_FIELD8") - 'User Defined 8'

LookupStringField("EVENTS", "CUSTOM_FIELD9") - 'User Defined 9'

LookupStringField("EVENTS", "CUSTOM_FIELD10") - 'User Defined 10'

LookupStringField("EVENTS", "LOCATION_ID_FROM") - 'Location (From)'

LookupStringField("EVENTS", "LOCATION_ID_TO") - 'Location (To)'

LookupStringField("EVENTS", "AS_FOUND_RESULT") - 'As Found Result'

LookupStringField("EVENTS", "AS_LEFT_RESULT") - 'As Left Result'

LookupStringField("EVENTS", "START_DATE") - 'Start Date'

LookupStringField("EVENTS", "START_TIME") - 'Start Time'

LookupStringField("EVENTS", "BP_VALUE") - 'Barometric Pressure' |