PTO Payroll Master (PTO00100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTO00100

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: PTO Payroll Master
Physical Name: PTO00100
Technical Name: PTO_UPR_MSTR

Group Display Name: PTO Tables
Group Technical Name: PTO_Tables

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2ID_Accrual_Code SearchID Accrual CodeSTR10_LBUString1210
3ID_Accrual_Code_2 SearchID Accrual Code 2STR10_LBUString1210
4ID_Accrual_Code_3 SearchID Accrual Code 3STR10_LBUString1210
5ID_Accrual_Code_4 SearchID Accrual Code 4STR10_LBUString1210
6ID_LTD_Vac_Hours_Worked SearchID LTD Vac Hours WorkedDLR11_S2Currency1011
7ID_LTD_Sick_Hours_Worked SearchID LTD Sick Hours WorkedDLR11_S2Currency1011
8ID_Vacation_Time_Accrued SearchID Vacation Time AccruedID_Max_HoursCurrency1011
9ID_Sick_Time_Accrued SearchID Sick Time AccruedID_Max_HoursCurrency1011
10ID_End_Date SearchID End DateDATE_LONGDate48
11ID_End_Sick_Date SearchID End Sick DateDATE_LONGDate48
12ID_Vacation_Hours_Pendin SearchID Vacation Hours PendingDLR11_S2Currency1011
13ID_Sick_Hours_Pending SearchID Sick Hours PendingDLR11_S2Currency1011
14ID_Max_Carry_Over_Hours SearchID Max Carry Over HoursID_Max_HoursCurrency1011
15ID_Max_Sick_Carry_Over_H SearchID Max Sick Carry Over HoursID_Max_HoursCurrency1011
16ID_Max_Annual_Hours SearchID Max Vac HoursID_Max_HoursCurrency1011
17ID_Annualized_Expiration SearchID Annualized ExpirationCB_Annualized_ExpBoolean20
18ID_Use_Anniversary_Years SearchID Use Anniversary YearsCB_Use AnniversaryBoolean20
19ID_Annualized_Sick_Expir SearchID Annualized Sick ExpirationCB_Annualized_ExpBoolean20
20ID_Use_Sick_Anniv_Years SearchID Use Sick Anniv YearsCB_Use AnniversaryBoolean20
21ID_Max_Vac_Type SearchID Max Vac TypeID Max Vac TypeInteger20
22ID_Max_Sick_Type SearchID Max Sick TypeID Max Sick TypeInteger20
23ID_Max_Sick_Hours SearchID Max Sick HoursID_Max_HoursCurrency1011
24ID_Max_Code SearchID Max CodeSTR8_LBUString108
25ID_Max_Code_2 SearchID Max Code 2STR8_LBUString108
26NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
27PTO_Code SearchPTO CodeSTR15_LBUString1615
28INACTIVE SearchInactiveCB_InactiveBoolean20
29DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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