Table Detail Report
PRSNL_PRIV_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel privilege detail. |
Definition: | This table is used to store the privilege details for the user to maintain the personnel. |
Table Type: | REFERENCE |
Column Detail - PRSNL_PRIV_DETAIL
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. |
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 | N | 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. |
PRIV_TYPE_ID | DOUBLE | N | The Id of the row specifying the detail for the privilege |
PRIV_TYPE_NAME | VARCHAR(30) | N | The source of the PRIV_TYPE_ID. Valid tables: CODE_VALUE, ORGANIZATION |
PRSNL_PRIV_DETAIL_ID | DOUBLE | N | The unique ID of the Personnel Privilege Detail record |
PRSNL_PRIV_ID | DOUBLE | N | The Personnel Privilege row for which the detail is being stored |
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 - PRSNL_PRIV_DETAIL
Child Column in PRSNL_PRIV_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_PRIV_ID | PRSNL_PRIV | PRSNL_PRIV_ID |
PRSNL_PRSNL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel Personnel Relationship |
Definition: | The personnel-personnel relationship table identifies relationships between two personnel (I.e., supervisor) |
Table Type: | REFERENCE |
Column Detail - PRSNL_PRSNL_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. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
ORGANIZATION_ID | DOUBLE | Y | Foreign key to the ORGANIZATION table. Allows definition of relationships at an org only level |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRSNL_PRSNL_RELTN_CD | DOUBLE | N | Identifies the specific type of relationship between two personnel (I.e., supervisor, backup coverage, etc.) |
PRSNL_PRSNL_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the personnel-personnel relationship table. It is an internal system assigned number. |
RELATED_PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in 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 - PRSNL_PRSNL_RELTN
Child Column in PRSNL_PRSNL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
RELATED_PERSON_ID | PRSNL | PERSON_ID |
PRSNL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PRSNL RELTN |
Definition: | This table contains demographic, address, and phone relationships for personnel |
Table Type: | REFERENCE |
Column Detail - PRSNL_RELTN
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. |
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 | N | 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 | Y | 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. |
DISPLAY_SEQ | DOUBLE | N | Sequence used by the application to display relationships |
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. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the prsnl_reltn row is related (i.e., organization_id) |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The upper case name of the table to which this prsnl_reltn row is related (i.e., ORGANIZATION) |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRSNL_RELTN_ID | DOUBLE | N | The primary key of the Prsnl_Reltn table |
RELTN_TYPE_CD | DOUBLE | N | The type of relationship (i.e., Demographic, Address, Phone) |
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 - PRSNL_RELTN
Child Column in PRSNL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
Parent Column in PRSNL_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRSNL_RELTN_ID | CHART_REQUEST | PRSNL_RELTN_ID |
CR_REPORT_REQUEST | PRSNL_RELTN_ID | ||
EPRESCRIBE_DETAIL | PRSNL_RELTN_ID | ||
PRSNL_RELTN_ACTIVITY | PRSNL_RELTN_ID | ||
PRSNL_RELTN_CHILD | PRSNL_RELTN_ID |
PRSNL_RELTN_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel Relation Activity |
Definition: | Contains the activity data for all the personnel relationships(from the prsnl_reltn table) that have been selected. |
Table Type: | ACTIVITY |
Column Detail - PRSNL_RELTN_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_NBR | VARCHAR(20) | N | The Accession Number if it can be renormalized based on the parent_entity_id |
ENCNTR_ID | DOUBLE | N | The Encounter ID if it can be renormalized based on the parent_entity_id |
ENTITY_TYPE_ID | DOUBLE | N | The primary key from the parent table that defines the specific entity type that will be used when there are more than one possible relationships within the same parent entity object. E.g. relationship type code for an encounter relationship, or a oe_field_id for an order. |
ENTITY_TYPE_NAME | VARCHAR(30) | N | The name of the table that contains the entity_type_id as a primary key. E.g. would be "CODE_VALUE" from the relationship_type_cd or "ORDER_ENTRY_FIELD". This will be changing over time as teams start using it. |
ORDER_ID | DOUBLE | N | The Order ID if it can be denormlized based on the parent_entity_id |
PARENT_ENTITY_ID | DOUBLE | N | The primary key from the parent table that defines the specific personnel relationship is selected for. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The Name of the table that contains the parent entity Id as the primary key. Current valid values are "ENCOUNTER", "PERSON", "ORDERS" |
PERSON_ID | DOUBLE | N | The Person ID if it can be denormlized based on the parent_entity_id |
PRSNL_ID | DOUBLE | N | The Person_id from the Personnel table for the person for whom this relationship has been selected. |
PRSNL_RELTN_ACTIVITY_ID | DOUBLE | N | The Primary Key for the table identifying the unique activity row of the Personnel Relationship selected. |
PRSNL_RELTN_ID | DOUBLE | N | The Relationship that has been selected. |
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. |
USAGE_NBR | DOUBLE | N | This is to identify what the usage is for. This is a bitmap of the usage flags: The current values are:1 Charting |
Relationship Detail - PRSNL_RELTN_ACTIVITY
Child Column in PRSNL_RELTN_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PRSNL_ID | PRSNL | PERSON_ID | |
PRSNL_RELTN_ID | PRSNL_RELTN | PRSNL_RELTN_ID |
PRSNL_RELTN_CHILD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores each association between the prsnl_reltn_id and the parent entity. |
Definition: | This table is the child of the prsnl_reltn table. This table stores each association between the prsnl_reltn_id and the parent entity (i.e., a record for each address, phone #, or alias involved in a personnel relationship). |
Table Type: | REFERENCE |
Column Detail - PRSNL_RELTN_CHILD
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
DISPLAY_SEQ | DOUBLE | N | Sequence used by the application to display relationships |
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. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the prsnl_reltn_child row is related (i.e., address_id, prsnl_alias_id, person_alias_id) |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The upper case name of the table to which this prsnl_reltn_child row is related (i.e., ADDRESS, PHONE, PRSNL_ALIAS) |
PRSNL_RELTN_CHILD_ID | DOUBLE | N | The value of the primary identifier of the Prsnl_Reltn table |
PRSNL_RELTN_ID | DOUBLE | N | The value of the primary identifier of the Prsnl_Reltn 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 - PRSNL_RELTN_CHILD
Child Column in PRSNL_RELTN_CHILD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_RELTN_ID | PRSNL_RELTN | PRSNL_RELTN_ID |