BSS Plan Benefit Header (APR_BSS40200)

azurecurveProductsHRM Solution Series (1911)PayrollBSS Plan Benefit Header (APR_BSS40200)

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

Product: HRM Solution Series (1911)
Series:

Display Name: BSS Plan Benefit Header
Physical Name: APR_BSS40200
Technical Name: APR_BSS_PlanBenefit_Header

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1APR_Plan_Code SearchAPR Plan CodeStringSTR15_Employee_ID15
2DSCRIPTN SearchDescriptionStringSTR3030
3INACTIVE SearchInactiveBooleanCB_Inactive0
4APR_Required_Selection SearchAPR Required SelectionBooleanCB APR Required Selection0
5APR_Multi_Selection SearchAPR Multi SelectionIntegerAPR_MultiSelection0
6BENEFIT SearchBenefitStringSTR6_Payroll_Code6
7APR_Benefit_Type SearchAPR Benefit TypeStringSTR15_LBU15
8APR_Age_Range_Enabled SearchAPR Age Range EnabledBooleanAPR Age Range Enabled0
9APR_Age_Based_On SearchAPR Age Based OnIntegerAPR Age Based On0
10APR_Age_From SearchAPR Age FromIntegerINT33
11APR_Age_To SearchAPR Age ToIntegerINT33
12NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['BSS Plan Benefit Header'].NOTEINDX AS 'BSS Plan Benefit Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       APR_BSS40200 AS ['BSS Plan Benefit Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['BSS Plan Benefit Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
azurecurveProductsHRM Solution Series (1911)PayrollBSS Plan Benefit Header (APR_BSS40200)

Leave a Reply

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