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. |
VARCHAR(100) | Y | ||
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 |