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 |