MSG_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Category
Definition: Group level item within a Messaging Configuration defined by it's type, item groups, and filter groups.
Table Type: REFERENCE





Column Detail - MSG_CATEGORY


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Represents the private owner of this category
CATEGORY_DESC VARCHAR(40) N The Category Description
CATEGORY_NAME VARCHAR(40) N The Category Name
CREATE_DT_TM DATETIME N Original Creation Date and Time
MSG_CATEGORY_ID DOUBLE N %Catetory%
MSG_CATEGORY_TYPE_CD DOUBLE N %Catetory%
MSG_COLUMN_GRP_ID DOUBLE N Message Column data Group ID
MSG_ENCNTR_GRP_ID DOUBLE N Message Encounter filter Group ID
MSG_EVENT_GRP_ID DOUBLE N Message Event filter Group ID
MSG_NOTIFY_CATEGORY_CD DOUBLE N Identify this category as belonging to the key notifications or due.
MSG_NOTIFY_ITEM_CD DOUBLE N Identify what type of key notification this is.
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_CATEGORY


Child Column in MSG_CATEGORY(FK) Parent Table Name Parent Column Name
Parents: MSG_COLUMN_GRP_ID MSG_COLUMN_GRP MSG_COLUMN_GRP_ID
MSG_ENCNTR_GRP_ID MSG_ENCNTR_GRP MSG_ENCNTR_GRP_ID
MSG_EVENT_GRP_ID MSG_EVENT_GRP MSG_EVENT_GRP_ID




Parent Column in MSG_CATEGORY (PK) Child Table Name Child Column Name
Children: MSG_CATEGORY_ID MSG_CFG_CAT_RELTN MSG_CATEGORY_ID
MSG_ITM_GRP_CAT_RELTN MSG_CATEGORY_ID


MSG_CFG_CAT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Configuration Category Relation
Definition: Defines which categories are related to a configuration
Table Type: REFERENCE





Column Detail - MSG_CFG_CAT_RELTN


Column Name Type Null? Definition
MSG_CATEGORY_ID DOUBLE N Message Catgetory ID
MSG_CFG_CAT_R_ID DOUBLE N Primary key
MSG_CONFIG_ID DOUBLE N Message Config ID
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_CFG_CAT_RELTN


Child Column in MSG_CFG_CAT_RELTN(FK) Parent Table Name Parent Column Name
Parents: MSG_CATEGORY_ID MSG_CATEGORY MSG_CATEGORY_ID
MSG_CONFIG_ID MSG_CONFIG MSG_CONFIG_ID


MSG_COLUMN_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Column Group
Definition: Defines a subset of columns within a messaging category
Table Type: REFERENCE





Column Detail - MSG_COLUMN_GRP


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y Represents the private owner of this category
COLUMN_GRP_DESC VARCHAR(40) N Column Group Description
COLUMN_GRP_NAME VARCHAR(40) N Column Group Name
CREATE_DT_TM DATETIME N Create Date Time
DEF_COLUMN_TYPE_CD DOUBLE N The column to default sort by for this column group
DESCEND_IND DOUBLE N Indicates the direction to sort the default column by, 0 - ascending, 1- descending
MSG_CATEGORY_TYPE_CD DOUBLE N Message catetory type code
MSG_COLUMN_GRP_ID DOUBLE N Message Column Group ID
MSG_COLUMN_TYPE_CD DOUBLE N Column type code
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_COLUMN_GRP




Parent Column in MSG_COLUMN_GRP (PK) Child Table Name Child Column Name
Children: MSG_COLUMN_GRP_ID MSG_CATEGORY MSG_COLUMN_GRP_ID
MSG_COLUMN_GRP_DTL_RELTN MSG_COLUMN_GRP_ID


MSG_COLUMN_GRP_DTL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MSG_COLUMN_GRP_DTL_RELTN


Column Name Type Null? Definition
MSG_COLUMN_GRP_DTL_R_ID DOUBLE N PRIMARY KEY
MSG_COLUMN_GRP_ID DOUBLE N Parent Column Group
MSG_COLUMN_TYPE_CD DOUBLE N Associated Child Column Type
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_COLUMN_GRP_DTL_RELTN


Child Column in MSG_COLUMN_GRP_DTL_RELTN(FK) Parent Table Name Parent Column Name
Parents: MSG_COLUMN_GRP_ID MSG_COLUMN_GRP MSG_COLUMN_GRP_ID


MSG_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Configuration
Definition: Defines a view of messaging items and filtering arrangements
Table Type: REFERENCE





Column Detail - MSG_CONFIG


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y Represents the private owner of this category
CONFIG_DESC VARCHAR(40) N Config Description
CONFIG_NAME VARCHAR(40) N Configuration Name
CREATE_DT_TM DATETIME N Original Creation Date
MSG_CONFIG_ID DOUBLE N Msg Config 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
SEARCH_RNG_UNITS DOUBLE Y Search range units, i.e. 1 = Days
SEARCH_RNG_VALUE DOUBLE Y Search range value, i.e. 30
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.
USER_MODIFY_IND DOUBLE N Indicates whether the user can modify this configuration from outside the build tools



Relationship Detail - MSG_CONFIG




Parent Column in MSG_CONFIG (PK) Child Table Name Child Column Name
Children: MSG_CONFIG_ID MSG_CFG_CAT_RELTN MSG_CONFIG_ID
MSG_CONFIG_PUB_ASNMNT MSG_CONFIG_ID