Table Detail Report

SCH_APPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Schedule Appointment
Definition: Contains the appointments for a resource.
Table Type: ACTIVITY





Column Detail - SCH_APPT


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.
ACTIVITY_CD DOUBLE N The unique identifier for the scheduling activity type.
ACTIVITY_MEANING VARCHAR(12) Y A 12-char description of the scheduling activity type.
ALERT_BIT_MASK DOUBLE Y Alert Bit Mask. Do not believe this column is used. It is obsolete.
ALLOCATED_PRSNL_ID DOUBLE N Identifies the clinician allocated to a specific slot.
APPLY_DEF_ID DOUBLE N This unique identifier for a slot is used to store the slot definitions for the slot. The field is used to join to the SCH_APPT_DEF table for the slot definition.
APPLY_LIST_ID DOUBLE N The unique identifier for the application of a default schedule to a resource
APPLY_SLOT_ID DOUBLE N The unique identifier for the applied slot.
APPT_LOCATION_CD DOUBLE N A coded identifier corresponding to the scheduled appointment location.
APPT_SCHEME_ID DOUBLE N The scheduling display scheme for the appointment type and state.
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.
BIT_MASK DOUBLE N A Bit String used to store internal processing flags.
BOOKING_ID DOUBLE N The unique identifier for a resource availability lock.
BORDER_COLOR DOUBLE Y The numeric equilivant of the border color.
BORDER_SIZE DOUBLE Y The numeric equilivant of the border size.
BORDER_STYLE DOUBLE Y The numeric equilivant of the border style.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
CLEANUP_DURATION DOUBLE Y The duration for patient recovery or resource (such as room) clean up.
CONTIGUOUS_IND DOUBLE N Determines if a slot type is defined to be contiguous or discrete.
DEFINING_IND DOUBLE N Determines if the role is the defining role.
DEF_SLOT_ID DOUBLE N The identifier for the default schedule slot.
DESCRIPTION VARCHAR(255) Y A long description used for documentation.
DURATION DOUBLE N The duration in minutes.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
EXCLUDE_IND DOUBLE Y NOT CURRENTLY USED.
GROUP_SLOT_LINK_VALUE DOUBLE N An identifier to link all the slots or/and appointments in the same group session together.
GRPSESSION_ID DOUBLE N This will be used to find the appts associated to a given group session. This will be when viewing the appointments on the book.
HOLIDAY_WEEKEND_FLAG DOUBLE Y This field is used to denote if holidays and/or weekend should be excluded in the computation of scheduling release times.
LIST_ROLE_ID DOUBLE N The identifier for the list role.
NON_SCHEDULE_IND DOUBLE Y To indicate that the slot type is not schedulable. 1 = Not Schedulable.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ORIG_BEG_DT_TM DATETIME Y The original beg date and time for the default schedule slot. This is used to restore a modified slot to its original state.
ORIG_END_DT_TM DATETIME Y The original end date and time for the default schedule slot. This is used to restore a modified slot to its original state.
PEN_SHAPE DOUBLE Y A "0" in this column will indicate a "square" border pen. A "1" in this column will represent a "round" border pen.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number. If the role is a patient role, the person_id is patient's person_id. If the role is not a patient role, it will be a scheduling resource. There are different type of resources. If the resource is a personnel resource, the person_id will be provider's person_id. If the resource is not a personnel resource, then the person_id will be 0.
PRIMARY_ROLE_IND DOUBLE N Designated the resource's appointment role as the primary role for the appointment.
REFERRING_ORG_ID DOUBLE N The ID of the referring organization.
RESERVE_RELEASE_DT_TM DATETIME N The date that the slot will be released for general booking.
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
ROLE_DESCRIPTION VARCHAR(200) Y The description of the role on the resource list.
ROLE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling role.
ROLE_SEQ DOUBLE N The order of the role on the resource list.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule.
SCHEDULE_SEQ DOUBLE N Used to document the rescheduling of appointments.
SCH_APPT_ID DOUBLE N The unique identifier for a resource's/patient's appointment.
SCH_DATE_APPLY_ID DOUBLE N Identifies the date and resource template associated to the appointment.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_ROLE_CD DOUBLE N The coded identifier for the scheduling role.
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of the appointment.
SCH_TYPE_ID DOUBLE N The unique identifier of the slot type at the time of scheduling.
SERVICE_RESOURCE_CD DOUBLE N The generic term used to denote a physical place in the Health Care Organization.
SETUP_DURATION DOUBLE Y The duration for patient arrival or resource (such as room) set up.
SHAPE DOUBLE Y The numeric equilivant of the shape.
SLOT_MNEMONIC VARCHAR(100) Y A 100-character string used for identification and selection.
SLOT_SCHEME_ID DOUBLE N The coded identifier of the disp scheme associated to the appointment..
SLOT_STATE_CD DOUBLE N The code_value for the current slot state.
SLOT_STATE_MEANING VARCHAR(12) Y A 12-char description of the schedule slot state.
SLOT_TYPE_ID DOUBLE N The identifier for the slot type that is associated to the appointment.
SLOT_VIS_BEG_DT_TM DATETIME Y The visible beginning time for the original slot.
SLOT_VIS_END_DT_TM DATETIME Y The visible end time for the original slot.
STATE_MEANING VARCHAR(12) Y The 12-character string corresponding to the current state of the appointment.
TEMPLATE_LOCATION_CD DOUBLE Y Indicates which location can be booked into this slot, 0 means all locations.
TIME_TYPE_FLAG DOUBLE N Determines if the current entry is holding time. 0 - Unheld Time, 1 - Held Time.
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.
VIS_BEG_DT_TM DATETIME N NOT CURRENTLY USED.
VIS_END_DT_TM DATETIME N NOT CURRENTLY USED.
WARN_BIT_MASK DOUBLE N This field is a bit mask used to store indicators about the warnings generated during the life-cycle of the appointment.



