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 |