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 |