|
Name |
Type |
Discontinued? |
|
| 1 |
TX_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the transaction record. |
|
|
| 2 |
ORIGINATING_TAR_ID |
NUMERIC |
No |
|
|
|
| This item holds the originating temporary transaction ID for this transaction. If the transaction is a charge, then the originating temporary transaction ID will be the temporary transaction ID of the charge. If transaction is a payment, then the originating temporary transaction ID will be the payment temporary transaction ID unless the payment is from fast payment. In the fast payment case, the originating temporary transaction ID will be the charge temporary transaction ID. |
|
|
| 3 |
SOURCE_TAR_ID |
NUMERIC |
No |
|
|
|
| This item holds the source temporary transaction ID for this transaction. The source temporary transaction ID will always be equal to the temporary transaction ID that generates the transaction. |
|
|
| 4 |
SRC_TAR_CHG_LINE |
INTEGER |
No |
|
|
|
| Indicates the temporary transaction charge line this transaction originated from. |
|
|
| 5 |
PAT_AGING_DATE |
DATETIME |
No |
|
|
|
| Aging date used for self-pay aged A/R |
|
|
| 6 |
INS_AGING_DATE |
DATETIME |
No |
|
|
|
| Aging date used for insurance aged A/R |
|
|
| 7 |
HOSP_ACCT_ID |
NUMERIC |
No |
|
|
|
| This item stores the hospital account record ID for the transaction. |
|
|
| 8 |
ORDER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the order record that triggered this transaction. This item is not always populated if you use the Charge Router. |
|
|
| 9 |
EXT_REF_NUM |
VARCHAR |
No |
|
|
|
| External reference number. This is a customer item that can be populated as they see fit. Typically, this item is populated with data from an external system via an interface or transaction import. |
|
|
| 10 |
REFERENCE_NUM |
VARCHAR |
No |
|
|
|
| This item stores the reference number (check number) for a payment transaction. |
|
|
| 11 |
PMT_RECEIPT_NUM |
VARCHAR |
No |
|
|
|
| This item stores the receipt number for a payment transaction. |
|
|
| 12 |
PAT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the patient type for the patient on this transaction. |
| May contain organization-specific values: Yes |
|
|
| 13 |
REFERRAL_PROV_ID |
VARCHAR |
No |
|
|
|
| This stores this transaction's referral provider. Note that this field is linked to the referral source master file and not the provider master file. |
|
|
| 14 |
REFERRAL_PROV_ID_REFERRING_PROV_NAM |
VARCHAR |
No |
|
|
|
| The name of the referral source. |
|
|
| 15 |
INSURANCE_AMT_PAID |
NUMERIC |
No |
|
|
|
| This item stores the insurance amount that has been paid on a charge transaction. |
|
|
| 16 |
WRITEOFF_EXCEPT_C_NAME |
VARCHAR |
No |
|
|
|
| The Yes-No write-off category number for a charge transaction. The value indicates whether the charge transaction was adjudicated as a write-off in charge entry and thus the insurance portion write-off is suppressed. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| Yes, No NCC either |
|
|
| 17 |
PAT_LOCATION_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the location associated with the patient for this transaction. |
|
|
| 18 |
ORIG_PRICE |
NUMERIC |
No |
|
|
|
| This item stores the original price of the transaction if the price was changed during charge entry. |
|
|
| 19 |
EXP_REIMB_DYNAMIC |
NUMERIC |
No |
|
|
|
| The expected reimbursement will be updated whenever reimbursement is calculated. This amount cannot exceed the charge amount. |
|
|
| 20 |
EXPECTED_REIMB |
NUMERIC |
No |
|
|
|
| The expected reimbursement calculated at charge entry. This item is not updated by any change during claims. Also, this amount cannot exceed the charge amount. |
|
|
| 21 |
COVERAGE_PLAN_ID |
NUMERIC |
No |
|
|
|
| The Plan (EPP) ID that is associated with this transaction. |
|
|
| 22 |
CVG_PLAN_GROUP_ID |
VARCHAR |
No |
|
|
|
| This item stores the employer group (PPG) ID that is associated with this transaction. |
|
|
| 23 |
CVG_PLAN_GROUP_ID_PLAN_GRP_NAME |
VARCHAR |
No |
|
|
|
| The name of the employer group record |
|
|
| 24 |
MED_NEC_YN |
VARCHAR |
No |
|
|
|
| This is the flag that is set in charge entry if medical necessity is needed for a transaction. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 25 |
TECHNICAL_CHG_FL_YN |
VARCHAR |
No |
|
|
|
| This flag is set to yes if the transaction is a technical charge. This is only populated if using the split billing functionality. |
| The category values for this column were already listed for column: MED_NEC_YN |
|
|
| 26 |
CNTR_DISCOUNT_AMT |
VARCHAR |
No |
|
|
|
| This item stores the pricing contract discount amount for a transaction. |
|
|
| 27 |
UNDIST_TX_DATE |
DATETIME |
No |
|
|
|
| This items stores the date that a transaction was undistributed (unmatched). |
|
|
| 28 |
UNDIST_CHG_USER_ID |
VARCHAR |
No |
|
|
|
| This item stores the user that unmatched a transaction. |
|
|
| 29 |
UNDIST_CHG_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 30 |
UNDIST_INSTANT |
DATETIME (Local) |
No |
|
|
|
| This item stores the instant that a transaction was undistributed (unmatched). |
|
|
| 31 |
ORIGINAL_AMT_COPAY |
NUMERIC |
No |
|
|
|
| This item stores the original copay amount for the transaction. |
|
|
| 32 |
BAD_DEBT_CHG_YN |
VARCHAR |
No |
|
|
|
| Indicates whether the charges is written off to bad debt. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 33 |
AUTO_PAT_WO_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores if a transaction had its self-pay portion automatically written off. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| yes and new SST |
|
|
| 34 |
TX_USER_COMMENT |
VARCHAR |
No |
|
|
|
| The comments entered by users when they perform an action like transfer, retro, void, and undistribute on a transaction in Transaction Inquiry are stored in this item. |
|
|
| 35 |
CONTESTED_YN |
VARCHAR |
No |
|
|
|
| This item stores a flag to determine if a transaction is contested. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 36 |
CONTEST_REASON_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the reason that a transaction is contested if the transaction is contested. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Not Contested |
| Contested |
| Contested at Visit Account Level |
| Not Contested at Visit Account Level |
|
|
| 37 |
MEA_IDENTIFIER_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the measurement (MEA) identifiers that are entered in charge entry. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Original/Starting dosage |
| Test Results |
|
|
| 38 |
CRC_CODE_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the CRC code entered in charge entry. |
| May contain organization-specific values: Yes |
| Category Entries: |
| E1 - Spectacle Lenses |
| E2 - Contact Lenses |
| E3 - Spectacle Frames |
|
|
| 39 |
REIMB_CONTRACT_AMT |
NUMERIC |
No |
|
|
|
| Stores the allowed amount as calculated by the reimbursement contract. This amount can exceed the charge amount. |
|
|
| 40 |
EXT_CUR_AGENCY_ID |
NUMERIC |
No |
|
|
|
| The current collections agency. |
|
|
| 41 |
EXT_CUR_AGENCY_ID_COLL_AGENCY_NAME |
VARCHAR |
No |
|
|
|
| The name of the collection agency. |
|
|
| 42 |
EXT_CURAGNCY_STAT_C_NAME |
VARCHAR |
No |
|
|
|
| The current agency status category ID for the transaction. |
| May contain organization-specific values: No |
| Category Entries: |
| Sent to Agency |
| Returned |
|
|
| 43 |
EXTERNAL_ID |
VARCHAR |
No |
|
|
|
| This item stores the external transaction ID |
|
|
| 44 |
SURGICAL_LOG_ID |
VARCHAR |
No |
|
|
|
| The unique ID associated with the surgical log record for this row. This column is frequently used to link to the OR_LOG table. This item is populated if charge is entered from OpTime. |
|
|
| 45 |
SUPPLY_ID |
VARCHAR |
No |
|
|
|
| The unique ID associated with the supply record for this row. This column is frequently used to link to the OR_SPLY table. |
|
|
| 46 |
SUPPLY_ID_SUPPLY_NAME |
VARCHAR |
No |
|
|
|
| The name of the inventory item. |
|
|
| 47 |
IMPLANT_ID |
VARCHAR |
No |
|
|
|
| The unique ID associated with the implant record for this row. This column is frequently used to link to the OR_IMP table. |
|
|
| 48 |
EXT_AGNCY_SENT_DTTM |
DATETIME (Local) |
No |
|
|
|
| The instant the charge was sent to its current agency. |
|
|
| 49 |
FIRST_SELFPAY_DATE |
DATETIME |
No |
|
|
|
| This items stores the date when a charge first goes to self-pay. |
|
|
| 50 |
PROV_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The provider type for the transaction. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Resource |
| Physician |
|
|
| 51 |
CLAIM_ID |
NUMERIC |
No |
|
|
|
| The claim record for the transaction. |
|
|
| 52 |
IS_WK_COMP |
VARCHAR |
No |
|
|
|
| Indicates whether the transaction is for worker's comp. |
|
|
| 53 |
EOB_UPDATED_DT |
DATETIME |
No |
|
|
|
| Date in which the Explanation of Benefits for this transaction was last updated. |
|
|
| 54 |
RAD_THER_COMP_TX_ID |
NUMERIC |
No |
|
|
|
| This item stores the ID for radiation therapy component transactions and rollup charges. |
|
|
| 55 |
RAD_THER_END_YN |
VARCHAR |
No |
|
|
|
| Indicates whether Radiation Therapy is at the end of treatment for this transaction. |
| May contain organization-specific values: No |
| Category Entries: |
| NO |
| YES |
|
|
| 56 |
START_TIME |
DATETIME (Local) |
No |
|
|
|
| Start time of a timed procedure. |
|
|
| 57 |
STOP_TIME |
DATETIME (Local) |
No |
|
|
|
| Stop time of a timed procedure. |
|
|
| 58 |
SERVICE_TIME |
DATETIME (Local) |
No |
|
|
|
| Time when service is performed. |
|
|
| 59 |
PURCHASESERVICE_AMT |
NUMERIC |
No |
|
|
|
| This is the amount paid for or to be paid to a third party for performing a service. This field is used to report this amount on claims and statements along with price being charged to the payor or guarantor for the service. This item should only be used if it is desired this purchased service information be reported on claims and statements. |
|
|
| 60 |
THIRD_PARTY_POS_ID |
NUMERIC |
No |
|
|
|
| The third party or reference lab where an individual purchased service was performed. This item is used to reference a Place of Service in order to report the address and National Provider Identifier of the third party on claims and statements. This item should only be used if it is desired this purchased service information be reported on claims and statements. |
|
|
| 61 |
MNL_RETRO_REASON_C_NAME |
VARCHAR |
No |
|
|
|
| The retroadjudication reason category ID for the transaction |
| May contain organization-specific values: Yes |
| Category Entries: |
| Other |
| Addition/Deletion/Change in Patients |
| Change Patient Covered Flag |
| Change Patient Effective Date |
| Change Coverage Effective Date |
| New Coverages |
| Add Member |
| Change Member Effective Date |
| Remove Member |
| Add Account |
| Change Benefit Plan on Employer Group |
| Change Coverage Term Date |
| Change Member Term Date |
| Change Covered Status |
| Change Riders on Employer Group |
| Remove Benefit Plan from Employer Group |
| Change Activation Date on Employer Group |
| Change Termination Date on Employer Group |
| Change Effective Date due to Group Term Date |
| Change Term Date due to Group Effective Date |
| Change Coverages |
| Change Visit Coverage |
|
|
| 62 |
TYPE_OF_SERVICE_C_NAME |
VARCHAR |
No |
|
|
|
| The type of service category number associated with the transaction. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Medical Care |
| Surgery |
| Consultation |
| Diagnostic Radiology |
| Diagnostic Laboratory |
| Therapeutic Radiology |
| Anesthesia |
| Assistant at Surgery |
| Other Medical Items or Services |
| Whole Blood |
| Used Durable Medical Equipment (DME) |
| Ambulatory Surgical Center (Facility usage for Surgical Services) |
| Hospice (Obsolete, Discontinued 1/95) |
| ESRD Supplies |
| Monthly Capitation Payment for Dialysis |
| Kidney Donor |
| Pneumococcal/Flu Vaccine |
| Second Opinion on Elective Surgery (Obsolete) |
| Third Opinion on Elective Surgery (Obsolete) |
| Diagnostic Medical (Obsolete) |
| Ancillaries, Hospital and Nursing Home (Obsolete) |
| Drug Services (Obsolete) |
| Accommodations, Hospital and Nursing Home (Obsolete) |
| Dental (Obsolete) |
| Vision Care and Cataract Lens (Obsolete) |
| Nuclear Medicine (Obsolete) |
| Diagnostic X-Ray (Professional) (Obsolete) |
| Rental of DME |
| Radiation Therapy (Professional) (Obsolete) |
| Diagnostic Lab (Professional) (Obsolete) |
| Diagnostic Medical (Professional) (Obsolete) |
| DME Purchase (Obsolete) |
| CRD Equipment (Obsolete) |
| Pre-Admission Testing (Obsolete) |
| EPSDT |
| High Risk Screening Mammography |
| Low Risk Screening Mammography |
| Ambulance |
| Enteral/Parenteral Nutrients/Supplies |
| Immunosuppressive Drugs |
| Diabetic Shoes |
| Hearing Items and Services |
| Lump Sum Purchase of DME, Prostethics, Orthotics |
| Vision Items or Services |
| Surgical Dressings or Other Medical Supplies |
| Psychological Therapy |
| Occupational Therapy |
| Physical Therapy |
| Medication (Obsolete) |
| Chiropractic Care |
| DME Prescription |
|
|
| 63 |
DX_PRIM_CODESET_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the primary diagnosis codeset for the transaction. |
| May contain organization-specific values: Yes |
| Category Entries: |
| ICD-9-CM |
| ICD-10-CM |
| ICD-10-CA |
| ICD-10-UK |
| DBC |
| ICD-10 Dutch |
| ICD-10-AM |
| A&E Diagnoses |
| SKS |
| ICD-10-THL |
| ICPC-2 |
| ICD-O-3 |
| ICD-10-GM |
| ICD-9-CM Supplemental |
| ICD-10-BE |
| ICD-10-NO |
| Apache |
| DSM-5 |
| KinCor |
| ORPHA |
|
|
| 64 |
DX_ALT_CODESET_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the alternate diagnosis codeset for the transaction. |
| The category values for this column were already listed for column: DX_PRIM_CODESET_C_NAME |
|
|
| 65 |
START_DATE |
DATETIME |
No |
|
|
|
| The date on which a service is started. |
|
|
| 66 |
STOP_DATE |
DATETIME |
No |
|
|
|
| The date on which a service was stopped. |
|
|
| 67 |
PROC_MINUTES |
INTEGER |
No |
|
|
|
| The length of time in minutes that this procedure took. |
|
|
| 68 |
CRD_CHARGE_SLIP_NO |
NUMERIC |
No |
|
|
|
| The encounter form number associated with copay payments entered during scheduling. |
|
|
