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