Table Detail Report

REPORT_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Queue
Definition: The report queue is the actual records that need to be processed, have been selected to be processed or have already been transmitted.
Table Type: ACTIVITY





Column Detail - REPORT_QUEUE


Column Name Type Null? Definition
CONVERTED_FILE_CHECKSUM DOUBLE N The checksum for the converted file
CONVERTED_FILE_IDENTIFIER VARCHAR(64) Y The media object identifier for the converted report file.
CONVERTED_FILE_NAME VARCHAR(300) Y This will be the full path name and report name for the report that needs to be converted to the correct device driver format. UNC paths are preferred
CUTOFF_DT_TM DATETIME Y The cutoff time which indicates the last possible time that the report can be transmitted in the current time scheme. Blank if not defined.
NEXT_AGING_DT_TM DATETIME Y If the report has waited past a certain time parameter then it's transmit date and time will be moved to an earlier time. This represents that time.
NUM_OF_BUSY DOUBLE Y How many times this report has attempted to transmit and received a busy signal.
NUM_OF_DISCONNECT DOUBLE Y How many times this report attempted to transmit and received a disconnect while transmitting.
NUM_OF_NOCONNECT DOUBLE Y How many time this report has attempted to transmit and received a noconnect signal.
ORIGINAL_DT_TM DATETIME Y The time the original report was requestedColumn
OUTPUT_HANDLE_ID DOUBLE N Value that identifies a specific report. Foreign key into the outputctx table....Matches up with the Handle_id field.
PRIORITY_VALUE DOUBLE Y The current priority level of this report. If multiple reports were set to transmit at the same time, this priority would determine in what order they should be transmitted.
TRANSMISSION_STATUS_CD DOUBLE N The current transmission status of the report.
TRANSMIT_DT_TM DATETIME Y The next valid time that the report can be transmitted based on time scheme criteria.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - REPORT_QUEUE




Parent Column in REPORT_QUEUE (PK) Child Table Name Child Column Name
Children: OUTPUT_HANDLE_ID TRANS_ADMIT_NOTIFY_ALT REPORT_QUEUE_ID


REPORT_QUEUE_DELETES



Column Section Top of Page


Table-level Detail

Description: REPORT QUEUE DELETES
Definition: List of rows to be deleted from Report_queue
Table Type: ACTIVITY





Column Detail - REPORT_QUEUE_DELETES


Column Name Type Null? Definition
OUTPUT_HANDLE_ID DOUBLE N The main index for this tableColumn
SERVER VARCHAR(128) Y NT server that is currently trying to delete filesColumn
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.


RETRIES



Column Section Top of Page


Table-level Detail

Description: Retries
Definition: This table defines the criteria for retrying a transmission for each station defined. The retry type indicates what to do for each type of transmission failure.
Table Type: REFERENCE





Column Detail - RETRIES


Column Name Type Null? Definition
IMMEDIATE_DELAY DOUBLE Y The time to wait between transmission attempts. No other stations will be able to be sent out of the port while the immediate delay is in effect.
IMMEDIATE_RETRIES DOUBLE Y The number of immediate retries to attempt before giving up the port to another fax.
OUTPUT_DEST_CD DOUBLE N Foreign Key into the station table.
QUEUED_DELAY DOUBLE Y The amount of time that the report has to wait in the report queue prior to attempting another transmission.
QUEUED_RETRIES DOUBLE Y The number of times a queued retry will be attempted
RETRY_PRIORITY DOUBLE Y The priority assigned to the report if it has been returned to the delivery class queue. This can be either 0 or 1. 0 = re-queue at priority zero, 1 = no change
RETRY_TYPE_CD DOUBLE N Unique system assigned value that identifies the type of retry I.e. Busy, NoConnect etc.
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.


RRDBRIDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RRD BRIDGE
Definition: This table is used to track documents that are to be sent to the Cerner Interchange server
Table Type: ACTIVITY





Column Detail - RRDBRIDGE


Column Name Type Null? Definition
FILE_NAME VARCHAR(200) N Path and name of file to be sent
MESSAGE_ID_HEADER VARCHAR(255) Y Once the Secure Email is transmitted, Mime Message ID will be assigned to it. This ID is Unique.
ORIGINAL_DT_TM DATETIME Y The time the original report was requested
OUTPUT_HANDLE_ID DOUBLE N Value that identifies a specific report. Foreign Key from the OUTPUTCTX table (HANDLE_ID).
RRDBRIDGE_ID DOUBLE N PRIMARY KEY
STATION_DEST_CD DOUBLE N Relates to STATION row containing fax number. It is NOT a code value, but really an ID value which originates from the OUTPUT_DEST table.
SUBSTATUS VARCHAR(20) N Descriptive text for reason of an ERROR status in TRANSMISSION_STATUS_CD
TRANSMISSION_ATTEMPTS DOUBLE N Number of times the document tried to send to Cerner Interchange.
TRANSMISSION_STATUS_CD DOUBLE N Status of the transmission.
TRANSMIT_DT_TM DATETIME N Date and time of the transmission. Blank until successfully sent.
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 - RRDBRIDGE


Child Column in RRDBRIDGE(FK) Parent Table Name Parent Column Name
Parents: OUTPUT_HANDLE_ID OUTPUTCTX HANDLE_ID
STATION_DEST_CD STATION OUTPUT_DEST_CD


RRDDEFAULTS



Column Section Top of Page


Table-level Detail

Description: Remote Report Dist. Defaults
Definition: This table contains default information for the entire Remote Report Dist. product.
Table Type: REFERENCE





Column Detail - RRDDEFAULTS


Column Name Type Null? Definition
BCKGRND_SRVR_1_LVL DOUBLE Y Defines the message log level for the Remote Report Distribution Server 1.
BCKGRND_SRVR_2_LVL DOUBLE Y Defines the message log level for Remote Report Distribution Server 2.
CONV_FILE_DIR VARCHAR(128) Y Location of the converted fileColumn
DFLT_STATION_ID DOUBLE N The id value that identifies the default station.Column
EMAIL_ALERT VARCHAR(255) Y If filled out, this is the E-Mail address for RRD error message notificationsColumn
LAST_CHANGE_DT_TM DATETIME Y This indicates the last time a change was made to a table pertient to viewing the Delivery Class Q Audit
LAST_SESS_NBR DOUBLE Y The last session number that was used.Column
NT_POLL_INTERVAL DOUBLE Y The number of seconds the NT checks the database for tasks to be done.
PRINTER_ALERT_ID DOUBLE Y If filled out, RRD error notifications will go to this printerColumn
RRDDEFAULTS_ID DOUBLE N The unique number that identifies the id for the RRDDEFAULTS table.
SERVICELOG_IND DOUBLE Y This indicator tells the RRD service and agent whether or not to output debugging type messages to the log.txt file.
SESS_PURGE_DAYS DOUBLE Y Number of days to retain session information.Column
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.