Table Detail Report

PRSNL_ROLE_TYPE_RESP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel role type responsibillity
Definition: Contains the role type responsibillity of the personnel.
Table Type: REFERENCE





Column Detail - PRSNL_ROLE_TYPE_RESP


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.
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CREATE_PRSNL_ID DOUBLE N The id of the person who created the request.
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.
PRSNL_RESP_ID DOUBLE N Personnel responsible identifier
PRSNL_ROLE_TYPE_ID DOUBLE N Personnel role type identifier
ROLE_TYPE_RESP_ID DOUBLE N role type responsible identifier
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_ROLE_TYPE_RESP


Child Column in PRSNL_ROLE_TYPE_RESP(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ROLE_TYPE_ID PRSNL_ROLE_TYPE PRSNL_ROLE_TYPE_ID
ROLE_TYPE_RESP_ID ROLE_TYPE_RESP ROLE_TYPE_RESP_ID


PRSNL_SPECIALTY_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Specialty Location Relationship
Definition: Defines a relationship between personnel specialties and a location
Table Type: REFERENCE





Column Detail - PRSNL_SPECIALTY_LOC_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.
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.
LOCATION_CD DOUBLE N Contains the value of the related location for this relationship.
ORIG_PRSNL_SPECIALTY_LOC_R_ID DOUBLE N Used to track versions of the personnel location relationship. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRSNL_SPECIALTY_LOC_RELTN_ID DOUBLE N Uniquely identifies a relationship between a personnel and a provider specialty location. Unique generated number that identifies a single row on the prsnl_specialty_loc_reltn table.
PRSNL_SPECIALTY_RELTN_ID DOUBLE N Uniquely identifies thepersonnel to specialty 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 - PRSNL_SPECIALTY_LOC_RELTN


Child Column in PRSNL_SPECIALTY_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORIG_PRSNL_SPECIALTY_LOC_R_ID PRSNL_SPECIALTY_LOC_RELTN PRSNL_SPECIALTY_LOC_RELTN_ID
PRSNL_SPECIALTY_RELTN_ID PRSNL_SPECIALTY_RELTN PRSNL_SPECIALTY_RELTN_ID




Parent Column in PRSNL_SPECIALTY_LOC_RELTN (PK) Child Table Name Child Column Name
Children: PRSNL_SPECIALTY_LOC_RELTN_ID PRSNL_SPECIALTY_LOC_RELTN ORIG_PRSNL_SPECIALTY_LOC_R_ID


PRSNL_SPECIALTY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Specialty Relationship
Definition: Defines a relationship between a personnel and a provider specialty.
Table Type: REFERENCE





Column Detail - PRSNL_SPECIALTY_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.
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.
ORIG_PRSNL_SPECIALTY_RELTN_ID DOUBLE N Used to track versions of the personnel specialty relationship. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRIMARY_IND DOUBLE N A value indicating whether this relationship is a primary relationship.
PRSNL_ID DOUBLE N The unique identifier of the personnel in this relationship.
PRSNL_SPECIALTY_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the prsnl_specialty_reltn table.
SPECIALTY_CD DOUBLE N The code value for the provider specialty.
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_SPECIALTY_RELTN


Child Column in PRSNL_SPECIALTY_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
ORIG_PRSNL_SPECIALTY_RELTN_ID PRSNL_SPECIALTY_RELTN PRSNL_SPECIALTY_RELTN_ID




Parent Column in PRSNL_SPECIALTY_RELTN (PK) Child Table Name Child Column Name
Children: PRSNL_SPECIALTY_RELTN_ID PRSNL_SPECIALTY_LOC_RELTN PRSNL_SPECIALTY_RELTN_ID
PRSNL_SPECIALTY_RELTN ORIG_PRSNL_SPECIALTY_RELTN_ID


PRSNL_TEXT_RELTN



Column Section Top of Page


Table-level Detail

Description: Personnel text relationship.
Definition: Personnel text relationship.
Table Type: REFERENCE





Column Detail - PRSNL_TEXT_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 Y The date and time that the active_status_cd was set.
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.
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_TEXT_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the prsnl_text_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.


RC_ORG_SERVICE_SET_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Organization Service Set Relationship
Definition: Identifies a Relationship between an organization and a service set.
Table Type: REFERENCE





Column Detail - RC_ORG_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.
FACILITY_ORG_ID DOUBLE N The organization that is being associated to the service set.
RC_ORG_SERVICE_SET_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RC_ORG_SERVICE_SET_RELTN table.
RC_SERVICE_SET_ID DOUBLE N The service set that is associated to 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_ORG_SERVICE_SET_RELTN


Child Column in RC_ORG_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