Table Detail Report

PM_FILTER_VALUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains relationships for filter values.
Definition: This table holds the relationship for a filter value.
Table Type: REFERENCE





Column Detail - PM_FILTER_VALUES


Column Name Type Null? Definition
BEG_VALUE VARCHAR(100) N Initial value for filter.
END_VALUE VARCHAR(100) Y Last value for filter values.
FIELD_TYPE VARCHAR(12) Y Type of field for filter
PM_FILTER_ID DOUBLE N foreign key
PM_FILTER_VALUES_ID DOUBLE N primary key
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.
VALUE_TYPE_FLAG DOUBLE N Type flag for value



Relationship Detail - PM_FILTER_VALUES


Child Column in PM_FILTER_VALUES(FK) Parent Table Name Parent Column Name
Parents: PM_FILTER_ID PM_FILTER PM_FILTER_ID


PM_FLX_ACTION



Column Section Top of Page


Table-level Detail

Description: Person Management flexible action table
Definition: This table contains information about actions that are used to build conversations.
Table Type: REFERENCE





Column Detail - PM_FLX_ACTION


Column Name Type Null? Definition
ACTION DOUBLE N Cerner-defined action constant
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DATA_SOURCE_ID DOUBLE N ID of data source from parent data source
DESCRIPTION VARCHAR(255) Y A text description of the action.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INFO_LONG_TEXT_ID DOUBLE Y Key to long text table where information is stored.
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.


PM_FLX_CONVERSATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores information pertaining to conversations that have been created.
Definition: Conversation table
Table Type: REFERENCE





Column Detail - PM_FLX_CONVERSATION


Column Name Type Null? Definition
ACTION DOUBLE Y Cerner-defined action constant
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONVERSATION_ID DOUBLE N Unique ID for the conversation.
COPY_FIELDS_LONG_TEXT_ID DOUBLE N Stores the identifier of the row in the long_txt_reference table containing the copy fields option.
DESCRIPTION VARCHAR(255) Y Text description of the conversation
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
END_RULE_LONG_BLOB_REF_ID DOUBLE N The ID of the conversation end rule stored of the long_blob_reference table.
EPSD_COLUMNS_LONG_TEXT_ID DOUBLE N Used to store the identifier of the row in the LONG_TEXT_REFERENCE table containing the Episode column option.
ICON_LONG_BLOB_REF_ID DOUBLE N The ID of the conversation icon stored on the long_blob_reference table.
ICON_LONG_TEXT_ID DOUBLE N This is a unique id for an item that contains a long text description of the icon.
INFO_LONG_TEXT_ID DOUBLE N This is a unique id for an item that contains a long text description of the information.
OPTIONS VARCHAR(255) Y Options for Conversation Level Information.
OPTIONS_LONG_TEXT_REF_ID DOUBLE N Stores the identifier of the row on the long_text_reference table containing the text associated with the options of the conversation.
RELTN_DEFAULT_LONG_TEXT_ID DOUBLE N Newborn Options long text row
RULE_LONG_TEXT_ID DOUBLE N This is a unique id for an item that contains a long text description of the rule.
START_RULE_LONG_BLOB_REF_ID DOUBLE N The id of the conversation start rule stored of the long_blob_reference table.
TASK DOUBLE Y This is a number that coincides with a task number that we can use for security reasons to lock out a given user
UNAUTH_FLAG DOUBLE Y This flag determines how data is saved into the database for a given conversation.
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 - PM_FLX_CONVERSATION


Child Column in PM_FLX_CONVERSATION(FK) Parent Table Name Parent Column Name
Parents: END_RULE_LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
ICON_LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
START_RULE_LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
COPY_FIELDS_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
EPSD_COLUMNS_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OPTIONS_LONG_TEXT_REF_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in PM_FLX_CONVERSATION (PK) Child Table Name Child Column Name
Children: CONVERSATION_ID PM_CONV_RELTN CONVERSATION_ID
PM_FLX_CONV_OPTIONS CONVERSATION_ID
PM_FLX_TASK_CONV_RELTN CONVERSATION_ID


PM_FLX_CONV_OPTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM FLX CONV OPTIONS
Definition: Person managements conversation options
Table Type: REFERENCE





Column Detail - PM_FLX_CONV_OPTIONS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONVERSATION_ID DOUBLE N ID for the conversation that the option is relevant to.
OPTION_TYPE_CD DOUBLE N Option type code value.
PM_FLX_CONV_OPTIONS_ID DOUBLE N Unique ID for the conversation option.
PRIORITY_SEQ DOUBLE N Priority of each option.
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.
VALUE_DT_TM DATETIME Y Value for a date time option.
VALUE_LONG_BLOB_REF_ID DOUBLE N Value for a long blob option.
VALUE_LONG_TEXT_REF_ID DOUBLE N Value for a long text option.
VALUE_NBR DOUBLE Y Value for a number option.
VALUE_STRING VARCHAR(100) Y Value for a string option.



Relationship Detail - PM_FLX_CONV_OPTIONS


Child Column in PM_FLX_CONV_OPTIONS(FK) Parent Table Name Parent Column Name
Parents: VALUE_LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
VALUE_LONG_TEXT_REF_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
CONVERSATION_ID PM_FLX_CONVERSATION CONVERSATION_ID


PM_FLX_DATA_SOURCE



Column Section Top of Page


Table-level Detail

Description: Person Management Flexible Data Source
Definition: This table contains information used to set up the directory hierarchy in the Conversation Builder.
Table Type: REFERENCE





Column Detail - PM_FLX_DATA_SOURCE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DATA_SOURCE_ID DOUBLE N Unique ID of the data source.
DESCRIPTION VARCHAR(255) Y Text description of data source.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FIELD VARCHAR(255) Y A field in a table that this data source is connected to.
INFO_LONG_TEXT_ID DOUBLE N Key to long text table.
OPTIONS VARCHAR(100) Y A text string that identifies options on a individual data sources.
PARENT_ENTITY_ID DOUBLE N Id of the parent entity
PARENT_ENTITY_NAME VARCHAR(32) Y Name of Parent Entity.
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.