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 Group Display Name: HRM Solution Series
Physical Name: APR_APR70500
Technical Name: APR_Options_ROPT
Group Technical Name: APR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | APR_RPTCH | APR Report Choices | Integer | LB_Financial_Report_Choices | 0 | |
2 | PRNTNOTS | Print Notes | Boolean | CB_Print_Notes | 0 | |
3 | PRNTTYPE | Print Type | Integer | GB | 0 | |
4 | ASKECHTM | Ask Each Time | Boolean | CB_Ask_Each_Time | 0 | |
5 | INCLGNDS | Include Legends | Boolean | CB_Include_Legends | 0 | |
6 | PRNTOFIL | Print to File | Boolean | CB_Print_to_File | 0 | |
7 | PRTOPRTR | Print to Printer | Boolean | CB_Print_to_Printer | 0 | |
8 | PRTOSCRN | Print to Screen | Boolean | CB_Print_to_Screen | 0 | |
9 | IFFILXST | If File Existing | Integer | GB | 0 | |
10 | FILEXPNM | File Export Name | String | STR255 | 255 | |
11 | EXPTTYPE | Export Type | Integer | INT | 0 | |
12 | RPTGRIND | Report Group Index | Integer | INT | 0 | |
13 | RTPACHIN | Report Palette Choice Index | Integer | INT | 0 | |
14 | RTGRSBIN | Report Group Sub Index | Currency | DLR14 | 14 | |
15 | SORTBY | Sort By | Integer | DDL_Sort_By | 0 | |
16 | MTHSLCTD | Month Selected | Integer | Month | 0 | |
17 | AUCTRLCD | Audit Control Code | String | STR13_LBAU | 13 | |
18 | INCINEMP | Include Inactive Employees | Boolean | CB_Include_Inactive_Employees | 0 | |
19 | STTEMPID | Start Employee ID | String | STR15_Employee_ID | 15 | |
20 | STTEMNAM | Start Employee Name | String | STR20 | 20 | |
21 | STRTDEPT | Start Department | String | STR6_Payroll_Code | 6 | |
22 | STTJBTIT | Start Job Title | String | STR6_Payroll_Code | 6 | |
23 | STRTNGDT | Starting Date | Date | DT | 8 | |
24 | STRTPYDT | Start Pay Date | Date | DT6 | 6 | |
25 | STPSTDDT | Start Posted Date | Date | DT | 8 | |
26 | STTEMPCL | Start Employee Class | String | STR15_Employee_Class | 15 | |
27 | STPRTKDT | Start Payroll Token Date | Integer | DDL_Payroll_Dates | 0 | |
28 | STTLOCID | Start Location ID | String | STR15_Location_ID | 15 | |
29 | STRTSPRVSRCD | Start Supervisor Code | String | STR6_U | 6 | |
30 | ENAUCNCD | End Audit Control Code | String | STR13_LBAU | 13 | |
31 | ENDEMPL | End Employee ID | String | STR15_Employee_ID | 15 | |
32 | ENEMPNAM | End Employee Name | String | STR20 | 20 | |
33 | ENDDEPT | End Department | String | STR6_Payroll_Code | 6 | |
34 | ENJBTITL | End Job Title | String | STR6_Payroll_Code | 6 | |
35 | ENDINGDT | Ending Date | Date | DT | 8 | |
36 | ENDPAYDT | End Pay Date | Date | DT6 | 6 | |
37 | ENPSTDDT | End Posted Date | Date | DT | 8 | |
38 | ENEMPCLS | End Employee Class | String | STR15_Employee_Class | 15 | |
39 | EPRTKNDT | End Payroll Token Date | Integer | DDL_Payroll_Dates | 0 | |
40 | ENDLOCID | End Location ID | String | STR15_Location_ID | 15 | |
41 | SEGSRTBY | Segment Sort By | Integer | INT1 | 1 | |
42 | RANGEBY | Range By | Integer | INT | 0 | |
43 | APR_FrequencyDDL | APR Frequency DDL | Integer | APR_DDL_Frequency | 0 | |
44 | BUDGETID | Budget ID | String | STR15_LBAU | 15 | |
Key to the Budget Master (GL00200).
Click to show/hideSELECT
['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 | ||||||
45 | APR_TypeofYearRG | APR Type of Year RG | Integer | APR RG Year | 0 | |
46 | APR_FTEReportRG | APR FTE Report RG | Integer | APR FTE Report RG | 0 | |
47 | APR_StartAreasofResp | APR Start Areas of Responsibility | String | STR6_Payroll_Code | 6 | |
48 | APR_EndAreasofRespon | APR End Areas of Responsibility | String | STR6_Payroll_Code | 6 | |
49 | APR_StartDateDDL | APR Start Date DDL | Integer | INT | 0 | |
50 | APR_EndDateDDL | APR End Date DDL | Integer | INT | 0 | |
51 | YEAR1 | Year | Integer | Year | 4 | |
52 | STRTPER1 | StartPeriod1 | Integer | INT3 | 3 | |
53 | ENDPER1 | EndPeriod1 | Integer | INT3 | 3 | |
54 | PERNAMES_1 | Period Names[1] | String | STR20 | 20 | |
55 | PERNAMES_2 | Period Names[2] | String | STR20 | 20 | |
56 | PERNAMES_3 | Period Names[3] | String | STR20 | 20 | |
57 | PERNAMES_4 | Period Names[4] | String | STR20 | 20 | |
58 | PERNAMES_5 | Period Names[5] | String | STR20 | 20 | |
59 | PERNAMES_6 | Period Names[6] | String | STR20 | 20 | |
60 | PERNAMES_7 | Period Names[7] | String | STR20 | 20 | |
61 | PERNAMES_8 | Period Names[8] | String | STR20 | 20 | |
62 | PERNAMES_9 | Period Names[9] | String | STR20 | 20 | |
63 | PERNAMES_10 | Period Names[10] | String | STR20 | 20 | |
64 | PERNAMES_11 | Period Names[11] | String | STR20 | 20 | |
65 | PERNAMES_12 | Period Names[12] | String | STR20 | 20 | |
66 | PERNAMES_13 | Period Names[13] | String | STR20 | 20 | |
67 | PERNAMES_14 | Period Names[14] | String | STR20 | 20 | |
68 | PERNAMES_15 | Period Names[15] | String | STR20 | 20 | |
69 | PERNAMES_16 | Period Names[16] | String | STR20 | 20 | |
70 | PERNAMES_17 | Period Names[17] | String | STR20 | 20 | |
71 | PERNAMES_18 | Period Names[18] | String | STR20 | 20 | |
72 | PERNAMES_19 | Period Names[19] | String | STR20 | 20 | |
73 | PERNAMES_20 | Period Names[20] | String | STR20 | 20 | |
74 | PERNAMES_21 | Period Names[21] | String | STR20 | 20 | |
75 | PERNAMES_22 | Period Names[22] | String | STR20 | 20 | |
76 | PERNAMES_23 | Period Names[23] | String | STR20 | 20 | |
77 | PERNAMES_24 | Period Names[24] | String | STR20 | 20 | |
78 | PERNAMES_25 | Period Names[25] | String | STR20 | 20 | |
79 | PERNAMES_26 | Period Names[26] | String | STR20 | 20 | |
80 | PERNAMES_27 | Period Names[27] | String | STR20 | 20 | |
81 | PERNAMES_28 | Period Names[28] | String | STR20 | 20 | |
82 | PERNAMES_29 | Period Names[29] | String | STR20 | 20 | |
83 | PERNAMES_30 | Period Names[30] | String | STR20 | 20 |