ENTITY_ID |
DOUBLE |
N |
The Entity ID is the foreign surrogate key identity the entity that this lock represents. This column along with the Entity Name should uniquely identity a lock. |
ENTITY_ID_DATA |
DOUBLE |
Y |
This is a duplicate of the entity id column and is started separate from the entity id so that the unique is not effected when the entity is unlocked. |
ENTITY_NAME |
VARCHAR(35) |
N |
The name of the entity domain being locked. This along with the entity id column will uniquely identify the locked entity. The current values are: PERSON FILL BATCH ENCOUNTER ORDER EVENT |
ENTITY_NAME_DATA |
VARCHAR(35) |
Y |
This is a duplicate of the entity name column stored in a non-indexed column. |
EXPIRE_DT_TM |
DATETIME |
Y |
The date and time that the lock will expire. |
FORCE_IND |
DOUBLE |
Y |
If the lock is forced to expire, this indicator will be set to the value of 1 (one). |
LOCKING_APPLICATION_NAME |
VARCHAR(35) |
N |
Name of the application that currently owns the lock. |
LOCKKEY_ID |
DOUBLE |
Y |
The Lock Key is a unique value that represents the lock. The lock key is held by the lock requestor and can be used to identify the lock. This number will always be unique. |
LOCK_DT_TM |
DATETIME |
Y |
The date and time that the lock was granted or renewed. |
LOCK_PRSNL_ID |
DOUBLE |
Y |
The prsn_id of the user that requested the lock. |
LOCK_SEQ_ID |
DOUBLE |
N |
The lock sequence is used as a surrogate key to control the size of the entity lock table. The sequence is set to wrap, which allow a sequence to be used more than once. |
LOCK_TYPE |
DOUBLE |
N |
This column indicates the lock type or level of the lock. Currently only lock type of 1 is supported. Future lock types might include: 1 - enterprise 2 - department 3 - function/application |
LOCK_TYPE_DATA |
DOUBLE |
Y |
This is a duplicate of the lock_type field stored in a non-indexed column. |
UNLOCK_DT_TM |
DATETIME |
Y |
The date and time that the lock was unlocked. |
UNLOCK_PRSNL_ID |
DOUBLE |
Y |
The prsnl_id of the user that unlocked the entity. |
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. |