Table Detail Report

APPLICATION_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Application Group
Definition: Used in authorization security to group applications into functional areas. These functional areas (groups) are then accessed with users to grant them access to applications and application_tasks.
Table Type: REFERENCE





Column Detail - APPLICATION_GROUP


Column Name Type Null? Definition
APPLICATION_GROUP_ID DOUBLE N This is the unique ID associated with the application group
APP_GROUP_CD DOUBLE N The code set in the decoder that holds the application group display. A user's app group code is grouped with the task_number is what determines if a user has access to the task.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N The code set in the decoder that holds the position display values.
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 - APPLICATION_GROUP


Child Column in APPLICATION_GROUP(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


APPLICATION_INI



Column Section Top of Page


Table-level Detail

Description: Application Initialization Parameters
Definition: Stores application parameters for each user in a section / name value pair sequence. Sections and name values can store preferences the user has defined. Sections and name values are defined by each application and can be any validate alpha/numeric combination.
Table Type: REFERENCE





Column Detail - APPLICATION_INI


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N The number of the application with the init parameters in this row.
PARAMETER_DATA LONGTEXT Y A string of parameters in the form (parameter) = value
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SECTION VARCHAR(50) N This is any textual parameter, or group of parameters as defined by the application.
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.


APPLICATION_PARAMETER



Column Section Top of Page


Table-level Detail

Description: Application Parameter
Definition: Used to store additional information about clients accessing applications. This table is not used at this time.
Table Type: ACTIVITY





Column Detail - APPLICATION_PARAMETER


Column Name Type Null? Definition
APP_CTX_ID DOUBLE N
PARAMETER VARCHAR(32) N
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(100) Y


APPLICATION_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Application Task
Definition: Application Tasks are functional divisions within an application intended to be divisions at which applications can grant or revoke access to those functions. So for example, if an application has the functions of ordering, resulting, and viewing, these would be defined as application tasks. This would then allow user to be granted access to any or all of those application tasks.
Table Type: REFERENCE





Column Detail - APPLICATION_TASK


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y This is the date the task was created, or the last time the active_indicator was set on.
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.
DESCRIPTION VARCHAR(200) Y The description as the task as defined in AppReg
INACTIVE_DT_TM DATETIME Y This date is filled out if the active_indicator is not checked.
OLD_TASK_NUMBER DOUBLE Y Contains old task number
OPTIONAL_REQUIRED_FLAG DOUBLE Y The values in this column are 1 for required and 0 for optional. This column is used in building task access security. Tasks that are required should always be granted when granting access to an application to minimize access issues. The application Task Access uses this flag to facilitate authorization granting.
SUBORDINATE_TASK_IND DOUBLE Y A subordinate task is one that is usually shared by many applications. The reason you would want to make a task subordinate is if you will grant a user access to your task, but you don't want to give them free reign over all the tasks in all of the applications this task is associated with.
TASK_NUMBER DOUBLE N The unique number of this component.
TEXT VARCHAR(500) Y Free text area exposed to the user in AppReg.
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 - APPLICATION_TASK




Parent Column in APPLICATION_TASK (PK) Child Table Name Child Column Name
Children: TASK_NUMBER APPLICATION_TASK_R TASK_NUMBER
TASK_ACCESS TASK_NUMBER
TASK_REQUEST_R TASK_NUMBER


APPLICATION_TASK_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Application Task Relationships
Definition: Maintains the relationship between an application and the application tasks that it contains.
Table Type: REFERENCE





Column Detail - APPLICATION_TASK_R


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N This is the unique application number that tasks are being associated to in this row.
TASK_NUMBER DOUBLE N This is the unique task number that is being associated with the application number.
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 - APPLICATION_TASK_R


Child Column in APPLICATION_TASK_R(FK) Parent Table Name Parent Column Name
Parents: APPLICATION_NUMBER APPLICATION APPLICATION_NUMBER
TASK_NUMBER APPLICATION_TASK TASK_NUMBER