Relationship Detail - SCH_APPT


Child Column in SCH_APPT(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_CD CODE_VALUE CODE_VALUE
SCH_STATE_CD CODE_VALUE CODE_VALUE
SLOT_STATE_CD CODE_VALUE CODE_VALUE
ENCNTR_ID ENCOUNTER ENCNTR_ID
APPT_LOCATION_CD LOCATION LOCATION_CD
TEMPLATE_LOCATION_CD LOCATION LOCATION_CD
REFERRING_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
ALLOCATED_PRSNL_ID PRSNL PERSON_ID
APPLY_LIST_ID SCH_APPLY_LIST APPLY_LIST_ID
BOOKING_ID SCH_BOOKING BOOKING_ID
APPT_SCHEME_ID SCH_DISP_SCHEME DISP_SCHEME_ID
SLOT_SCHEME_ID SCH_DISP_SCHEME DISP_SCHEME_ID
GRPSESSION_ID SCH_EVENT SCH_EVENT_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID
SCH_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID
SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in SCH_APPT (PK) Child Table Name Child Column Name
Children: SCH_APPT_ID BH_GROUP_DOC SCH_APPT_ID
SCH_DISPLACED_APPT SCH_APPT_ID
SCH_ENTRY SCH_APPT_ID
SCH_EVENT_DISP SCH_APPT_ID
WL_ACTIVITY SCH_APPT_ID


SCH_APPT_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Definitions
Definition: This table contains definitions for scheduling appointments.
Table Type: ACTIVITY





Column Detail - SCH_APPT_DEF


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.
APPLY_DEF_ID DOUBLE N This unique identifier for a slot is used to store the slot definitions for the slot. The field is used to join to the SCH_APPT_DEF table for the slot definition.
APPT_DEF_ID DOUBLE N The unique identifier for the slot definition.
BEG_DT_TM DATETIME N Begin Date and Time value of the appointment.
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.
DEF_STATE_CD DOUBLE N The coded identifier for the current state of the default schedule application.
DEF_STATE_MEANING VARCHAR(12) Y A 12-character description corresponding to the default schedule state.
DESCRIPTION VARCHAR(200) N A long description used for documentation.
DURATION DOUBLE N The duration in minutes.
END_DT_TM DATETIME N End Date and Time value of the appointment.
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.
INTERVAL DOUBLE Y Time interval that the apptointments within the slot should start at.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
SCH_FLEX_ID DOUBLE N The ID of the schedule flex string associated to this appointment definition.
SLOT_MNEMONIC VARCHAR(100) N A 100-character string used for identification and selection.
SLOT_SCHEME_ID DOUBLE N The coded identifier of the disp scheme.
SLOT_TYPE_ID DOUBLE N The identifier for the slot 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.
VIS_BEG_DT_TM DATETIME N NOT CURRENTLY USED.
VIS_BEG_UNITS DOUBLE N The beg offset interval of when the slot definition becomes visable.
VIS_BEG_UNITS_CD DOUBLE N A coded identifier for the visable beg units of measure.
VIS_BEG_UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the visable beg units of measure.
VIS_END_DT_TM DATETIME N NOT CURRENTLY USED.
VIS_END_UNITS DOUBLE N The beg offset interval of when the slot definition becomes visable.
VIS_END_UNITS_CD DOUBLE N A coded identifier for the visable end units of measure.
VIS_END_UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the visable end units of measure.



Relationship Detail - SCH_APPT_DEF


Child Column in SCH_APPT_DEF(FK) Parent Table Name Parent Column Name
Parents: DEF_STATE_CD CODE_VALUE CODE_VALUE
SLOT_SCHEME_ID SCH_DISP_SCHEME DISP_SCHEME_ID
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID
SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID




Parent Column in SCH_APPT_DEF (PK) Child Table Name Child Column Name
Children: APPT_DEF_ID SCH_SLOT_ALIAS APPT_DEF_ID


SCH_APPT_OPTION_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Option Configuration
Definition: Stored appointment option configuration for appointment actions.
Table Type: REFERENCE





Column Detail - SCH_APPT_OPTION_CONFIG


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.
APPOINTMENT_OPTION VARCHAR(100) N The value to return that relates to the appointment level configuration for a scheduling action.
APPT_TYPE_CD DOUBLE N The appointment type code (from scheduling appointment type code set: 14230) the OPTION_VALUE applies to
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 The unit (from location code set: 220) related to the option
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.
OPTION_MEANING VARCHAR(12) N The CDF meaning of the input option action
ORDER_OPTION VARCHAR(100) N The value to return that relates to the order level configuration for a scheduling action.
SCH_APPT_OPTION_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the SCH_APPT_OPTION_CONFIG 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 - SCH_APPT_OPTION_CONFIG


Child Column in SCH_APPT_OPTION_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


SCH_BOOKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Booking
Definition: This table is used to record time availability used or released by scheduling appointments.
Table Type: ACTIVITY





Column Detail - SCH_BOOKING


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.
APPLY_SLOT_ID DOUBLE N The unique identifier for the applied slot.
APPT_TYPE_CD DOUBLE N The identifier for an appointment type.
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.
BOOKING_ID DOUBLE N The unique identifier for a resource availability lock.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
FORCE_IND DOUBLE Y Determines if the user force the locking of the resource's availability.
GRANTED_DT_TM DATETIME Y Date and Time the availability lock as granted.
GRANTED_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) to whom the availability lock was granted. There will be situations where the person will be a patient and not be a PRSNL. In this case the source of the _id will be PERSON.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ORIG_BEG_DT_TM DATETIME Y Begin Date and Time prior to extending the slot.
ORIG_END_DT_TM DATETIME Y End Date and Time prior to extending the slot.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number. If the role is a patient role, the person_id is patient's person_id. If the role is not a patient role, it will be a scheduling resource. There are different type of resources. If the resource is a personnel resource, the person_id will be provider's person_id. If the resource is not a personnel resource, then the person_id will be 0.
RELEASE_DT_TM DATETIME Y The date and time the row should automatically release.
RELEASE_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that released the availability lock. There will be situations where the person will be a patient and not be a PRSNL. In this case the source of the _id will be PERSON.
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
ROLE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling role.
SCH_ROLE_CD DOUBLE N The coded identifier for the scheduling role.
SEQ_NBR DOUBLE N The sequence number of the resource list role for the booking appointment.
STATUS_FLAG DOUBLE Y A coded field used to denote the current status.
STATUS_MEANING VARCHAR(12) Y A 12-character description corresponding to the STATUS_FLAG.
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.
VERIFY_DT_TM DATETIME Y The date and time the record was verified.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.
WRITTEN_DT_TM DATETIME Y The date and time the corresponding record was written.



