Table Detail Report

SCH_DEF_SLOT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Default Slots
Definition: Defines the slot for a default schedule.
Table Type: REFERENCE





Column Detail - SCH_DEF_SLOT


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.
BEG_OFFSET DOUBLE N Defines the beginning offset for the slot from the begin time of the default schedule.
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.
CONTIGUOUS_IND DOUBLE Y Determines if a slot type is defined to be contiguous or discrete.
DEF_SCHED_ID DOUBLE N The identifier for a default schedule.
DEF_SLOT_ID DOUBLE N The identifier for the default schedule slot.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
DURATION DOUBLE Y The duration in minutes.
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_OFFSET DOUBLE N Defines the ending offset for the slot from the begin time of the default schedule.
GROUP_CAPACITY_QTY DOUBLE N The group capacity for inpatient group appointments.
HOLIDAY_WEEKEND_FLAG DOUBLE N This field is used to denote if holidays and/or weekend should be excluded in the computation of scheduling release times.
INTERVAL DOUBLE Y Time interval that the apptointments within the slot should start at
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
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.
SCH_FLEX_ID DOUBLE N Scheduling Flexing Identifier
SEQ_NBR DOUBLE N Determines the order among the children of a group.
SHAPE DOUBLE Y The numeric equilivant of the shape.
SLOT_BEG_OFFSET DOUBLE N The beg offset (in minutes) of the slot definition within the default schedule.
SLOT_DURATION DOUBLE N Slot Duration
SLOT_END_OFFSET DOUBLE N The end offset (in minutes) of the slot definition within the default schedule.
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.
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_OFFSET DOUBLE N The beg offset (in minutes) of when the slot definition becomes visable.
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_OFFSET DOUBLE N The end offset (in minutes) of when the slot definition becomes visable.
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_DEF_SLOT


Child Column in SCH_DEF_SLOT(FK) Parent Table Name Parent Column Name
Parents: VIS_BEG_UNITS_CD CODE_VALUE CODE_VALUE
VIS_END_UNITS_CD CODE_VALUE CODE_VALUE
DEF_SCHED_ID SCH_DEF_SCHED DEF_SCHED_ID
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


SCH_DEL_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Delete List
Definition: Scheduling Delete List
Table Type: REFERENCE





Column Detail - SCH_DEL_LIST


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.
CHILD_COLUMN VARCHAR(30) N The column name used for qualification on the child table.
CHILD_TABLE VARCHAR(30) N Child Table
DELETE_ACTION_CD DOUBLE N The coded identifier for the expected delete action.
DELETE_ACTION_MEANING VARCHAR(12) N A 12-character description corresponding to the expected delete action.
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.
FOUND_MESSAGE VARCHAR(255) Y The message to display of the record is found.
NOT_FOUND_MESSAGE VARCHAR(255) Y The message to be displayed if the object is not found.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_CD DOUBLE N The coded identifier for the parent object.
PARENT_MEANING VARCHAR(12) N Parent Meaning
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.
WHERE_CLAUSE VARCHAR(255) Y The where clause used for dynamic selects.
WITH_CLAUSE VARCHAR(255) Y The with clause used for dynamic selects.



Relationship Detail - SCH_DEL_LIST


Child Column in SCH_DEL_LIST(FK) Parent Table Name Parent Column Name
Parents: DELETE_ACTION_CD CODE_VALUE CODE_VALUE
PARENT_CD CODE_VALUE CODE_VALUE


SCH_DISPLAY_TOKEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the valid Scheduling Display Tokens
Definition: Scheduling Display Tokens
Table Type: REFERENCE





Column Detail - SCH_DISPLAY_TOKEN


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.
DATA_TYPE_CD DOUBLE N A unique identifier for the Scheduling Data Type Code.
DATA_TYPE_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Data Type.
DATE_FORMAT_CD DOUBLE N A unique identifier for the Scheduling Data Format Code.
DATE_FORMAT_MEANING VARCHAR(12) Y A 12-char description corresponding to the Schedulng Date Format Code.
DATE_ORDER_CD DOUBLE N A Coded Identifier for the Scheduling Date Order
DATE_ORDER_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Date Order Code.
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
SEQ_NBR DOUBLE N Determines the order among the children of a group.
STRING_LENGTH DOUBLE N The number of character that is allowed in the string. If populated, this field is used to extract a subset of character from a larger string.
STRING_START DOUBLE N The start character in a string. If populated, this field is used to extract a subset of character from a larger string.
TIME_FORMAT_CD DOUBLE N A Coded identifier for the Scheduling Time Code
TIME_FORMAT_MEANING VARCHAR(12) Y A 12-char description cooresponding to the Scheduling Time Formet Code
TRIM_FLAG DOUBLE N Determines if the trailing spaces should be truncated from the string.
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.
WARN_TOKEN_CD DOUBLE N A unique identifier for the Scheduling Warning Token Code.
WARN_TOKEN_MEANING VARCHAR(12) Y A 12-char description corresponding Scheduling Warning TokenCode.
WARN_TYPE_CD DOUBLE N The identifier for the scheduling warning type.
WARN_TYPE_MEANING VARCHAR(12) Y The 12-character description corresponding to the schedulingwarning type code.



Relationship Detail - SCH_DISPLAY_TOKEN


Child Column in SCH_DISPLAY_TOKEN(FK) Parent Table Name Parent Column Name
Parents: DATA_TYPE_CD CODE_VALUE CODE_VALUE
DATE_FORMAT_CD CODE_VALUE CODE_VALUE
DATE_ORDER_CD CODE_VALUE CODE_VALUE
TIME_FORMAT_CD CODE_VALUE CODE_VALUE
WARN_TOKEN_CD CODE_VALUE CODE_VALUE
WARN_TYPE_CD CODE_VALUE CODE_VALUE


SCH_DISP_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Display Field
Definition: Flexible display fields
Table Type: REFERENCE





Column Detail - SCH_DISP_FIELD


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.
DEFINITION VARCHAR(255) Y The 12-character string corresponding to the field meaning.
DESCRIPTION VARCHAR(255) Y A long description used for documentation.
DISP_FIELD_ID DOUBLE N The unique identifier for the scheduling display field.
DISP_FIELD_MEANING VARCHAR(12) N The 12-character string corresponding to the field meaning.
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
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_DISP_FIELD




Parent Column in SCH_DISP_FIELD (PK) Child Table Name Child Column Name
Children: DISP_FIELD_ID SCH_EVENT_DISP DISP_FIELD_ID


SCH_DISP_SCHEME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Display Scheme
Definition: Contains the display attributes for scheduling objects.
Table Type: REFERENCE





Column Detail - SCH_DISP_SCHEME


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.
BACK_COLOR DOUBLE Y The numeric equilivant of the background color.
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.
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.
BRUSH_TYPE DOUBLE Y The numeric equilivant of the brush type.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
DAYS_OF_WEEK VARCHAR(7) Y A 7-char string representing the days of the week.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
DISP_SCHEME_ID DOUBLE N The coded identifier of the disp scheme.
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.
FORE_COLOR DOUBLE Y The numeric equilivant of the foreground color.
HATCH_COLOR DOUBLE Y The numeric equilivant of the hatching color.
HATCH_STYLE DOUBLE Y The numeric equilivant of the hatching style.
INFO_SCH_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
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.
MNEMONIC VARCHAR(100) N A 100-character string used for identification and selection.
MNEMONIC_KEY VARCHAR(100) N The MNEMONIC in uppercase with the non-alphanumeric characters removed.
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) Y A native sort version of the MNEMONIC_KEY FIELD.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
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.
RELEASE_INTERVAL DOUBLE Y The time interval in minutes before the display should expire.
SCHEME_TYPE_FLAG DOUBLE N Deteremines the usage of the display scheme.
SHAPE DOUBLE Y The numeric equilivant of the shape.
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_DISP_SCHEME


Child Column in SCH_DISP_SCHEME(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in SCH_DISP_SCHEME (PK) Child Table Name Child Column Name
Children: DISP_SCHEME_ID SCH_ACTIVITY DISP_SCHEME_ID
SCH_APPT APPT_SCHEME_ID
SCH_APPT SLOT_SCHEME_ID
SCH_APPT_BOOK DISP_SCHEME_ID
SCH_APPT_DEF SLOT_SCHEME_ID
SCH_APPT_STATE DISP_SCHEME_ID
SCH_BASE_SCHEDULE_ACTIVITY ACTIVITY_SCHEME_ID
SCH_DEF_SLOT SLOT_SCHEME_ID
SCH_SLOT_TYPE DISP_SCHEME_ID