Table Detail Report

SCH_ROLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Role
Definition: Scheduling Role
Table Type: REFERENCE





Column Detail - SCH_ROLE


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.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
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.
INFO_SCH_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MNEMONIC VARCHAR(100) N A 100-character string used for identification and selection.
MNEMONIC_KEY VARCHAR(100) N The MNEMONIC in uppercase with the non-alphanumeric characters removed.
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) Y A native sort version of the MNEMONIC_KEY FIELD.
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.
ROLE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling role.
SCH_ROLE_CD DOUBLE N The coded identifier for the scheduling role.
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_ROLE


Child Column in SCH_ROLE(FK) Parent Table Name Parent Column Name
Parents: SCH_ROLE_CD CODE_VALUE CODE_VALUE
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


SCH_ROUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Routes
Definition: Scheduling Routes
Table Type: REFERENCE





Column Detail - SCH_ROUTE


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.
DESCRIPTION VARCHAR(200) Y A long description used for documentation.
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.
INFO_SCH_TEXT_ID DOUBLE N The identifier of the information-only text associated with the record.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MNEMONIC VARCHAR(100) N A 100-character string used for identification and selection.
MNEMONIC_KEY VARCHAR(100) N The MNEMONIC in uppercase with the non-alphanumeric characters removed.
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) Y A native sort version of the MNEMONIC_KEY FIELD.
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.
ROUTE_MEANING VARCHAR(12) Y A 12-character description corresponding to the ROUTING_ID
ROUTE_TYPE_CD DOUBLE N A unique identifier for the scheduling routing type.
SCH_ROUTE_ID DOUBLE N The unique identifier for a scheduling route.
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_ROUTE


Child Column in SCH_ROUTE(FK) Parent Table Name Parent Column Name
Parents: ROUTE_TYPE_CD CODE_VALUE CODE_VALUE
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in SCH_ROUTE (PK) Child Table Name Child Column Name
Children: SCH_ROUTE_ID SCH_ACTION_NOTIFY BASE_ROUTE_ID
SCH_APPT_NOTIFY SCH_ROUTE_ID
SCH_NOTIFY SCH_ROUTE_ID
SCH_ROUTE_LIST CHILD_SCH_ROUTE_ID
SCH_ROUTE_LIST SCH_ROUTE_ID


SCH_ROUTE_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Route List
Definition: List the reports associated with a scheduling routing
Table Type: REFERENCE





Column Detail - SCH_ROUTE_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.
CHILD_SCH_ROUTE_ID DOUBLE N The unique identifier corresponding to the child routing.
EMAIL VARCHAR(100) Y FREE TEXT 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 Y The requested number of copies.
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.)
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 hold 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.
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_ROUTE_LIST


Child Column in SCH_ROUTE_LIST(FK) Parent Table Name Parent Column Name
Parents: OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD
TO_PRSNL_ID PRSNL PERSON_ID
SCH_REPORT_ID SCH_REPORT SCH_REPORT_ID
CHILD_SCH_ROUTE_ID SCH_ROUTE SCH_ROUTE_ID
SCH_ROUTE_ID SCH_ROUTE SCH_ROUTE_ID


SCH_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Security
Definition: Scheduling Security
Table Type: REFERENCE





Column Detail - SCH_SECURITY


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.
DATA1_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA1_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DATA2_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA2_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DATA3_SOURCE_CD DOUBLE N A coded identifier for the scheduling data source.
DATA3_SOURCE_MEANING VARCHAR(12) Y A 12-char description corresponding to the scheduling data source.
DISPLAY1_ID DOUBLE N The unique identifier of the display object.
DISPLAY1_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID1
DISPLAY1_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID1
DISPLAY2_ID DOUBLE N The unique identifier of the display object.
DISPLAY2_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID2
DISPLAY2_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID2
DISPLAY3_ID DOUBLE N The unique identifier of the display object.
DISPLAY3_MEANING VARCHAR(12) Y A 12-character description corresponding to the DISPLAY_ID3
DISPLAY3_TABLE VARCHAR(32) Y The parent table corresponding to the DISPLAY_ID3
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.
LOCK_ID DOUBLE N The unique identifier for the scheduling lock.
LOCK_MEANING VARCHAR(12) Y The 12-character meaning corresponding to the scheduling lock.
LOCK_TABLE VARCHAR(32) Y The parent table corresponding to the scheduling lock. This is the table on which the scheduling lock is defined.
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.
PARENT1_ID DOUBLE N The unique identifier of the parent object.
PARENT1_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT1_ID
PARENT1_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT1_ID
PARENT2_ID DOUBLE N The unique identifier of the parent object.
PARENT2_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT2_ID
PARENT2_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT2_ID
PARENT3_ID DOUBLE N The unique identifier of the parent object.
PARENT3_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT3_ID
PARENT3_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT3_ID
SECURITY_ID DOUBLE N The unique identifier for the scheduling security record. The record is used to secure an action for a object.
SEC_TYPE_CD DOUBLE N The coded identifier for the scheduling security type. The types determines the type of object that is being secured.
SEC_TYPE_MEANING VARCHAR(12) N A 12-character description corresponding to scheduling security type.
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_SECURITY


Child Column in SCH_SECURITY(FK) Parent Table Name Parent Column Name
Parents: DATA1_SOURCE_CD CODE_VALUE CODE_VALUE
DATA2_SOURCE_CD CODE_VALUE CODE_VALUE
DATA3_SOURCE_CD CODE_VALUE CODE_VALUE
SEC_TYPE_CD CODE_VALUE CODE_VALUE


SCH_SEC_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Security Comments
Definition: Scheduling Security Comments
Table Type: REFERENCE





Column Detail - SCH_SEC_COMMENT


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
SEC_ACTION_CD DOUBLE N Scheduling Security Action
SEC_ACTION_MEANING VARCHAR(12) Y Security Action Meaning
SEC_TYPE_CD DOUBLE N Scheduling Security Types
SEC_TYPE_MEANING VARCHAR(12) Y Scheduling Security Type Meaning
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_SEC_COMMENT


Child Column in SCH_SEC_COMMENT(FK) Parent Table Name Parent Column Name
Parents: SEC_ACTION_CD CODE_VALUE CODE_VALUE
SEC_TYPE_CD CODE_VALUE CODE_VALUE
SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID