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 TypeLength
1RPTGRIND SearchReport Group IndexINTInteger0
2RTPACHIN SearchReport Palette Choice IndexINTInteger0
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
4RPRTNAME SearchReport NameSTR30String30
5PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
6PRNTTYPE SearchPrint TypeGBInteger0
7ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
8INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
10PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
11PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
12IFFILXST SearchIf File ExistingGBInteger0
13FILEXPNM SearchFile Export NameSTR255String255
14EXPTTYPE SearchExport TypeINTInteger0
15SORTBY SearchSort ByDDL_Sort_ByInteger0
16STRTDATE SearchStart DateDTDate8
17ENDDATE SearchEnd DateDTDate8
18POSSTATUS SearchPosition StatusDDL_PosStatusInteger0
19HRSTATUS SearchHR StatusDDL_HRStatusInteger0
20EMPLTYPE SearchEmployment TypeSTR7_LBString7
21EEOCLASS_I SearchEEO ClassDDL_EEOInteger0
22FLSASTATUS SearchFLSA StatusDDL_FLSA_StatusInteger0
23SHOWINACTIVE SearchShow InactiveCB_ShowInactiveBoolean0
24STRTCHANGEDT SearchStart Change DateDTDate8
25STTUSRID SearchStart User IDSTR15_User_IDString15
26STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString6
27STRDIVISIONCODE SearchStart Division CodeSTR6_Payroll_CodeString6
28STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString15
29STTEMPID SearchStart Employee IDSTR15_Employee_IDString15
30STTLOCID SearchStart Location IDSTR15_Location_IDString15
31STARTPLAN SearchStart PlanSTR15_LBAUString15
32STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString6
33STRTRPTPOS SearchStart Reports to PositionSTR6_Payroll_CodeString6
34STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString6
35ENDCHANGEDT SearchEnd Change DateDTDate8
36ENDUSRID SearchEnd User IDSTR15_User_IDString15
37ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString6
38ENDDIVISIONCODE SearchEnd Division CodeSTR6_Payroll_CodeString6
39ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString15
40ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString15
41ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
42ENDPLAN SearchEnd PlanSTR15_LBAUString15
43ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString6
44ENDRPTPOS SearchEnd Reports to PositionSTR6_Payroll_CodeString6
45ENDSPRVSRCD SearchEnd Supervisor CodeSTR6_UString6
46RANGEBY SearchRange ByINTInteger0
47ASSIGNMENTSTATUS SearchAssignment StatusDDL_AssignmentStatusInteger0
48INHERITSTATUS SearchInheritance StatusDDL_InheritanceStatusInteger0
49SEATTYPE SearchSeat TypeDDL_Seat_TypeInteger0
50DEX_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 *