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. |