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 |