Table Detail Report

PRSNL_GROUP_POOL_ROUTING_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prsnl_group_pool_routing_reltn
Definition: This table Identifies the prsnl_group_pool, it's routing rules, location and priority, used for Results to Endorse that are assigned to a prsnl_group. Data will be delted and not merged.
Table Type: REFERENCE





Column Detail - PRSNL_GROUP_POOL_ROUTING_R


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.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient associated with routing rule.
PRSNL_GROUP_POOL_ID DOUBLE N The PRSNL_GROUP_POOL_ID from the PRSNL_GROUP_POOL table
PRSNL_GROUP_POOL_ROUTING_R_ID DOUBLE N The ID of the table. SEQUENCE NAME:CARENET_SEQ
PRSNL_ID DOUBLE N Personnel Id associated with routing rule
ROUTE_TYPE_CD DOUBLE N The code value that indicates the routing criteria
ROUTING_PRIORITY_NBR DOUBLE N The priority/ranking of importance for prsnl group pool routing relations
SCH_FLEX_ID DOUBLE N The SCH_FLEX_ID from the SCH_FLEX_STRING 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_GROUP_POOL_ROUTING_R


Child Column in PRSNL_GROUP_POOL_ROUTING_R(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_POOL_ID PRSNL_GROUP PRSNL_GROUP_ID
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID


PRSNL_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Group Relationship
Definition: The personnel group relation table contains pointers to groups which a personnel is included in. Additionally, this table can be used to identify all the personnel in a specific group.
Table Type: REFERENCE





Column Detail - PRSNL_GROUP_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 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.
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 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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIMARY_IND DOUBLE Y (Future Use)
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_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the personnel group relationship table. It is an internal system assigned number.
PRSNL_GROUP_R_CD DOUBLE N (Future Use). Code set does not exist.
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_RELTN


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




Parent Column in PRSNL_GROUP_RELTN (PK) Child Table Name Child Column Name
Children: PRSNL_GROUP_RELTN_ID BR_PRSNL_CCN_RELTN PRSNL_GROUP_RELTN_ID
BR_PRSNL_ELIG_PROV_GRP_R PRSNL_GROUP_RELTN_ID
PROXY GROUP_PROXY_ID
QMD_PORTAL_PERMISSION PRSNL_GROUP_RELTN_ID
TEAM_MEM_PPR_RELTN PRSNL_GROUP_RELTN_ID


PRSNL_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Information
Definition: Allows the storage of comments at the personnel level.
Table Type: REFERENCE





Column Detail - PRSNL_INFO


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 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.
CHARTABLE_IND DOUBLE Y Determines whether this comment should show on the chart.
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.
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.
INFO_SUB_TYPE_CD DOUBLE N Information Sub Type Code identifies the category if additional information contained in the row. (For Example: Clerical Contact, etc.)
INFO_TYPE_CD DOUBLE N Information Type Code identifies the type of the information. (For Example: Comment, General Announcement, etc.)
LONG_TEXT_ID DOUBLE N The unique identifier to the LONG_TEXT table where textual comments are stored.
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_INFO_ID DOUBLE N This is the value of the unique primary identifier of the prsnl_info table. It is an internal system assigned number.
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.
VALUE_DT_TM DATETIME Y If the comment stored is of a date and time format, store the information in this attribute.
VALUE_NUMERIC DOUBLE Y If the comment stored is of a numeric format, store the information in this attribute .



Relationship Detail - PRSNL_INFO


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


PRSNL_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRSNL LOC RELTN
Definition: Relationship table tying Prsnl to locations
Table Type: ACTIVITY





Column Detail - PRSNL_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 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.
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.
LOC_BED_CD DOUBLE N The internal identifier associated with the bed to which the prsnl is associated.
LOC_BUILDING_CD DOUBLE N The internal identifier associated with the building to which the prsnl is associated.
LOC_FACILITY_CD DOUBLE N The internal identifier associated with the facility to which the prsnl is associated.
LOC_NURSE_UNIT_CD DOUBLE N The internal identifier associated with the nurse unit to which the prsnl is associated.
LOC_ROOM_CD DOUBLE N The internal identifier associated with the room to which the prsnl is associated.
PRSNL_LOC_RELTN_CD DOUBLE N Defines the type of relationship between the Prsnl and the location
PRSNL_LOC_RELTN_ID DOUBLE N Primary Key identifier to the PRSNL_LOC_RELTN table. Uses the PERSON_SEQ.
PRSNL_PERSON_ID DOUBLE N The person_id of the prsnl who is tied to the location via this 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_LOC_RELTN


Child Column in PRSNL_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD


PRSNL_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PRSNL ORG RELTN
Definition: Relationship table tying prsnl to organizations
Table Type: REFERENCE





Column Detail - PRSNL_ORG_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.
CONFID_LEVEL_CD DOUBLE N Confidence level code identifies the level of security that the personnel has to the organization. (i.e. No-Access, Non-Clinical, etc.)
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 N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
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_ORG_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the prsnl_org_reltn table. It is an internal system assigned number.
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_ORG_RELTN


Child Column in PRSNL_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PRSNL PERSON_ID