Table Detail Report
SCH_WARN_LEVEL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Warning Levels |
Definition: | Scheduling Warning Level |
Table Type: | REFERENCE |
Column Detail - SCH_WARN_LEVEL
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. The information-only text is used by the client to document the database. |
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 | Mnemonic Key NLS |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00 |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
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 and time this version of the current record becomes historical. |
WARN_LEVEL_CD | DOUBLE | N | The coded identifier for the scheduling warning level. |
WARN_LEVEL_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the schedulingwarning level. |
Relationship Detail - SCH_WARN_LEVEL
Child Column in SCH_WARN_LEVEL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WARN_LEVEL_CD | CODE_VALUE | CODE_VALUE |
INFO_SCH_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
SCH_WARN_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Warning Types |
Definition: | Scheduling Warning Types |
Table Type: | REFERENCE |
Column Detail - SCH_WARN_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 | Y | 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 | Y | 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. The information-only text is used by the client to document the database. |
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. |
NULL_DT_TM | DATETIME | N | contains 31-DEC-2100 00:00:00.00 |
REASON_ACCEPT_CD | DOUBLE | N | The coded identifier for the reason accept option. |
REASON_ACCEPT_MEANING | VARCHAR(12) | N | Th 12-character description corresponding to the scheduling reason accept code. |
STARTER_DATA_IND | DOUBLE | N | Starter Data Indicator |
TEMPLATE_ACCEPT_CD | DOUBLE | N | The coded identifier for the scheduling accept option. |
TEMPLATE_ACCEPT_MEANING | VARCHAR(12) | Y | The 12-character string corresponding to the scheduling accept code. |
TEXT_ACCEPT_CD | DOUBLE | N | The coded indentifer for the scheduling text accept option. |
TEXT_ACCEPT_MEANING | VARCHAR(12) | Y | The 12-character string corresponding to the scheduling accept code. |
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 and time this version of the current record becomes historical. |
WARN_LEVEL_CD | DOUBLE | N | The coded identifier for the scheduling warning level. |
WARN_LEVEL_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the schedulingwarning level. |
WARN_TYPE_CD | DOUBLE | N | The identifier for the scheduling warning type. |
WARN_TYPE_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the schedulingwarning type code. |
Relationship Detail - SCH_WARN_TYPE
Child Column in SCH_WARN_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REASON_ACCEPT_CD | CODE_VALUE | CODE_VALUE |
TEMPLATE_ACCEPT_CD | CODE_VALUE | CODE_VALUE | |
TEXT_ACCEPT_CD | CODE_VALUE | CODE_VALUE | |
WARN_LEVEL_CD | CODE_VALUE | CODE_VALUE | |
WARN_TYPE_CD | CODE_VALUE | CODE_VALUE | |
INFO_SCH_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
SCH_WIZARD_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Wizard Comments |
Definition: | Scheduling Wizard Comments |
Table Type: | REFERENCE |
Column Detail - SCH_WIZARD_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. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key. |
SUB_TEXT_CD | DOUBLE | N | The coded identifier for the scheduling sub text type. The sub text types allow for multiple set of text within a text type (prep, post, guidelines, etc.) |
SUB_TEXT_MEANING | VARCHAR(12) | Y | The 12-character string corresponding to the scheduling text sub-type. |
TEXT_ID | DOUBLE | N | The unique identifier used to store the actual test on the LONG_TEXT table. |
TEXT_TYPE_CD | DOUBLE | N | The coded 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. |
WIZ_OPTION_CD | DOUBLE | N | The unique identifier for the wizard option. |
WIZ_OPTION_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the wizard option. |
WIZ_TYPE_CD | DOUBLE | N | A unique identifier for the scheduling wizard type. |
WIZ_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling wizard type. |
Relationship Detail - SCH_WIZARD_COMMENT
Child Column in SCH_WIZARD_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SUB_TEXT_CD | CODE_VALUE | CODE_VALUE |
TEXT_TYPE_CD | CODE_VALUE | CODE_VALUE | |
WIZ_OPTION_CD | CODE_VALUE | CODE_VALUE | |
WIZ_TYPE_CD | CODE_VALUE | CODE_VALUE | |
TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SCH_WIZARD_OPTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Wizard Options |
Definition: | Scheduling Wizard Options |
Table Type: | REFERENCE |
Column Detail - SCH_WIZARD_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. |
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. |
WIZ_DISPLAY_CD | DOUBLE | N | The unique identifier for the wizard display. |
WIZ_DISPLAY_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the wizard display. |
WIZ_OPTION_CD | DOUBLE | N | The unique identifier for the wizard option. |
WIZ_OPTION_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the wizard option. |
WIZ_TYPE_CD | DOUBLE | N | A unique identifier for the scheduling wizard type. |
WIZ_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling wizard type. |
Relationship Detail - SCH_WIZARD_OPTION
Child Column in SCH_WIZARD_OPTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WIZ_DISPLAY_CD | CODE_VALUE | CODE_VALUE |
WIZ_OPTION_CD | CODE_VALUE | CODE_VALUE | |
WIZ_TYPE_CD | CODE_VALUE | CODE_VALUE |
SCH_WIZARD_PARAM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Wizard Parameters |
Definition: | Scheduling Wizard Parameters |
Table Type: | REFERENCE |
Column Detail - SCH_WIZARD_PARAM
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. |
CDF_MEANING | VARCHAR(12) | Y | The actual string value for the cdf meaning. |
CODE_SET | DOUBLE | N | Code Set |
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. |
DOUBLE_VALUE | DOUBLE | Y | Numeric Value |
DT_TM_VALUE | DATETIME | Y | Date and Time Value |
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. |
EVAL_TYPE_CD | DOUBLE | N | A coded identifier for the evaluation type. |
EVAL_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the evaluation type. |
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. |
STRING_VALUE | VARCHAR(255) | Y | Alphanumeric Value. |
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. |
WIZ_OPTION_CD | DOUBLE | N | The unique identifier for the wizard option. |
WIZ_OPTION_MEANING | VARCHAR(12) | Y | The 12-character description corresponding to the wizard option. |
WIZ_PARAM_NAME | VARCHAR(30) | N | A free textname used to identify scheduling wizard parameters. |
WIZ_TYPE_CD | DOUBLE | N | A unique identifier for the scheduling wizard type. |
WIZ_TYPE_MEANING | VARCHAR(12) | Y | A 12-character description corresponding to the scheduling wizard type. |
Relationship Detail - SCH_WIZARD_PARAM
Child Column in SCH_WIZARD_PARAM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DATA_TYPE_CD | CODE_VALUE | CODE_VALUE |
EVAL_TYPE_CD | CODE_VALUE | CODE_VALUE | |
WIZ_OPTION_CD | CODE_VALUE | CODE_VALUE | |
WIZ_TYPE_CD | CODE_VALUE | CODE_VALUE |