HL7 message and MSCM staging table
| MSCM STAGING TABLE (CLOVERLEAF_CHARGE_HEADER) | HL7 MESSAGE | ||||
|---|---|---|---|---|---|
| FIELD NAME | COLUMN NAME | DATA TYPE | CONSTRAINTS / COMMENTS |
DFT SEGMENT (BILLING SYSTEM) |
SEGMENT SUBCOMPONENT |
| CHARGE_BATCH_ID | NUMBER | PK, UNIQUE, NOT NULL. Auto-generated sequence number. Will also serve as the batch number. (Depends on the customer if they will use this batch id). | FT1-3 | ||
| Sending Application | SENDING_APP_ID | VARCHAR2 (20 BYTES) | NOT NULL | MSH-3 | |
| Sending Facility | FACILITY_CODE | VARCHAR2 (20 BYTES) | NOT NULL | MSH-4 | |
| Patient Identifier List | PATIENT_NO | VARCHAR2 (20 BYTES) | NOT NULL | PID-3 | ID Number |
| Patient Name | PATIENT_LNAME | VARCHAR2 (194 BYTES) | NOT NULL | PID-5.0 | Family Name |
| Patient Name | PATIENT_FNAME | VARCHAR2 (30 BYTES) | NOT NULL | PID-5.1 | Given Name |
| Patient Name | PATIENT_MNAME | VARCHAR2 (26 BYTES) | NULLABLE | PID-5.2 | Middle Name |
| Date/Time of Birth | PATIENT_BDATE | DATE | NULLABLE | PID-7 | |
| Patient Account Number | PATIENT_ACCT_NO | VARCHAR2 (20 BYTES) | NULLABLE | PID-18 | ID Number |
| Patient Class | PATIENT_CLASS | CHAR (1 BYTE) | NOT NULL | PV1-2 | |
| Patient Assigned Location | ROOM | VARCHAR2 (80 BYTES) | NULLABLE | PV1-3.1 | Room |
| Patient Assigned Location | BED | VARCHAR2 (80 BYTES) | NULLABLE | PV1-3.2 | Bed |
| Visit Number | VISIT_NO | VARCHAR2 (20 BYTES) | NULLABLE | PV1-19 | ID Number |
| Admit Date | ADMIT_DATE | DATE | NOT NULL | PV1-44 | |
| Discharge Date | DISCHARGE_DATE | DATE | NULLABLE | PV1-45 | |
| PROCESS_FLAG | CHAR (1 BYTE)) |
NOT NULL. DEFAULT to 0. Updated to 1 or 2 by CloverLeaf after processing. State whether: 0 – New record 1 – Processed successfully 2 – Processed with errors |
|||
| PROCESS_DESC | VARCHAR2 (194 BYTES) | NULLABLE. Updated by CloverLeaf after processing depending on the PROCESS_FLAG. Description of errors or constraints. | |||
| CREATE_DATE | TIMESTAMP | NON-NULLABLE. Auto generated system date upon creation of record. | |||
| LAST_UPDATE_DATE | TIMESTAMP | NON-NULLABLE. DEFAULT to CREATE_DATE. Updated by CloverLeaf after processing. | |||
| MSCM STAGING TABLE (CLOVERLEAF_CHARGE_DETAIL) | HL7 MESSAGE | ||||
|---|---|---|---|---|---|
| FIELD NAME | COLUMN NAME | DATA TYPE | CONSTRAINTS / COMMENTS |
DFT SEGMENT (BILLING SYSTEM) |
SEGMENT SUBCOMPONENT |
| CHARGE_ TRNSCTN_ ID | NUMBER | PK, UNIQUE, NOT NULL. Auto-generated sequence number. | |||
| Transaction Batch ID | BATCH_ID | NUMBER | FK to CLOVERLEAF_CHARGE_HEADER which will also serve as the batch number. (Depends on the customer if they will use this batch id). | FT1-3 | |
| Transaction Date | TRANS_DATE | TIMESTAMP | NOT NULL | FT1-4 | |
| Transaction Type | TRANS_TYPE | VARCHAR2 (8) | NOT NULL States whether: CG – Charge; CD – Credit | FT1-6 | |
| Transaction Code | TRANS_CODE | VARCHAR2(80) | NOT NULL. Item’s CDM Number. | FT1-7 | |
| Transaction Quantity | QUANTITY | NUMBER (13, 0) | NULLABLE | FT1-10 | |
| Item Amount | AMOUNT | NUMBER (13, 2) | NULLABLE | FT1-12 | |
| Revenue Code | REVENUE_CODE | VARCHAR2 (20) | NULLABLE | FT1-13 | |