PC Report Options (PC70100)

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

Product: Human Resources (414)
Series: Payroll

Display Name: PC Report Options
Physical Name: PC70100
Technical Name: pcReportOptions

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
4RPRTNAME SearchReport NameSTR30String3230
5PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
6PRNTTYPE SearchPrint TypeGBInteger20
7ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
8INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
10PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
11PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
12IFFILXST SearchIf File ExistingGBInteger20
13FILEXPNM SearchFile Export NameSTR255String256255
14EXPTTYPE SearchExport TypeINTInteger20
15SORTBY SearchSort ByDDL_Sort_ByInteger20
16STRTDATE SearchStart DateDTDate48
17ENDDATE SearchEnd DateDTDate48
18POSSTATUS SearchPosition StatusDDL_PosStatusInteger20
19HRSTATUS SearchHR StatusDDL_HRStatusInteger20
20EMPLTYPE SearchEmployment TypeSTR7_LBString87
21EEOCLASS_I SearchEEO ClassDDL_EEOInteger20
22FLSASTATUS SearchFLSA StatusDDL_FLSA_StatusInteger20
23SHOWINACTIVE SearchShow InactiveCB_ShowInactiveBoolean20
24STRTCHANGEDT SearchStart Change DateDTDate48
25STTUSRID SearchStart User IDSTR15_User_IDString1615
26STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString86
27STRDIVISIONCODE SearchStart Division CodeSTR6_Payroll_CodeString86
28STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString1615
29STTEMPID SearchStart Employee IDSTR15_Employee_IDString1615
30STTLOCID SearchStart Location IDSTR15_Location_IDString1615
31STARTPLAN SearchStart PlanSTR15_LBAUString1615
32STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString86
33STRTRPTPOS SearchStart Reports to PositionSTR6_Payroll_CodeString86
34STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString86
35ENDCHANGEDT SearchEnd Change DateDTDate48
36ENDUSRID SearchEnd User IDSTR15_User_IDString1615
37ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString86
38ENDDIVISIONCODE SearchEnd Division CodeSTR6_Payroll_CodeString86
39ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString1615
40ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString1615
41ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
42ENDPLAN SearchEnd PlanSTR15_LBAUString1615
43ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString86
44ENDRPTPOS SearchEnd Reports to PositionSTR6_Payroll_CodeString86
45ENDSPRVSRCD SearchEnd Supervisor CodeSTR6_UString86
46RANGEBY SearchRange ByINTInteger20
47ASSIGNMENTSTATUS SearchAssignment StatusDDL_AssignmentStatusInteger20
48INHERITSTATUS SearchInheritance StatusDDL_InheritanceStatusInteger20
49SEATTYPE SearchSeat TypeDDL_Seat_TypeInteger20
50DEX_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 *