Table Detail Report

SCH_AUTO_MSG_APPT_TYPE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Automated Message Appointment Type Relation
Definition: Table used to store the relation between appointment reminders and appointment types.
Table Type: REFERENCE





Column Detail - SCH_AUTO_MSG_APPT_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.
APPT_TYPE_CD DOUBLE N The code value of an appointment type which has a relation to an automated messaging build.
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.
SCH_AUTO_MSG_APPT_TYPE_R_ID DOUBLE N Unique generated number that identifies a single row on the SCH_AUTO_MSG_APPT_TYPE_R table.
SCH_AUTO_MSG_ID DOUBLE N The id of an automated messaging build which has a relation to a resource.
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_APPT_TYPE_R


Child Column in SCH_AUTO_MSG_APPT_TYPE_R(FK) Parent Table Name Parent Column Name
Parents: SCH_AUTO_MSG_ID SCH_AUTO_MSG SCH_AUTO_MSG_ID


SCH_AUTO_MSG_RESOURCE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Automated Message Resource Relation
Definition: Table used to store the relation between appointment reminders and resources.
Table Type: REFERENCE





Column Detail - SCH_AUTO_MSG_RESOURCE_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.
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.
RESOURCE_CD DOUBLE N The code value of a resource which has a relation to an automated messaging build.
SCH_AUTO_MSG_ID DOUBLE N The id of an automated messaging build which has a relation to a resource.
SCH_AUTO_MSG_RESOURCE_R_ID DOUBLE N Unique generated number that identifies a single row on the SCH_AUTO_MSG_RESOURCE_R 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_RESOURCE_R


Child Column in SCH_AUTO_MSG_RESOURCE_R(FK) Parent Table Name Parent Column Name
Parents: SCH_AUTO_MSG_ID SCH_AUTO_MSG SCH_AUTO_MSG_ID


SCH_BASE_SCHEDULE_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Schedule Base Schedules With Activities
Definition: Contains data pertaining to a base schedule. The schedule will be built out using activities
Table Type: REFERENCE





Column Detail - SCH_BASE_SCHEDULE_ACTIVITY


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.
ACTIVITY_CD DOUBLE N The activity code (Code Set: 4014000) associated with the schedule.
ACTIVITY_SCHEME_ID DOUBLE N The unique identifier for the activities display scheme.
BEG_OFFSET DOUBLE N defines the beginning offset for the activity from the begin time of the unit schedule.
BORDER_COLOR DOUBLE N the numeric equilivant of the border color.
BORDER_SIZE DOUBLE N the numeric equilivant of the border size.
BORDER_STYLE DOUBLE N the numeric equilivant of the border style.
CANDIDATE_ID DOUBLE N a sequence-generated number to uniquely identify the specific row in the database.
DESCRIPTION VARCHAR(200) N a long description used for documentation.
DURATION DOUBLE N The duration of the unit's activity slot
END_OFFSET DOUBLE N defines the ending offset for the activity from the begin time of the unit schedule.
MNEMONIC VARCHAR(100) N a 100-character string used for identification and selection.
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_ENTITY_ID DOUBLE N Foreign key reference to other tables as defined by the parent_entity_name. Used to link a scheduled activity item to a base schedule.
PARENT_ENTITY_NAME VARCHAR(30) N Designates the location (table) of the parent_entity_id.
PEN_SHAPE DOUBLE N a ""0"" in this column will indicate a ""square"" border pen. a ""1"" in this column will represent a ""round"" border pen.
SCH_BASE_SCHEDULE_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on the SCH_BASE_SCHEDULE_ACTIVITY table.
SEQ_NBR DOUBLE N determines the order among the children of a group.
SERIES_UUID VARCHAR(36) N Contains the series identifier that this activity and base schedule pertain to. This will determine what rows need to be updated on a change of the base schedule. Generated from the Java UUID llibraries.
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_BASE_SCHEDULE_ACTIVITY


Child Column in SCH_BASE_SCHEDULE_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_SCHEME_ID SCH_DISP_SCHEME DISP_SCHEME_ID


SCH_BOOK_INSTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Booking Instructions
Definition: Scheduling Booking Instruction
Table Type: REFERENCE





Column Detail - SCH_BOOK_INSTR


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.
BOOK_INSTR_ID DOUBLE N The identifier for the scheduling insruction.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
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.
INFO_SCH_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
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
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_BOOK_INSTR


Child Column in SCH_BOOK_INSTR(FK) Parent Table Name Parent Column Name
Parents: INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in SCH_BOOK_INSTR (PK) Child Table Name Child Column Name
Children: BOOK_INSTR_ID SCH_INSTR_LIST BOOK_INSTR_ID


SCH_BOOK_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Appointment Book List
Definition: Contains the children of an appointment book.
Table Type: REFERENCE





Column Detail - SCH_BOOK_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.
APPT_BOOK_ID DOUBLE N The identifier for the appointment book.
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_APPT_BOOK_ID DOUBLE N The unique identifier for the child appointment book.
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
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_BOOK_LIST


Child Column in SCH_BOOK_LIST(FK) Parent Table Name Parent Column Name
Parents: RESOURCE_CD CODE_VALUE CODE_VALUE
APPT_BOOK_ID SCH_APPT_BOOK APPT_BOOK_ID
CHILD_APPT_BOOK_ID SCH_APPT_BOOK APPT_BOOK_ID