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 |