Table Detail Report

TASK_ACCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Application Task Authorization Access Control
Definition: Task access are groups of application_tasks rows that are grouped together in application_groups by which user gain access to though application authorization.
Table Type: REFERENCE





Column Detail - TASK_ACCESS


Column Name Type Null? Definition
APP_GROUP_CD DOUBLE N This is the code set that is maintained from crm_code. It is populated with the application groups. With this code you enable the groups that can access this task.
TASK_NUMBER DOUBLE N This is the task number that we are accessing.
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 - TASK_ACCESS


Child Column in TASK_ACCESS(FK) Parent Table Name Parent Column Name
Parents: TASK_NUMBER APPLICATION_TASK TASK_NUMBER


TASK_REQUEST_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Application Task Request Relationships
Definition: Maintains the relationship between an application_tasks and the requests that it contains.
Table Type: REFERENCE





Column Detail - TASK_REQUEST_R


Column Name Type Null? Definition
REQUEST_NUMBER DOUBLE N This is the unique request number that we are associating with the task number in this row.
TASK_NUMBER DOUBLE N This is the unique task number that the requests in this row are associated with.
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 - TASK_REQUEST_R


Child Column in TASK_REQUEST_R(FK) Parent Table Name Parent Column Name
Parents: TASK_NUMBER APPLICATION_TASK TASK_NUMBER


USAGE_SUMMARY



Column Section Top of Page


Table-level Detail

Description: Usage Summary
Definition: Statistical summary table. Collects data pertaining to step and app usages.
Table Type: ACTIVITY





Column Detail - USAGE_SUMMARY


Column Name Type Null? Definition
CPU_TIME DOUBLE Y amount of cpu time the component used
ELAPSED_TIME DOUBLE Y amount of time in the server
FREQUENCY DOUBLE Y count of usage
METRIC_NAME VARCHAR(40) N name
METRIC_TYPE DOUBLE N type
MET_DT_TM DATETIME Y unused
MONTH DOUBLE N month
NODE VARCHAR(18) Y unused
PARENT_ID DOUBLE N the app number or req number of the component
SERVICE VARCHAR(50) Y service the component executed from
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.
YEAR DOUBLE N year
YEAR_SEQ DOUBLE N year mod 2