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:

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 ChoicesIntegerLB_Financial_Report_Choices0
2PRNTNOTS SearchPrint NotesBooleanCB_Print_Notes0
3PRNTTYPE SearchPrint TypeIntegerGB0
4ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
5INCLGNDS SearchInclude LegendsBooleanCB_Include_Legends0
6PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
7PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
8PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
9IFFILXST SearchIf File ExistingIntegerGB0
10FILEXPNM SearchFile Export NameStringSTR255255
11EXPTTYPE SearchExport TypeIntegerINT0
12RPTGRIND SearchReport Group IndexIntegerINT0
13RTPACHIN SearchReport Palette Choice IndexIntegerINT0
14RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
15SORTBY SearchSort ByIntegerDDL_Sort_By0
16MTHSLCTD SearchMonth SelectedIntegerMonth0
17AUCTRLCD SearchAudit Control CodeStringSTR13_LBAU13
18INCINEMP SearchInclude Inactive EmployeesBooleanCB_Include_Inactive_Employees0
19STTEMPID SearchStart Employee IDStringSTR15_Employee_ID15
20STTEMNAM SearchStart Employee NameStringSTR2020
21STRTDEPT SearchStart DepartmentStringSTR6_Payroll_Code6
22STTJBTIT SearchStart Job TitleStringSTR6_Payroll_Code6
23STRTNGDT SearchStarting DateDateDT8
24STRTPYDT SearchStart Pay DateDateDT66
25STPSTDDT SearchStart Posted DateDateDT8
26STTEMPCL SearchStart Employee ClassStringSTR15_Employee_Class15
27STPRTKDT SearchStart Payroll Token DateIntegerDDL_Payroll_Dates0
28STTLOCID SearchStart Location IDStringSTR15_Location_ID15
29STRTSPRVSRCD SearchStart Supervisor CodeStringSTR6_U6
30ENAUCNCD SearchEnd Audit Control CodeStringSTR13_LBAU13
31ENDEMPL SearchEnd Employee IDStringSTR15_Employee_ID15
32ENEMPNAM SearchEnd Employee NameStringSTR2020
33ENDDEPT SearchEnd DepartmentStringSTR6_Payroll_Code6
34ENJBTITL SearchEnd Job TitleStringSTR6_Payroll_Code6
35ENDINGDT SearchEnding DateDateDT8
36ENDPAYDT SearchEnd Pay DateDateDT66
37ENPSTDDT SearchEnd Posted DateDateDT8
38ENEMPCLS SearchEnd Employee ClassStringSTR15_Employee_Class15
39EPRTKNDT SearchEnd Payroll Token DateIntegerDDL_Payroll_Dates0
40ENDLOCID SearchEnd Location IDStringSTR15_Location_ID15
41SEGSRTBY SearchSegment Sort ByIntegerINT11
42RANGEBY SearchRange ByIntegerINT0
43APR_FrequencyDDL SearchAPR Frequency DDLIntegerAPR_DDL_Frequency0
44BUDGETID SearchBudget IDStringSTR15_LBAU15
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 RGIntegerAPR RG Year0
46APR_FTEReportRG SearchAPR FTE Report RGIntegerAPR FTE Report RG0
47APR_StartAreasofResp SearchAPR Start Areas of ResponsibilityStringSTR6_Payroll_Code6
48APR_EndAreasofRespon SearchAPR End Areas of ResponsibilityStringSTR6_Payroll_Code6
49APR_StartDateDDL SearchAPR Start Date DDLIntegerINT0
50APR_EndDateDDL SearchAPR End Date DDLIntegerINT0
51YEAR1 SearchYearIntegerYear4
52STRTPER1 SearchStartPeriod1IntegerINT33
53ENDPER1 SearchEndPeriod1IntegerINT33
54PERNAMES_1 SearchPeriod Names[1]StringSTR2020
55PERNAMES_2 SearchPeriod Names[2]StringSTR2020
56PERNAMES_3 SearchPeriod Names[3]StringSTR2020
57PERNAMES_4 SearchPeriod Names[4]StringSTR2020
58PERNAMES_5 SearchPeriod Names[5]StringSTR2020
59PERNAMES_6 SearchPeriod Names[6]StringSTR2020
60PERNAMES_7 SearchPeriod Names[7]StringSTR2020
61PERNAMES_8 SearchPeriod Names[8]StringSTR2020
62PERNAMES_9 SearchPeriod Names[9]StringSTR2020
63PERNAMES_10 SearchPeriod Names[10]StringSTR2020
64PERNAMES_11 SearchPeriod Names[11]StringSTR2020
65PERNAMES_12 SearchPeriod Names[12]StringSTR2020
66PERNAMES_13 SearchPeriod Names[13]StringSTR2020
67PERNAMES_14 SearchPeriod Names[14]StringSTR2020
68PERNAMES_15 SearchPeriod Names[15]StringSTR2020
69PERNAMES_16 SearchPeriod Names[16]StringSTR2020
70PERNAMES_17 SearchPeriod Names[17]StringSTR2020
71PERNAMES_18 SearchPeriod Names[18]StringSTR2020
72PERNAMES_19 SearchPeriod Names[19]StringSTR2020
73PERNAMES_20 SearchPeriod Names[20]StringSTR2020
74PERNAMES_21 SearchPeriod Names[21]StringSTR2020
75PERNAMES_22 SearchPeriod Names[22]StringSTR2020
76PERNAMES_23 SearchPeriod Names[23]StringSTR2020
77PERNAMES_24 SearchPeriod Names[24]StringSTR2020
78PERNAMES_25 SearchPeriod Names[25]StringSTR2020
79PERNAMES_26 SearchPeriod Names[26]StringSTR2020
80PERNAMES_27 SearchPeriod Names[27]StringSTR2020
81PERNAMES_28 SearchPeriod Names[28]StringSTR2020
82PERNAMES_29 SearchPeriod Names[29]StringSTR2020
83PERNAMES_30 SearchPeriod Names[30]StringSTR2020
azurecurveProductsHRM Solution Series (1911)PayrollAPR Department Report Options (APR_APR70500)

Leave a Reply

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