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 TypeSQL DB LengthKeyable Length
1APR_Plan_Code SearchAPR Plan CodeSTR15_Employee_IDString1615
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3APR_Attribute_Type SearchAPR Attribute TypeAPR Attribute TypeInteger20
4APR_Attribute_Code SearchAPR Attribute CodeSTR15_LBUString1615
5APR_View_Rights_Enrollme SearchAPR View Rights EnrollmentAPR View Rights EnrollmentBoolean20
6APR_Edit_Rights_Enrollme SearchAPR Edit Rights EnrollmentAPR Edit Rights EnrollmentBoolean20
7APR_View_Rights_Existing SearchAPR View Rights ExistingAPR View Rights ExistingBoolean20
8APR_Default_Amount SearchAPR Default AmountDollar19Currency1019
9APR_Default_Date SearchAPR Default DateDATEDate46
10APR_Default_String SearchAPR Default StringSTR30String3230
11APR_Default_YesNo SearchAPR Default YesNoCBBoolean20
12APR_Minimum_Amount SearchAPR Minimum AmountDollar19Currency1019
13APR_Maximum_Amount SearchAPR Maximum AmountDollar19Currency1019
14APR_Required SearchAPR RequiredAPR RequiredBoolean20
15STRTDATE SearchStart DateDTDate48
16ENDDATE SearchEnd DateDTDate48
17DEX_ROW_ID Searchintint1010

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 *