Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EMUF0130
Product: Human Resources (414)
Series: System
Display Name: Employee_Report_Options Group Display Name: HR Multi-Company
Physical Name: EMUF0130
Technical Name: Employee_Report_Options
Group Technical Name: HR_MultiCmp_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | REPORTOPTION_I ![]() | Report Option | STR20 | String | 20 | |
2 | REPORTINDEX_I ![]() | Report Index | DLR14 | Currency | 14 | |
3 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
4 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
5 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
6 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
7 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
8 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
9 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
10 | RNGE ![]() | Range | STR132 | String | 132 | |
11 | SORTBY_I ![]() | sortby | STR_30 | String | 30 | |
12 | SORTBYNUMBER_I ![]() | Sort By Number | INT2 | Integer | 2 | |
13 | SORTOPTION_I ![]() | Sort Option | INT | Integer | 0 | |
14 | FROMISSN_I ![]() | from ISSN | STR15_Social_Security_Number | String | 15 | |
15 | TOISSN_I ![]() | to ISSN | STR15_Social_Security_Number | String | 15 | |
16 | FROMFIRSTNAME_I ![]() | from First Name | STR15_I | String | 15 | |
17 | FROMLASTNAME_I ![]() | from Last Name | STR20 | String | 20 | |
18 | TOFIRSTNAME_I ![]() | to First Name | STR15_I | String | 15 | |
19 | TOLASTNAME_I ![]() | to Last Name | STR20 | String | 20 | |
20 | COMPANYCODE_I ![]() | Company Code | STR6_Payroll_Code | String | 6 | |
21 | DIVISIONCODE_I ![]() | Division Code | STR6_Payroll_Code | String | 6 | |
22 | DEPARTMENTCODE_I ![]() | Department Code | STR6_Payroll_Code | String | 6 | |
23 | POSITIONCODE_I ![]() | Position Code | STR6_Payroll_Code | String | 6 | |
24 | LOCATNID ![]() | Location ID | STR15_Location_ID | String | 15 | |
25 | FROMEMPLOYEEID_I ![]() | from Employee ID | STR15_Employee_ID | String | 15 | |
26 | TOEMPLOYEEID_I ![]() | to Employee ID | STR15_Employee_ID | String | 15 | |
27 | FROMDATE_I ![]() | from Date | DT | Date | 8 | |
28 | TODATE_I ![]() | to Date | DT | Date | 8 | |
29 | HRSTATUS ![]() | HR Status | DDL_HRStatus | Integer | 0 | |
30 | EMPLOYMENTTYPE ![]() | Type of Employment | DDL_Employment_Type | Integer | 0 | |
31 | INCINEMP ![]() | Include Inactive Employees | CB_Include_Inactive_Employees | Boolean | 0 | |
32 | DATEENDING ![]() | Date Ending | DT | Date | 8 | |
33 | RESID ![]() | Resid | ID_INT | Integer | 4 | |
34 | ReportingOrganization ![]() | Reporting Organization | DDL_Reporting_Organization | Integer | 0 | |
35 | TypeofVETSForm ![]() | Type of VETS Form | DDL_Type_VETS_Form | Integer | 0 | |
36 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |