Table Detail Report

SCH_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Request Log
Definition: Allows the scheduling application to log failed request/reply messages.
Table Type: ACTIVITY





Column Detail - SCH_LOG


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.
APPLICATION_NUMBER DOUBLE N Application Number of the application generating the error.
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.
GENERATED_DT_TM DATETIME N The date and time the log as generated.
MNEMONIC VARCHAR(100) Y 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.
PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that performed the action.
REQUEST_NUMBER DOUBLE N The request number of the request that failed.
SCH_LOG_ID DOUBLE N The internal identifier for the scheduling log
TASK_NUMBER DOUBLE N The task number of the request that failed.
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_LOG


Child Column in SCH_LOG(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in SCH_LOG (PK) Child Table Name Child Column Name
Children: SCH_LOG_ID SCH_LOG_LIST SCH_LOG_ID


SCH_LOG_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Log Lists
Definition: Provides a link between the scheduling logs and the long text tables. This table is used to store the request, reply, and comments for a scheduling log.
Table Type: ACTIVITY





Column Detail - SCH_LOG_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.
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.
LOG_TEXT_CD DOUBLE N The coded identifier for the scheduling log text type
LOG_TEXT_MEANING VARCHAR(12) Y The 12-character meaning corresponding to LOG_TEXT_CD.
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.
SCH_LOG_ID DOUBLE N The internal identifier for the scheduling log
SEQ_NBR DOUBLE N Determines the order of the object within a collection.
TEXT_ID DOUBLE N The unique identifier used to store the actual test on the LONG_TEXT table.
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_LOG_LIST


Child Column in SCH_LOG_LIST(FK) Parent Table Name Parent Column Name
Parents: LOG_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT LONG_TEXT_ID
SCH_LOG_ID SCH_LOG SCH_LOG_ID


SCH_MESSAGING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Messaging
Definition: Table used to capture what appointments reminder messages were sent out for.
Table Type: ACTIVITY





Column Detail - SCH_MESSAGING


Column Name Type Null? Definition
CONTACT_METHOD_CD DOUBLE N This is the contact cd value of the type of contact (text, email, phone call, ect..)
GROUP_IDENT VARCHAR(100) N The identifier for the transaction that was called to get the response to the message. ID comes from Transaction Services which is external to Millennium.
LOCATION_CD DOUBLE N The location where the appointment is expected to take place.
MESSAGE_SENT_FLAG DOUBLE N This is the numerical value that represents the message we sent to the patient or correct responsible party for that patient. 0 - Value Not Entered, 1 = Standard Message, 3 - New Patient Message, 8 - No Show Message
PATIENT_FIN_RESPONSIBILITY_AMT DOUBLE N The amount of money the patient is financially responsible for services and goods rendered during their appointment.
PATIENT_RESPONSE_CD DOUBLE N This is the response about the appointment provided by the patient or responsible party for said patient.
PERSON_ID DOUBLE N The ID of the person that the appointment is about.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule. The schedules are used to track rescheduling of an event.
SCH_APPT_DT_TM DATETIME N When the appointment is scheduled to take place.
SCH_EVENT_ID DOUBLE N The key that matches the message sent to the event it is about.
SCH_MESSAGING_ID DOUBLE N Unique generated number that identifies a single row on the SCH_MESSAGING 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.
WRITTEN_DT_TM DATETIME N The date and time for which this table row is written out to the table.



Relationship Detail - SCH_MESSAGING


Child Column in SCH_MESSAGING(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID


SCH_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Notify
Definition: Scheduling Generic Reference Notifications
Table Type: ACTIVITY





Column Detail - SCH_NOTIFY


Column Name Type Null? Definition
ACTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Action Code.
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.
EMAIL VARCHAR(100) Y Email
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.
NBR_COPIES DOUBLE N The requested number of copies.
NOTIFY_ID DOUBLE N The unique identifier corresponding to the scheduling notification.
NOTIFY_TYPE_CD DOUBLE N The coded identifier for the type of notification.
NOTIFY_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding the type of notification.
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.
OUTPUT_DEST_ID DOUBLE N The unique identifier of the output destination (printer, fax, etc.)
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT_ID
REPORT_TYPE_CD DOUBLE N The coded identifier for the scheduling report type.
REPORT_TYPE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling report type.
SCH_ACTION_CD DOUBLE N A coded identifier for the scheduling action.
SCH_REPORT_ID DOUBLE N The unique identifier for the scheduling report.
SCH_ROUTE_ID DOUBLE N The unique identifier for a scheduling route.
SEQ_NBR DOUBLE N Determines the order of the object within a collection.
SUFFIX VARCHAR(50) Y This field holds the phone number when ad-hoc reporting is used.
TO_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) to whom the notification should be sent.
UNITS DOUBLE N Units
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.



Relationship Detail - SCH_NOTIFY


Child Column in SCH_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: NOTIFY_TYPE_CD CODE_VALUE CODE_VALUE
REPORT_TYPE_CD CODE_VALUE CODE_VALUE
SCH_ACTION_CD CODE_VALUE CODE_VALUE
UNITS_CD CODE_VALUE CODE_VALUE
OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD
TO_PRSNL_ID PRSNL PERSON_ID
SCH_REPORT_ID SCH_REPORT SCH_REPORT_ID
SCH_ROUTE_ID SCH_ROUTE SCH_ROUTE_ID


SCH_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the Scheduling Warning Option chosen for a Scheduling Warning Type
Definition: Scheduling Warning Option
Table Type: ACTIVITY





Column Detail - SCH_OPTION


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.
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(32) Y The parent table corresponding to the PARENT_ID
SCH_OPTION_ID DOUBLE N The unique identifier for the warning option chosen for a generated warning.
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_CLASS_CD DOUBLE N A unique identifier for the scheduling warning class.
WARN_CLASS_MEANING VARCHAR(12) Y A 12-char description of the scheduling warning class.
WARN_DT_TM DATETIME N The date and time was warning was generated.
WARN_LEVEL_CD DOUBLE N The coded identifier for the scheduling warning severity level.
WARN_LEVEL_MEANING VARCHAR(12) Y The 12-character description corresponding to the scheduling warning severity level.
WARN_OPTION_CD DOUBLE N A coded identifier for the warning option that was chosen by the user.
WARN_OPTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling warning option chosen.
WARN_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that created the warning.
WARN_REASON_CD DOUBLE N The unique identifier for the scheduling warning override reason.
WARN_REASON_MEANING VARCHAR(12) Y The 12-character description corresponing to the scheduling override warning reason.



Relationship Detail - SCH_OPTION


Child Column in SCH_OPTION(FK) Parent Table Name Parent Column Name
Parents: WARN_CLASS_CD CODE_VALUE CODE_VALUE
WARN_LEVEL_CD CODE_VALUE CODE_VALUE
WARN_OPTION_CD CODE_VALUE CODE_VALUE
WARN_REASON_CD CODE_VALUE CODE_VALUE
WARN_PRSNL_ID PRSNL PERSON_ID