PTO Code Setup (APR_PTO40400)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: PTO Code Setup
Physical Name: APR_PTO40400
Technical Name: APR_SETP_PTO

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PTO_Code SearchPTO CodeSTR15_LBUString15
2DSCRIPTN SearchDescriptionSTR30String30
3ID_Accrual_Code SearchID Accrual CodeSTR10_LBUString10
4ID_Accrual_Code_2 SearchID Accrual Code 2STR10_LBUString10
5ID_Accrual_Code_3 SearchID Accrual Code 3STR10_LBUString10
6ID_Accrual_Code_4 SearchID Accrual Code 4STR10_LBUString10
7ID_End_Date SearchID End DateDATE_LONGDate8
8ID_End_Sick_Date SearchID End Sick DateDATE_LONGDate8
9ID_Max_Carry_Over_Hours SearchID Max Carry Over HoursID_Max_HoursCurrency11
10ID_Max_Sick_Carry_Over_H SearchID Max Sick Carry Over HoursID_Max_HoursCurrency11
11ID_Max_Vac_Type SearchID Max Vac TypeID Max Vac TypeInteger0
12ID_Max_Sick_Type SearchID Max Sick TypeID Max Sick TypeInteger0
13ID_Max_Sick_Hours SearchID Max Sick HoursID_Max_HoursCurrency11
14ID_Max_Code SearchID Max CodeSTR8_LBUString8
15ID_Max_Code_2 SearchID Max Code 2STR8_LBUString8
16NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
17ID_Vac_Carry_Over_Anniv_ SearchID Vac Carry Over Anniv DateID Carry Over Anniv Date CBBoolean0
18ID_Allow_Vac_Carry_Over SearchID Allow Vac Carry OverID_Allow_Vac_Carry_OverBoolean0
19ID_Sick_Carry_Over_Anniv SearchID Sick Carry Over Anniv DateID Carry Over Anniv Date CBBoolean0
20ID_Allow_Sick_Carry_Over SearchID Allow Sick Carry OverID_Allow_Sick_Carry_OverBoolean0
21INACTIVE SearchInactiveCB_InactiveBoolean0
22ID_Annualized_Expiration SearchID Annualized ExpirationCB_Annualized_ExpBoolean0
23ID_Use_Anniversary_Years SearchID Use Anniversary YearsCB_Use AnniversaryBoolean0
24ID_Max_Annual_Hours SearchID Max Vac HoursID_Max_HoursCurrency11
25ID_Annualized_Sick_Expir SearchID Annualized Sick ExpirationCB_Annualized_ExpBoolean0
26ID_Use_Sick_Anniv_Years SearchID Use Sick Anniv YearsCB_Use AnniversaryBoolean0
27DEX_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 *