hrReportOptions (HR70500)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR70500

Product: Human Resources (414)
Series: 3rd Party

Display Name: hrReportOptions
Physical Name: HR70500
Technical Name: hrReportOptions

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RPTGRIND SearchReport Group IndexINTInteger20
2RTPACHIN SearchReport Palette Choice IndexINTInteger20
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
8IFFILXST SearchIf File ExistingGBInteger20
9FILEXPNM SearchFile Export NameSTR255String256255
10EXPTTYPE SearchExport TypeINTInteger20
11RNGE SearchRangeSTR132String134132
12SORTBY_I SearchsortbySTR_30String3230
13SORTBYNUMBER_I SearchSort By NumberINT2Integer22
14SORTOPTION_I SearchSort OptionINTInteger20
15FROMISSN_I Searchfrom ISSNSTR15_Social_Security_NumberString1615
16TOISSN_I Searchto ISSNSTR15_Social_Security_NumberString1615
17FROMFIRSTNAME_I Searchfrom First NameSTR15_IString1615
18FROMLASTNAME_I Searchfrom Last NameSTR20String2220
19TOFIRSTNAME_I Searchto First NameSTR15_IString1615
20TOLASTNAME_I Searchto Last NameSTR20String2220
21COMPANYCODE_I SearchCompany CodeSTR6_Payroll_CodeString86
22DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
23DEPARTMENTCODE_I SearchDepartment CodeSTR6_Payroll_CodeString86
24POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString86
25LOCATNID SearchLocation IDSTR15_Location_IDString1615
26FROMEMPLOYEEID_I Searchfrom Employee IDSTR15_Employee_IDString1615
27TOEMPLOYEEID_I Searchto Employee IDSTR15_Employee_IDString1615
28FROMDATE_I Searchfrom DateDTDate48
29TODATE_I Searchto DateDTDate48
30HRSTATUS SearchHR StatusDDL_HRStatusInteger20
31EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger20
32INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean20
33DATEENDING SearchDate EndingDTDate48
34SKILLSET_I SearchSkill SetSTR30_I0String3230
35REQUISITIONNUMBER_I SearchRequisition NumberINT60Long Integer46
36FROMTESTCODE_I Searchfrom Test CodeSTR6_IString86
37TOTESTCODE_I Searchto Test CodeSTR6_IString86
38ICLASSID_I SearchIClass IDSTR6_U0String86
39COURSEID_I SearchCourse IDSTR6_U0String86
40DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *