Table Detail Report

SCH_EVENT_RECUR_ROLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recur Role
Definition: Table to store the information about how a future instance of a recurring appointment should be booked in role level.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_ROLE


Column Name Type Null? Definition
BEG_DT_TM DATETIME N The begin Date and time value of the resource or the person for the resource list role or order role.
CLEANUP_DURATION DOUBLE Y The duration for patient recovery or resource (such as room) clean up.
ENCNTR_ID DOUBLE N The ID of the row of the encounter associated with this table.
END_DT_TM DATETIME N The end date and time value of the resource or the person for the resource list role or order role.
LIST_ROLE_ID DOUBLE N The identifier for the associated list role.
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.
RESOURCE_CD DOUBLE N The identifier for the associated resource. A resource is an item of limited availability.
ROLE_SEQ DOUBLE N The order of the role on the resource list.
SCH_EVENT_RECUR_LIST_ID DOUBLE N The unique identifier of associated row from the sch_event_recur_list table.
SCH_EVENT_RECUR_ROLE_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_ROLE table.
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.
SLOT_TYPE_ID DOUBLE N The identifier for the slot type that is associated to the appointment.
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_EVENT_RECUR_ROLE


Child Column in SCH_EVENT_RECUR_ROLE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SCH_EVENT_RECUR_LIST_ID SCH_EVENT_RECUR_LIST SCH_EVENT_RECUR_LIST_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID
RESOURCE_CD SCH_RESOURCE RESOURCE_CD
SERVICE_RESOURCE_CD SCH_RESOURCE RESOURCE_CD
SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID


SCH_EVENT_ROLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Role
Definition: Store the resource list modification for an event.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_ROLE


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.
EVENT_MOD_ID DOUBLE N The unique identifier for the event's resource list modification.
LIST_ROLE_ID DOUBLE N The identifier for the list role.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SELECTED_IND DOUBLE N Determines if the object is (by default) selected or not.
SLOT_TYPE_ID DOUBLE N The identifier for the slot 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_EVENT_ROLE


Child Column in SCH_EVENT_ROLE(FK) Parent Table Name Parent Column Name
Parents: RESOURCE_CD CODE_VALUE CODE_VALUE
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID
SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID


SCH_FREQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Frequencies
Definition: The table hold the scheduling frequencies for recurring scheduling entities such as default schedules or recurring events.
Table Type: ACTIVITY





Column Detail - SCH_FREQ


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_RANGE DOUBLE Y Indicate how far the recurring application should apply. The unit of measure is Days.
BEG_DT_TM DATETIME N The start date time of recurring entity.
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.
COUNTER DOUBLE N An internal counter.
DAILY_APPT_INTERVAL_MINS DOUBLE N Minimal minutes between two appointments in a recurrent instances in the same day.
DAILY_FREQUENCY_NBR DOUBLE N Number of appointments per day for a recurring event.
DAYS_OF_WEEK VARCHAR(10) N A character string used to store the valid days of the week.
DAY_STRING VARCHAR(31) N A character string used to store the valid days of the month.
END_DT_TM DATETIME N The end date time of recurring entity.
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.
END_TYPE_CD DOUBLE N The coded identifier for the scheduling frequency end type.
END_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling frequency end type.
FREQUENCY_ID DOUBLE N The unique identifier for a scheduling frequency.
FREQ_PATTERN_CD DOUBLE N A coded identifier for the frequency pattern.
FREQ_PATTERN_MEANING VARCHAR(12) Y A 12-character description corresponding to the frequency pattern.
FREQ_STATE_CD DOUBLE N A coded identifier for the frequency state.
FREQ_STATE_MEANING VARCHAR(12) Y A 12-character description corresponding to the frequency state. Examples are ACTIVE, COMPLETE, DISCONTINUE.
FREQ_TYPE_CD DOUBLE N A coded identifier for the frequency type.
FREQ_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding to the frequency type. Examples are SERVICE, DEFAULT SCHEDULE, RECURRING APPOINTMENT.
INTERVAL DOUBLE N Defines the time interval in minutes.
MAX_OCCURANCE DOUBLE N Defined the maximum number of occurrances for a frequency.
MONTH_STRING VARCHAR(12) N A string used to denote the valid months in a frequency.
NEXT_DT_TM DATETIME N The last date and time to be considered during the explosion of the frequency.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key.
OCCURANCE DOUBLE N The sequence of the object in an ordered list. (1 of 2, etc.)
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(30) N The parent table associated to the scheduling frequency. It corresponds to the PARENT_ID.
PATTERN_OPTION DOUBLE N This field is used to store the frequency option chosen by the user.
REF_FREQ_ID DOUBLE N The unique identifier for the scheduling reference frequency.
UNITS DOUBLE N The number of unit such as 4 hours, 180 minutes, etc.
UNITS_CD DOUBLE N The coded identifier of the units of measure.
UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the units of measure.
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.
WEEK_STRING VARCHAR(6) N A character string used to denote the valid weeks within the month.



Relationship Detail - SCH_FREQ


Child Column in SCH_FREQ(FK) Parent Table Name Parent Column Name
Parents: END_TYPE_CD CODE_VALUE CODE_VALUE
FREQ_PATTERN_CD CODE_VALUE CODE_VALUE
FREQ_STATE_CD CODE_VALUE CODE_VALUE
FREQ_TYPE_CD CODE_VALUE CODE_VALUE
UNITS_CD CODE_VALUE CODE_VALUE
REF_FREQ_ID SCH_REF_FREQ REF_FREQ_ID




Parent Column in SCH_FREQ (PK) Child Table Name Child Column Name
Children: FREQUENCY_ID SCH_DEF_APPLY FREQUENCY_ID
SCH_FREQ_DATE FREQUENCY_ID


SCH_FREQ_DATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Frequency Date
Definition: The table hold the information about the instance of recurring entity in sch_freq table.
Table Type: ACTIVITY





Column Detail - SCH_FREQ_DATE


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.
DATE_DT_TM DATETIME N The date and time generated for this instance of a frequency.
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.
FREQUENCY_ID DOUBLE N The unique identifier for a scheduling frequency.
INSTANCE_STATUS_CD DOUBLE N Indicates the instance status. Some examples are Active, Scheduled or Requested.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key.
OCCURANCE DOUBLE N The sequence of the object in an ordered list. (1 of 2, etc.)
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SCH_EVENT_RECUR_LIST_ID DOUBLE N The ID of the row from the SCH_EVENT_RECUR_LIST table that is associated to the frequency date.
SEQ_NBR DOUBLE N Determines the order of the object within a collection.
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_FREQ_DATE


Child Column in SCH_FREQ_DATE(FK) Parent Table Name Parent Column Name
Parents: SCH_ACTION_ID SCH_ACTION SCH_ACTION_ID
SCH_EVENT_RECUR_LIST_ID SCH_EVENT_RECUR_LIST SCH_EVENT_RECUR_LIST_ID
FREQUENCY_ID SCH_FREQ FREQUENCY_ID


SCH_GENERIC_LOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Generic Location desc
Definition: Scheduling Generic Location
Table Type: ACTIVITY





Column Detail - SCH_GENERIC_LOC


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.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
LOCATION_FREETEXT VARCHAR(255) N The free text description corresponding to the location.
LOCATION_TYPE_CD DOUBLE N Defines the locations meaning to scheduling.
LOCATION_TYPE_MEANING VARCHAR(12) Y A 12-char description of the location association type.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key.
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(30) N The parent table corresponding to the PARENT_ID
SEQ_NBR DOUBLE N Determines the order of the object within a collection.
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_GENERIC_LOC


Child Column in SCH_GENERIC_LOC(FK) Parent Table Name Parent Column Name
Parents: LOCATION_TYPE_CD CODE_VALUE CODE_VALUE
LOCATION_CD LOCATION LOCATION_CD