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 |