Table Detail Report
PM_QUE_METHOD
Column Section | Top of Page |
Table-level Detail
Description: | Work queue method. |
Definition: | Work queue method. |
Table Type: | REFERENCE |
Column Detail - PM_QUE_METHOD
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. |
APPLICATION_ID | DOUBLE | N | Foreign key attribute associating the method to a specific application (from pm_que_application table). |
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(255) | Y | Free-text description of the method. |
DISPLAY | VARCHAR(100) | N | Display value for the method. |
DISPLAY_KEY | VARCHAR(100) | N | Display key for the method. |
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. |
METHOD_ID | DOUBLE | N | Primary key. |
MODAL_IND | DOUBLE | Y | When set to "1", indicates that the method runs in a modal window. A modal window keeps the focus from the main work queue manager until the modal window is closed. |
NAME | VARCHAR(100) | N | This is the actual function name defined by the COM object. This name is not case-sensitive, but must match the name exactly as defined by the associated COM object. |
POSITIVE_RESULT | VARCHAR(100) | Y | Some methods return a value when executed. This column holds the value that the method will return if it is executed successfully. For future use. |
SUBROUTINE_IND | DOUBLE | Y | When set to "1", the method behaves as a subroutine and returns no value. |
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_QUE_PROPERTY
Column Section | Top of Page |
Table-level Detail
Description: | Work queue property. |
Definition: | Work queue property. |
Table Type: | REFERENCE |
Column Detail - PM_QUE_PROPERTY
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. |
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_TYPE_FLAG | DOUBLE | Y | Data type of this column. |
DESCRIPTION | VARCHAR(255) | Y | Description of the property. |
DISPLAY | VARCHAR(100) | N | Display value of the property. |
DISPLAY_KEY | VARCHAR(100) | N | Display key of the property. |
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. |
NAME | VARCHAR(100) | N | Name of the property. |
PARENT_ID | DOUBLE | N | Primary key for the table row associated with the property row. |
PARENT_TABLE | VARCHAR(32) | N | Name of the table associated with the property row. |
PROPERTY_ID | DOUBLE | N | Primary key. |
REQUIRED_IND | DOUBLE | Y | Indicates that the property must be populated before the associated method can be executed. For example, the ACTION property of the PMAction object must be populated before the ACTION method is executed. |
SEQUENCE | DOUBLE | Y | Sequence of the property on a given application/method |
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_QUE_VALUE
Column Section | Top of Page |
Table-level Detail
Description: | Work queue value. |
Definition: | Work queue value. |
Table Type: | REFERENCE |
Column Detail - PM_QUE_VALUE
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. |
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. |
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. |
PROPERTY_ID | DOUBLE | N | Foreign key attribute associating the value to a specific property (from the pm_que_property table). |
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(255) | Y | Some properties need to be "pre-valued" with a constant value. For example, the ACTION property of a PMAction object needs to be pre-valued to "201" when a "modify encounter" action is desired. |
VALUE_FLAG | DOUBLE | Y | Value flag. |
WORK_LIST_ID | DOUBLE | N | Foreign key attribute associating the value to a specific work list (from the pm_que_work_list table). |
PM_QUE_WORK_ITEM
Column Section | Top of Page |
Table-level Detail
Description: | Work queue item. |
Definition: | Work queue item. |
Table Type: | REFERENCE |
Column Detail - PM_QUE_WORK_ITEM
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. |
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. |
ITEM_DESC | VARCHAR(100) | Y | Free-text description for the work item |
ITEM_NAME | VARCHAR(40) | Y | Work item name that is displayed to the end user. |
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. |
WORK_ITEM_ID | DOUBLE | N | Primary key. |
PM_QUE_WORK_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM Queue Work List. |
Definition: | Used to store build data for Person Management Worklists, including query information and Worklist processing options. |
Table Type: | REFERENCE |
Column Detail - PM_QUE_WORK_LIST
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. |
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(255) | Y | Free-text description of the work queue. |
DISPLAY | VARCHAR(100) | N | Display value for the work queue. |
DISPLAY_KEY | VARCHAR(100) | N | Display key for the work queue. |
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. |
EXEC_SCRIPT_IND | DOUBLE | N | Used to store a 1 if the work list is script based or 0 if the work list is query based. |
EXEC_SCRIPT_LONG_TEXT_ID | DOUBLE | N | Used to store the identifier of the row in the LONG_TEXT_REFERENCE table containing the Execute Script text. |
METHOD_ID | DOUBLE | N | Foreign key attribute associating the work queue row to a specific method (from the pm_que_method table). |
SCHEDULE_IND | DOUBLE | N | Indicator for the option to launch Scheduling Appointment Book from the Worklist. |
SCRIPT | VARCHAR(40) | Y | This is the name of a client-defined script that can be executed when an item in the associated work list is processed. This value is optional for a work list that executes a method. |
TASK_LIST_IND | DOUBLE | Y | When set to "1", this work list simply executes a client-defined script when an item is selected. No method is executed. |
TASK_NUMBER | DOUBLE | N | This is the CRM task number associated with the work list. Users can be restricted from running this work list by using TaskAccess to limit access to this task. |
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. |
WORK_LIST_ID | DOUBLE | N | Primary key. |
Relationship Detail - PM_QUE_WORK_LIST
Child Column in PM_QUE_WORK_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXEC_SCRIPT_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in PM_QUE_WORK_LIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WORK_LIST_ID | PM_QUE_WORK_LIST_CONFIG | PM_QUE_WORK_LIST_ID |