Table Detail Report

SCH_TEMP_FLEX



Column Section Top of Page


Table-level Detail

Description: Scheduling Temporary Flexing Table
Definition: Scheduling Temporary Flexing Table
Table Type: REFERENCE





Column Detail - SCH_TEMP_FLEX


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.
FLEX_SEQ_NBR DOUBLE N The sequence of the flex token within the flex string.
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) N The parent table corresponding to the PARENT2_ID
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) N The parent table corresponding to the PARENT_ID
REQUIRED_IND DOUBLE N Determines if the component is a required member.
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.


SCH_TEXT_LINK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Text Link
Definition: Scheduling Text Link
Table Type: REFERENCE





Column Detail - SCH_TEXT_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.
LAPSE_UNITS DOUBLE N Lapse Units
LAPSE_UNITS_CD DOUBLE N The unique identifier for the lapse units of measure.
LAPSE_UNITS_MEANING VARCHAR(12) Y A 12-character description corresponding to the lapse units of measure.
MODIFIED_DT_TM DATETIME Y The date and time of the last modification.
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_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT2_ID
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_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT3_ID
PARENT3_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT3_ID
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_MEANING VARCHAR(12) Y A 12-character description corresponding to the PARENT_ID
PARENT_TABLE VARCHAR(32) Y The parent table corresponding to the PARENT_ID
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.
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.
TEXT_LINK_ID DOUBLE N The unique identifier for the scheduling text record.
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.



Relationship Detail - SCH_TEXT_LINK


Child Column in SCH_TEXT_LINK(FK) Parent Table Name Parent Column Name
Parents: LAPSE_UNITS_CD CODE_VALUE CODE_VALUE
SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEMPLATE_ACCEPT_CD CODE_VALUE CODE_VALUE
TEXT_ACCEPT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE




Parent Column in SCH_TEXT_LINK (PK) Child Table Name Child Column Name
Children: TEXT_LINK_ID SCH_USER_LINK TEXT_LINK_ID


SCH_UNIT_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Unit Activity
Definition: The relationship between units and activities, used to define which activities are associated with specific units
Table Type: REFERENCE





Column Detail - SCH_UNIT_ACTIVITY


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.
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 N 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.
ACTIVITY_CD DOUBLE N The scheduling activity code (Code Set: 4014000) related to the treatment unit.
BEG_EFFECTIVE_DT_TM DATETIME N 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 N 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.
LOCATION_CD DOUBLE N The treatment unit code (Code Set: 4018001) related to the scheduling activity
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.
SCH_UNIT_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on the SCH_UNIT_ACTIVITY table.
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_UNIT_ACTIVITY


Child Column in SCH_UNIT_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD


SCH_UNIT_PHASE_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling unit and phase schedule
Definition: Contains scheduling relations between a unit and phase, this combination will be tied to an id that can be used on the SCH_BASE_SCHEDULE_ACTIVITY table.
Table Type: REFERENCE





Column Detail - SCH_UNIT_PHASE_SCHEDULE


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.
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 N 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 N 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.
DAY_OF_WEEK VARCHAR(1) Y The day of the week that this activity is associated to. M = Monday, T = Tuesday, W = Wednesday, H = Thursday, F = Friday, S = Saturday, U = Sunday
END_EFFECTIVE_DT_TM DATETIME N 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.
LOCATION_CD DOUBLE N The location code (Code Set: 220) associated with the activity and base schedule.
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.
PHASE_CD DOUBLE N The phase code (Code Set: 4018002) associated with the treatment unit and base schedule.
SCH_UNIT_PHASE_SCHEDULE_ID DOUBLE N Unique generated number that identifies a single row on the SCH_UNIT_PHASE_SCHEDULE table.
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_UNIT_PHASE_SCHEDULE


Child Column in SCH_UNIT_PHASE_SCHEDULE(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD


SCH_WARNING_LEVEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Warning Level
Definition: Scheduling Warning Level
Table Type: REFERENCE





Column Detail - SCH_WARNING_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.
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.
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.
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.



Relationship Detail - SCH_WARNING_LEVEL


Child Column in SCH_WARNING_LEVEL(FK) Parent Table Name Parent Column Name
Parents: WARN_LEVEL_CD CODE_VALUE CODE_VALUE
INFO_SCH_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID