Procedure

TYPE

LEN

REQ

VALUE

NOTES

PK

Y

Procedure Primary Key

VARCHAR

100

Y

Client ID

Healthjump's client identifier.

VARCHAR

40

Y

Patient ID

VARCHAR

100

Y

CPT4/HCPCS Code

VARCHAR

1000

Procedure Description

VARCHAR

10

Procedure Date

Format: YYYYMMDD

VARCHAR

20

Units

VARCHAR

20

Modifier Code 1

CPT-4 or HCPCS modifier code

VARCHAR

20

Modifier Code 2

CPT-4 or HCPCS modifier code

VARCHAR

20

Modifier Code 3

CPT-4 or HCPCS modifier code

VARCHAR

20

Modifier Code 4

CPT-4 or HCPCS modifier code

VARCHAR

100

Place of Service

CMS place of service. Needs to be the actual name of the location.

VARCHAR

100

Performed by Clinician

Must be NPI

VARCHAR

100

Ordered by Clinician

Must be NPI

VARCHAR

40

Encounter Unique ID

Identifies the encounter during which this was performed from the source system.

VARCHAR

20

Internal Charge Code

VARCHAR

20

Total Charges

VARCHAR

20

Y*

LINC Code

VARCHAR

20

Y*

SNOMEDCode

VARCHAR

50

Procedure Result

Any result data associated with the performed procedure such as PHQ9, HCPCS, LOINC, SNOMED (mammogram, colonoscopy, diabetic eye exam results, etc.)

DATE (Time)

HJ Create Timestamp

For internal Healthjump use and reference. 

DATE (Time)

HJ Modify Timestamp

For internal Healthjump use and reference. 

VARCHAR

50

Dx1 Code

VARCHAR

50

Dx2 Code

VARCHAR

50

Dx3 Code

VARCHAR

50

Dx4 Code

VARCHAR

50

Dx5 Code

VARCHAR

50

Dx6 Code

VARCHAR

50

Dx7 Code

VARCHAR

50

Dx8 Code

VARCHAR

50

Client Procedure ID

CHAR

32

Row Hash