BSS Plan Option Attributes (APR_BSS40301)

azurecurveProductsHRM Solution Series (1911)PayrollBSS Plan Option Attributes (APR_BSS40301)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: BSS Plan Option Attributes
Physical Name: APR_BSS40301
Technical Name: APR_BSS_PlanOptionAttributes

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1APR_Plan_Code SearchAPR Plan CodeSTR15_Employee_IDString1615
2APR_Option_Code SearchAPR Option CodeSTR15_Employee_IDString1615
3APR_Attribute_Type SearchAPR Attribute TypeAPR Attribute TypeInteger20
4APR_Attribute_Code SearchAPR Attribute CodeSTR15_LBUString1615
5APR_Default_Amount SearchAPR Default AmountDollar19Currency1019
6APR_Default_Date SearchAPR Default DateDATEDate46
7APR_Default_String SearchAPR Default StringSTR30String3230
8APR_Default_YesNo SearchAPR Default YesNoCBBoolean20
9APR_Minimum_Amount SearchAPR Minimum AmountDollar19Currency1019
10APR_Maximum_Amount SearchAPR Maximum AmountDollar19Currency1019
11APR_Validation_From_RG_1 SearchAPR Validation From RG[1]RG_DefaultInteger20
12APR_Validation_From_RG_2 SearchAPR Validation From RG[2]RG_DefaultInteger20
13APR_Required SearchAPR RequiredAPR RequiredBoolean20
14STRTDATE SearchStart DateDTDate48
15ENDDATE SearchEnd DateDTDate48
16APR_Comparison_DDL SearchAPR Comparison DDLAPR Comparison DDLInteger20
17PRCNTAGE SearchPercentageDLR5_%2Currency108
18APR_Enabled_CB_Array_1 SearchAPR Enabled CB Array[1]APR Enabled CBBoolean20
19APR_Enabled_CB_Array_2 SearchAPR Enabled CB Array[2]APR Enabled CBBoolean20
20APR_Enabled_CB_Array_3 SearchAPR Enabled CB Array[3]APR Enabled CBBoolean20
21APR_Enabled_CB_Array_4 SearchAPR Enabled CB Array[4]APR Enabled CBBoolean20
22APR_Enabled_CB_Array_5 SearchAPR Enabled CB Array[5]APR Enabled CBBoolean20
23APR_Enabled_CB_Array_6 SearchAPR Enabled CB Array[6]APR Enabled CBBoolean20
24APR_Enabled_CB_Array_7 SearchAPR Enabled CB Array[7]APR Enabled CBBoolean20
25APR_Enabled_CB_Array_8 SearchAPR Enabled CB Array[8]APR Enabled CBBoolean20
26APR_Enabled_CB_Array_9 SearchAPR Enabled CB Array[9]APR Enabled CBBoolean20
27APR_Enabled_CB_Array_10 SearchAPR Enabled CB Array[10]APR Enabled CBBoolean20
28APR_Attribute_Code_Array_1 SearchAPR Attribute Code Array[1]STR15_LBUString1615
29APR_Attribute_Code_Array_2 SearchAPR Attribute Code Array[2]STR15_LBUString1615
30APR_Attribute_Code_Array_3 SearchAPR Attribute Code Array[3]STR15_LBUString1615
31APR_Attribute_Code_Array_4 SearchAPR Attribute Code Array[4]STR15_LBUString1615
32APR_Attribute_Code_Array_5 SearchAPR Attribute Code Array[5]STR15_LBUString1615
33APR_Attribute_Code_Array_6 SearchAPR Attribute Code Array[6]STR15_LBUString1615
34APR_Attribute_Code_Array_7 SearchAPR Attribute Code Array[7]STR15_LBUString1615
35APR_Attribute_Code_Array_8 SearchAPR Attribute Code Array[8]STR15_LBUString1615
36APR_Attribute_Code_Array_9 SearchAPR Attribute Code Array[9]STR15_LBUString1615
37APR_Attribute_Code_Array_10 SearchAPR Attribute Code Array[10]STR15_LBUString1615
38DEX_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 Option Attributes (APR_BSS40301)

Leave a Reply

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