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.