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 TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2IC_Instance_Number_I SearchIC Instance NumberINT4Integer4
3EFFECTIVEDATE_I SearchEffective Date0DTDate8
4LLASTNAME_I SearchLLast NameSTR20String20
5FFIRSTNAME_I SearchFFirst NameSTR15_IString15
6MI_I SearchMIISTR1String1
7ADDRESS1 SearchAddress 1STR60String60
8ADDRESS2 SearchAddress 2STR60String60
9CITY SearchCitySTR35String35
10STATE SearchStateSTR30_StateString29
11ZIPCODE_I SearchIZip CodeSTR10String10
12HOMEPHONE SearchHome PhoneSTR10_PhoneString10
13DATEOFBIRTH_I SearchDate Of BirthDTDate8
14RELATIONSHIP SearchRelationshipDDL_RelationshipInteger0
15DEPSSN_I SearchDep SSNSTR15_Social_Security_NumberString15
16SSN_I SearchISSNSTR15_Social_Security_NumberString15
17BENEFITEXPIRE_I SearchBenefit ExpireDTDate8
18BNFBEGDT SearchBenefit Beg DateDTDate8
19COBRAQE_I SearchCOBRA QEGB_IInteger0
20COMMENTSTR20 SearchCommentStr20STR20String20
21DSCRIPTN SearchDescriptionSTR30String30
22IC_Initial_Balance_I SearchIC Initial BalanceDLR14_RB2_ST$Currency14
23COSTCOBRA_I SearchCost COBRADLR11_$U2Currency14
24IC_Months_INT_I SearchIC Months INTINT4Integer4
25IC_Cobra_Month_DDL_I SearchIC Cobra Month DDLIC Cobra Month DDLInteger0
26IC_Cobra_Dependent_DDL_I SearchIC Cobra Dependent DDLIC Cobra Dependent DDLInteger0
27IC_Cobra_Employee_DDL_I SearchIC Cobra Employee DDLIC Cobra Employee DDLInteger0
28IBENEFITFREQUENCY_I SearchIBenefit FrequencyDDL_Benefit_FrequencyInteger0
29IC_First_Payment_Date_I SearchIC First Payment DateDTDate8
30IC_Last_Payment_Date_I SearchIC Last Payment DateDTDate8
31IC_Auto_Post_CB_I SearchIC Auto Post CBIC Auto Post CBBoolean0
32IC_Next_Auto_Post_Date_I SearchIC Next Auto Post DateDTDate8
33DEX_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.

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_COBRA_MSTR (BEA40100)

Leave a Reply

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