ACCESS_CONTROL_POLICY
Column Section | Top of Page |
Table-level Detail
Description: | Access Control Policy |
Definition: | This table stores policies used to determine a consumer's authorization decision based on the consumers's access control status. |
Table Type: | REFERENCE |
Column Detail - ACCESS_CONTROL_POLICY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESS_CONTROL_DECISION_CD | DOUBLE | N | The consumer's authorization decision. (I.E Permit or Deny) |
ACCESS_CONTROL_POLICY_ID | DOUBLE | N | The primary key of the ACCESS_CONTROL_POLICY table. |
ACCESS_CONTROL_POLICY_NAME | VARCHAR(100) | N | The name of the Access Control Policy |
ACCESS_CONTROL_POLICY_NAME_KEY | VARCHAR(100) | N | Identical to column Access_Control_Policy_Name except it is in all capitals with special characters and blanks removed. Used for indexing and searching for a policy by name. |
ACCESS_CONTROL_TYPE_ENTITY_ID | DOUBLE | N | The entity ID for the type of access control to which this policy applies. |
ACCESS_CONTROL_TYPE_ENTITY_NM | VARCHAR(30) | N | The entity name for the type of access control to which this policy applies. (I.e. CODE_VALUE) |
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_SOURCE_ENTITY_ID | DOUBLE | N | The entity ID for the data source that defines the policy. |
DATA_SOURCE_ENTITY_NAME | VARCHAR(30) | N | The entity name for the data source that defines the policy.(i.e Contibutor_system, Organization) |
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. |
STATUS_CD | DOUBLE | N | The access control status to which this policy applies. |
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. |
APPBAR_SECURITY
Column Section | Top of Page |
Table-level Detail
Description: | Denormaliztion of the application task Security |
Definition: | Specifically for use with the application_taskbar |
Table Type: | REFERENCE |
Column Detail - APPBAR_SECURITY
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NAME | VARCHAR(200) | Y | Application Name |
APPLICATION_NUMBER | DOUBLE | N | Application Number |
APP_GROUP_CD | DOUBLE | N | application group code |
OBJECT_NAME | VARCHAR(60) | Y | Object name |
POSITION_CD | DOUBLE | N | Position Code |
APPLICATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Application |
Definition: | An Application is any software component that provides connectivity to servers and databases. Each application has a name and a number. The number is used by the software component to be identified by the system as that application through the client/server architecture. |
Table Type: | REFERENCE |
Column Detail - APPLICATION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | Y | This is the date and time that the application's active_ind was set on. It defaults to the day the application was created if the indicator has never been toggled. |
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. |
APPLICATION_INI_IND | DOUBLE | Y | The application INI IND determines if the CRMBEGINAPP will check for and return any application iniparameters. Generally this is set to 1 because most application will have some parameters. However, if the application does not have parameters, setting this indicator to 0 will reduce reads from the database. Application parameters are stored on an application/ user basis on the APPLICATION_INI t |
APPLICATION_NUMBER | DOUBLE | N | This the unique number that identifies a component (application). All HNAM applications have an application number that uniquely identifies them to the system. |
COMMON_APPLICATION_IND | DOUBLE | Y | Indicates if application is common |
DESCRIPTION | VARCHAR(200) | Y | This is the description of the application that the user generally sees in the main form of the application. It is prefixed by the HNA area that the application provides functionality. |
DIRECT_ACCESS_IND | DOUBLE | Y | This determines if the application will be access directly by the user. This flag determines which application will appear to the Application Taskbar. If you have a component such as a DLL or OCX that does not get accessed by the user directly, this indictor should be set to 0. |
DISABLE_CACHE_IND | DOUBLE | Y | This indicator allows the application to deactivate desktop caching of requests. This will mainly be used by applications that do database building that do not which to be impacted with data that might be cached on the desktop. |
INACTIVE_DT_TM | DATETIME | Y | This is the date and time that the active_ind was set to off. This date will not initially be filled out. |
LAST_LOCALIZED_DT_TM | DATETIME | Y | This field is not used at this time. |
LOG_ACCESS_IND | DOUBLE | Y | This indicator determines if activation, via CRMBEGINAPP, of the application will be recorded on the APPLICATION_CONTEXT table. Generally this should always be on (value of 1). For some applications such as DLL or OCX that do a CRMBEGINAPP, this could be set off (value of 0). |
LOG_LEVEL | DOUBLE | Y | The log level is a numeric field with the values of 0 through 4 that set the default logging level for an application. Generally this will be set to 0. However, for debug or tracing of a given application, this level can be set higher so that an application can be logged at a more detailed level. The system manager through the application 'Application Context Viewer' can set this parameter. Log l |
MIN_VERSION_REQUIRED | VARCHAR(40) | Y | This functionality has not be implemented as of yet, but the concept is to record a minimum version of the application that we are expecting. In the future we might limit access to clients that have a version equal to or greater than the minimum version. This will allow old clients to be found and upgraded if the old client will no longer work with the new version. |
OBJECT_NAME | VARCHAR(60) | Y | This is the OLE name of the application. It provides functionality for the Application Taskbar as well as other applications to activate your application via OLE. This must be the registered OLE name that is exposed in the application |
OWNER | VARCHAR(20) | Y | This is a free-text field to record the group or owner of the application. |
REQUEST_LOG_LEVEL | DOUBLE | Y | This determines the maximum level at which the server will log on requests set by the client that has the log level set above audit (2) level. Since the log level can be set from the APPLICATION table or directly by the client, this allows the system manager to stop clients that are running at a high logging level from impacting server performance by limiting the level at which the servers will h |
TEXT | VARCHAR(500) | Y | This is a free-text field used to describe 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. |
Relationship Detail - APPLICATION
Parent Column in APPLICATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | APPLICATION_NUMBER | APPLICATION_TASK_R | APPLICATION_NUMBER |
APPLICATION_ACCESS
Column Section | Top of Page |
Table-level Detail
Description: | Application Access |
Definition: | Allows discrete application access for user groups. |
Table Type: | REFERENCE |
Column Detail - APPLICATION_ACCESS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | Y | The date at which the relationship between the application and the application group became active. |
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. |
ACTIVE_PRSNL_ID | DOUBLE | N | The id of the person who activated the relationship between the application and the application group. |
APPLICATION_ACCESS_ID | DOUBLE | N | A unique number to identify a specific application to application group relationship in the table. |
APPLICATION_NUMBER | DOUBLE | N | The number of the application for which the application group is being granted access to. |
APP_GROUP_CD | DOUBLE | N | The code representing the application group that has access to the application. |
INACTIVE_DT_TM | DATETIME | Y | The date at which the relationship between the application group and the application is no longer valid. |
INACTIVE_PRSNL_ID | DOUBLE | N | The id of the person who inactivated the relationship between the application and the application group. |
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_CONTEXT
Column Section | Top of Page |
Table-level Detail
Description: | Application Context |
Definition: | When a user activates an application, a context is created that represents a unique occurrence of the application being activated by that user. The context is associated with a unique number that can be used to identify other rows that have been modified or created during that context. The context number is recorded in the column UPDT_APPLCTX on most tables. |
Table Type: | ACTIVITY |
Column Detail - APPLICATION_CONTEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLCTX | DOUBLE | Y | An Application Context is a numeric value that represents a unique activation of an application by an user. This values is recorded on most tables in the updt_applctx field when a record is added or modified. |
APPLICATION_DIR | VARCHAR(100) | Y | This is the directory where the executable image was located when the user activated it. |
APPLICATION_IMAGE | VARCHAR(32) | Y | The name of the executable image file that is being started. |
APPLICATION_NUMBER | DOUBLE | Y | he number that is associated with the application that is being started. |
APPLICATION_STATUS | DOUBLE | Y | This is the status that the user received when the application was started. Zero (0) is a successful status, anything else was a failure. |
APPLICATION_VERSION | VARCHAR(40) | Y | The internal version information is extracted from the executable image when it is started by the user and record in this field. |
APP_CTX_ID | DOUBLE | N | This is internal identifier of the Application Context row. The table will automatically wrap when the maxvalue specified by the sequence is reached. This field is only used to keep records unique and is not the application context itself. |
AUTHORIZATION_IND | DOUBLE | Y | This determines if the user had the correct security to access the application or not. Valid values are 1, the user had security or 0, the user do not have security. |
CLIENT_NODE_NAME | VARCHAR(100) | Y | If available, this is the identifier that the network operation system assigned to the PC that is starting the application. |
CLIENT_START_DT_TM | DATETIME | Y | This is the date time the PC client had at the time the application was started. |
CLIENT_TZ | DOUBLE | Y | Time zone for all dates on the row. This comes from the front-end application. |
DEFAULT_LOCATION | VARCHAR(40) | Y | This is the value of the register key default_location that is set on the local PC client. |
DEVICE_ADDRESS | VARCHAR(50) | Y | The value of the registry key device_address as specific on the client PC that is starting the application. |
DEVICE_LOCATION | VARCHAR(50) | Y | The location of the Client. |
END_DT_TM | DATETIME | Y | This is the system date and time that application was ended. This ends the application context. |
LOGDIRECTORY | VARCHAR(50) | Y | This is the directory that is specified on the client PC where log files are keep. |
NAME | VARCHAR(100) | Y | The full name of the user that started the application as defined on the PRSNL table. |
PARMS_FLAG | DOUBLE | Y | Determines if any data for this application context exists on the application_parameter table. |
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 position this person generally is assigned. |
START_DT_TM | DATETIME | Y | This is the system date and time that the application context was created. |
TCPIP_ADDRESS | VARCHAR(40) | Y | If available, this is the TCP/IP address of the PC Client that started the application. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
USERNAME | VARCHAR(50) | Y | This is the user's login into the system. It is a unique value that is assigned to each user. The user gains access to the system by specifying their username and password. |