BSS Plan Benefit Attributes (APR_BSS40202)

azurecurveProductsHRM Solution Series (1911)PayrollBSS Plan Benefit Attributes (APR_BSS40202)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: BSS Plan Benefit Attributes
Physical Name: APR_BSS40202
Technical Name: APR_BSS_PlanBenefit_Attributes

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1APR_Plan_Code SearchAPR Plan CodeSTR15_Employee_IDString15
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
3APR_Attribute_Type SearchAPR Attribute TypeAPR Attribute TypeInteger0
4APR_Attribute_Code SearchAPR Attribute CodeSTR15_LBUString15
5APR_View_Rights_Enrollme SearchAPR View Rights EnrollmentAPR View Rights EnrollmentBoolean0
6APR_Edit_Rights_Enrollme SearchAPR Edit Rights EnrollmentAPR Edit Rights EnrollmentBoolean0
7APR_View_Rights_Existing SearchAPR View Rights ExistingAPR View Rights ExistingBoolean0
8APR_Default_Amount SearchAPR Default AmountDollar19Currency19
9APR_Default_Date SearchAPR Default DateDATEDate6
10APR_Default_String SearchAPR Default StringSTR30String30
11APR_Default_YesNo SearchAPR Default YesNoCBBoolean0
12APR_Minimum_Amount SearchAPR Minimum AmountDollar19Currency19
13APR_Maximum_Amount SearchAPR Maximum AmountDollar19Currency19
14APR_Required SearchAPR RequiredAPR RequiredBoolean0
15STRTDATE SearchStart DateDTDate8
16ENDDATE SearchEnd DateDTDate8
17DEX_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.

azurecurveProductsHRM Solution Series (1911)PayrollBSS Plan Benefit Attributes (APR_BSS40202)

Leave a Reply

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