Table Detail Report

DEVICE_OUTPUT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DEVICE PROFILE RELATION
Definition: Relates Devices with document profiles
Table Type: REFERENCE





Column Detail - DEVICE_OUTPUT_RELTN


Column Name Type Null? Definition
DEFAULT_IND DOUBLE N When this value is set, the output_content_type_cd is the default for the selected device.
DEVICE_CD DOUBLE N Device code to be related to a output_content_cd. this value comes from the DEVICE table and is not a true CODE_VALUE.
DEVICE_OUTPUT_RELTN_ID DOUBLE N Primary Key
ENVELOPE_PROCESS_CD DOUBLE N Dictates how documents sent to repositories will be processed through this relationship
OUTPUT_CONTENT_TYPE_CD DOUBLE N These are the document types that are related to the selected devices. This can also be thought of as output content Code.
TEMPLATE_ID DOUBLE N The Template ID used by CDG to build the dataset for transformation (FK from CR_REPORT_TEMPLATE)
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 - DEVICE_OUTPUT_RELTN


Child Column in DEVICE_OUTPUT_RELTN(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
DEVICE_CD DEVICE DEVICE_CD




Parent Column in DEVICE_OUTPUT_RELTN (PK) Child Table Name Child Column Name
Children: DEVICE_OUTPUT_RELTN_ID DEVICE_OUTPUT_RELTN_R DEVICE_OUTPUT_RELTN_ID


DEVICE_OUTPUT_RELTN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Device Output Relation Relationships
Definition: This table will relate items like Organizations and Event Sets to specified Device Output Relationships.
Table Type: REFERENCE





Column Detail - DEVICE_OUTPUT_RELTN_R


Column Name Type Null? Definition
DEVICE_OUTPUT_RELTN_ID DOUBLE N A Foreign Key that defines a relationship to devices which can also be tied to Organizations and Event Set Codes
DEVICE_OUTPUT_RELTN_R_ID DOUBLE N PRIMARY KEY.
EVENT_SET_CD DOUBLE N Event Set Code that can be used as part of the relationship between devices and output_content types
ORGANIZATION_ID DOUBLE N Foreign Key to Organization table. Used to route organizations to devices through a relationship with event sets
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 - DEVICE_OUTPUT_RELTN_R


Child Column in DEVICE_OUTPUT_RELTN_R(FK) Parent Table Name Parent Column Name
Parents: DEVICE_OUTPUT_RELTN_ID DEVICE_OUTPUT_RELTN DEVICE_OUTPUT_RELTN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


DEVICE_XREF



Column Section Top of Page


Table-level Detail

Description: DEVICE XREF
Definition: Lists hardware devices resident on the system.
Table Type: REFERENCE





Column Detail - DEVICE_XREF


Column Name Type Null? Definition
DEVICE_CD DOUBLE N Device code specific to host type
PARENT_ENTITY_ID DOUBLE N Parent entity id for device
PARENT_ENTITY_NAME VARCHAR(30) N name of parent entity 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.
USAGE_TYPE_CD DOUBLE N Unit of measure code


MODEM_COMMANDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: MODEM COMMANDS
Definition: Identifies the various modem commands associated with each modem.
Table Type: REFERENCE





Column Detail - MODEM_COMMANDS


Column Name Type Null? Definition
COMMAND_STRING VARCHAR(100) Y String which contains specific modem commands for a particular Modem Type.Column
COMMAND_TYPE_CD DOUBLE N Identifies that type of command being sent to the modem.Column
CR_LF_IND DOUBLE Y Indicates whether to send a carriage return line feed commands to the device.
DELAY DOUBLE Y How many seconds to wait before sending the command.Column
EXP_RESPONSE CHAR(20) Y What type of response is expected from the modem when the command string is sent.
MODEM_TYPE_ID DOUBLE N The type of modem.Column
QUALIFIER DOUBLE N A unique number identifying the command string for a particular modem typeColumn
REMOTE_DEV_TYPE_ID DOUBLE N Indicates what remote device type is using this modem.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.



Relationship Detail - MODEM_COMMANDS


Child Column in MODEM_COMMANDS(FK) Parent Table Name Parent Column Name
Parents: MODEM_TYPE_ID MODEM_TYPE MODEM_TYPE_ID


MODEM_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MODEM TYPE
Definition: Table that contains different types of Modems as defined by the user.
Table Type: REFERENCE





Column Detail - MODEM_TYPE


Column Name Type Null? Definition
DESCRIPTION CHAR(40) Y Modem NameColumn
MODEM_TYPE_ID DOUBLE N Unique number that identifies each Modem as defined by the user.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.



Relationship Detail - MODEM_TYPE




Parent Column in MODEM_TYPE (PK) Child Table Name Child Column Name
Children: MODEM_TYPE_ID MODEM_COMMANDS MODEM_TYPE_ID