Table Detail Report

SCH_APPT_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Notifications
Definition: Scheduling Appointment Notifications
Table Type: REFERENCE





Column Detail - SCH_APPT_NOTIFY


Column Name Type Null? Definition
ACTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling ActionCode.
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_TYPE_CD DOUBLE N The identifier for an appointment type.
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_UNITS DOUBLE N Gegin Units
BEG_UNITS_CD DOUBLE N Begin Units Code
BEG_UNITS_MEANING VARCHAR(12) Y Begin Units Meaning
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.
END_UNITS DOUBLE N End Units
END_UNITS_CD DOUBLE N End Units Code
END_UNITS_MEANING VARCHAR(12) Y End Units Meaning
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
SCH_ACTION_CD DOUBLE N A unique identifier for the Scheduling Action Code
SCH_FLEX_ID DOUBLE N Scheduling Flexing Identifier
SCH_ROUTE_ID DOUBLE N The internal unique identifier for a scheduling route.
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_APPT_NOTIFY


Child Column in SCH_APPT_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
BEG_UNITS_CD CODE_VALUE CODE_VALUE
END_UNITS_CD CODE_VALUE CODE_VALUE
SCH_ACTION_CD CODE_VALUE CODE_VALUE
LOCATION_CD LOCATION LOCATION_CD
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID
SCH_ROUTE_ID SCH_ROUTE SCH_ROUTE_ID


SCH_APPT_OBJECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Objects
Definition: Scheduling Appointment Objects
Table Type: REFERENCE





Column Detail - SCH_APPT_OBJECT


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_TYPE_CD DOUBLE N The identifier for an appointment type.
ASSOC_TYPE_CD DOUBLE N A coded identifier for the Scheduling Association Type
ASSOC_TYPE_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Association Type Code
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
SCH_OBJECT_ID DOUBLE N A unique identifier for the Scheduling Generic Object
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_APPT_OBJECT


Child Column in SCH_APPT_OBJECT(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
ASSOC_TYPE_CD CODE_VALUE CODE_VALUE
SCH_OBJECT_ID SCH_OBJECT SCH_OBJECT_ID


SCH_APPT_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds the processing option associated with the scheduling appointment type
Definition: Scheduling Appointment Type Option
Table Type: REFERENCE





Column Detail - SCH_APPT_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.
APPT_TYPE_CD DOUBLE N The identifier for an appointment type.
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
OPTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Processing Option Code
SCH_OPTION_CD DOUBLE N A unique identifier of the Scheduling Processing Option
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_APPT_OPTION


Child Column in SCH_APPT_OPTION(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
SCH_OPTION_CD CODE_VALUE CODE_VALUE


SCH_APPT_PRODUCT



Column Section Top of Page


Table-level Detail

Description: Scheduling Appointment Product
Definition: This table is used to filter appointment types by product
Table Type: REFERENCE





Column Detail - SCH_APPT_PRODUCT


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_TYPE_CD DOUBLE N The identifier for an appointment type.
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
PRODUCT_CD DOUBLE N Scheduling Product Code
PRODUCT_MEANING VARCHAR(12) Y Product 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.


SCH_APPT_ROUTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Appointment Routing
Definition: Scheduling Appointment Routing
Table Type: REFERENCE





Column Detail - SCH_APPT_ROUTING


Column Name Type Null? Definition
ACTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling ActionCode.
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_TYPE_CD DOUBLE N The identifier for an appointment type.
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_UNITS DOUBLE N Gegin Units
BEG_UNITS_CD DOUBLE N Begin Units Code
BEG_UNITS_MEANING VARCHAR(12) Y Begin Units Meaning
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.
END_UNITS DOUBLE N End Units
END_UNITS_CD DOUBLE N End Units Code
END_UNITS_MEANING VARCHAR(12) Y End Units Meaning
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ROUTING_ID DOUBLE N Scheduling Routing Identifier
ROUTING_MEANING VARCHAR(12) Y Scheduling Routing Meaning
ROUTING_TABLE VARCHAR(32) N Scheduling Routing Table
SCH_ACTION_CD DOUBLE N A unique identifier for the Scheduling Action Code
SCH_FLEX_ID DOUBLE N Scheduling Flexing Identifier
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. 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_APPT_ROUTING


Child Column in SCH_APPT_ROUTING(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
BEG_UNITS_CD CODE_VALUE CODE_VALUE
END_UNITS_CD CODE_VALUE CODE_VALUE
SCH_ACTION_CD CODE_VALUE CODE_VALUE
LOCATION_CD LOCATION LOCATION_CD
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID