Table Detail Report

PRSNL_CODE_VALUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Code Value Relationship
Definition: A table that defines a relationship between a personnel and a code value.
Table Type: REFERENCE





Column Detail - PRSNL_CODE_VALUE_R


Column Name Type Null? Definition
CODE_SET DOUBLE N The value of the code set. Code sets are groupings of code values.
CODE_VALUE DOUBLE N The code value associated with this code.
PRSNL_CODE_VALUE_R_ID DOUBLE N Unique generated number that identifies a single row on the prsnl_code_value_r table.
PRSNL_ID DOUBLE N Identifies the personnel related to the code value.
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 - PRSNL_CODE_VALUE_R


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


PRSNL_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Comment
Definition: Defines a comment for a personnel
Table Type: REFERENCE





Column Detail - PRSNL_COMMENT


Column Name Type Null? Definition
COMMENT_LONG_TEXT_ID DOUBLE N Uniquely identifies the row on the long text table related to this comment.
COMMENT_TYPE_CD DOUBLE N The comment type code value. Code Set 4300005.
PRSNL_COMMENT_ID DOUBLE N Unique generated number that identifies a single row on the prsnl_comment table.
PRSNL_ID DOUBLE N Uniquely identifies the personnel realted to this comment.
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_COMMENT


Child Column in PRSNL_COMMENT(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID


PRSNL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Group
Definition: The personnel group table contains categories for identifying personnel with a common purpose, job,responsibility, specialty, credential, team, etc.
Table Type: REFERENCE





Column Detail - PRSNL_GROUP


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.
PRSNL_GROUP_CLASS_CD DOUBLE N Personnel Group Classifications code identifies the classification of the group. (i.e. Physician gourp, Provider group, etc.)
PRSNL_GROUP_DESC VARCHAR(255) Y Text description of the prsnl group. Used to provider more detail.
PRSNL_GROUP_ID DOUBLE N This is the value of the unique primary identifier of the personnel group table. It is an internal system assigned number.
PRSNL_GROUP_NAME VARCHAR(100) Y Name given to the personnel group.
PRSNL_GROUP_NAME_KEY VARCHAR(100) Y personnel group name key
PRSNL_GROUP_NAME_KEY_A_NLS VARCHAR(400) Y PRSNL_GROUP_NAME_KEY_A_NLS column
PRSNL_GROUP_NAME_KEY_NLS VARCHAR(202) Y This is the description used for non-English based strings for the NLSSORT function.
PRSNL_GROUP_TYPE_CD DOUBLE N Personnel Group Type Code identifies the type of group. (i.e. Surgeon, Vascular, Dental, etc.)
SERVICE_RESOURCE_CD DOUBLE N Service Resource Code identifies the resource associated with the prsnl group. (i.e. Pharmacy, Surgery, etc.)
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 - PRSNL_GROUP




Parent Column in PRSNL_GROUP (PK) Child Table Name Child Column Name
Children: PRSNL_GROUP_ID AP_DC_EVENT PRSNL_GROUP_ID
AP_DC_EVENT_PRSNL PRSNL_GROUP_ID
AP_SYS_CORR ASSIGN_TO_GROUP_ID
CE_EVENT_ACTION ACTION_PRSNL_GROUP_ID
CE_EVENT_PRSNL ACTION_PRSNL_GROUP_ID
CE_EVENT_PRSNL REQUEST_PRSNL_GROUP_ID
CV_PROC PHYS_GROUP_ID
DA_DOCUMENT_PRSNL_RELTN PRSNL_GROUP_ID
DCP_MP_PL_CUSTOM_ENTRY PRSNL_GROUP_ID
DCP_PL_CUSTOM_ENTRY PRSNL_GROUP_ID
DCP_PL_QUERY_TEMP_ACCESS PROVIDER_GROUP_ID
DCP_PL_RELTN PRSNL_GROUP_ID
ENCNTR_PRSNL_GRP_RELTN PRSNL_GROUP_ID
GL_TRANS_QUALIFIER ORDERING_PHYS_GROUP_ID
GL_TRANS_QUALIFIER RENDERING_PHYS_GROUP_ID
MESSAGING_FAVORITES PRSNL_GROUP_ID
MESSAGING_NOTIFY ASSIGN_PRSNL_GROUP_ID
MESSAGING_NOTIFY NOTIFY_PRSNL_GROUP_ID
MESSAGING_OUT_OF_OFFICE PRSNL_GROUP_ID
MP_PRIMED_VIEW_REF PRSNL_GROUP_ID
MSG_CONFIG_PUB_ASNMNT PRSNL_GROUP_ID
OMF_AUTH_PRSNL_GROUP PRSNL_GROUP_ID
OMF_PVI_FOLDERS PRSNL_GROUP_ID
OMF_PV_ITEMS PRSNL_GROUP_ID
ORDER_DAILY_REVIEW_DEFER DEFER_FROM_PRSNL_GROUP_ID
ORDER_DAILY_REVIEW_RSPNL RSPNL_PRSNL_GROUP_ID
ORDER_NOTIFICATION FROM_PRSNL_GROUP_ID
ORDER_NOTIFICATION TO_PRSNL_GROUP_ID
ORDER_PROPOSAL_NOTIF FROM_PRSNL_GROUP_ID
ORDER_PROPOSAL_NOTIF TO_PRSNL_GROUP_ID
PATHWAY_NOTIFICATION FORWARDING_PRSNL_GROUP_ID
PATHWAY_NOTIFICATION FROM_PRSNL_GROUP_ID
PATHWAY_NOTIFICATION TO_PRSNL_GROUP_ID
PFT_QUEUE_ASSIGNMENT ASSIGNED_PRSNL_GROUP_ID
PFT_QUEUE_ITEM DEPARTMENT_ID
PFT_QUEUE_ITEM_WF_HIST DEPARTMENT_ID
PFT_WF_DEPARTMENT_RELTN DEPARTMENT_ID
PRACTICE_SITE_MSG_ROUTING INTENDED_RECIP_PRSNL_GROUP_ID
PRACTICE_SITE_MSG_ROUTING ROUTED_RECIP_PRSNL_GROUP_ID
PREFERENCE_CARD SURG_SPECIALTY_ID
PRSNL_GROUP_ORG_RELTN PRSNL_GROUP_ID
PRSNL_GROUP_POOL PRSNL_GROUP_ID
PRSNL_GROUP_POOL_ROUTING_R PRSNL_GROUP_POOL_ID
PRSNL_ROLE_PROFILE CHART_ACCESS_PRSNL_GROUP_ID
RCM_CLARIFICATION PRSNL_GROUP_ID
RC_PRSNL_GROUP_EXCLUSION PRSNL_GROUP_ID
RC_PRSNL_GROUP_INCLUSION PRSNL_GROUP_ID
RES_REVIEWER PRSNL_GROUP_ID
SURGICAL_CASE SURG_SPECIALTY_ID
SURGICAL_PROCEDURE SURG_SPECIALTY_ID
SURG_CASE_PROCEDURE SCHED_SURG_SPECIALTY_ID
SURG_CASE_PROCEDURE SURG_SPECIALTY_ID
SURG_PROC_DETAIL SURG_SPECIALTY_ID
TASK_ACTIVITY MSG_SENDER_PRSNL_GROUP_ID
TASK_ACTIVITY_ASSIGNMENT ASSIGN_PRSNL_GROUP_ID
TASK_ACTIVITY_ASSIGN_MSG_H ASSIGN_PRSNL_GROUP_ID
TASK_ACTIVITY_MSG_H MSG_SENDER_PRSNL_GROUP_ID
TEST_REVIEWER QUEUED_TO_PRSNL_GROUP_ID


PRSNL_GROUP_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Group Organization Relationships
Definition: Relates personnel groups to organizations.
Table Type: REFERENCE





Column Detail - PRSNL_GROUP_ORG_RELTN


Column Name Type Null? Definition
ORGANIZATION_ID DOUBLE N The Organization ID from the Organization table
PRSNL_GROUP_ID DOUBLE N Foreign Key from the PRSNL_GROUP table
PRSNL_GROUP_ORG_RELTN_ID DOUBLE N The primary key for this row
RELTN_TYPE_CD DOUBLE N Defines the type of relationship
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_GROUP_ORG_RELTN


Child Column in PRSNL_GROUP_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


PRSNL_GROUP_POOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Group Pool
Definition: Stores information specific to the 'pool' use of a prsnl group. Pools are a group of providers, typically working together and sharing Inbox Tasks.
Table Type: REFERENCE





Column Detail - PRSNL_GROUP_POOL


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.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
OUTSIDE_ADD_IND DOUBLE N Can Add Prsnl To Pool From Outside Org. Indicates if prsnl who are not members of the pool's organization can add new pool members.
OUTSIDE_FORWARD_IND DOUBLE N Can Forward To Pool From Outside Org. Indicates if prsnl who are not members of the pool's organization can forward Inbox items to the pool.
PRSNL_GROUP_ID DOUBLE N Personnel Group Identification. The source Personnel Group which Uniquely identifies the Pool.
PRSNL_GROUP_POOL_ID DOUBLE N The Primary Key for this table.
SCH_FLEX_ID DOUBLE N The flex-id used for the flex-engine. Comes from SCH_FLEX_STRING
SELF_ASSIGN_LEADER_IND DOUBLE N Allow user to self-declare team leader
SELF_ENROLL_IND DOUBLE N Allow users to opt-in or opt-out of membership
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_GROUP_POOL


Child Column in PRSNL_GROUP_POOL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID