Table Detail Report
ROI_INVOICE_BILLING
Column Section | Top of Page |
Table-level Detail
Description: | ROI Invoice Billing table. |
Definition: | This table contains billing and payment information for ROI Invoices. |
Table Type: | ACTIVITY |
Column Detail - ROI_INVOICE_BILLING
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BILL_DT_TM | DATETIME | Y | The date the charged amount was billed |
CHARGED_AMOUNT | DOUBLE | N | Charged Amount |
CHECK_NUMBER | DOUBLE | Y | Check number |
CREDIT_CARD_CD | DOUBLE | N | credit card code |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
INVOICE_NUMBER | DOUBLE | N | This is a number assigned to this invoice |
PAYMENT_AMOUNT | DOUBLE | N | The amount to be paid. |
PAYMENT_DT_TM | DATETIME | Y | The Payment Date Time may provide the date and time that the invoice was actually paid when a two way accounts payable interface is present. |
PAYMENT_TYPE_CD | DOUBLE | N | The payment type (credit card, cash, check, etc.) |
REQUESTER_ID | DOUBLE | N | This is the value of the unique primary identifier of the requester table. It is an internal system assigned number. |
REQUEST_NUMBER | DOUBLE | N | Request number |
ROI_INVOICE_BILLING_ID | DOUBLE | N | This is the value of the unique primary identifier of the ROI_Invoice_Billing table. It is an internal system assigned number. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROI_INVOICE_CHARGE
Column Section | Top of Page |
Table-level Detail
Description: | Roi Invoice charges has the charges for the invoice |
Definition: | This table has fields like charges type and charges |
Table Type: | ACTIVITY |
Column Detail - ROI_INVOICE_CHARGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CHARGES | DOUBLE | Y | This is the charges value |
CHARGE_RATE | DOUBLE | Y | The price per page or mile. |
CHARGE_RATE_FLAG | DOUBLE | N | Indicates what the charge rate applies to, 0 - None, 1 - Paper, 2 - Electronic, and 3 - Microfilm, 9 - mileage |
CHARGE_TYPE_CD | DOUBLE | N | This is the type of charge such as mileage or postage |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
END_NUMBER | DOUBLE | Y | The ending range for the charge tier. |
FLAT_CHARGE_IND | DOUBLE | Y | Indicates if the charge is a flat rate for the page range |
INVOICE_NUMBER | DOUBLE | N | This is a number assigned to this invoice |
REQUESTER_ID | DOUBLE | N | This is the value of the unique primary identifier of the requester table. It is an internal system assigned number. |
REQUEST_NUMBER | DOUBLE | N | Request number |
ROI_INVOICE_CHARGE_ID | DOUBLE | N | This is the value of the unique primary identifier of the roi invoice charge table. It is an internal system assigned number. |
ROI_INVOICE_ID | DOUBLE | N | This is the value of the unique primary identifier of the roi invoice table. It is an internal system assigned number. |
START_NUMBER | DOUBLE | Y | The starting range for the charge tier. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROI_INV_CHG_DEFS
Column Section | Top of Page |
Table-level Detail
Description: | ROI Invoice Charge Defaults table. |
Definition: | This table contains invoice default values for HIM ROI Requesters and Requester Source. |
Table Type: | REFERENCE |
Column Detail - ROI_INV_CHG_DEFS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CHARGES | DOUBLE | N | This is the charges value |
CHARGE_RATE | DOUBLE | Y | The price per page or mile. |
CHARGE_RATE_FLAG | DOUBLE | N | Indicates what the charge rate applies to, 0 - None, 1 - Paper, 2 - Electronic, and 3 - Microfilm, 9 - mileage |
CHARGE_TYPE_CD | DOUBLE | N | This is the type of charge such as mileage or postage |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
END_NUMBER | DOUBLE | Y | The ending range for the charge tier. |
FLAT_CHARGE_IND | DOUBLE | Y | Indicates if the charge is a flat rate for the page range |
REQUESTER_ID | DOUBLE | N | This is the value of the unique primary identifier of the requester table. It is an internal system assigned number. |
REQUESTER_SOURCE_CD | DOUBLE | N | This is the type of requester(i.e. attorneys, insurance company) |
ROI_INV_CHG_DEFS_ID | DOUBLE | N | This is the value of the unique primary identifier of the ROI_Invoice_Charge_Defaults table. It is an internal system assigned number. |
START_NUMBER | DOUBLE | Y | The starting range for the charge tier. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROI_REJECT_REASON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table stores reject reasons for roi request. |
Definition: | This table stores zero to many reject reasons for roi requests |
Table Type: | ACTIVITY |
Column Detail - ROI_REJECT_REASON
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | Y | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CREATE_PRSNL_ID | DOUBLE | Y | This is the unique identifier for the person who created this row |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
HIM_REQUEST_ID | DOUBLE | Y | The ID of him_request |
LAST_UPDATE_PRSNL_ID | DOUBLE | Y | This is the unique identifier for the person who last updated this row |
REJECTED_REASON_CD | DOUBLE | Y | This is the reason that the roi request was rejected |
ROI_REJECT_REASON_ID | DOUBLE | N | This is the unique identifier for the table. |
ROI_REQUEST_ID | DOUBLE | Y | This is the unique identifier for the roi request table |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ROI_REJECT_REASON
Child Column in ROI_REJECT_REASON(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HIM_REQUEST_ID | HIM_REQUEST | HIM_REQUEST_ID |
ROI_REQUEST_ID | ROI_REQUEST | ROI_REQUEST_ID |
ROI_REQUEST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores Request for Medical record information (i.e. request for patient chart). |
Definition: | Stores request information such as request type, request reason, requester type, requester id, etc for ROI Request row |
Table Type: | ACTIVITY |
Column Detail - ROI_REQUEST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
APPROVAL_IND | DOUBLE | Y | This is an indicator the is valued when a request needing approval is approved. *****This column is not being used |
AUTHORIZATION_FLAG | DOUBLE | N | Identifies if a request has been authorization. Flag values 1- Authorized; 2- Not Authorized; 3- Implied Consent |
AUTHORIZED_IND | DOUBLE | Y | Indicates if we have an authorization to fill this request |
AUTHORIZED_NEEDED_IND | DOUBLE | Y | The indicator of authorized needed |
AUTHORIZED_REJECT_REASON_CD | DOUBLE | N | This is the code value for the authorize reject reason |
BATCH_IND | DOUBLE | Y | This field is used to show if this request is a batch request ****This column is not being used |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BILLABLE_IND | DOUBLE | Y | Indicates if this request is billable |
BILL_TO_ADDRESS_ID | DOUBLE | N | This is the unique identifier to the address table |
BILL_TO_ADDRESS_TYPE_CD | DOUBLE | N | CODE SET:212 The address type is the code set value which identifies the type of address for the address row (i.e., home, business, etc.) |
BILL_TO_ADDRESS_TYPE_SEQ | DOUBLE | N | This is the numeric sequence that determines the priority or precedence that one address row has over another when both address rows contain the same parent_entity_name, parent_entity_id, and address_type_cd with the same meaning. |
BILL_TO_FAX_ID | DOUBLE | N | Unique identifier to the phone table, identifies the fax number associated with the bill to address. |
BILL_TO_PHONE_ID | DOUBLE | N | This is the unique identifier to the phone table, it identifies the phone number associated with the bill to address |
CANCEL_PRSNL_ID | DOUBLE | N | The id of the person who cancelled the request.This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number. ***This column is not being used |
CHARGES_PER_PAGE | DOUBLE | Y | Charges per page |
CHART_REQUEST_ID | DOUBLE | N | Identifies the chart request that was created when documents are printed via MRP |
CREATE_PRSNL_ID | DOUBLE | N | The id of the person who created the request.This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number. *** This column isnot being used |
DELIVERY_METHOD_CD | DOUBLE | N | This is the method of delivery that will be used. |
DISCLOSURE_IND | DOUBLE | N | disclosure indicator |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXPECTED_TURN_AROUND | DOUBLE | Y | expected turn around |
HIM_REQUEST_ID | DOUBLE | N | The primary key of him_request table |
LAST_UPDATE_PRSNL_ID | DOUBLE | N | The id of the person who last updated the request.This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number. *** This column is not being used |
MAIL_TO_ADDRESS_ID | DOUBLE | N | This is the unique identifier to the address table |
MAIL_TO_ADDRESS_TYPE_CD | DOUBLE | N | CODE SET:212 The address type is the code set value which identifies the type of address for the address row (i.e., home, business, etc.) |
MAIL_TO_ADDRESS_TYPE_SEQ | DOUBLE | N | This is the numeric sequence that determines the priority or precedence that one address row has over another when both address rows contain the same parent_entity_name, parent_entity_id, and address_type_cd with the same meaning. |
MAIL_TO_FAX_ID | DOUBLE | N | This is the unique identifier to the phone table, it identifies the fax number associated with the mail to address |
MAIL_TO_PHONE_ID | DOUBLE | N | This is the unique identifier to the Phone table that identifies the phone number to be associated with the mail to address. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PREBILL_IND | DOUBLE | Y | The indicator of pre-bill |
PREBILL_OVER_AMOUNT | DOUBLE | Y | Pre-bill over amount |
PREBILL_OVER_IND | DOUBLE | Y | The indicator of pre-bill over |
REJECTED_REASON_CD | DOUBLE | N | This is the reason that the request was rejected *** This column is not being used |
REPORT_REQUEST_ID | DOUBLE | N | This is the value of the unique primary identifier of the CR_REPORT_REQUEST table. It is an internal system assigned number. |
REQUESTER_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. *** This column is not being used |
REQUESTER_SOURCE_CD | DOUBLE | N | requester source code |
REQUESTER_TYPE_CD | DOUBLE | N | Requester source such as Health care institution, Physician,attorney, or patient *** This column is not being used |
REQUEST_DT_TM | DATETIME | Y | The Date and Time that the request was entered *** This column is not being used |
REQUEST_NUMBER | DOUBLE | Y | This is a unique number that will be used by the user to reference the request *** This column is not being used |
REQUEST_NUMBER_POOL_CD | DOUBLE | N | request number pool code identifies a unique set or list of request identifiers (I.e., numbers). The request number pool code also determines the accept/display format for the unique set of identifiers. *** This column is not being used |
REQUEST_PARENT_ID | DOUBLE | N | This is the value of the unique primary identifier of the requester table. It is an internal system assigned number.This identifies of the parent batch request. *** This column is not being used |
REQUEST_REASON_CD | DOUBLE | N | The reason the request was made such as Subpoenas, court order, further medical care |
REQUEST_STATUS_CD | DOUBLE | N | This is the status of the request. (i.e. Canceled, completed or hold) *** This column is not being used |
REQUEST_STATUS_DT_TM | DATETIME | Y | This is the date and time that the status was set/changed *** This column is not being used |
REQUEST_STATUS_PRSNL_ID | DOUBLE | N | This is the person id of the person who is requesting this information *** This column is not being used |
REQUEST_TYPE_CD | DOUBLE | N | This is the type of request. (i.e. Patient care, ROI, committee) *** This column is not being used |
REQUIRED_DT_TM | DATETIME | Y | This is the date and time that the requester is wanting the request to be completed *** This column is not being used |
ROI_REQUESTER_ID | DOUBLE | N | .This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number. *** This column is not being used |
ROI_REQUEST_ID | DOUBLE | N | This is the value of the unique primary identifier of the Roi request table. It is an internal system assigned number |
TO_LOCATION_CD | DOUBLE | N | This is the location that the request should be delivered to. *** This column is not being used |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ROI_REQUEST
Child Column in ROI_REQUEST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_TO_ADDRESS_ID | ADDRESS | ADDRESS_ID |
MAIL_TO_ADDRESS_ID | ADDRESS | ADDRESS_ID | |
REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID | |
HIM_REQUEST_ID | HIM_REQUEST | HIM_REQUEST_ID | |
PERSON_ID | PERSON | PERSON_ID | |
BILL_TO_FAX_ID | PHONE | PHONE_ID | |
BILL_TO_PHONE_ID | PHONE | PHONE_ID | |
MAIL_TO_FAX_ID | PHONE | PHONE_ID | |
MAIL_TO_PHONE_ID | PHONE | PHONE_ID | |
REQUESTER_ID | REQUESTER | REQUESTER_ID | |
REQUEST_PARENT_ID | REQUESTER | REQUESTER_ID | |
ROI_REQUESTER_ID | REQUESTER | REQUESTER_ID |
Parent Column in ROI_REQUEST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ROI_REQUEST_ID | REQUEST_EVENT_RELTN | ROI_REQUEST_ID |
ROI_REJECT_REASON | ROI_REQUEST_ID |