Table Detail Report
SCH_WARNING_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Hold the valid warning tokens for a schedulng warning type |
Definition: | Scheduling Warning List |
Table Type: | REFERENCE |
Column Detail - SCH_WARNING_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. |
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. |
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. |
WARN_TOKEN_CD | DOUBLE | N | A unique identifier for the scheduling display token. |
WARN_TOKEN_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling display token. |
WARN_TYPE_CD | DOUBLE | N | The unique identifier for the scheduling warning type. |
WARN_TYPE_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling warning type. |
Relationship Detail - SCH_WARNING_LIST
Child Column in SCH_WARNING_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WARN_TOKEN_CD | CODE_VALUE | CODE_VALUE |
WARN_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_WARNING_OPTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Warning Options |
Definition: | Scheduling Warning Options |
Table Type: | REFERENCE |
Column Detail - SCH_WARNING_OPTION
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. |
REASON_ACCEPT_CD | DOUBLE | N | The unique identifier for the scheduling reason accept option. (required, optional, disable) |
REASON_ACCEPT_MEANING | VARCHAR(12) | N | A 12-character description corresponding to the scheduling reason accept option. |
REASON_VALIDATE_FLAG | DOUBLE | N | Determines the validation status for the scheduling reason accept. (all, exclude, include) |
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. |
WARN_CLASS_CD | DOUBLE | N | A unique identifier for the scheduling warning class. |
WARN_CLASS_MEANING | VARCHAR(12) | Y | A 12-char description of the scheduling warning class. |
WARN_LEVEL_CD | DOUBLE | N | The coded identifier for the scheduling warning severity level. |
WARN_LEVEL_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling warning severity level. |
WARN_OPTION_CD | DOUBLE | N | A coded identifier for the warning option that was chosen by the user. |
WARN_OPTION_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling warning option chosen. |
WARN_PROCESS_CD | DOUBLE | N | A unique identifier for the warning process code. (none, write, etc.) |
WARN_PROCESS_MEANING | VARCHAR(12) | Y | A 12-char description of the scheduling warning process code. |
WARN_TYPE_CD | DOUBLE | N | The unique identifier for the scheduling warning type. |
WARN_TYPE_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling warning type. |
Relationship Detail - SCH_WARNING_OPTION
Child Column in SCH_WARNING_OPTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REASON_ACCEPT_CD | CODE_VALUE | CODE_VALUE |
WARN_CLASS_CD | CODE_VALUE | CODE_VALUE | |
WARN_LEVEL_CD | CODE_VALUE | CODE_VALUE | |
WARN_OPTION_CD | CODE_VALUE | CODE_VALUE | |
WARN_PROCESS_CD | CODE_VALUE | CODE_VALUE | |
WARN_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_WARNING_REASON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Warning Reason |
Definition: | Scheduling Warning Reason |
Table Type: | REFERENCE |
Column Detail - SCH_WARNING_REASON
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. |
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. |
WARN_OPTION_CD | DOUBLE | N | A coded identifier for the warning option that was chosen by the user. |
WARN_OPTION_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the scheduling warning option chosen. |
WARN_REASON_CD | DOUBLE | N | The unique identifier for the scheduling warning override reason. |
WARN_REASON_MEANING | VARCHAR(12) | Y | The 12-character description corresponing to the scheduling override warning reason. |
WARN_TYPE_CD | DOUBLE | N | The unique identifier for the scheduling warning type. |
WARN_TYPE_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling warning type. |
Relationship Detail - SCH_WARNING_REASON
Child Column in SCH_WARNING_REASON(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WARN_OPTION_CD | CODE_VALUE | CODE_VALUE |
WARN_REASON_CD | CODE_VALUE | CODE_VALUE | |
WARN_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_WARNING_TOKEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | The valid Scheduling Warning Token |
Definition: | Scheduling Warning Token |
Table Type: | REFERENCE |
Column Detail - SCH_WARNING_TOKEN
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. |
DATA_TYPE_CD | DOUBLE | N | A coded identifier for the scheduling date type. |
DATA_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling data type. |
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. |
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. |
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. |
WARN_TOKEN_CD | DOUBLE | N | A unique identifier for the scheduling display token. |
WARN_TOKEN_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling display token. |
Relationship Detail - SCH_WARNING_TOKEN
Child Column in SCH_WARNING_TOKEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DATA_TYPE_CD | CODE_VALUE | CODE_VALUE |
WARN_TOKEN_CD | CODE_VALUE | CODE_VALUE | |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SCH_WARNING_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Warning Types |
Definition: | Scheduling Warning Type |
Table Type: | REFERENCE |
Column Detail - SCH_WARNING_TYPE
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. |
BIT_MASK | DOUBLE | N | A bit mask used to store internal processing flags. |
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. |
DISPLAY_TEXT_ID | DOUBLE | N | The unique identifier for the associated text. |
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. |
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. |
STARTER_DATA_IND | DOUBLE | N | Determines if the record was populated as part of the starter data during install. |
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. |
WARN_BATCH_CD | DOUBLE | N | A unique identifier for the type of scheduling warning. (warning, alert) |
WARN_BATCH_MEANING | VARCHAR(12) | Y | A 12-char description corresponding to the type of scheduling warning. |
WARN_TYPE_CD | DOUBLE | N | The unique identifier for the scheduling warning type. |
WARN_TYPE_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the scheduling warning type. |
Relationship Detail - SCH_WARNING_TYPE
Child Column in SCH_WARNING_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WARN_BATCH_CD | CODE_VALUE | CODE_VALUE |
WARN_TYPE_CD | CODE_VALUE | CODE_VALUE | |
DISPLAY_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
INFO_SCH_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |