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:

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 CodeStringSTR15_LBU15
2DSCRIPTN SearchDescriptionStringSTR3030
3ID_Accrual_Code SearchID Accrual CodeStringSTR10_LBU10
4ID_Accrual_Code_2 SearchID Accrual Code 2StringSTR10_LBU10
5ID_Accrual_Code_3 SearchID Accrual Code 3StringSTR10_LBU10
6ID_Accrual_Code_4 SearchID Accrual Code 4StringSTR10_LBU10
7ID_End_Date SearchID End DateDateDATE_LONG8
8ID_End_Sick_Date SearchID End Sick DateDateDATE_LONG8
9ID_Max_Carry_Over_Hours SearchID Max Carry Over HoursCurrencyID_Max_Hours11
10ID_Max_Sick_Carry_Over_H SearchID Max Sick Carry Over HoursCurrencyID_Max_Hours11
11ID_Max_Vac_Type SearchID Max Vac TypeIntegerID Max Vac Type0
12ID_Max_Sick_Type SearchID Max Sick TypeIntegerID Max Sick Type0
13ID_Max_Sick_Hours SearchID Max Sick HoursCurrencyID_Max_Hours11
14ID_Max_Code SearchID Max CodeStringSTR8_LBU8
15ID_Max_Code_2 SearchID Max Code 2StringSTR8_LBU8
16NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateBooleanID Carry Over Anniv Date CB0
18ID_Allow_Vac_Carry_Over SearchID Allow Vac Carry OverBooleanID_Allow_Vac_Carry_Over0
19ID_Sick_Carry_Over_Anniv SearchID Sick Carry Over Anniv DateBooleanID Carry Over Anniv Date CB0
20ID_Allow_Sick_Carry_Over SearchID Allow Sick Carry OverBooleanID_Allow_Sick_Carry_Over0
21INACTIVE SearchInactiveBooleanCB_Inactive0
22ID_Annualized_Expiration SearchID Annualized ExpirationBooleanCB_Annualized_Exp0
23ID_Use_Anniversary_Years SearchID Use Anniversary YearsBooleanCB_Use Anniversary0
24ID_Max_Annual_Hours SearchID Max Vac HoursCurrencyID_Max_Hours11
25ID_Annualized_Sick_Expir SearchID Annualized Sick ExpirationBooleanCB_Annualized_Exp0
26ID_Use_Sick_Anniv_Years SearchID Use Sick Anniv YearsBooleanCB_Use Anniversary0

Leave a Reply

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