Table Detail Report

RC_PRSNL_GROUP_EXCLUSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Personnel Group Exclusion
Definition: Personnel members of a personnel group that are excluded from personnel preferential agreements.
Table Type: REFERENCE





Column Detail - RC_PRSNL_GROUP_EXCLUSION


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.
PRSNL_GROUP_ID DOUBLE N ID of the personnel group from which the personnel is being exluded.
PRSNL_ID DOUBLE N ID of personnel being excluded from the personnel group.
RC_PRSNL_GROUP_EXCLUSION_ID DOUBLE N Unique generated number that identifies a single row on the RC_PRSNL_GROUP_EXCLUSION table.
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 - RC_PRSNL_GROUP_EXCLUSION


Child Column in RC_PRSNL_GROUP_EXCLUSION(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


RC_PRSNL_GROUP_INCLUSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Personnel Group Inclusion
Definition: Personnel members of a personnel group that are included from personnel preferential agreements.
Table Type: REFERENCE





Column Detail - RC_PRSNL_GROUP_INCLUSION


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.
PRSNL_GROUP_ID DOUBLE N Uniquely identifies the personnel group from which the personnel is being included.
PRSNL_ID DOUBLE N Uniquely identifies the personnel that is being included from the personnel group.
RC_PRSNL_GROUP_INCLUSION_ID DOUBLE N Unique generated number that identifies a single row on the RC_PRSNL_GROUP_INCLUSION table.
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 - RC_PRSNL_GROUP_INCLUSION


Child Column in RC_PRSNL_GROUP_INCLUSION(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


RC_PRSNL_SERVICE_SET_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Personnel Service Set Relationship
Definition: Contains a relationship between personnel and service sets.
Table Type: REFERENCE





Column Detail - RC_PRSNL_SERVICE_SET_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.
FACILITY_ORG_ID DOUBLE N The organization that is being associated to the service set.
PARENT_ENTITY_ID DOUBLE N Related Entity ID (from prsnl or prsnl_group table)
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table that the Parent_Entity_ID is from. (prsnl or prsnl_group)
PPA_BEG_EFFECTIVE_DT_TM DATETIME N The date and time that the row becomes effective.
PPA_END_EFFECTIVE_DT_TM DATETIME N The date and time of when this row is no longer effective.
RC_PRSNL_SERVICE_SET_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RC_PRSNL_SERVICE_SET_RELTN table.
RC_SERVICE_SET_ID DOUBLE N Uniquely identifies the service set associated with this relationship.
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 - RC_PRSNL_SERVICE_SET_RELTN


Child Column in RC_PRSNL_SERVICE_SET_RELTN(FK) Parent Table Name Parent Column Name
Parents: FACILITY_ORG_ID ORGANIZATION ORGANIZATION_ID
RC_SERVICE_SET_ID RC_SERVICE_SET RC_SERVICE_SET_ID


RC_SERVICE_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Service Set
Definition: Contains set information about a set that contains personnel preferential agreements that could be applied to a personnel.
Table Type: REFERENCE





Column Detail - RC_SERVICE_SET


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 N 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.
RC_SERVICE_SET_ID DOUBLE N Unique generated number that identifies a single row on the RC_SERVICE_SET table.
SERVICE_SET_DISPLAY VARCHAR(100) N Contains the Mnemonic for this service set. This column should be unique within a given domain for active rows.
SERVICE_SET_DISPLAY_KEY VARCHAR(100) N The key version of the service set display (all uppercase and all spaces removed).
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 - RC_SERVICE_SET


Child Column in RC_SERVICE_SET(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in RC_SERVICE_SET (PK) Child Table Name Child Column Name
Children: RC_SERVICE_SET_ID RC_ORG_SERVICE_SET_RELTN RC_SERVICE_SET_ID
RC_PRSNL_SERVICE_SET_RELTN RC_SERVICE_SET_ID
RC_SERVICE_SET_ITEM RC_SERVICE_SET_ID


RC_SERVICE_SET_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Service Set Item
Definition: Items with in a service set
Table Type: REFERENCE





Column Detail - RC_SERVICE_SET_ITEM


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.
ORDER_ACTIVITY_SUB_TYPE_CD DOUBLE N The order sub activity type code that is associated with this service set time.
ORDER_ACTIVITY_TYPE_CD DOUBLE N The order activity type code that is associated with this service set item.
ORDER_CATALOG_TYPE_CD DOUBLE N The order catalog type code that is associated with this service set item.
RC_SERVICE_SET_ID DOUBLE N The identifier of the service set to which this item is associated.
RC_SERVICE_SET_ITEM_ID DOUBLE N Unique generated number that identifies a single row on the RC_SERVICE_SET_ITEM table.
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 - RC_SERVICE_SET_ITEM


Child Column in RC_SERVICE_SET_ITEM(FK) Parent Table Name Parent Column Name
Parents: RC_SERVICE_SET_ID RC_SERVICE_SET RC_SERVICE_SET_ID