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 |