Table Detail Report

SCH_CLINIC_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Clinic Personnel Relation
Definition: Relationship between Clinics and personnel.
Table Type: REFERENCE





Column Detail - SCH_CLINIC_PRSNL_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.
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_SCH_CLINIC_PRSNL_RELTN_ID DOUBLE N The PK value of the Original (Effective) Row for this versioned set
PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that performed the action
RESPONSIBLE_CLINICIAN_IND DOUBLE N Set to true, if the personnel is a reponsible clinician otherwise, set to false.
SCH_CLINIC_ID DOUBLE N FK Value from the
SCH_CLINIC_PRSNL_RELTN_ID DOUBLE N PRIMARY KEY
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 - SCH_CLINIC_PRSNL_RELTN


Child Column in SCH_CLINIC_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SCH_CLINIC_ID SCH_CLINIC SCH_CLINIC_ID


SCH_CLINIC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCHEDULING CLINIC RELATIONSHIPS
Definition: Relationship between Clinics and other scheduling data such as medical services, templates, resources.
Table Type: REFERENCE





Column Detail - SCH_CLINIC_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_SCH_CLINIC_RELTN_ID DOUBLE N Contains the PK value of the Original (Effective) Row for this versioned group.
PARENT_ENTITY_ID DOUBLE N Primary key from the table contained in the parent_entity_name field.
PARENT_ENTITY_NAME VARCHAR(30) N The parent table for the ID contained in the parent_entity_id field
SCH_CLINIC_ID DOUBLE N FK VALUE FROM THE SCH_CLINIC TABLE
SCH_CLINIC_RELTN_ID DOUBLE N PRIMARY KEY
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 - SCH_CLINIC_RELTN


Child Column in SCH_CLINIC_RELTN(FK) Parent Table Name Parent Column Name
Parents: SCH_CLINIC_ID SCH_CLINIC SCH_CLINIC_ID


SCH_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Comments
Definition: Scheduling Comments table
Table Type: ACTIVITY





Column Detail - SCH_COMMENT


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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
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.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) N Parent Table
SUB_TEXT_CD DOUBLE N The identifier for the scheduling text sub-type.
SUB_TEXT_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N Text Identifier
TEXT_TYPE_CD DOUBLE N The identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) N The 12-character string corresponding to the scheduling text type.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_COMMENT


Child Column in SCH_COMMENT(FK) Parent Table Name Parent Column Name
Parents: SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT LONG_TEXT_ID


SCH_DATE_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Date Comments
Definition: Comments about the scheduling date.
Table Type: ACTIVITY





Column Detail - SCH_DATE_COMMENT


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Scheduling Action Data and Time
ACTION_PRSNL_ID DOUBLE N Action Personnel Identifier
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_DT_TM DATETIME N Begin Date and Time value
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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
DATE_COMMENT_ID DOUBLE N Scheduling Date Comment Identifier
END_DT_TM DATETIME N End Date and Time value
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.
MNEMONIC VARCHAR(100) Y A 100-character string used for identification and selection.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ORIG_TEXT_ID DOUBLE N The unique identifier for the original text associated with the object.
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) Y Parent Table
SCH_APPLY_ID DOUBLE N Scheduling Application Identifier
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of the appointment.
STATE_MEANING VARCHAR(12) N The 12-character string corresponding to the current state of the appointment.
SUB_TEXT_CD DOUBLE N The identifier for the scheduling text sub-type.
SUB_TEXT_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N Text Identifier
TEXT_TYPE_CD DOUBLE N The identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) N The 12-character string corresponding to the scheduling text type.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_DATE_COMMENT


Child Column in SCH_DATE_COMMENT(FK) Parent Table Name Parent Column Name
Parents: SCH_STATE_CD CODE_VALUE CODE_VALUE
SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
ACTION_PRSNL_ID PRSNL PERSON_ID
SCH_APPLY_ID SCH_APPLY SCH_APPLY_ID


SCH_DATE_COMMENT_HISTORY



Column Section Top of Page


Table-level Detail

Description: Scheduling Date Comment History
Definition: Table used to capture the history of the date comment table.
Table Type: ACTIVITY





Column Detail - SCH_DATE_COMMENT_HISTORY


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N scheduling action data and time
ACTION_PRSNL_ID DOUBLE N action personnel identifier
ACTION_TYPE_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_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_DT_TM DATETIME N begin date and time value
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.
CANDIDATE_ID DOUBLE N a sequence-generated number to uniquely identify the specific row in the database.
DATE_COMMENT_ID DOUBLE N scheduling date comment identifier
END_DT_TM DATETIME N end date and time value
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.
MNEMONIC VARCHAR(100) Y a 100-character string used for identification and selection.
NULL_DT_TM DATETIME N contains 31-dec-2100 00:00:00.00
ORIG_TEXT_ID DOUBLE N the unique identifier for the original text associated with the object.
PARENT_ID DOUBLE N parent identifier
PARENT_TABLE VARCHAR(32) Y parent table
REASON_CD DOUBLE N REASON_CD column
SCH_APPLY_ID DOUBLE N scheduling application identifier
SCH_DATE_COMMENT_HISTORY_ID DOUBLE N Unique generated number that identifies a single row on the SCH_DATE_COMMENT_HISTORY table.
SCH_STATE_CD DOUBLE N the coded identifier corresponding to the current state of the appointment.
STATE_MEANING VARCHAR(12) N the 12-character string corresponding to the current state of the appointment.
SUB_TEXT_CD DOUBLE N the identifier for the scheduling text sub-type.
SUB_TEXT_MEANING VARCHAR(12) Y the 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N text identifier
TEXT_TYPE_CD DOUBLE N the identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) N the 12-character string corresponding to the scheduling text type.
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.
VERSION_DT_TM DATETIME N the version date and time marks the date the record became historical.