Flex Transaction File Data Elements

The Extract Identifier code for this file is FT.

 

Refer to Appendix B, “Flex Transaction Data-Map Process,” for details on how Flex Transaction 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

Location

R

20

AN

Member Location

4

MemberID

K

64

AN

ID Number of the Member (from their ID card)

5

FlexType

K

10

AN

Flex Type Code

6

PlanYear

K

4

NU

Plan Year (CCYY)

7

TransactionNumber

R

20

AN

Transaction Number

8

TransactionStatus

R

20

AN

Transaction Status

9

FlexRecordType

R

10

AN

Flex Record Type

10

FlexRecordTypeDesc

R

50

AN

Flex Record Type Description

11

ExpenseType

R

10

AN

Expense Type

12

ExpenseTypeDesc

R

50

AN

Expense Type Description

13

IncurredDate

R

8

DT

Incurred Date

14

PostingDate

R

8

DT

Posting Date

15

ProcessedDate

R

8

DT

Processed Date

16

Transaction

R

12

DE

Transaction Amount

17

Ineligible

R

12

DE

Ineligible Amount

18

TotalPaid

R

12

DE

Total Amount Paid

19

IneligibleCode

R

10

AN

Ineligible Code

20

IneligibleCodeDesc

R

50

AN

Ineligible Code Description

21

ReferenceNumber

R

20

AN

Reference Number

22

Comment

O

1000

AN

Comment

23

NumericQualifier1

O

50

AN

Numeric Qualifier 1

24

UserDefinedNumeric1

O

12

NU

User Defined Numeric Field 1

25

NumericQualifier2

O

50

AN

Numeric Qualifier 2

26

UserDefinedNumeric2

O

12

NU

User Defined Numeric Field 2

27

NumericQualifier3

O

50

AN

Numeric Qualifier 3

28

UserDefinedNumeric3

O

12

NU

User Defined Numeric Field 3

29

NumericQualifier4

O

50

AN

Numeric Qualifier 4

30

UserDefinedNumeric4

O

12

NU

User Defined Numeric Field 4

31

NumericQualifier5

O

50

AN

Numeric Qualifier 5

32

UserDefinedNumeric5

O

12

NU

User Defined Numeric Field 5

33

NumericQualifier6

O

50

AN

Numeric Qualifier 6

34

UserDefinedNumeric6

O

12

NU

User Defined Numeric Field 6

35

NumericQualifier7

O

50

AN

Numeric Qualifier 7

36

UserDefinedNumeric7

O

12

NU

User Defined Numeric Field 7

37

NumericQualifier8

O

50

AN

Numeric Qualifier 8


Field #

Field Name

Req.

Len

Type

Notes

38

UserDefinedNumeric8

O

12

NU

User Defined Numeric Field 8

39

TextQualifier1

O

50

AN

Text Qualifier 1

40

UserDefinedText1

O

50

AN

User Defined Text Field 1

41

TextQualifier2

O

50

AN

Text Qualifier 2

42

UserDefinedText2

O

50

AN

User Defined Text Field 2

43

TextQualifier3

O

50

AN

Text Qualifier 3

44

UserDefinedText3

O

50

AN

User Defined Text Field 3

45

TextQualifier4

O

50

AN

Text Qualifier 4

46

UserDefinedText4

O

50

AN

User Defined Text Field 4

47

TextQualifier5

O

50

AN

Text Qualifier 5

48

UserDefinedText5

O

50

AN

User Defined Text Field 5

49

TextQualifier6

O

50

AN

Text Qualifier 6

50

UserDefinedText6

O

50

AN

User Defined Text Field 6

51

TextQualifier7

O

50

AN

Text Qualifier 7

52

UserDefinedText7

O

50

AN

User Defined Text Field 7

53

TextQualifier8

O

50

AN

Text Qualifier 8

54

UserDefinedText8

O

50

AN

User Defined Text Field 8

55

DateQualifier1

O

50

AN

Date Qualifier 1

56

UserDefinedDate1

O

8

DT

User Defined Date Field 1

57

DateQualifier2

O

50

AN

Date Qualifier 2

58

UserDefinedDate2

O

8

DT

User Defined Date Field 2

59

DateQualifier3

O

50

AN

Date Qualifier 3

60

UserDefinedDate3

O

8

DT

User Defined Date Field 3

61

DateQualifier4

O

50

AN

Date Qualifier 4

62

UserDefinedDate4

O

8

DT

User Defined Date Field 4

63

DateQualifier5

O

50

AN

Date Qualifier 5

64

UserDefinedDate5

O

8

DT

User Defined Date Field 5

65

DateQualifier6

O

50

AN

Date Qualifier 6

66

UserDefinedDate6

O

8

DT

User Defined Date Field 6

67

DateQualifier7

O

50

AN

Date Qualifier 7

68

UserDefinedDate7

O

8

DT

User Defined Date Field 7

69

DateQualifier8

O

50

AN

Date Qualifier 8

70

UserDefinedDate8

O

8

DT

User Defined Date Field 8




Comments