Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_PTO40400
Product: HRM Solution Series (1911)
Series:
Display Name: PTO Code Setup Group Display Name: HRM Solution Series
Physical Name: APR_PTO40400
Technical Name: APR_SETP_PTO
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PTO_Code  | PTO Code | String | STR15_LBU | 15 | |
| 2 | DSCRIPTN | Description | String | STR30 | 30 | |
| 3 | ID_Accrual_Code | ID Accrual Code | String | STR10_LBU | 10 | |
| 4 | ID_Accrual_Code_2 | ID Accrual Code 2 | String | STR10_LBU | 10 | |
| 5 | ID_Accrual_Code_3 | ID Accrual Code 3 | String | STR10_LBU | 10 | |
| 6 | ID_Accrual_Code_4 | ID Accrual Code 4 | String | STR10_LBU | 10 | |
| 7 | ID_End_Date | ID End Date | Date | DATE_LONG | 8 | |
| 8 | ID_End_Sick_Date | ID End Sick Date | Date | DATE_LONG | 8 | |
| 9 | ID_Max_Carry_Over_Hours | ID Max Carry Over Hours | Currency | ID_Max_Hours | 11 | |
| 10 | ID_Max_Sick_Carry_Over_H | ID Max Sick Carry Over Hours | Currency | ID_Max_Hours | 11 | |
| 11 | ID_Max_Vac_Type | ID Max Vac Type | Integer | ID Max Vac Type | 0 | |
| 12 | ID_Max_Sick_Type | ID Max Sick Type | Integer | ID Max Sick Type | 0 | |
| 13 | ID_Max_Sick_Hours | ID Max Sick Hours | Currency | ID_Max_Hours | 11 | |
| 14 | ID_Max_Code | ID Max Code | String | STR8_LBU | 8 | |
| 15 | ID_Max_Code_2 | ID Max Code 2 | String | STR8_LBU | 8 | |
| 16 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PTO Code Setup'].NOTEINDX AS 'PTO Code Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
APR_PTO40400 AS ['PTO Code Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PTO Code Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 17 | ID_Vac_Carry_Over_Anniv_ | ID Vac Carry Over Anniv Date | Boolean | ID Carry Over Anniv Date CB | 0 | |
| 18 | ID_Allow_Vac_Carry_Over | ID Allow Vac Carry Over | Boolean | ID_Allow_Vac_Carry_Over | 0 | |
| 19 | ID_Sick_Carry_Over_Anniv | ID Sick Carry Over Anniv Date | Boolean | ID Carry Over Anniv Date CB | 0 | |
| 20 | ID_Allow_Sick_Carry_Over | ID Allow Sick Carry Over | Boolean | ID_Allow_Sick_Carry_Over | 0 | |
| 21 | INACTIVE | Inactive | Boolean | CB_Inactive | 0 | |
| 22 | ID_Annualized_Expiration | ID Annualized Expiration | Boolean | CB_Annualized_Exp | 0 | |
| 23 | ID_Use_Anniversary_Years | ID Use Anniversary Years | Boolean | CB_Use Anniversary | 0 | |
| 24 | ID_Max_Annual_Hours | ID Max Vac Hours | Currency | ID_Max_Hours | 11 | |
| 25 | ID_Annualized_Sick_Expir | ID Annualized Sick Expiration | Boolean | CB_Annualized_Exp | 0 | |
| 26 | ID_Use_Sick_Anniv_Years | ID Use Sick Anniv Years | Boolean | CB_Use Anniversary | 0 | |