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 TypeLength
1RPTGRIND SearchReport Group IndexINTInteger0
2RTPACHIN SearchReport Palette Choice IndexINTInteger0
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
8IFFILXST SearchIf File ExistingGBInteger0
9FILEXPNM SearchFile Export NameSTR255String255
10EXPTTYPE SearchExport TypeINTInteger0
11RNGE SearchRangeSTR132String132
12SORTBY_I SearchsortbySTR_30String30
13SORTBYNUMBER_I SearchSort By NumberINT2Integer2
14SORTOPTION_I SearchSort OptionINTInteger0
15FROMISSN_I Searchfrom ISSNSTR15_Social_Security_NumberString15
16TOISSN_I Searchto ISSNSTR15_Social_Security_NumberString15
17FROMFIRSTNAME_I Searchfrom First NameSTR15_IString15
18FROMLASTNAME_I Searchfrom Last NameSTR20String20
19TOFIRSTNAME_I Searchto First NameSTR15_IString15
20TOLASTNAME_I Searchto Last NameSTR20String20
21COMPANYCODE_I SearchCompany CodeSTR6_Payroll_CodeString6
22DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
23DEPARTMENTCODE_I SearchDepartment CodeSTR6_Payroll_CodeString6
24POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString6
25LOCATNID SearchLocation IDSTR15_Location_IDString15
26FROMEMPLOYEEID_I Searchfrom Employee IDSTR15_Employee_IDString15
27TOEMPLOYEEID_I Searchto Employee IDSTR15_Employee_IDString15
28FROMDATE_I Searchfrom DateDTDate8
29TODATE_I Searchto DateDTDate8
30HRSTATUS SearchHR StatusDDL_HRStatusInteger0
31EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger0
32INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean0
33DATEENDING SearchDate EndingDTDate8
34SKILLSET_I SearchSkill SetSTR30_I0String30
35REQUISITIONNUMBER_I SearchRequisition NumberINT60Long Integer6
36FROMTESTCODE_I Searchfrom Test CodeSTR6_IString6
37TOTESTCODE_I Searchto Test CodeSTR6_IString6
38ICLASSID_I SearchIClass IDSTR6_U0String6
39COURSEID_I SearchCourse IDSTR6_U0String6
40DEX_ROW_ID Searchintint10

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 *