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 TypeLength
1APR_Plan_Code SearchAPR Plan CodeSTR15_Employee_IDString15
2APR_Option_Code SearchAPR Option CodeSTR15_Employee_IDString15
3APR_Attribute_Type SearchAPR Attribute TypeAPR Attribute TypeInteger0
4APR_Attribute_Code SearchAPR Attribute CodeSTR15_LBUString15
5APR_Default_Amount SearchAPR Default AmountDollar19Currency19
6APR_Default_Date SearchAPR Default DateDATEDate6
7APR_Default_String SearchAPR Default StringSTR30String30
8APR_Default_YesNo SearchAPR Default YesNoCBBoolean0
9APR_Minimum_Amount SearchAPR Minimum AmountDollar19Currency19
10APR_Maximum_Amount SearchAPR Maximum AmountDollar19Currency19
11APR_Validation_From_RG_1 SearchAPR Validation From RG[1]RG_DefaultInteger0
12APR_Validation_From_RG_2 SearchAPR Validation From RG[2]RG_DefaultInteger0
13APR_Required SearchAPR RequiredAPR RequiredBoolean0
14STRTDATE SearchStart DateDTDate8
15ENDDATE SearchEnd DateDTDate8
16APR_Comparison_DDL SearchAPR Comparison DDLAPR Comparison DDLInteger0
17PRCNTAGE SearchPercentageDLR5_%2Currency8
18APR_Enabled_CB_Array_1 SearchAPR Enabled CB Array[1]APR Enabled CBBoolean0
19APR_Enabled_CB_Array_2 SearchAPR Enabled CB Array[2]APR Enabled CBBoolean0
20APR_Enabled_CB_Array_3 SearchAPR Enabled CB Array[3]APR Enabled CBBoolean0
21APR_Enabled_CB_Array_4 SearchAPR Enabled CB Array[4]APR Enabled CBBoolean0
22APR_Enabled_CB_Array_5 SearchAPR Enabled CB Array[5]APR Enabled CBBoolean0
23APR_Enabled_CB_Array_6 SearchAPR Enabled CB Array[6]APR Enabled CBBoolean0
24APR_Enabled_CB_Array_7 SearchAPR Enabled CB Array[7]APR Enabled CBBoolean0
25APR_Enabled_CB_Array_8 SearchAPR Enabled CB Array[8]APR Enabled CBBoolean0
26APR_Enabled_CB_Array_9 SearchAPR Enabled CB Array[9]APR Enabled CBBoolean0
27APR_Enabled_CB_Array_10 SearchAPR Enabled CB Array[10]APR Enabled CBBoolean0
28APR_Attribute_Code_Array_1 SearchAPR Attribute Code Array[1]STR15_LBUString15
29APR_Attribute_Code_Array_2 SearchAPR Attribute Code Array[2]STR15_LBUString15
30APR_Attribute_Code_Array_3 SearchAPR Attribute Code Array[3]STR15_LBUString15
31APR_Attribute_Code_Array_4 SearchAPR Attribute Code Array[4]STR15_LBUString15
32APR_Attribute_Code_Array_5 SearchAPR Attribute Code Array[5]STR15_LBUString15
33APR_Attribute_Code_Array_6 SearchAPR Attribute Code Array[6]STR15_LBUString15
34APR_Attribute_Code_Array_7 SearchAPR Attribute Code Array[7]STR15_LBUString15
35APR_Attribute_Code_Array_8 SearchAPR Attribute Code Array[8]STR15_LBUString15
36APR_Attribute_Code_Array_9 SearchAPR Attribute Code Array[9]STR15_LBUString15
37APR_Attribute_Code_Array_10 SearchAPR Attribute Code Array[10]STR15_LBUString15
38DEX_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 Option Attributes (APR_BSS40301)

Leave a Reply

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