APR Department Report Options (APR_APR70500)

azurecurveProductsHRM Solution Series (1911)PayrollAPR Department Report Options (APR_APR70500)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: APR Department Report Options
Physical Name: APR_APR70500
Technical Name: APR_Options_ROPT

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1APR_RPTCH SearchAPR Report ChoicesLB_Financial_Report_ChoicesInteger20
2PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
3PRNTTYPE SearchPrint TypeGBInteger20
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
9IFFILXST SearchIf File ExistingGBInteger20
10FILEXPNM SearchFile Export NameSTR255String256255
11EXPTTYPE SearchExport TypeINTInteger20
12RPTGRIND SearchReport Group IndexINTInteger20
13RTPACHIN SearchReport Palette Choice IndexINTInteger20
14RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
15SORTBY SearchSort ByDDL_Sort_ByInteger20
16MTHSLCTD SearchMonth SelectedMonthInteger20
17AUCTRLCD SearchAudit Control CodeSTR13_LBAUString1413
18INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean20
19STTEMPID SearchStart Employee IDSTR15_Employee_IDString1615
20STTEMNAM SearchStart Employee NameSTR20String2220
21STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString86
22STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString86
23STRTNGDT SearchStarting DateDTDate48
24STRTPYDT SearchStart Pay DateDT6Date46
25STPSTDDT SearchStart Posted DateDTDate48
26STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString1615
27STPRTKDT SearchStart Payroll Token DateDDL_Payroll_DatesInteger20
28STTLOCID SearchStart Location IDSTR15_Location_IDString1615
29STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString86
30ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString1413
31ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString1615
32ENEMPNAM SearchEnd Employee NameSTR20String2220
33ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString86
34ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString86
35ENDINGDT SearchEnding DateDTDate48
36ENDPAYDT SearchEnd Pay DateDT6Date46
37ENPSTDDT SearchEnd Posted DateDTDate48
38ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString1615
39EPRTKNDT SearchEnd Payroll Token DateDDL_Payroll_DatesInteger20
40ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
41SEGSRTBY SearchSegment Sort ByINT1Integer21
42RANGEBY SearchRange ByINTInteger20
43APR_FrequencyDDL SearchAPR Frequency DDLAPR_DDL_FrequencyInteger20
44BUDGETID SearchBudget IDSTR15_LBAUString1615
Key to the Budget Master (GL00200).

Click to show/hide

SELECT
       ['APR Department Report Options'].BUDGETID AS 'APR Department Report Options-Budget ID'
       ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
       APR_APR70500 AS ['APR Department Report Options']
INNER JOIN
       GL00200 AS ['Budget Master']
              ON
                     ['APR Department Report Options'].BUDGETID = ['Budget Master'].BUDGETID
45APR_TypeofYearRG SearchAPR Type of Year RGAPR RG YearInteger20
46APR_FTEReportRG SearchAPR FTE Report RGAPR FTE Report RGInteger20
47APR_StartAreasofResp SearchAPR Start Areas of ResponsibilitySTR6_Payroll_CodeString86
48APR_EndAreasofRespon SearchAPR End Areas of ResponsibilitySTR6_Payroll_CodeString86
49APR_StartDateDDL SearchAPR Start Date DDLINTInteger20
50APR_EndDateDDL SearchAPR End Date DDLINTInteger20
51YEAR1 SearchYearYearInteger24
52STRTPER1 SearchStartPeriod1INT3Integer23
53ENDPER1 SearchEndPeriod1INT3Integer23
54PERNAMES_1 SearchPeriod Names[1]STR20String2220
55PERNAMES_2 SearchPeriod Names[2]STR20String2220
56PERNAMES_3 SearchPeriod Names[3]STR20String2220
57PERNAMES_4 SearchPeriod Names[4]STR20String2220
58PERNAMES_5 SearchPeriod Names[5]STR20String2220
59PERNAMES_6 SearchPeriod Names[6]STR20String2220
60PERNAMES_7 SearchPeriod Names[7]STR20String2220
61PERNAMES_8 SearchPeriod Names[8]STR20String2220
62PERNAMES_9 SearchPeriod Names[9]STR20String2220
63PERNAMES_10 SearchPeriod Names[10]STR20String2220
64PERNAMES_11 SearchPeriod Names[11]STR20String2220
65PERNAMES_12 SearchPeriod Names[12]STR20String2220
66PERNAMES_13 SearchPeriod Names[13]STR20String2220
67PERNAMES_14 SearchPeriod Names[14]STR20String2220
68PERNAMES_15 SearchPeriod Names[15]STR20String2220
69PERNAMES_16 SearchPeriod Names[16]STR20String2220
70PERNAMES_17 SearchPeriod Names[17]STR20String2220
71PERNAMES_18 SearchPeriod Names[18]STR20String2220
72PERNAMES_19 SearchPeriod Names[19]STR20String2220
73PERNAMES_20 SearchPeriod Names[20]STR20String2220
74PERNAMES_21 SearchPeriod Names[21]STR20String2220
75PERNAMES_22 SearchPeriod Names[22]STR20String2220
76PERNAMES_23 SearchPeriod Names[23]STR20String2220
77PERNAMES_24 SearchPeriod Names[24]STR20String2220
78PERNAMES_25 SearchPeriod Names[25]STR20String2220
79PERNAMES_26 SearchPeriod Names[26]STR20String2220
80PERNAMES_27 SearchPeriod Names[27]STR20String2220
81PERNAMES_28 SearchPeriod Names[28]STR20String2220
82PERNAMES_29 SearchPeriod Names[29]STR20String2220
83PERNAMES_30 SearchPeriod Names[30]STR20String2220
84DEX_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.

azurecurveProductsHRM Solution Series (1911)PayrollAPR Department Report Options (APR_APR70500)

Leave a Reply

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