Table Detail Report

PM_FLX_PROMPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM Flex Prompt
Definition: Table that stores prompt information.
Table Type: REFERENCE





Column Detail - PM_FLX_PROMPT


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.
CODESET DOUBLE Y Codeset value that is used for the prompt.
DESCRIPTION VARCHAR(255) Y Text description of the prompt.
DISPLAY_ONLY_IND DOUBLE Y Specifies whether the control allows the user ability to change data.
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.
EXT_OPTIONS_LONG_TEXT_REF_ID DOUBLE N SEQUENCE NAME: LONG_DATA_SEQ Stores the identifier of the row on the long_text_reference table containing the text associated with the options of the prompt.
FIELD VARCHAR(255) Y The table field this prompt is connected to.
FORMAT VARCHAR(100) Y Used to store the default format of the prompt if applicable.
HELP_LONG_TEXT_ID DOUBLE N Stores the identifier of the row in the Long_Blob_Reference table containing the text associated with the prompt.
HL7_DESCRIPTION VARCHAR(80) Y Stores the description, according to HL7 definition, for the prompt.
INFO_LONG_TEXT_ID DOUBLE N The unique id for a field which contains the long text description for this information.
LABEL VARCHAR(255) Y Text label for the prompt.
LENGTH DOUBLE Y Length of text field.
MESSAGE VARCHAR(255) Y Used to store client site defined help comments for the prompt.
OPTIONS VARCHAR(100) Y A text string that identifies options on a individual prompt.
PARENT_DATA_SOURCE_NBR DOUBLE Y This column is for import purposes mainly. The importer can read the csv and keep track of that row it should map to. Thus allowing us to not overlay clients changes with a new import.
PARENT_ENTITY_ID DOUBLE N Primary key of the parent table
PARENT_ENTITY_NAME VARCHAR(32) Y Name of the parent entitiy.
PM_FLX_FORM_ID DOUBLE N SEQUENCE NAME: PM_FLX_CONVERSATION_ID_SEQ Stores the identifier of the row on the pm_flx_form table containing the reference data of the flexible form
PROMPT_ID DOUBLE N Unique identifier for a prompt.
PROMPT_TYPE VARCHAR(12) Y The data type of the prompt. For example, a prompt may be text, date, phone, a coded value, etc.
REQUIRED_IND DOUBLE Y Indicates whether this field is required in a conversation.
RULE_LONG_TEXT_ID DOUBLE N ID of a long text description stored in a table.
SEQUENCE DOUBLE Y This field represents the order in which the prompt appears on the conversation.
STATIC_IND DOUBLE Y Static Indicator (Not Used)
STYLE DOUBLE Y This field is used to further define the display characteristics of a given prompt.
SUB_TYPE_CD DOUBLE N The user defined code_value for the sub type
SUB_TYPE_MEANING VARCHAR(12) Y The cdf_meaning from codeset 356 for a given prompt of type user-defined.
TAB DOUBLE Y Represents the sequential tab number on which the prompt appears in the 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.
USER_DEFINED_IND DOUBLE Y This indicator will tell us whether this is a 'Cerner' defined field or whether the user created this field at run time.
VALUE_CD DOUBLE N Code Value for the prompt. This column can be a code value from many different code sets. The "default" value of a prompt is stored in this field. It would not be tied to one single code set.
VALUE_DT_TM DATETIME Y The value of the prompt if it is a date/time type.
VALUE_IND DOUBLE Y Field that contains the default value for a prompt with value type of indicatory (short).
VALUE_NBR DOUBLE Y Field that contains the default value for a prompt with a value type of number.
VALUE_STRING VARCHAR(255) Y Field that contains the default value for a prompt with a text value.
VALUE_TYPE VARCHAR(1) Y Indicates the type of default value that is being held.
VERIFY_IND DOUBLE Y Indicates whether or not the prompt should be verified.



Relationship Detail - PM_FLX_PROMPT


Child Column in PM_FLX_PROMPT(FK) Parent Table Name Parent Column Name
Parents: HELP_LONG_TEXT_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
EXT_OPTIONS_LONG_TEXT_REF_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RULE_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PM_FLX_FORM_ID PM_FLX_FORM PM_FLX_FORM_ID


PM_FLX_REG_RULE



Column Section Top of Page


Table-level Detail

Description: Person Management Flexible Registration Rule.
Definition: Contains information on the restrictions placed on PM_FLX_TASK as to what types of conversations specific applications can invoke.
Table Type: REFERENCE





