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