Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTO00100
Product: HRM Solution Series (1911)
Series:
Display Name: PTO Payroll Master Group Display Name: PTO Tables
Physical Name: PTO00100
Technical Name: PTO_UPR_MSTR
Group Technical Name: PTO_Tables
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | EMPLOYID  | Employee ID | String | STR15_Employee_ID | 15 | |
| 2 | ID_Accrual_Code | ID Accrual Code | String | STR10_LBU | 10 | |
| 3 | ID_Accrual_Code_2 | ID Accrual Code 2 | String | STR10_LBU | 10 | |
| 4 | ID_Accrual_Code_3 | ID Accrual Code 3 | String | STR10_LBU | 10 | |
| 5 | ID_Accrual_Code_4 | ID Accrual Code 4 | String | STR10_LBU | 10 | |
| 6 | ID_LTD_Vac_Hours_Worked | ID LTD Vac Hours Worked | Currency | DLR11_S2 | 11 | |
| 7 | ID_LTD_Sick_Hours_Worked | ID LTD Sick Hours Worked | Currency | DLR11_S2 | 11 | |
| 8 | ID_Vacation_Time_Accrued | ID Vacation Time Accrued | Currency | ID_Max_Hours | 11 | |
| 9 | ID_Sick_Time_Accrued | ID Sick Time Accrued | Currency | ID_Max_Hours | 11 | |
| 10 | ID_End_Date | ID End Date | Date | DATE_LONG | 8 | |
| 11 | ID_End_Sick_Date | ID End Sick Date | Date | DATE_LONG | 8 | |
| 12 | ID_Vacation_Hours_Pendin | ID Vacation Hours Pending | Currency | DLR11_S2 | 11 | |
| 13 | ID_Sick_Hours_Pending | ID Sick Hours Pending | Currency | DLR11_S2 | 11 | |
| 14 | ID_Max_Carry_Over_Hours | ID Max Carry Over Hours | Currency | ID_Max_Hours | 11 | |
| 15 | ID_Max_Sick_Carry_Over_H | ID Max Sick Carry Over Hours | Currency | ID_Max_Hours | 11 | |
| 16 | ID_Max_Annual_Hours | ID Max Vac Hours | Currency | ID_Max_Hours | 11 | |
| 17 | ID_Annualized_Expiration | ID Annualized Expiration | Boolean | CB_Annualized_Exp | 0 | |
| 18 | ID_Use_Anniversary_Years | ID Use Anniversary Years | Boolean | CB_Use Anniversary | 0 | |
| 19 | ID_Annualized_Sick_Expir | ID Annualized Sick Expiration | Boolean | CB_Annualized_Exp | 0 | |
| 20 | ID_Use_Sick_Anniv_Years | ID Use Sick Anniv Years | Boolean | CB_Use Anniversary | 0 | |
| 21 | ID_Max_Vac_Type | ID Max Vac Type | Integer | ID Max Vac Type | 0 | |
| 22 | ID_Max_Sick_Type | ID Max Sick Type | Integer | ID Max Sick Type | 0 | |
| 23 | ID_Max_Sick_Hours | ID Max Sick Hours | Currency | ID_Max_Hours | 11 | |
| 24 | ID_Max_Code | ID Max Code | String | STR8_LBU | 8 | |
| 25 | ID_Max_Code_2 | ID Max Code 2 | String | STR8_LBU | 8 | |
| 26 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PTO Payroll Master'].NOTEINDX AS 'PTO Payroll Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PTO00100 AS ['PTO Payroll Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PTO Payroll Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 27 | PTO_Code | PTO Code | String | STR15_LBU | 15 | |
| 28 | INACTIVE | Inactive | Boolean | CB_Inactive | 0 | |