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