Document extraction will read and write documents to S3 in the format they are natively stored in. Such as pdf, word, jpeg, png, tiff, etc.
Once extracted, document metadata will be available via the Patient_Document table in Redshift and via API, DBX, and unloads. The S3 file path is where the document can be retrieved. Extraction timelines for backloads are dependent on patient volume and how far back documents are extracted.
Please reach out to your sales executive for setup/backload costs.
| Column Name | Type | Length | Required | Notes |
| HJ_Import_Int | INT | Y | For internal Healthjump use and reference. | |
| Client_ID | VARCHAR | 100 | Y | HJ assigned id |
| Patient_ID | VARCHAR | 64 | Y | Patient id that joins to demographic client_patient_id |
| Document_ID | VARCHAR | 64 | Y | The document's unique identifier in the source system |
| Encounter_ID | VARCHAR | 64 | N | Encounter id document is tied to, maybe empty as not all documents are associated with an encounter |
| Document_Type | VARCHAR | 100 | N | Grouper in EMR index such as Clinical Document, Image Result |
| Document_Description | VARCHAR | 1000 | N | Description of document such as Cardiology Progress Note |
| Document_Date | VARCHAR | 8 | N | Date of document - Format: YYYYMMDD |
| Document_Signed_By | VARCHAR | 100 | N | User that signed and/or generated the document |
| Document_Signed_Date | VARCHAR | 8 | Date document was signed | |
| File_Name | VARCHAR | 1000 | Y | Name of document stored in S3 |
| File_Path | VARCHAR | 1000 | Y | Path to document in S3 |
| Fetch_Document | CHAR | 1 | Y | Y/N for document fetch. Y indicates document is available and path_path will be documented |
| source_file_storage_type | CHAR | 1 | Y | How the document was stored in the source system. 1 = Physical, 0 = Text in DB |
| source_create_timestamp | TIMESTAMP | Y | Date document was first created in the source system | |
| source_modify_timestamp | TIMESTAMP | Y | Date document was last modified in the source system | |
| hj_create_timestamp | TIMESTAMP | Y | For internal Healthjump use and reference. | |
| hj_modify_timestamp | TIMESTAMP | Y | For internal Healthjump use and reference. | |
| row_hash | CHAR | 32 | Y | For internal Healthjump use and reference. |