Table Detail Report
SCH_DATE_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Date List |
Definition: | Stores all the dates associated to a scheduling date set. |
Table Type: | REFERENCE |
Column Detail - SCH_DATE_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
SCH_DATE_DT_TM | DATETIME | N | The date associated to the date set. |
SCH_DATE_LIST_ID | DOUBLE | N | The unique primary key of this table. It is internally genreated. |
SCH_DATE_SET_ID | DOUBLE | N | The ID of the date set this date is associated to. It is the primary key of the SCH_DATE_SET table. |
SCH_DATE_TXT | VARCHAR(20) | N | This is the date associated to a date set but stored in a text form. This is done to ensure RDDS can correctly merge this column across domains. The value into his column should be the same as the value in SCH_DATE_DT_TM. |
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. |
Relationship Detail - SCH_DATE_LIST
Child Column in SCH_DATE_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCH_DATE_SET_ID | SCH_DATE_SET | SCH_DATE_SET_ID |
Parent Column in SCH_DATE_LIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCH_DATE_LIST_ID | SCH_DATE_APPLY | SCH_DATE_LIST_ID |
SCH_DATE_SET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Date Set |
Definition: | Stores information about a scheduling date set. A date set is a group of dates associated to a scheduling template. |
Table Type: | REFERENCE |
Column Detail - SCH_DATE_SET
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
DATE_SET_TYPE_CD | DOUBLE | N | Used to identify the type of date set. Some examples are personal holiday and public holiday. |
DEF_SCHED_ID | DOUBLE | N | The ID of the default schedule associated to this date set. It is the primary key of the SCH_DEF_SCHED table. |
DESCRIPTION | VARCHAR(200) | N | The description of the date set. |
INCLUDE_IND | DOUBLE | N | Indicates if the resource or resource group should be included or excluded in the display. |
INFO_SCH_TEXT_ID | DOUBLE | N | An ID to the LONG_TEXT_REFERENCE table used to associate information only text to this date set. |
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 string used for identification and selection of the date set. |
MNEMONIC_KEY | VARCHAR(100) | N | The MNEMONIC stored in uppercase with the non-alphanumeric characters removed. |
SCH_DATE_SET_ID | DOUBLE | N | The unique primary key of this table. It is internally generated. |
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. |
Relationship Detail - SCH_DATE_SET
Child Column in SCH_DATE_SET(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
DEF_SCHED_ID | SCH_DEF_SCHED | DEF_SCHED_ID |
Parent Column in SCH_DATE_SET (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCH_DATE_SET_ID | SCH_APPLY_LIST | SCH_DATE_SET_ID |
SCH_DATE_LINK_R | SCH_DATE_SET_ID | ||
SCH_DATE_LIST | SCH_DATE_SET_ID |
SCH_DEF_LOC_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Default Location Relationship |
Definition: | Defines the locations which can be associated to the default template. |
Table Type: | REFERENCE |
Column Detail - SCH_DEF_LOC_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DEF_SCHED_ID | DOUBLE | N | SEQUENCE NAME:SCH_DEFAULT_SEQ The identifier for a default schedule. |
LOCATION_CD | DOUBLE | N | The location associcted to the scheduling default template. |
SCH_DEF_LOC_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the SCH_DEF_LOC_R table.; |
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. |
Relationship Detail - SCH_DEF_LOC_R
Child Column in SCH_DEF_LOC_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
DEF_SCHED_ID | SCH_DEF_SCHED | DEF_SCHED_ID |
SCH_DEF_RES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Default Resources |
Definition: | Defined the resources which can utilize the default schedule. |
Table Type: | REFERENCE |
Column Detail - SCH_DEF_RES
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. |
DEF_SCHED_ID | DOUBLE | N | The identifier for a default schedule. |
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 |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. |
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_DEF_RES
Child Column in SCH_DEF_RES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RESOURCE_CD | CODE_VALUE | CODE_VALUE |
DEF_SCHED_ID | SCH_DEF_SCHED | DEF_SCHED_ID |
SCH_DEF_SCHED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Default Schedules |
Definition: | The default schedule defined the planned workload of a resource. |
Table Type: | REFERENCE |
Column Detail - SCH_DEF_SCHED
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_RANGE | DOUBLE | Y | Application Range |
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. |
BEG_TM | DOUBLE | N | Defines the standard start time. |
CANDIDATE_ID | DOUBLE | N | A sequence-generated number to uniquely identify the specific row in the database. |
DEFAULT_TYPE_CD | DOUBLE | N | A coded identifier for the default schedule type. |
DEFAULT_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the default schedule type. |
DEF_SCHED_ID | DOUBLE | N | The identifier for a default schedule. |
DESCRIPTION | VARCHAR(200) | Y | A long description used for documentation. |
DURATION | DOUBLE | Y | The duration in minutes. |
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. |
END_TM | DOUBLE | N | Defines the standard ending time. |
INFO_SCH_TEXT_ID | DOUBLE | N | The identifier of the information-only text associated with the record. |
INTERVAL | DOUBLE | N | Defines the time interval in minutes. |
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 |
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_DEF_SCHED
Child Column in SCH_DEF_SCHED(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DEFAULT_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_DEF_SCHED (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DEF_SCHED_ID | SCH_APPLY_LIST | DEF_SCHED_ID |
SCH_DATE_SET | DEF_SCHED_ID | ||
SCH_DEF_APPLY | DEF_SCHED_ID | ||
SCH_DEF_LOC_R | DEF_SCHED_ID | ||
SCH_DEF_RES | DEF_SCHED_ID | ||
SCH_DEF_SLOT | DEF_SCHED_ID |