Column Detail - PM_FLX_REG_RULE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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_DT_TM DATETIME Y The date and time that the active_status_cd was set.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
END_APP_NUM DOUBLE Y The ending number for the range of applications a rule applies to.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PRODUCT_ID DOUBLE Y This is the unique identifier from the product table of the product associated with the registration rule.
RULE VARCHAR(25) Y Text that signals what type of rule/restriction applies..
RULE_ID DOUBLE N Unique identifier for the rule.
START_APP_NUM DOUBLE Y The starting number for the range of applications a rule applies to.
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 VARCHAR(25) Y Rule/Restrction value.


PM_FLX_RULE_LIB



Column Section Top of Page


Table-level Detail

Description: Person Management Flexible Rule Library
Definition: Library of interfield rules used by person management.
Table Type: REFERENCE





Column Detail - PM_FLX_RULE_LIB


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
CATEGORY VARCHAR(60) Y Classification of a rule.
DESCRIPTION VARCHAR(255) Y Text description of the rule library.
FIELD VARCHAR(255) Y Field in a table associated with a rule library.
OPTIONS VARCHAR(255) Y A text string that identifies options on a library rule.
REVISION VARCHAR(20) Y The particular revision that a rule was added to this library.
RULE_LIB_ID DOUBLE N Unique identifier of a rule library.
RULE_LONG_TEXT_ID DOUBLE N ID where long text description is stored..
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.


PM_FLX_TASK_CONV_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Flexible Task Conversation Relationship
Definition: Relationship Table between Tasks and pm_flx_conversation
Table Type: REFERENCE





Column Detail - PM_FLX_TASK_CONV_RELTN


Column Name Type Null? Definition
ACTION DOUBLE Y Long that relates to the conversation type.
ACTIVE_IND DOUBLE Y 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 Y 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 Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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 Y Conversation_Id from pm_flx_conversation table
END_EFFECTIVE_DT_TM DATETIME Y 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.
FLX_FORM_TYPE_CD DOUBLE N This is a value that is populated when the pm_flx_form_id is populated and it refers to the type of flexible form attached to the task.
ORGANIZATION_ID DOUBLE Y Unique Identifier on Organization Table
PM_FLX_FORM_ID DOUBLE N The ID of the flexible form that the task and conversation are associated to.
TASK DOUBLE Y Number from the application_task table.
TASK_CONV_RELTN_ID DOUBLE N System Generated number that uniquely identifies each row.
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_TASK_CONV_RELTN


Child Column in PM_FLX_TASK_CONV_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
CONVERSATION_ID PM_FLX_CONVERSATION CONVERSATION_ID
PM_FLX_FORM_ID PM_FLX_FORM PM_FLX_FORM_ID


PM_LOC_ATTRIB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Mgmt: Tie flexible attributes to locations.
Definition: PM table to relate flexible attributes to locations.
Table Type: REFERENCE





Column Detail - PM_LOC_ATTRIB


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
ATTRIB_TYPE_CD DOUBLE N Type of attribute that is related to a location (e.g. Motor Vehicle, Fire/Explosion)
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.
DESCRIPTION VARCHAR(40) Y Free-text description of the attribute
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.
LOCATION_CD DOUBLE N Code value describing the location related to the attribute
LOC_TEMPLATE_STRING VARCHAR(20) Y Column is not used
PARENT_ENTITY_ID DOUBLE N When a location is closed, this column gets stamped with the location_cd of the parent location that was closed. (e.g. if a Room gets closed, the bed locations belonging in that room will have a parent_entity_id equal to the location_cd for the Room)
PARENT_ENTITY_NAME VARCHAR(60) Y CDF meaning from code set 17649 describing the type of attribute
PM_LOC_ATTRIB_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_CD DOUBLE N Code value for coded attributes
VALUE_DT_TM DATETIME Y Value for date/time attributes
VALUE_ID DOUBLE N Value used for tying id's to attributes. May be obsolete, do not believe this column is used any more.
VALUE_NUM DOUBLE Y Value used for tying integers to attributes
VALUE_STRING VARCHAR(40) Y Value used for tying strings to attributes
VALUE_TIME_NUM DOUBLE Y Value used for tying times to attributes
VALUE_TYPE VARCHAR(1) Y Indicates which value type is filled out (date, string, etc.)



Relationship Detail - PM_LOC_ATTRIB


Child Column in PM_LOC_ATTRIB(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD