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 |