Table Detail Report

SCH_USER_LINK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling User Link
Definition: Scheduling User Link
Table Type: ACTIVITY





Column Detail - SCH_USER_LINK


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.
EXPERTISE_LEVEL DOUBLE N The number of times a user would have to view an object before they are considered an expert.
LAST_SEEN_DT_TM DATETIME Y The date and time of the last time the readme was checked.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned number.
TEXT_LINK_ID DOUBLE N The unique identifier for the scheduling text record.
TOTAL_COUNTER DOUBLE Y A counter used to track the number of times a user has viewed a specific template.
TOTAL_SECONDS DOUBLE Y A summation of the number of seconds a user has spent viewing the template.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_USER_LINK


Child Column in SCH_USER_LINK(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
TEXT_LINK_ID SCH_TEXT_LINK TEXT_LINK_ID


SCH_WARNING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Warning
Definition: This table is where the scheduling warning overrides created by the user are stored.
Table Type: ACTIVITY





Column Detail - SCH_WARNING


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.
AUTHORIZED_PRSNL_ID DOUBLE N The ID of the personnel who gives permission to override the warning. It is a foreign key to the PRSNL table.
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.
COMMENT_TEXT_ID DOUBLE N Used to store the override comment when the client tries to override the warning.
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.
PARENT2_ID DOUBLE N The unique identifier of the parent object.
PARENT2_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT2_ID
PARENT3_ID DOUBLE N The unique identifier of the parent object.
PARENT3_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT3_ID
PARENT4_ID DOUBLE N The unique identifier of the parent object.
PARENT4_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT4_ID
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT_ID
SCH_WARN_ID DOUBLE N The unique identifier for the scheduling warning.
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.
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_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_DT_TM DATETIME Y The date and time was warning was generated.
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_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that created the warning.
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_STATE_CD DOUBLE N A unique identifier for the current state of the warning.
WARN_STATE_MEANING VARCHAR(12) Y A 12-char description corresponding to the current warning state.
WARN_TYPE_CD DOUBLE N The unique identifier for the scheduling warning type.
WARN_TYPE_MEANING VARCHAR(12) N The 12-character description corresponding to the scheduling warning type.



Relationship Detail - SCH_WARNING


Child Column in SCH_WARNING(FK) Parent Table Name Parent Column Name
Parents: WARN_BATCH_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_REASON_CD CODE_VALUE CODE_VALUE
WARN_STATE_CD CODE_VALUE CODE_VALUE
WARN_TYPE_CD CODE_VALUE CODE_VALUE
COMMENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
AUTHORIZED_PRSNL_ID PRSNL PERSON_ID
WARN_PRSNL_ID PRSNL PERSON_ID