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