Table Detail Report

SCH_ACTION_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Action Notifications
Definition: Scheduling Action Notifications
Table Type: ACTIVITY





Column Detail - SCH_ACTION_NOTIFY


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.
BASE_ROUTE_ID DOUBLE N Scheduling Route Identifier
BEG_DT_TM DATETIME Y Begin Date and Time value
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.
CONVERSATION_ID DOUBLE N Scheduling Conversation Identifier. This identifier is used to track all the reports to be created at the same transaction.This field makes debugging much easier.
EMAIL VARCHAR(100) Y FREE TEXT EMAIL
END_DT_TM DATETIME Y End Date and Time value
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 Requested Number of Copies
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
OUTPUT_DEST_ID DOUBLE N Output Destination Identifier
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) Y Parent Table
REPORT_ID DOUBLE N Scheduling Report Identifier
REPORT_TABLE VARCHAR(32) Y Scheduling Report Table
REPORT_TYPE_CD DOUBLE N The coded identifier for the scheduling report type.
REPORT_TYPE_MEANING VARCHAR(12) Y Scheduling Report Type Meaning
REQUESTED_DT_TM DATETIME N Reqeusted Date and Time
SCH_FLEX_ID DOUBLE N schedule flex identifier
SCH_NOTIFY_ID DOUBLE N A unique identifier for a Scheduling Notification
SCH_REPORT_ID DOUBLE N The identifier for the scheduling report.
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of the appointment.
SOURCE_TYPE_CD DOUBLE N Scheduling Notication Source Type Code
SOURCE_TYPE_MEANING VARCHAR(12) Y Scheduling Notication Source Type Meaning
STATE_MEANING VARCHAR(12) Y The 12-character string corresponding to the current state of the appointment.
SUFFIX VARCHAR(50) Y This field holds the phone number when ad-hoc faxing 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.
TRANSMIT_DT_TM DATETIME Y Not Currently Used
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_ACTION_NOTIFY


Child Column in SCH_ACTION_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: REPORT_TYPE_CD CODE_VALUE CODE_VALUE
SCH_STATE_CD CODE_VALUE CODE_VALUE
SOURCE_TYPE_CD CODE_VALUE CODE_VALUE
OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD
TO_PRSNL_ID PRSNL PERSON_ID
SCH_FLEX_ID SCH_FLEX_STRING SCH_FLEX_ID
SCH_REPORT_ID SCH_REPORT SCH_REPORT_ID
BASE_ROUTE_ID SCH_ROUTE SCH_ROUTE_ID


SCH_ACTION_ROLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Request List Modifications desc
Definition: Scheduling Request List Modifications
Table Type: ACTIVITY





Column Detail - SCH_ACTION_ROLE


Column Name Type Null? Definition
ACTION_MOD_ID DOUBLE N The unique identifier for the scheduling action resource list modification.
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.
LIST_ROLE_ID DOUBLE N The identifier for the list role.
LOCATION_TYPE_CD DOUBLE N Defines the locations meaning to scheduling.
LOCATION_TYPE_MEANING VARCHAR(12) Y A 12-char description of the location's meaning to scheduling.
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.
SCENARIO_NBR DOUBLE N Scenario Number
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SELECTED_IND DOUBLE N Determines if the object is (by default) selected or not.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
SLOT_TYPE_ID DOUBLE N The identifier for the slot type.
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_ACTION_ROLE


Child Column in SCH_ACTION_ROLE(FK) Parent Table Name Parent Column Name
Parents: LOCATION_TYPE_CD CODE_VALUE CODE_VALUE
RESOURCE_CD CODE_VALUE CODE_VALUE
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID
SLOT_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID


SCH_APPLY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Apply String
Definition: Scheduling Apply String
Table Type: ACTIVITY





Column Detail - SCH_APPLY


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.
APPLY_TYPE_CD DOUBLE N A unique identifier of the Scheduling Application Type.
APPLY_TYPE_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling Application Type Code.
BEG_DT_TM DATETIME N Begin Date and Time value
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.
DAYS_OF_WEEK VARCHAR(7) N A 7-char string representing the days of the week.
END_DT_TM DATETIME N End Date and Time value
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.
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
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) Y Parent Table
SCH_APPLY_ID DOUBLE N Scheduling Application Identifier
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of the appointment.
STATE_MEANING VARCHAR(12) Y The 12-character string corresponding to the current state of the appointment.
SUB_TEXT_CD DOUBLE N The identifier for the scheduling text sub-type.
SUB_TEXT_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N Text Identifier
TEXT_TYPE_CD DOUBLE N The identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) Y The 12-character string corresponding to the scheduling text type.
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_APPLY


Child Column in SCH_APPLY(FK) Parent Table Name Parent Column Name
Parents: APPLY_TYPE_CD CODE_VALUE CODE_VALUE
SCH_STATE_CD CODE_VALUE CODE_VALUE
SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in SCH_APPLY (PK) Child Table Name Child Column Name
Children: SCH_APPLY_ID SCH_APPLY_EXCEPT SCH_APPLY_ID
SCH_DATE_COMMENT SCH_APPLY_ID


SCH_APPLY_EXCEPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Application Exceptions
Definition: Scheduling Application Exceptions
Table Type: ACTIVITY





Column Detail - SCH_APPLY_EXCEPT


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_DT_TM DATETIME N Begin Date and Time value
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_DT_TM DATETIME N End Date and Time value
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_APPLY_ID DOUBLE N Scheduling Application 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.
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_APPLY_EXCEPT


Child Column in SCH_APPLY_EXCEPT(FK) Parent Table Name Parent Column Name
Parents: SCH_APPLY_ID SCH_APPLY SCH_APPLY_ID


SCH_APPLY_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Default Schedule Application Instances
Definition: Defines the days of a default schedule application on which the default schedule was actually applied.
Table Type: ACTIVITY





Column Detail - SCH_APPLY_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.
APPLY_LIST_ID DOUBLE N The unique identifier for the application of a default schedule to a resource
BEG_DT_TM DATETIME N Begin Date and Time value
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.
DEF_APPLY_ID DOUBLE N The unique identifier for the default schedule application.
DEF_BEG_DT_TM DATETIME N The date and time matching the default schedule application begin date and time.
DEF_END_DT_TM DATETIME N The date and time matching the default schedule application end date and time.
DEF_SCHED_ID DOUBLE N The identifier for a default schedule.
END_DT_TM DATETIME N End Date and Time value
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
OCCURANCE DOUBLE Y The sequence of the object in an ordered list. (1 of 2, etc.)
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
SCH_DATE_SET_ID DOUBLE N The ID of the date set this apply list is associated to. It is the primary key of the SCH_DATE_SET table.
SLOT_STATE_CD DOUBLE N The code_value for the current slot state.
SLOT_STATE_MEANING VARCHAR(12) Y A 12-char description of the schedule slot state.
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_APPLY_LIST


Child Column in SCH_APPLY_LIST(FK) Parent Table Name Parent Column Name
Parents: RESOURCE_CD CODE_VALUE CODE_VALUE
SLOT_STATE_CD CODE_VALUE CODE_VALUE
SCH_DATE_SET_ID SCH_DATE_SET SCH_DATE_SET_ID
DEF_APPLY_ID SCH_DEF_APPLY DEF_APPLY_ID
DEF_SCHED_ID SCH_DEF_SCHED DEF_SCHED_ID




Parent Column in SCH_APPLY_LIST (PK) Child Table Name Child Column Name
Children: APPLY_LIST_ID SCH_APPT APPLY_LIST_ID