Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BNUF0131
Product: HRM Solution Series (1911)
Series: System
Display Name: Benefit Report Options DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: BNUF0131
Technical Name: Benefit_Report_OptionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 REPORTOPTION_I Report Option STR20 String 22 20 2 REPORTINDEX_I Report Index DLR14 Currency 10 14 3 ASKECHTM Ask Each Time CB_Ask_Each_Time Boolean 2 0 4 STARTBENEFIT_I Start Benefit STR6_Payroll_Code String 8 6 5 STARTEFFECTIVEDATE_I Start Effective Date DT Date 4 8 6 STTEMPID Start Employee ID STR15_Employee_ID String 16 15 7 STARTCOPAYCODE_I Start CoPay Code STR15_Employee_ID String 16 15 8 ENDBENEFIT_I End Benefit STR6_Payroll_Code String 8 6 9 ENDEFFECTIVEDATE_I End Effective Date DT Date 4 8 10 ENDEMPL End Employee ID STR15_Employee_ID String 16 15 11 ENDCOPAYCODE_I End CoPay Code STR15_Employee_ID String 16 15 12 INCLGNDS Include Legends CB_Include_Legends Boolean 2 0 13 FROMFIRSTNAME_I from First Name STR15_I String 16 15 14 TOFIRSTNAME_I to First Name STR15_I String 16 15 15 FROMLASTNAME_I from Last Name STR20 String 22 20 16 TOLASTNAME_I to Last Name STR20 String 22 20 17 FROMISSN_I from ISSN STR15_Social_Security_Number String 16 15 18 TOISSN_I to ISSN STR15_Social_Security_Number String 16 15 19 SORTBYNUMBER_I Sort By Number INT2 Integer 2 2 20 PRNTOFIL Print to File CB_Print_to_File Boolean 2 0 21 PRTOPRTR Print to Printer CB_Print_to_Printer Boolean 2 0 22 PRTOSCRN Print to Screen CB_Print_to_Screen Boolean 2 0 23 IFFILXST If File Existing GB Integer 2 0 24 FILEXPNM File Export Name STR255 String 256 255 25 EXPTTYPE Export Type INT Integer 2 0 26 DEPARTMENTCODE_I Department Code STR6_Payroll_Code String 8 6 27 DIVISIONCODE_I Division Code STR6_Payroll_Code String 8 6 28 POSITIONCODE_I Position Code STR6_Payroll_Code String 8 6 29 HRSTATUS HR Status DDL_HRStatus Integer 2 0 30 STARTINDEX_I Start Index INT Integer 2 0 31 SORTOPTION_I Sort Option INT Integer 2 0 32 INCINEMP Include Inactive Employees CB_Include_Inactive_Employees Boolean 2 0 33 RESID Resid ID_INT Integer 2 4 34 DEX_ROW_ID int int 10 10