Table Detail Report

PRIVILEGE_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRIVILEGE EXCEPTION
Definition: This table contains inclusions or exclusioins to privileges defined.
Table Type: REFERENCE





Column Detail - PRIVILEGE_EXCEPTION


Column Name Type Null? Definition
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_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
EVENT_SET_NAME VARCHAR(100) Y Event set name of the event code
EXCEPTION_ENTITY_NAME VARCHAR(40) Y The name of the table that the exception row is from.
EXCEPTION_ID DOUBLE N Contains a pointer to the database that this exception pertains to. It could contain an order_catalog_cd, a task_assay_cd, etc.
EXCEPTION_TYPE_CD DOUBLE N Indicates which database this exception relates to. Could be the order catalog, an event set, etc.
PRIVILEGE_EXCEPTION_ID DOUBLE N The unique identifier of a row on this table.
PRIVILEGE_ID DOUBLE N The primary index of the privilege that this exception is tied to.
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 - PRIVILEGE_EXCEPTION


Child Column in PRIVILEGE_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: PRIVILEGE_ID PRIVILEGE PRIVILEGE_ID


PRIVILEGE_EXCEPTION_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Privilege Exception Definition
Definition: This table defines the exception template for a privilege defintion.
Table Type: REFERENCE





Column Detail - PRIVILEGE_EXCEPTION_DEF


Column Name Type Null? Definition
EXCEPTION_ENTITY_NAME VARCHAR(50) N Name of the exception entity that can be set for the privilege.
EXCEPTION_ENTITY_TYPE_CD DOUBLE N Type of exception entity that can be set for the privilege.
PRIVILEGE_DEF_ID DOUBLE N Privilege for which the exception is being defined.
PRIVILEGE_EXCEPTION_DEF_ID DOUBLE N Primary key for the privilege exception definition table.
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 - PRIVILEGE_EXCEPTION_DEF


Child Column in PRIVILEGE_EXCEPTION_DEF(FK) Parent Table Name Parent Column Name
Parents: PRIVILEGE_DEF_ID PRIVILEGE_DEF PRIVILEGE_DEF_ID


PRIV_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Privilege Group Relationship
Definition: This table relates privileges to logical groupings
Table Type: REFERENCE





Column Detail - PRIV_GROUP_RELTN


Column Name Type Null? Definition
LOG_GROUPING_CD DOUBLE N Foreign key to logical_grouping table.
PRIVILEGE_ID DOUBLE N Foreign key to privilege table.
PRIV_GROUP_RELTN_ID DOUBLE N Primary key
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 - PRIV_GROUP_RELTN


Child Column in PRIV_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOG_GROUPING_CD LOGICAL_GROUPING LOG_GROUPING_CD
PRIVILEGE_ID PRIVILEGE PRIVILEGE_ID


PRIV_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRIV LOC RELTN
Definition: This table relates a privilege to a user, position or a ppr & a location(opt).
Table Type: REFERENCE





Column Detail - PRIV_LOC_RELTN


Column Name Type Null? Definition
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_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
LOCATION_CD DOUBLE N This is an optional field that would allow privileges to be defined diffenently based on location.
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 This field is valued if the privilege is defined at the position level.
PPR_CD DOUBLE N This field is valued if the privilege is being defined at the patient/provider relationship level.
PRIV_LOC_RELTN_ID DOUBLE N The unique identifier of a row on this table.
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 - PRIV_LOC_RELTN


Child Column in PRIV_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID




Parent Column in PRIV_LOC_RELTN (PK) Child Table Name Child Column Name
Children: PRIV_LOC_RELTN_ID PRIVILEGE PRIV_LOC_RELTN_ID


PROXY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Table for storing proxy relationships
Definition: Table for storing proxy relationship
Table Type: REFERENCE





Column Detail - PROXY


Column Name Type Null? Definition
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.
END_EFFECTIVE_DT_TM DATETIME Y 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.
GROUP_PROXY_ID DOUBLE N This item is the value of the unique primary identifier of the prsnl_group_reltn table. It is an internal assigned number.
MSG_CATEGORY_ID DOUBLE N This is a Message Category code from the NOTIFICATION TYPE Code Set ( 3404 )
MSG_ITEM_GRP_ID DOUBLE N This is a Message Item Group Code from the NOTIFICATION SUB TYPE Code Set ( 3405 )
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROXY_ID DOUBLE N The unique index for a row on this table.
PROXY_PERSON_ID DOUBLE N This column stores the identifier of the user that has been declared a proxy.
PROXY_TYPE_CD DOUBLE N The code value for the type of proxy relationship that a row on this table represents.
TAKE_PROXY_STATUS_FLAG DOUBLE Y Status flag of the Take Proxy row. 0 or NULL = not a take proxy row; 1 = Another user can take proxy; 2 = Another user has taken proxy; 3 = User acknowledges proxy was taken
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.



Relationship Detail - PROXY


Child Column in PROXY(FK) Parent Table Name Parent Column Name
Parents: GROUP_PROXY_ID PRSNL_GROUP_RELTN PRSNL_GROUP_RELTN_ID