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