Flex Election Data Elements

The Extract Identifier code for this file is FE.

 

Refer to Appendix B, “Flex Election Data-Map Process,” for details on how Flex Election records are added or updated in the Healthx database.

 

Field #

Field Name

Req.

Len

Type

Notes

1

VersionNumber

K

10

AN

Spec Version Number: 3.04

2

GroupNumber

K

20

AN

Group Number

3

GroupName

R

100

AN

Group Name

4

GroupAddress1

O

100

AN

Group Address Line 1

5

GroupAddress2

O

100

AN

Group Address Line 2

6

GroupCity

O

50

AN

Group City

7

GroupState

O

2

AN

Group State

8

GroupZip

O

10

AN

Group Zip Code

9

Location

R

9

AN

Member Location Code

10

LocationDesc

R

100

AN

Member Location Description

11

MemberID

K

64

AN

ID # of the Member (from their ID card)

12

SSN

R

9

AN

Member’s SSN

13

LastName

R

50

AN

Member Last Name

14

FirstName

R

50

AN

Member First Name

15

MiddleName

O

50

AN

Member Middle Name

16

Address1

O

100

AN

Member Address Line 1

17

Address2

O

100

AN

Member Address Line 2

18

City

O

50

AN

Member City

19

State

O

2

AN

Member State

20

Zip

O

10

AN

Member Zip Code

21

DOB

R

8

DT

Member Date of Birth

22

Gender

R

1

AN

Member Gender

23

FlexType

K

10

AN

Flex Type Code

24

FlexTypeDesc

R

50

AN

Flex Type Description

25

PlanYear

K

4

NU

Plan Year (CCYY)

26

PlanPeriodBeginDate

R

8

DT

Plan Period Begin Date

27

PlanPeriodEndDate

R

8

DT

Plan Period End Date

28

Contribution

R

12

DE

Contribution Amount

29

MaxContribution

R

12

DE

Maximum Contribution Amount

30

YTDContribution

R

12

DE

YTD Contribution

31

YTDPayment

R

12

DE

YTD Payments Made

32

BalanceRemaining

R

12

DE

Balance Remaining

33

Comment

O

1000

AN

Comments

34

TotalExpenses

R

12

DE

Total Expenses

35

NumericQualifier1

O

50

AN

Numeric Qualifier 1

36

UserDefinedNumeric1

O

12

NU

User Defined Numeric Field 1

37

NumericQualifier2

O

50

AN

Numeric Qualifier 2

38

UserDefinedNumeric2

O

12

NU

User Defined Numeric Field 2

39

NumericQualifier3

O

50

AN

Numeric Qualifier 3

40

UserDefinedNumeric3

O

12

NU

User Defined Numeric Field 3

41

NumericQualifier4

O

50

AN

Numeric Qualifier 4


Field #

Field Name

Req.

Len

Type

Notes

42

UserDefinedNumeric4

O

12

NU

User Defined Numeric Field 4

43

NumericQualifier5

O

50

AN

Numeric Qualifier 5

44

UserDefinedNumeric5

O

12

NU

User Defined Numeric Field 5

45

NumericQualifier6

O

50

AN

Numeric Qualifier 6

46

UserDefinedNumeric6

O

12

NU

User Defined Numeric Field 6

47

NumericQualifier7

O

50

AN

Numeric Qualifier 7

48

UserDefinedNumeric7

O

12

NU

User Defined Numeric Field 7

49

NumericQualifier8

O

50

AN

Numeric Qualifier 8

50

UserDefinedNumeric8

O

12

NU

User Defined Numeric Field 8

51

TextQualifier1

O

50

AN

Text Qualifier 1

52

UserDefinedText1

O

50

AN

User Defined Text Field 1

53

TextQualifier2

O

50

AN

Text Qualifier 2

54

UserDefinedText2

O

50

AN

User Defined Text Field 2

55

TextQualifier3

O

50

AN

Text Qualifier 3

56

UserDefinedText3

O

50

AN

User Defined Text Field 3

57

TextQualifier4

O

50

AN

Text Qualifier 4

58

UserDefinedText4

O

50

AN

User Defined Text Field 4

59

TextQualifier5

O

50

AN

Text Qualifier 5

60

UserDefinedText5

O

50

AN

User Defined Text Field 5

61

TextQualifier6

O

50

AN

Text Qualifier 6

62

UserDefinedText6

O

50

AN

User Defined Text Field 6

63

TextQualifier7

O

50

AN

Text Qualifier 7

64

UserDefinedText7

O

50

AN

User Defined Text Field 7

65

TextQualifier8

O

50

AN

Text Qualifier 8

66

UserDefinedText8

O

50

AN

User Defined Text Field 8

67

DateQualifier1

O

50

AN

Date Qualifier 1

68

UserDefinedDate1

O

8

DT

User Defined Date Field 1

69

DateQualifier2

O

50

AN

Date Qualifier 2

70

UserDefinedDate2

O

8

DT

User Defined Date Field 2

71

DateQualifier3

O

50

AN

Date Qualifier 3

72

UserDefinedDate3

O

8

DT

User Defined Date Field 3

73

DateQualifier4

O

50

AN

Date Qualifier 4

74

UserDefinedDate4

O

8

DT

User Defined Date Field 4

75

DateQualifier5

O

50

AN

Date Qualifier 5

76

UserDefinedDate5

O

8

DT

User Defined Date Field 5

77

DateQualifier6

O

50

AN

Date Qualifier 6

78

UserDefinedDate6

O

8

DT

User Defined Date Field 6

79

DateQualifier7

O

50

AN

Date Qualifier 7

80

UserDefinedDate7

O

8

DT

User Defined Date Field 7

81

DateQualifier8

O

50

AN

Date Qualifier 8

82

UserDefinedDate8

O

8

DT

User Defined Date Field 8

83

ActionFlag

R

1

AN

D = Delete

Blank = Load/Update



Comments