Table Detail Report

SCH_AT_ENCNTR_TYPE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Type Encounter Type Relation
Definition: Links an appointment type to a list of related encounter types.
Table Type: REFERENCE





Column Detail - SCH_AT_ENCNTR_TYPE_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.
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.
APPT_TYPE_CD DOUBLE N Parent appointment type code.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
ENCNTR_TYPE_CD DOUBLE N The encounter type related to the appointment type.
SCH_ACTION_CD DOUBLE N The scheduling where the relationship is effective. The default is SCHEDULE. Another example would be CHECKIN which would mean that when the appointment is checked in, its encounter type should be one of the related encounter types built for the action of Check In.
SCH_AT_ENCNTR_TYPE_R_ID DOUBLE N The unique primary key of the SCH_AT_ENCNTR_TYPE_R table.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
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_AT_ENCNTR_TYPE_R


Child Column in SCH_AT_ENCNTR_TYPE_R(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD SCH_APPT_TYPE APPT_TYPE_CD


SCH_AT_INSUR_PROFILE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Type Insurance Profile Relationship
Definition: Contains the insurance profile linked to appointment type.
Table Type: REFERENCE





Column Detail - SCH_AT_INSUR_PROFILE_R


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 Y 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 Y The person who caused the active_status_cd to be set or change.
APPT_TYPE_CD DOUBLE N Indicate the Appointment Type Code.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
PROFILE_TYPE_CD DOUBLE N Indicates the type of health insurance profile for the person plan profile row(i.e., professional, institutional, workmen's comp).
SCH_AT_INSUR_PROFILE_R_ID DOUBLE N Unique generated number that identifies a single row on the SCH_AT_INSUR_PROFILE_R table.
SEQ_NBR DOUBLE N Determines the order among the insurance profiles.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - SCH_AT_INSUR_PROFILE_R


Child Column in SCH_AT_INSUR_PROFILE_R(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD SCH_APPT_TYPE APPT_TYPE_CD


SCH_AT_MED_SERVICE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Type Medical Service Relation
Definition: Links an appointment type to a list of related medical services.
Table Type: REFERENCE





Column Detail - SCH_AT_MED_SERVICE_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.
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.
APPT_TYPE_CD DOUBLE N Parent appointment type code.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
MED_SERVICE_CD DOUBLE N The medical service related to the appointment type.
SCH_AT_MED_SERVICE_R_ID DOUBLE N The unique primary key for the SCH_AT_MED_SERVICE_R 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 - SCH_AT_MED_SERVICE_R


Child Column in SCH_AT_MED_SERVICE_R(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD SCH_APPT_TYPE APPT_TYPE_CD


SCH_AT_SPECIALTY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Type Specialty Relation
Definition: Links an appointment type to a list of related Specialties.
Table Type: REFERENCE





Column Detail - SCH_AT_SPECIALTY_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.
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.
APPT_TYPE_CD DOUBLE N Parent appointment type code
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database
SCH_AT_SPECIALTY_R_ID DOUBLE N Unique generated number that identifies a single row on the SCH_AT_SPECIALTY_R table.
SPECIALTY_CD DOUBLE N Specialty related to the appointment 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.



Relationship Detail - SCH_AT_SPECIALTY_R


Child Column in SCH_AT_SPECIALTY_R(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD SCH_APPT_TYPE APPT_TYPE_CD


SCH_AUTO_MSG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Automated Messaging
Definition: Table used to store information regarding automated messaging
Table Type: REFERENCE





Column Detail - SCH_AUTO_MSG


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.
AUTOMATED_MESSAGE_TYPE_CD DOUBLE N The automated message type code value that the automated messaging build is associated with.
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.
DAYS_IN_ADVANCE DOUBLE N The number of days in advance to perform the automated message.
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 The location code value that the automated messaging build is associated with.
ORIG_SCH_AUTO_MSG_ID DOUBLE N ORIGINAL SCH_AUTO_MSG_ID for this set of versioned entries. Required for Type-2 Versioning
SCH_AUTO_MSG_ID DOUBLE N Unique generated number that identifies a single row on the SCH_AUTO_MSG 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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_AUTO_MSG


Child Column in SCH_AUTO_MSG(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
ORIG_SCH_AUTO_MSG_ID SCH_AUTO_MSG SCH_AUTO_MSG_ID




Parent Column in SCH_AUTO_MSG (PK) Child Table Name Child Column Name
Children: SCH_AUTO_MSG_ID SCH_AUTO_MSG ORIG_SCH_AUTO_MSG_ID
SCH_AUTO_MSG_APPT_TYPE_R SCH_AUTO_MSG_ID
SCH_AUTO_MSG_RESOURCE_R SCH_AUTO_MSG_ID