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 |