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. |
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 |