Table Detail Report
SCH_OBJECT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Generic Object |
Definition: | Scheduling Generic Object |
Table Type: | REFERENCE |
Column Detail - SCH_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. |
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. |
OBJECT_SUB_CD | DOUBLE | N | A coded identifier for the generic scheduling object sub type. |
OBJECT_SUB_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object sub type code. |
OBJECT_TYPE_CD | DOUBLE | N | A coded identifier for the generic scheduling object type. |
OBJECT_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object type. |
SCH_OBJECT_ID | DOUBLE | N | A unique identifier for the generic scheduling object. |
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_OBJECT
Child Column in SCH_OBJECT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OBJECT_SUB_CD | CODE_VALUE | CODE_VALUE |
OBJECT_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_OBJECT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCH_OBJECT_ID | SCH_APPT_OBJECT | SCH_OBJECT_ID |
SCH_ENTRY | QUEUE_ID |
SCH_OBJECT_ASSOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Object Association Types |
Definition: | Scheduling Object Association Types |
Table Type: | REFERENCE |
Column Detail - SCH_OBJECT_ASSOC
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. |
ASSOC_TYPE_CD | DOUBLE | N | A coded identifier of the scheduling association type. This is used to denote the type of association between the objects. |
ASSOC_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling association type code. |
ASSOC_WITH_CD | DOUBLE | N | A coded identifier for the scheduling association with type code. |
ASSOC_WITH_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling association with 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. |
MAX_SELECT | DOUBLE | N | Determines the maximum number of entries the user is allowed to select |
MIN_SELECT | DOUBLE | N | Determines the minimum number of entries the user is required to select |
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. |
OBJECT_SUB_CD | DOUBLE | N | A coded identifier for the generic scheduling object sub type. |
OBJECT_SUB_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object sub type code. |
OE_FORMAT_ID | DOUBLE | N | The identifier of the accept format. |
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_OBJECT_ASSOC
Child Column in SCH_OBJECT_ASSOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ASSOC_TYPE_CD | CODE_VALUE | CODE_VALUE |
ASSOC_WITH_CD | CODE_VALUE | CODE_VALUE | |
OBJECT_SUB_CD | CODE_VALUE | CODE_VALUE |
SCH_OBJECT_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Object Data Sources |
Definition: | Scheduling Object Data Sources |
Table Type: | REFERENCE |
Column Detail - SCH_OBJECT_DATA
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. |
ASSOC_TYPE_CD | DOUBLE | N | A coded identifier of the scheduling association type. This is used to denote the type of association between the objects. |
ASSOC_TYPE_MEANING | VARCHAR(12) | Y | A 12-character 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. |
DATA_SOURCE_CD | DOUBLE | N | A coded identifier for the scheduling data source. |
DATA_SOURCE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling data source. |
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. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
OBJECT_SUB_CD | DOUBLE | N | A coded identifier for the generic scheduling object sub type. |
OBJECT_SUB_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object sub type code. |
SCRIPT_NAME | VARCHAR(30) | Y | The CCL name of the program to execute. |
SEQ_NBR | DOUBLE | N | Determines the order of the object within a collection. |
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_OBJECT_DATA
Child Column in SCH_OBJECT_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ASSOC_TYPE_CD | CODE_VALUE | CODE_VALUE |
DATA_SOURCE_CD | CODE_VALUE | CODE_VALUE | |
OBJECT_SUB_CD | CODE_VALUE | CODE_VALUE |
SCH_OBJECT_SUB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Object Sub Types |
Definition: | Scheduling Object Sub Types |
Table Type: | REFERENCE |
Column Detail - SCH_OBJECT_SUB
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. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
OBJECT_SUB_CD | DOUBLE | N | A coded identifier for the generic scheduling object sub type. |
OBJECT_SUB_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object sub type code. |
OBJECT_TYPE_CD | DOUBLE | N | A coded identifier for the generic scheduling object type. |
OBJECT_TYPE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object type. |
OE_FORMAT_ID | DOUBLE | N | The identifier of the accept format. |
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_OBJECT_SUB
Child Column in SCH_OBJECT_SUB(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OBJECT_SUB_CD | CODE_VALUE | CODE_VALUE |
OBJECT_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_OBJECT_USAGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Object Usage |
Definition: | Scheduling Object Usage |
Table Type: | REFERENCE |
Column Detail - SCH_OBJECT_USAGE
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. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
OBJECT_SUB_CD | DOUBLE | N | A coded identifier for the generic scheduling object sub type. |
OBJECT_SUB_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the generic scheduling object sub type code. |
OBJECT_USAGE_CD | DOUBLE | N | A coded identifier for the scheduling object usage. |
OBJECT_USAGE_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling object usage. |
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_OBJECT_USAGE
Child Column in SCH_OBJECT_USAGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OBJECT_SUB_CD | CODE_VALUE | CODE_VALUE |
OBJECT_USAGE_CD | CODE_VALUE | CODE_VALUE |