Table Detail Report

SESSION_XREF



Column Section Top of Page


Table-level Detail

Description: Session Cross Reference
Definition: The session_xref table is linked to the session log table. It will link the output handle to the session number.
Table Type: ACTIVITY





Column Detail - SESSION_XREF


Column Name Type Null? Definition
DEVICE_CD DOUBLE N Unique number that identifies the Device. Foreign key into the device table.
OUTPUT_DEST_CD DOUBLE N Unique number that identifies the Output Dest. Foreign key into the output dest table
OUTPUT_HANDLE_ID DOUBLE N value that identifies a specific report
PHYSICAL_CHANNEL_NAME VARCHAR(40) Y the name of the physical channel used in this session
SESSION_NUM DOUBLE N Sequential number assigned at time of transmission.
SESSION_STATUS DOUBLE Y The status of the session.
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.


STATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Station
Definition: The station table defines the logical location of a destination. If multiple doctors are using one device, then they would each have a station pointing to the single device.
Table Type: REFERENCE





Column Detail - STATION


Column Name Type Null? Definition
AGE_CRITERIA DOUBLE Y The number of minutes the report will stay on the delivery queue, with it's current priority before it is aged.
AGING_PRIORITY_CHANGE DOUBLE Y Value to be decremented from the scheduled_value or non_scheduled_value when Aging the priority
BUNDLE_PAGE_LIMIT DOUBLE Y The number of additional pages of a lower priority can be sent with the current transmission. If the value for page numbers is blank, then no bundling will occur.
DELIVERY_CLASS_QUEUE_ID DOUBLE N Unique number identifying the Delivery Class QueueColumn
DESCRIPTION CHAR(20) Y Name of the Delivery Class QueueColumn
DESCRIPTION_TEXT_ID DOUBLE N Foreign Key from LONG_TEXT_REFERENCE table.
DISABLED_IND DOUBLE Y Status of station, either active or disabled.
EOT_TEMPLATE_ID DOUBLE N Foreign Key from WP_TEMPLATE table
NON_SCHEDULED_VALUE DOUBLE Y Priority assigned for a manual requested transmission.
NUMBER_OF_COPIES DOUBLE Y Number of copies
OUTPUT_DEST_CD DOUBLE N This is really a Foreign key into the output_dest table.
REPORT_LIST DOUBLE Y Indication if a report listing should be printed, if so where it should print.
REPORT_LIST_SIZE_CUTOFF DOUBLE Y Number of reports that need to be in a session before a listing of the reports will be generated.
SCHEDULED_VALUE DOUBLE Y Priority assigned for a schedule transmission for the station.
SEND_EOT_PAGE_IND DOUBLE Y Indicates whether to send an "End Of Page" page.
SEND_FLAG DOUBLE N This flag will determine whether to send reports to RRD, Healthe or both. 0 = Send to RRD Fax 1 = Send to Healthe Exchange account 2 = Send to both RRD Fax and Healthe Exchange account
TEMPLATE_ID DOUBLE N The numeric value for the cover page template that will be used for the specific station. Each station could have it's own Cover Page.
TIME_SCHEME_ID DOUBLE N number identifying what time scheme is attached to this station. Foreign Key into time_scheme_window
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 - STATION


Child Column in STATION(FK) Parent Table Name Parent Column Name
Parents: DELIVERY_CLASS_QUEUE_ID DELIVERY_CLASS_QUEUE DELIVERY_CLASS_QUEUE_ID
DESCRIPTION_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD
TIME_SCHEME_ID TIME_SCHEME_WINDOW TIME_SCHEME_ID
EOT_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID




Parent Column in STATION (PK) Child Table Name Child Column Name
Children: OUTPUT_DEST_CD RRDBRIDGE STATION_DEST_CD
VENDOR OUTPUT_DEST_ID


TIME_SCHEME_WINDOW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Time Scheme Window
Definition: This table defines the time scheme code, which then is linked to the daily schedule for each time.
Table Type: REFERENCE





Column Detail - TIME_SCHEME_WINDOW


Column Name Type Null? Definition
DESCRIPTION CHAR(40) Y Name of the Time Scheme
TIME_SCHEME_ID DOUBLE N Unique numeric value assigned by the system to identify each Time Scheme defined by the user.
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 - TIME_SCHEME_WINDOW




Parent Column in TIME_SCHEME_WINDOW (PK) Child Table Name Child Column Name
Children: TIME_SCHEME_ID STATION TIME_SCHEME_ID


WTS_LOCATION



Column Section Top of Page


Table-level Detail

Description: WTS Location configuration settings
Definition: This table is a reference table for WTS Location program configuration settings. It will hold all solution configuration settings.
Table Type: REFERENCE





Column Detail - WTS_LOCATION


Column Name Type Null? Definition
CONFIGURATION_NAME VARCHAR(100) N The configuration option name
CONFIGURATION_VALUE_TXT VARCHAR(512) N The configuration option value
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.
WTS_LOCATION_ID DOUBLE N Primary Key; Unique number identifying the WTS Location configuration options