Archive_HR_Benefit_COBRA_MSTR (BEA40100)

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_COBRA_MSTR (BEA40100)

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

Product: Human Resources (414)
Series: 3rd Party

Display Name: Archive_HR_Benefit_COBRA_MSTR
Physical Name: BEA40100
Technical Name: Archive_HR_Benefit_COBRA_MSTR

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2IC_Instance_Number_I SearchIC Instance NumberINT4Integer24
3EFFECTIVEDATE_I SearchEffective Date0DTDate48
4LLASTNAME_I SearchLLast NameSTR20String2220
5FFIRSTNAME_I SearchFFirst NameSTR15_IString1615
6MI_I SearchMIISTR1String21
7ADDRESS1 SearchAddress 1STR60String6260
8ADDRESS2 SearchAddress 2STR60String6260
9CITY SearchCitySTR35String3635
10STATE SearchStateSTR30_StateString3029
11ZIPCODE_I SearchIZip CodeSTR10String1210
12HOMEPHONE SearchHome PhoneSTR10_PhoneString2210
13DATEOFBIRTH_I SearchDate Of BirthDTDate48
14RELATIONSHIP SearchRelationshipDDL_RelationshipInteger20
15DEPSSN_I SearchDep SSNSTR15_Social_Security_NumberString1615
16SSN_I SearchISSNSTR15_Social_Security_NumberString1615
17BENEFITEXPIRE_I SearchBenefit ExpireDTDate48
18BNFBEGDT SearchBenefit Beg DateDTDate48
19COBRAQE_I SearchCOBRA QEGB_IInteger20
20COMMENTSTR20 SearchCommentStr20STR20String2220
21DSCRIPTN SearchDescriptionSTR30String3230
22IC_Initial_Balance_I SearchIC Initial BalanceDLR14_RB2_ST$Currency1014
23COSTCOBRA_I SearchCost COBRADLR11_$U2Currency1014
24IC_Months_INT_I SearchIC Months INTINT4Integer24
25IC_Cobra_Month_DDL_I SearchIC Cobra Month DDLIC Cobra Month DDLInteger20
26IC_Cobra_Dependent_DDL_I SearchIC Cobra Dependent DDLIC Cobra Dependent DDLInteger20
27IC_Cobra_Employee_DDL_I SearchIC Cobra Employee DDLIC Cobra Employee DDLInteger20
28IBENEFITFREQUENCY_I SearchIBenefit FrequencyDDL_Benefit_FrequencyInteger20
29IC_First_Payment_Date_I SearchIC First Payment DateDTDate48
30IC_Last_Payment_Date_I SearchIC Last Payment DateDTDate48
31IC_Auto_Post_CB_I SearchIC Auto Post CBIC Auto Post CBBoolean20
32IC_Next_Auto_Post_Date_I SearchIC Next Auto Post DateDTDate48
33DEX_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.

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_COBRA_MSTR (BEA40100)

Leave a Reply

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