Table Detail Report
SCH_CODE_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Code Group Reference |
Definition: | Scheduling Code Group Reference |
Table Type: | REFERENCE |
Column Detail - SCH_CODE_REF
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. |
ALLOW_MODIFY_IND | DOUBLE | N | Denotes if the user is allowed to modify enteries for this code group. |
ALLOW_SEQUENCE_IND | DOUBLE | N | Denotes if the user is allowed to order enteries for this code group. |
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. |
CODE_GROUP_ID | DOUBLE | N | The numeric identifier for the code value group. An Oracle sequence is not used to populate this PK. The number is loaded by a Cerner supplied csv. |
CODE_GROUP_MEANING | VARCHAR(30) | N | A 30 character description corresponding to the code group identifier. |
CODE_SET | DOUBLE | N | Denotes the codeset of valid values for the code group. |
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 |
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_CODE_REF
Child Column in SCH_CODE_REF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_SET | CODE_VALUE_SET | CODE_SET |
INFO_SCH_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SCH_COMP_LOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Appointment Type Component Locations |
Definition: | Define the valid locations for a protocol component |
Table Type: | REFERENCE |
Column Detail - SCH_COMP_LOC
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. |
APPT_TYPE_CD | DOUBLE | N | The identifier for an appointment type. |
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. |
COMP_LOCATION_CD | DOUBLE | N | The unique identifier for the component location. |
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. |
LOCATION_CD | DOUBLE | N | The field identifies the current permanent location of the patient. |
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 the record became historical. |
Relationship Detail - SCH_COMP_LOC
Child Column in SCH_COMP_LOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMP_LOCATION_CD | LOCATION | LOCATION_CD |
LOCATION_CD | LOCATION | LOCATION_CD | |
APPT_TYPE_CD | SCH_APPT_COMP | APPT_TYPE_CD | |
LOCATION_CD | SCH_APPT_COMP | LOCATION_CD | |
SEQ_NBR | SCH_APPT_COMP | SEQ_NBR |
SCH_DATA_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | schedule data comment |
Definition: | schedule data comment |
Table Type: | REFERENCE |
Column Detail - SCH_DATA_COMMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.) |
SCH_DATA_COMMENT_ID | DOUBLE | N | schedule data comment identifier |
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.) |
TEXT_ID | DOUBLE | N | text identifier |
TEXT_TYPE_CD | DOUBLE | N | text type 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. |
Relationship Detail - SCH_DATA_COMMENT
Child Column in SCH_DATA_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SCH_DATE_APPLY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Date Apply |
Definition: | Stores the resource and date to which the resource template is going to apply. |
Table Type: | REFERENCE |
Column Detail - SCH_DATE_APPLY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | N | Action_flag is used to determine what action to take for the date. 0 - No Change, 1 - Add Template, 2 - Change Template, 3 - Delete Template. |
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. |
APPLY_STATUS_CD | DOUBLE | N | Indicates the status. Some examples are applied, duplicated or requested. |
RESOURCE_CD | DOUBLE | N | The identifier for the resource. A resource is an item of limited availability. Associates the date to a resource. |
RES_GROUP_ID | DOUBLE | N | The unique identifier for the resource group associated to the date. |
SCH_DATE_APPLY_ID | DOUBLE | N | The unique primary key of this table. It is internally generated. |
SCH_DATE_DT_TM | DATETIME | N | The date associated to the date set. This column was duplicated from the SCH_DATE_LIST table for performance reasons. |
SCH_DATE_LIST_ID | DOUBLE | N | Identifies what date the resource is associated to. It is the primary key of the SCH_DATE_LIST 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. |
Relationship Detail - SCH_DATE_APPLY
Child Column in SCH_DATE_APPLY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCH_DATE_LIST_ID | SCH_DATE_LIST | SCH_DATE_LIST_ID |
RESOURCE_CD | SCH_RESOURCE | RESOURCE_CD | |
RES_GROUP_ID | SCH_RES_GROUP | RES_GROUP_ID |
SCH_DATE_LINK_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Scheduling Date Link Relationship |
Definition: | Stores the links between a date set in SCH_DATE_SET to resources from SCH_RESOURCE, resource groups from SCH_RES_GROUP and scheduling templates from SCH_DEF_APPLY. |
Table Type: | REFERENCE |
Column Detail - SCH_DATE_LINK_R
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. |
DATE_SET_SEQ_NBR | DOUBLE | N | Used to identify the order of the display of date sets on the screen. Each date set will have a different order sequence number. |
PARENT_ENTITY_ID | DOUBLE | N | The ID of the table row for the table represented by the parent_entity_name. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The table which is being referenced. A row in this table will be associated to the schedule date set. |
SCH_DATE_LINK_R_ID | DOUBLE | N | The unique primary key of this table. It is internally generated. |
SCH_DATE_SET_ID | DOUBLE | N | The ID of the date set that is associated to a row in the table identified in column parent_entity_name. It is the primary key of the SCH_DATE_SET 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. |
Relationship Detail - SCH_DATE_LINK_R
Child Column in SCH_DATE_LINK_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCH_DATE_SET_ID | SCH_DATE_SET | SCH_DATE_SET_ID |