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 TypeLength
1APR_RPTCH SearchAPR Report ChoicesLB_Financial_Report_ChoicesInteger0
2PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
3PRNTTYPE SearchPrint TypeGBInteger0
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
9IFFILXST SearchIf File ExistingGBInteger0
10FILEXPNM SearchFile Export NameSTR255String255
11EXPTTYPE SearchExport TypeINTInteger0
12RPTGRIND SearchReport Group IndexINTInteger0
13RTPACHIN SearchReport Palette Choice IndexINTInteger0
14RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
15SORTBY SearchSort ByDDL_Sort_ByInteger0
16MTHSLCTD SearchMonth SelectedMonthInteger0
17AUCTRLCD SearchAudit Control CodeSTR13_LBAUString13
18INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean0
19STTEMPID SearchStart Employee IDSTR15_Employee_IDString15
20STTEMNAM SearchStart Employee NameSTR20String20
21STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString6
22STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString6
23STRTNGDT SearchStarting DateDTDate8
24STRTPYDT SearchStart Pay DateDT6Date6
25STPSTDDT SearchStart Posted DateDTDate8
26STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString15
27STPRTKDT SearchStart Payroll Token DateDDL_Payroll_DatesInteger0
28STTLOCID SearchStart Location IDSTR15_Location_IDString15
29STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString6
30ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString13
31ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString15
32ENEMPNAM SearchEnd Employee NameSTR20String20
33ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString6
34ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString6
35ENDINGDT SearchEnding DateDTDate8
36ENDPAYDT SearchEnd Pay DateDT6Date6
37ENPSTDDT SearchEnd Posted DateDTDate8
38ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString15
39EPRTKNDT SearchEnd Payroll Token DateDDL_Payroll_DatesInteger0
40ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
41SEGSRTBY SearchSegment Sort ByINT1Integer1
42RANGEBY SearchRange ByINTInteger0
43APR_FrequencyDDL SearchAPR Frequency DDLAPR_DDL_FrequencyInteger0
44BUDGETID SearchBudget IDSTR15_LBAUString15
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 YearInteger0
46APR_FTEReportRG SearchAPR FTE Report RGAPR FTE Report RGInteger0
47APR_StartAreasofResp SearchAPR Start Areas of ResponsibilitySTR6_Payroll_CodeString6
48APR_EndAreasofRespon SearchAPR End Areas of ResponsibilitySTR6_Payroll_CodeString6
49APR_StartDateDDL SearchAPR Start Date DDLINTInteger0
50APR_EndDateDDL SearchAPR End Date DDLINTInteger0
51YEAR1 SearchYearYearInteger4
52STRTPER1 SearchStartPeriod1INT3Integer3
53ENDPER1 SearchEndPeriod1INT3Integer3
54PERNAMES_1 SearchPeriod Names[1]STR20String20
55PERNAMES_2 SearchPeriod Names[2]STR20String20
56PERNAMES_3 SearchPeriod Names[3]STR20String20
57PERNAMES_4 SearchPeriod Names[4]STR20String20
58PERNAMES_5 SearchPeriod Names[5]STR20String20
59PERNAMES_6 SearchPeriod Names[6]STR20String20
60PERNAMES_7 SearchPeriod Names[7]STR20String20
61PERNAMES_8 SearchPeriod Names[8]STR20String20
62PERNAMES_9 SearchPeriod Names[9]STR20String20
63PERNAMES_10 SearchPeriod Names[10]STR20String20
64PERNAMES_11 SearchPeriod Names[11]STR20String20
65PERNAMES_12 SearchPeriod Names[12]STR20String20
66PERNAMES_13 SearchPeriod Names[13]STR20String20
67PERNAMES_14 SearchPeriod Names[14]STR20String20
68PERNAMES_15 SearchPeriod Names[15]STR20String20
69PERNAMES_16 SearchPeriod Names[16]STR20String20
70PERNAMES_17 SearchPeriod Names[17]STR20String20
71PERNAMES_18 SearchPeriod Names[18]STR20String20
72PERNAMES_19 SearchPeriod Names[19]STR20String20
73PERNAMES_20 SearchPeriod Names[20]STR20String20
74PERNAMES_21 SearchPeriod Names[21]STR20String20
75PERNAMES_22 SearchPeriod Names[22]STR20String20
76PERNAMES_23 SearchPeriod Names[23]STR20String20
77PERNAMES_24 SearchPeriod Names[24]STR20String20
78PERNAMES_25 SearchPeriod Names[25]STR20String20
79PERNAMES_26 SearchPeriod Names[26]STR20String20
80PERNAMES_27 SearchPeriod Names[27]STR20String20
81PERNAMES_28 SearchPeriod Names[28]STR20String20
82PERNAMES_29 SearchPeriod Names[29]STR20String20
83PERNAMES_30 SearchPeriod Names[30]STR20String20
84DEX_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.

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

Leave a Reply

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