COMMUNICATIONS_PORT



Column Section Top of Page


Table-level Detail

Description: Communications Port
Definition: The communications_port table defines the port characteristics of a specific port in a Delivery Class Queue.
Table Type: REFERENCE





Column Detail - COMMUNICATIONS_PORT


Column Name Type Null? Definition
ACTIVE_AREA_CODE CHAR(25) Y Area Code of the station that the communications port is currently transmitting reports to.
ACTIVE_COUNTRY_ACCESS CHAR(25) Y Country Code of the station that the communications port is currently transmitting reports to I.e. the United States country code is 1.
ACTIVE_DEST_CD DOUBLE N Destination (Station) that is currently using the communications port.
ACTIVE_EXCHANGE CHAR(25) Y Phone Exchange of the station that the communications port is currently transmitting reports to.
ACTIVE_PHONE_SUFFIX CHAR(50) Y Phone Suffix of the station that the communications port is currently transmitting report to.
AUTO_DIAL_IND DOUBLE Y Indicates whether this communications port uses a leased line.
DELIVERY_CLASS_QUEUE_ID DOUBLE N Foreign Key into the Delivery Class Queue Table. Specifies which comm port is associated with a delivery class.
DEVICE VARCHAR(50) Y Currently not used.
DEVICE_CD DOUBLE N Foreign key into the device table. Indentifes what device is being sent to.
DISABLED_IND DOUBLE Y Indicates whether or not this communications port is disabled.
KILL_ACTIVE_IND DOUBLE Y Indicates whether to kill the current process
MODEM_TYPE_ID DOUBLE N The type of Modem used by this port. Foreign key into the modem_type table
PORT_AREA_CODE CHAR(10) Y The area code for this port
PORT_COUNTRY_ACCESS CHAR(3) Y The Country Access for this port
PORT_EXCHANGE CHAR(10) Y The exchange for this port
PORT_PHONE_SUFFIX CHAR(30) Y The phone suffix for this port
PREFIX_DIAL_STRING CHAR(25) Y The local prefix dial string, if any, for this port
PREFIX_LONG_DISTANCE VARCHAR(25) Y The long distance prefix dial string, if any, for this port
PREFIX_MANUAL VARCHAR(25) Y The manual prefix dial string, if any, for this port
PREFIX_METRO VARCHAR(25) Y The metro prefix dial string, if any, for this port
STATUS DOUBLE Y Current status of the communications port.
SUFFIX_DIAL_STRING CHAR(25) Y The local suffix dial string, if any, for this port
SUFFIX_LONG_DISTANCE VARCHAR(25) Y The long distance suffix dial string, if any, for this port
SUFFIX_MANUAL VARCHAR(25) Y The manual suffix dial string, if any, for this port
SUFFIX_METRO VARCHAR(25) Y The metro suffix dial string, if any, for this port
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.


DAILY_SCHEDULE



Column Section Top of Page


Table-level Detail

Description: Daily Schedule
Definition: The daily schedule table represents the individual times associated with a specific time scheme.
Table Type: REFERENCE





Column Detail - DAILY_SCHEDULE


Column Name Type Null? Definition
CUTOFF_WINDOW_IND DOUBLE Y Indicates that additional transmissions will not be processed after the cutoff time.
DAY_OF_WEEK DOUBLE N Represents the day of week for this specific time frame for a time scheme. Day of week: 0 = Sun¿6 = Sat.
END_TIME DOUBLE Y Ending time for this specific day and time frame for a time scheme. (Military Time)
QUALIFIER DOUBLE N Needed for multiple times in the same day.
START_TIME DOUBLE Y Starting time for this specific day and time frame for a time scheme. (Military Time)
TIME_SCHEME_ID DOUBLE N Unique numeric identifier for each Time Scheme that the user defines.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.


DELIVERY_CLASS_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Table which identifies the Delivery Class Queues.
Definition: Delivery Class Queues.
Table Type: REFERENCE





Column Detail - DELIVERY_CLASS_QUEUE


Column Name Type Null? Definition
DELIVERY_CLASS_QUEUE_ID DOUBLE N The unique numeric value for the delivery class queue that will be used by the communications port. The delivery class queue is made up of one or more communications ports.
DESCRIPTION CHAR(40) Y Delivery Class Queue NameColumn
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 - DELIVERY_CLASS_QUEUE




Parent Column in DELIVERY_CLASS_QUEUE (PK) Child Table Name Child Column Name
Children: DELIVERY_CLASS_QUEUE_ID STATION DELIVERY_CLASS_QUEUE_ID


DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Device Table
Definition: THE Device Table
Table Type: REFERENCE





Column Detail - DEVICE


Column Name Type Null? Definition
BASE_FOLDER_PATH VARCHAR(255) Y The base folder for the specified device
DESCRIPTION VARCHAR(110) Y The description of the device.
DEVICE_CD DOUBLE N The unique primary key of the Device table. It does not have a code set associated with it.
DEVICE_FUNCTION_CD DOUBLE N The device_function_cd is mainly to help distinguish a fax from a remote printer from a local printer. Basically how the device will distribute (i.e. remotely, network, local, fax, etc.)
DEVICE_TYPE_CD DOUBLE N The code value for the type of device. Some examples are printer, IV pump, monitor, fax, etc.)
DISTRIBUTION_FLAG DOUBLE N Determines the type of distribution that this device is configured for:0 = CCL1 = WINDOWS
DMS_SERVICE_ID DOUBLE N This is a foreign key to the DMS_SERVICE table to represent which Digital Media Service that this DEVICE row maps to. If there is no corresponding mapping then this column will be left blank.
LOCAL_ADDRESS VARCHAR(20) Y The local address name for the device.
LOCATION_CD DOUBLE N The location of the device.
MEDIA_TYPE_ENUM DOUBLE N The media type supported by the specified divide. Will hold a numeric value corresponding to the types supported.
NAME VARCHAR(50) Y The name of the device.
PHYSICAL_DEVICE_NAME VARCHAR(50) Y The physical printer name of the specified device.
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 - DEVICE


Child Column in DEVICE(FK) Parent Table Name Parent Column Name
Parents: DMS_SERVICE_ID DMS_SERVICE DMS_SERVICE_ID




Parent Column in DEVICE (PK) Child Table Name Child Column Name
Children: DEVICE_CD CR_DESTINATION_XREF DEVICE_CD
DEVICE_OUTPUT_RELTN DEVICE_CD
FILL_BATCH DEFAULT_PRINTER_CD
FORM_LIBRARY_MAPPING PRINTER_ID
FORM_LIBRARY_MAPPING REDIRECT_PRINTER_ID
PC_ATTRIBUTE_VALUE DEVICE_CD
RXS_WORKLIST LABEL_PRINTER_CD
RXS_WORKLIST REPORT_PRINTER_CD
RX_IMAGE DEVICE_CD
RX_PRINTER_LOCATION_R DENIAL_REPORT_DEVICE_CD
RX_PRINTER_LOCATION_R DEVICE_CD


DEVICE_ADDRESS



Column Section Top of Page


Table-level Detail

Description: Device Address Table
Definition: THE Device Address Table
Table Type: REFERENCE





Column Detail - DEVICE_ADDRESS


Column Name Type Null? Definition
DEVICE_ADDRESS_TYPE_CD DOUBLE N Unique number identifying device addressColumn
DEVICE_CD DOUBLE N Unique number identifying deviceColumn
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.