Table Detail Report

MSG_CONFIG_PUB_ASNMNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Configuration Public Assignment
Definition: Assigns a particular user context to a configuration
Table Type: REFERENCE





Column Detail - MSG_CONFIG_PUB_ASNMNT


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y Application Context Modifier
MSG_CONFIG_ID DOUBLE N Selected Configuration
MSG_CONFIG_PUB_ASNMNT_ID DOUBLE N Primary key
POSITION_CD DOUBLE N Assigned Position
PRSNL_GROUP_ID DOUBLE N Assigned Pool
PRSNL_ID DOUBLE N Assigned 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 - MSG_CONFIG_PUB_ASNMNT


Child Column in MSG_CONFIG_PUB_ASNMNT(FK) Parent Table Name Parent Column Name
Parents: MSG_CONFIG_ID MSG_CONFIG MSG_CONFIG_ID
PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


MSG_ENCNTR_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Encounter Group
Definition: Defines a set of Encounter Type Filters
Table Type: REFERENCE





Column Detail - MSG_ENCNTR_GRP


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y Represents the private owner of this category
CREATE_DT_TM DATETIME N Original Create Date
ENCNTR_GRP_DESC VARCHAR(40) N Encounter Group Description
ENCNTR_GRP_NAME VARCHAR(40) N Encounter Group Name
MSG_CATEGORY_TYPE_CD DOUBLE N Category Type
MSG_ENCNTR_GRP_ID DOUBLE N Message Encounter Group ID. Primary Key
POSITION_CD DOUBLE N Represents the private owner of this category
PRSNL_GROUP_ID DOUBLE N Represents the private owner of this category
PRSNL_ID DOUBLE N Represents the private owner of this category
PUBLIC_IND DOUBLE N Indicates whether this configuration is offered to others for reuse
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 - MSG_ENCNTR_GRP




Parent Column in MSG_ENCNTR_GRP (PK) Child Table Name Child Column Name
Children: MSG_ENCNTR_GRP_ID MSG_CATEGORY MSG_ENCNTR_GRP_ID
MSG_ENCNTR_GRP_DTL_RELTN MSG_ENCNTR_GRP_ID


MSG_ENCNTR_GRP_DTL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Encounter Group Detail
Definition: Identifies encounter types assigned to a messaging encounter group
Table Type: REFERENCE





Column Detail - MSG_ENCNTR_GRP_DTL_RELTN


Column Name Type Null? Definition
ENCNTR_TYPE_CD DOUBLE N Associated Child Encounter Type
MSG_ENCNTR_GRP_DTL_R_ID DOUBLE N PRIMARY KEY
MSG_ENCNTR_GRP_ID DOUBLE N Parent Encounter Group
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 - MSG_ENCNTR_GRP_DTL_RELTN


Child Column in MSG_ENCNTR_GRP_DTL_RELTN(FK) Parent Table Name Parent Column Name
Parents: MSG_ENCNTR_GRP_ID MSG_ENCNTR_GRP MSG_ENCNTR_GRP_ID


MSG_EVENT_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Event Group
Definition: Defines a set of Event Set Filters
Table Type: REFERENCE





Column Detail - MSG_EVENT_GRP


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y Represents the private owner of this category
CREATE_DT_TM DATETIME N Original Creation Date
EVENT_GRP_DESC VARCHAR(40) N Event Group Description
EVENT_GRP_NAME VARCHAR(40) N Event Group Name
FILTER_INCLUSIVE_IND DOUBLE N Indicates inclusive filtering
MSG_CATEGORY_TYPE_CD DOUBLE N Category Type
MSG_EVENT_GRP_ID DOUBLE N Message Event Group ID - Primary Key
POSITION_CD DOUBLE N Represents the private owner of this category
PRSNL_GROUP_ID DOUBLE N Represents the private owner of this category
PRSNL_ID DOUBLE N Represents the private owner of this category
PUBLIC_IND DOUBLE N Indicates whether this configuration is offered to others for reuse
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 - MSG_EVENT_GRP




Parent Column in MSG_EVENT_GRP (PK) Child Table Name Child Column Name
Children: MSG_EVENT_GRP_ID MSG_CATEGORY MSG_EVENT_GRP_ID
MSG_EVENT_GRP_DTL_RELTN MSG_EVENT_GRP_ID


MSG_EVENT_GRP_DTL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Event Group Detail
Definition: Identifies event sets assigned to a messaging event group
Table Type: REFERENCE





Column Detail - MSG_EVENT_GRP_DTL_RELTN


Column Name Type Null? Definition
EVENT_SET_NAME VARCHAR(100) N Associated Child Event Set Name
MSG_EVENT_GRP_DTL_R_ID DOUBLE N PRIMARY KEY
MSG_EVENT_GRP_ID DOUBLE N Parent Event Group
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 - MSG_EVENT_GRP_DTL_RELTN


Child Column in MSG_EVENT_GRP_DTL_RELTN(FK) Parent Table Name Parent Column Name
Parents: MSG_EVENT_GRP_ID MSG_EVENT_GRP MSG_EVENT_GRP_ID