Relationship Detail - SCH_BOOKING


Child Column in SCH_BOOKING(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
RESOURCE_CD CODE_VALUE CODE_VALUE
ENCNTR_ID ENCOUNTER ENCNTR_ID
LOCATION_CD LOCATION LOCATION_CD
GRANTED_PRSNL_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
RELEASE_PRSNL_ID PERSON PERSON_ID




Parent Column in SCH_BOOKING (PK) Child Table Name Child Column Name
Children: BOOKING_ID SCH_APPT BOOKING_ID
SCH_BOOKING_ORD BOOKING_ID
SCH_PEND_APPT BOOKING_ID


SCH_CLINIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCHEDULING CLINIC
Definition: SCHEDULING CLINIC DATA
Table Type: REFERENCE





Column Detail - SCH_CLINIC


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.
CLINIC_DESCRIPTION VARCHAR(200) N FREE TEXT FIELD DESCRIBING THE CLINIC
CLINIC_NAME VARCHAR(200) N THE NAME OF THE CLINIC
CLINIC_NAME_KEY VARCHAR(200) N Clinic's name all capitals with punctuation removed. this field is used for indexing and searching for a person by name.
CLINIC_NAME_KEY_A_NLS VARCHAR(800) N for national language support only
DAYS_OF_WEEK VARCHAR(7) N A character string used to store the valid days of the week.
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 field identifies the current location of the clinic.
ORIG_SCH_CLINIC_ID DOUBLE N ORIGINAL SCH_CLINIC_ID for this set of versioned entries. Required for Type-2 Versioning
SCH_CLINIC_ID DOUBLE N PRIMARY KEY
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 - SCH_CLINIC


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




Parent Column in SCH_CLINIC (PK) Child Table Name Child Column Name
Children: SCH_CLINIC_ID SCH_CLINIC ORIG_SCH_CLINIC_ID
SCH_CLINIC_PRSNL_RELTN SCH_CLINIC_ID
SCH_CLINIC_RELTN SCH_CLINIC_ID
SCH_DEF_APPLY SCH_CLINIC_ID
SCH_LOCATION SCH_CLINIC_ID