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