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:

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 IDStringSTR15_Employee_ID_I15
2IC_Instance_Number_I SearchIC Instance NumberIntegerINT44
3EFFECTIVEDATE_I SearchEffective Date0DateDT8
4LLASTNAME_I SearchLLast NameStringSTR2020
5FFIRSTNAME_I SearchFFirst NameStringSTR15_I15
6MI_I SearchMIStringISTR11
7ADDRESS1 SearchAddress 1StringSTR6060
8ADDRESS2 SearchAddress 2StringSTR6060
9CITY SearchCityStringSTR3535
10STATE SearchStateStringSTR30_State29
11ZIPCODE_I SearchIZip CodeStringSTR1010
12HOMEPHONE SearchHome PhoneStringSTR10_Phone10
13DATEOFBIRTH_I SearchDate Of BirthDateDT8
14RELATIONSHIP SearchRelationshipIntegerDDL_Relationship0
15DEPSSN_I SearchDep SSNStringSTR15_Social_Security_Number15
16SSN_I SearchISSNStringSTR15_Social_Security_Number15
17BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
18BNFBEGDT SearchBenefit Beg DateDateDT8
19COBRAQE_I SearchCOBRA QEIntegerGB_I0
20COMMENTSTR20 SearchCommentStr20StringSTR2020
21DSCRIPTN SearchDescriptionStringSTR3030
22IC_Initial_Balance_I SearchIC Initial BalanceCurrencyDLR14_RB2_ST$14
23COSTCOBRA_I SearchCost COBRACurrencyDLR11_$U214
24IC_Months_INT_I SearchIC Months INTIntegerINT44
25IC_Cobra_Month_DDL_I SearchIC Cobra Month DDLIntegerIC Cobra Month DDL0
26IC_Cobra_Dependent_DDL_I SearchIC Cobra Dependent DDLIntegerIC Cobra Dependent DDL0
27IC_Cobra_Employee_DDL_I SearchIC Cobra Employee DDLIntegerIC Cobra Employee DDL0
28IBENEFITFREQUENCY_I SearchIBenefit FrequencyIntegerDDL_Benefit_Frequency0
29IC_First_Payment_Date_I SearchIC First Payment DateDateDT8
30IC_Last_Payment_Date_I SearchIC Last Payment DateDateDT8
31IC_Auto_Post_CB_I SearchIC Auto Post CBBooleanIC Auto Post CB0
32IC_Next_Auto_Post_Date_I SearchIC Next Auto Post DateDateDT8
azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_COBRA_MSTR (BEA40100)

Leave a Reply

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