Table Detail Report

PM_QST_QUESTION



Column Section Top of Page


Table-level Detail

Description: PM QST QUESTION
Definition: Person Mgmt: Defines the questions for flexible questionnaires.
Table Type: REFERENCE





Column Detail - PM_QST_QUESTION


Column Name Type Null? Definition
QUESTIONNAIRE_ID DOUBLE N This is the value of the unique primary identifier of the pm_qst_questionaire table. It is an internal system assigned number.
QUESTION_COND VARCHAR(255) Y (Future Use)
QUESTION_ID DOUBLE N This is the value of the unique primary identifier of the pm_qst_question table. It is an internal system assigned number.
QUESTION_MEANING VARCHAR(12) Y String value representing the question. (i.e. Q1, Q12, etc.)
QUESTION_PARENT_ID DOUBLE Y This id represent the parent question. This is the value of the unique primary identifier of the pm_qst_question table. It is an internal system assigned number.
QUESTION_PARENT_VALUE VARCHAR(255) Y Value of the parent question that must be answered in order to display this question.
QUESTION_SEQ DOUBLE Y The sequence the question is in the list.
QUESTION_TEXT VARCHAR(255) Y Text describing the question.
QUESTION_TYPE VARCHAR(3) Y Identifies the type of question.
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_QST_QUESTIONNAIRE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM QST QUESTIONNAIRE
Definition: Person Mgmt: Defines flexible questionnaires.
Table Type: REFERENCE





Column Detail - PM_QST_QUESTIONNAIRE


Column Name Type Null? Definition
ENTITY_NAME VARCHAR(32) N Name of the table that this questionnaire is associated with.
QUESTIONNAIRE_COND VARCHAR(255) Y (Future Use)
QUESTIONNAIRE_ID DOUBLE N This is the value of the unique primary identifier of the pm_qst_questionnaire table. It is an internal system assigned number.
QUESTIONNAIRE_NAME VARCHAR(255) N Name that identifies the questionnaire.
QUESTIONNAIRE_TYPE_FLAG DOUBLE Y Setting this to a 0 specifies a generic questionnaire. A value of 1 specifies a MSP questionnaire; 2 Cerner Practice Management (CPM) MSP Questionnaire.
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_QST_QUESTIONNAIRE




Parent Column in PM_QST_QUESTIONNAIRE (PK) Child Table Name Child Column Name
Children: QUESTIONNAIRE_ID PM_QST_QUESTIONNAIRE_ACT QUESTIONNAIRE_ID


PM_QST_QUESTIONNAIRE_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Questionnaire Activity
Definition: Person Mgmt: Stores data related to activity occurring to a questionnaire
Table Type: ACTIVITY





Column Detail - PM_QST_QUESTIONNAIRE_ACT


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.
COMPLETED_DT_TM DATETIME Y The date and time the questionnaire was completed.
COMPLETED_PRSNL_ID DOUBLE N The identifier of the person who completed the questionnaire.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the questionnaire activity is related (i.e., person_id, encounter_id, etc.)
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this questionnaire activity row is related (i.e. PERSON, ENCOUNTER, etc.)
PM_QST_QUESTIONNAIRE_ACT_ID DOUBLE N Uniquely identifies activity occurring to a questionnaire.
QUESTIONNAIRE_ID DOUBLE N Uniquely identifies a related questionnaire.
REVIEWED_DT_TM DATETIME Y The date and time at which an already completed questionnaire was reviewed..
REVIEWED_PRSNL_ID DOUBLE N The id of the person who reviewed the completed questionnaire.
STATUS_CD DOUBLE N The status of the questionnaire. Examples are In Progress, Completed, etc.
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_QST_QUESTIONNAIRE_ACT


Child Column in PM_QST_QUESTIONNAIRE_ACT(FK) Parent Table Name Parent Column Name
Parents: QUESTIONNAIRE_ID PM_QST_QUESTIONNAIRE QUESTIONNAIRE_ID
COMPLETED_PRSNL_ID PRSNL PERSON_ID
REVIEWED_PRSNL_ID PRSNL PERSON_ID


PM_SCH_COUNTER



Column Section Top of Page


Table-level Detail

Description: Search counter.
Definition: Search counter.
Table Type: ACTIVITY





Column Detail - PM_SCH_COUNTER


Column Name Type Null? Definition
COUNTER_ID DOUBLE N Primary key.
START_DT_TM DATETIME Y Counter start date and time.
VALUE DOUBLE Y Counter value.


PM_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: Person Management Template table.
Definition: Template for days of the week and scheduling of location closings...
Table Type: REFERENCE





Column Detail - PM_TEMPLATE


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.
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(60) Y Description of the template as defined by the user.
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.
TEMPLATE_ID DOUBLE N Sequence used for the table.
TEMPLATE_TYPE_CD DOUBLE N This field contains the internal identification code associated with the template type. Template types include options such as templates and letters, for example. Template type parameters are stored on codeset 1303.
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.