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 TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2ID_Accrual_Code SearchID Accrual CodeSTR10_LBUString10
3ID_Accrual_Code_2 SearchID Accrual Code 2STR10_LBUString10
4ID_Accrual_Code_3 SearchID Accrual Code 3STR10_LBUString10
5ID_Accrual_Code_4 SearchID Accrual Code 4STR10_LBUString10
6ID_LTD_Vac_Hours_Worked SearchID LTD Vac Hours WorkedDLR11_S2Currency11
7ID_LTD_Sick_Hours_Worked SearchID LTD Sick Hours WorkedDLR11_S2Currency11
8ID_Vacation_Time_Accrued SearchID Vacation Time AccruedID_Max_HoursCurrency11
9ID_Sick_Time_Accrued SearchID Sick Time AccruedID_Max_HoursCurrency11
10ID_End_Date SearchID End DateDATE_LONGDate8
11ID_End_Sick_Date SearchID End Sick DateDATE_LONGDate8
12ID_Vacation_Hours_Pendin SearchID Vacation Hours PendingDLR11_S2Currency11
13ID_Sick_Hours_Pending SearchID Sick Hours PendingDLR11_S2Currency11
14ID_Max_Carry_Over_Hours SearchID Max Carry Over HoursID_Max_HoursCurrency11
15ID_Max_Sick_Carry_Over_H SearchID Max Sick Carry Over HoursID_Max_HoursCurrency11
16ID_Max_Annual_Hours SearchID Max Vac HoursID_Max_HoursCurrency11
17ID_Annualized_Expiration SearchID Annualized ExpirationCB_Annualized_ExpBoolean0
18ID_Use_Anniversary_Years SearchID Use Anniversary YearsCB_Use AnniversaryBoolean0
19ID_Annualized_Sick_Expir SearchID Annualized Sick ExpirationCB_Annualized_ExpBoolean0
20ID_Use_Sick_Anniv_Years SearchID Use Sick Anniv YearsCB_Use AnniversaryBoolean0
21ID_Max_Vac_Type SearchID Max Vac TypeID Max Vac TypeInteger0
22ID_Max_Sick_Type SearchID Max Sick TypeID Max Sick TypeInteger0
23ID_Max_Sick_Hours SearchID Max Sick HoursID_Max_HoursCurrency11
24ID_Max_Code SearchID Max CodeSTR8_LBUString8
25ID_Max_Code_2 SearchID Max Code 2STR8_LBUString8
26NOTEINDX SearchNote IndexDLR14Currency14
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_LBUString15
28INACTIVE SearchInactiveCB_InactiveBoolean0
29DEX_ROW_ID Searchintint10

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 *