Table Detail Report
SECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Section |
Definition: | Subtable of service resource. Third level in the hierarchy. Below department and above subsection. |
Table Type: | REFERENCE |
Column Detail - SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
EXPEDITE_NURSING_IND | DOUBLE | Y | Used by RadNet. Whether information verified within this section should be expedited to the patient's location. |
NBR_EXAM_ON_REQ | DOUBLE | Y | used by RadNet. Not currently functional as of March 1997. To be deleted |
PRELIM_IND | DOUBLE | Y | Used by RadNet. Whether reports generated within the section can be viewed in a preliminary status. |
SERVICE_RESOURCE_CD | DOUBLE | N | Internal unique identifier for the section. |
TEMP_MULTI_FLAG | DOUBLE | Y | Used by RadNet. Not currently in use. To be deleted. |
TRANSCRIPT_QUE_CD | DOUBLE | N | Used by RadNet. Exams completed within the section, the reports will load to this transcription service resource. |
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 - SECTION
Child Column in SECTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in SECTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SERVICE_RESOURCE_CD | RAD_WORKLIST_SECTION_R | SERVICE_RESOURCE_CD |
SERVICE_RESOURCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Service Resource |
Definition: | The primary table for person (role), place or thing that performs work. Holds all levels of the hierarchy including Institutions, Departments, Sections, Subsections, and the fifth level which varies dependent upon the discipline. |
Table Type: | REFERENCE |
Column Detail - SERVICE_RESOURCE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCN_SITE_PREFIX | CHAR(5) | Y | Used by SurgiNet. Associated with a Surgical Staging Area. Used when generating an OR Case numberwhen a surgical procedure is requested. User defined. |
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. |
ACTIVITY_SUBTYPE_CD | DOUBLE | N | A filtering mechanism for service resource cdf_meanings which are used across disciplines (such as subsection). The user selects the subtype when adding the service resource. Programmatically an application can return a subset of resources with a specific subtype. |
ACTIVITY_TYPE_CD | DOUBLE | N | A filtering mechanism for service resource cdf_meanings which are used across disciplines (such as section). The user selects the activity type when adding the service resource. Programmatically an application can return a subset of resources with a specific activity type. |
AUTOLOGIN_IND | DOUBLE | Y | Determines whether or not to perform a login of the specimen container when results are posting from an MDI. |
AUTO_VERF_IND | DOUBLE | Y | Allows the user to indicate whether results posted from this resource should be automatically verified without human intervention or review. |
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. |
CLIA_NUMBER_TXT | VARCHAR(40) | N | CLIA Number in text format. The Clinical Laboratory Improvement Act number associated with the service resource. |
COLLECTED_DOWNLOAD_IND | DOUBLE | N | Will be used to determine whether an accn will be downloaded to an instrument when it is collected(true) or whether it will be downloaded when it is either logged into lab or dispatched(false) |
CS_LOGIN_LOC_CD | DOUBLE | N | Used by PathNet. Determines whether a specimen is 'in lab' and ready for processing. When a specimen is logged in, the login app prompts for a login location. It compares that login location to the resource's login location. If they are different, the specimen isn't considered 'in lab' and will not appear on pending worklists, etc.. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
DISCIPLINE_TYPE_CD | DOUBLE | N | A filtering mechanism for service resource cdf_meanings which are used across disciplines (such as department). The user selects the discipline when adding the service resource. Programmatically an application can return a subset of resources with a specific discipline. |
DISPATCH_DOWNLOAD_IND | DOUBLE | Y | Will be used to determine whether an accn will be downloaded to an instrument when it is dispatched(true) or whether it will be downloaded when it is either logged into lab or in collected status(false). |
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. |
EXCEPT_EXIST_IND | DOUBLE | Y | Used to determine whether an exception to the calendar for the resource exists (i.e., down on New Year's Day even though it falls on a Monday which is normally an open day). |
INSTANCE_ID | DOUBLE | N | Not currently in use. To be Obsoleted. |
INVENTORY_RESOURCE_CD | DOUBLE | N | Filled out for pharmacy subsections. If the pharmacy subsection maintains their inventory at a different service_resource, this indicates which pharmacy has the inventory. |
INV_LOCATION_CD | DOUBLE | N | Identifies the related inventory location for a primary service resource. |
LOCATION_CD | DOUBLE | N | The physical location of the service resource. A unique internal identifier. |
MEDICAL_DIRECTOR_NAME | VARCHAR(100) | N | Medical Dirctor Name associated with the Service Resource. |
OPER_MODE | CHAR(1) | Y | Identifies interface functionality with regards to bidirectional, unidirectional or Host Query. B, U, or Q respectively. |
ORGANIZATION_ID | DOUBLE | N | A unique internal identifier for the organization to which the service resource is associated. |
PAT_CARE_LOC_IND | DOUBLE | Y | Used by pharmacy to indicate that this resource is located in a nurse unit rather than in the pharmacy. |
PHARMACY_TYPE_CD | DOUBLE | N | If the service resource is a pharmacy section or subsection, indicates the type of pharmacy from code_set 4500. Currently home infustion, long term care, inpatient, mail order, and retail. |
RUN_TMPLT_CD | DOUBLE | N | The rule by which the system will determine how large a (lab) instrument's run can be which will impact how often quality control is run. Examples include: the number of accns, certain number of minutes, by shift, etc. This column is not being used. |
RX_CHARGE_IND | DOUBLE | Y | For Unit Based Cabinets this indicates whether the dispense event should always be charged thus overriding the dispense category settings. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique internal identifier for this service resource. |
SERVICE_RESOURCE_TYPE_CD | DOUBLE | N | Service resource type defines the kind of resource (I.e., department, section, exam room. instrument, etc.). Service Resource types have Cerner defined meanings in the common data foundation. |
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. |
VIEW_TYPE_CD | DOUBLE | N | View Type. Archived; Replaced by Root_cd. The conversion utility uses this field though to fill out root_cd. LOC_CONVERT_VIEW_TYPES. |
Relationship Detail - SERVICE_RESOURCE
Child Column in SERVICE_RESOURCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | VIEW_TYPE_CD | CODE_VALUE | CODE_VALUE |
LOCATION_CD | LOCATION | LOCATION_CD | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
Parent Column in SERVICE_RESOURCE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SERVICE_RESOURCE_CD | AP_PREFIX | SERVICE_RESOURCE_CD |
ASSAY_PROCESSING_R | LOADED_SERVICE_RESOURCE_CD | ||
ASSAY_PROCESSING_R | SERVICE_RESOURCE_CD | ||
ASSAY_RESOURCE_LIST | SERVICE_RESOURCE_CD | ||
ASSAY_RESOURCE_LOT | SERVICE_RESOURCE_CD | ||
AUTO_VERIFY | SERVICE_RESOURCE_CD | ||
AV_RES_CAT | SERVICE_RESOURCE_CD | ||
BB_INVENTORY_AREA | SERVICE_RESOURCE_CD | ||
BILL_ONLY_SUBSECT_RELTN | SERVICE_RESOURCE_CD | ||
BMDI_ACQUIRED_DATA_TRACK | DEVICE_CD | ||
BMDI_DEVICE_NOMENCLATURE | DEVICE_CD | ||
BMDI_DEVICE_PARAMETER | DEVICE_CD | ||
BMDI_MONITORED_DEVICE | ALTERNATE_DEVICE_CD | ||
BMDI_MONITORED_DEVICE | DEVICE_CD | ||
CALENDAR_EXCEPTION | SERVICE_RESOURCE_CD | ||
CONCEPT_IDENTIFIER_DTA | SERVICE_RESOURCE_CD | ||
CONTAINER_EVENT | FROM_SERVICE_RESOURCE_CD | ||
CONTAINER_EVENT | SERVICE_RESOURCE_CD | ||
CV_STEP | PERF_LOC_CD | ||
CV_STEP_SCHED | SCHED_LOC_CD | ||
CYTO_ALPHA_SECURITY | REQUEUE_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | ABNORMAL_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | ATYPICAL_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | CHR_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | NORMAL_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | OVER_SERVICE_RESOURCE_CD | ||
CYTO_SCREENING_SECURITY | UNSAT_SERVICE_RESOURCE_CD | ||
DEPARTMENT | SERVICE_RESOURCE_CD | ||
DEVICE_HL7_MAP | DEVICE_CD | ||
DI_CLIENT_CONFIG | SERVICE_RESOURCE_CD | ||
EXAM_FOLDER | LIB_GROUP_CD | ||
IMAGE_CLASS_TYPE | DEFAULT_RETURN_LOCN_CD | ||
IMAGE_CLASS_TYPE | DEFAULT_TRACKING_POINT_CD | ||
IMAGE_CLASS_TYPE | LIB_GROUP_CD | ||
IM_DEVICE | SERVICE_RESOURCE_CD | ||
INSTR_ACCN_QUEUE | SERVICE_RESOURCE_CD | ||
INTERP_DATA | SERVICE_RESOURCE_CD | ||
INTERP_TASK_ASSAY | SERVICE_RESOURCE_CD | ||
ITEM_SR_LOC_R | SERVICE_RESOURCE_CD | ||
LAB_BENCH | SERVICE_RESOURCE_CD | ||
LIBRARY_GROUP | SERVICE_RESOURCE_CD | ||
LOC_RESOURCE_R | SERVICE_RESOURCE_CD | ||
MAMMO_FOL_UP_LETTER_SECT | SERVICE_RESOURCE_CD | ||
MAMMO_STUDY | SUBSECTION_CD | ||
MDI_PARAMETER | SERVICE_RESOURCE_CD | ||
MIC_ABN_ORG_RESPONSE_CODE | SERVICE_RESOURCE_CD | ||
MIC_ABN_SUS_RESULT | SERVICE_RESOURCE_CD | ||
MIC_ACT_ANG_SUM_RPT | SERVICE_RESOURCE_CD | ||
MIC_ANG_AUTOMATED | INSTR_RESOURCE_CD | ||
MIC_ANG_AUTOMATED | SERVICE_RESOURCE_CD | ||
MIC_ANG_TIMES | SERVICE_RESOURCE_CD | ||
MIC_EVENT_LOG | SERVICE_RESOURCE_CD | ||
MIC_GROUP_RESPONSE | SERVICE_RESOURCE_CD | ||
MIC_INSTR_TRANS | SERVICE_RESOURCE_CD | ||
MIC_MEDIA_DEFAULT | SERVICE_RESOURCE_CD | ||
MIC_ORDER_LAB | SERVICE_RESOURCE_CD | ||
MIC_REF_ANG | SERVICE_RESOURCE_CD | ||
MIC_REF_BILLING_AB | SERVICE_RESOURCE_CD | ||
MIC_REF_BILLING_SUS | SERVICE_RESOURCE_CD | ||
MIC_REF_BIO_FORMAT | SERVICE_RESOURCE_CD | ||
MIC_REPORT_CORRELATION | SERVICE_RESOURCE_CD | ||
MIC_RPT_PARAMS | SERVICE_RESOURCE_CD | ||
MIC_STAIN_CORRELATION | SERVICE_RESOURCE_CD | ||
MIC_TASK_LOG | TASK_LOCATION_CD | ||
MIC_VALID_SUS_PANEL | SERVICE_RESOURCE_CD | ||
MIC_WORKCARD_CORRELATION | SERVICE_RESOURCE_CD | ||
MM_INSTANCE | MFR_CD | ||
MM_XFI_INSTANCE | MFR_CD | ||
MM_XFI_QOH | MANUF_CD | ||
ORGANIZATION_RESOURCE | SERVICE_RESOURCE_CD | ||
PROCESSING_TASK | SERVICE_RESOURCE_CD | ||
PROFILE_RESOURCE_LIST | SERVICE_RESOURCE_CD | ||
PULL_LIST_CONTROLS | SERVICE_RESOURCE_CD | ||
QC_ALPHA_RESPONSES | SERVICE_RESOURCE_CD | ||
QC_TROUBLE_STEP | SERVICE_RESOURCE_CD | ||
RAD_DEF_SERV_RES | DEF_SER_RES_CD | ||
RAD_DEF_SERV_RES | SERVICE_RESOURCE_CD | ||
RAD_EXAM_ROOM | SERVICE_RESOURCE_CD | ||
RAD_FOLD_TRANS_RULE | FROM_LIB_CD | ||
RAD_FOLD_TRANS_RULE | TO_LIB_CD | ||
RAD_FOLLOW_UP_PRINT_CTRL | DEPARTMENT_CD | ||
RAD_FOLLOW_UP_PRINT_CTRL | SECTION_CD | ||
RAD_FOLLOW_UP_PRINT_CTRL | SUBSECTION_CD | ||
RAD_FOL_UP_CONTROL_SECT | SERVICE_RESOURCE_CD | ||
RAD_IMAGE_SYS_CONTROLS | SERVICE_RESOURCE_CD | ||
RAD_PROTOCOL_CATALOG_R | SERVICE_RESOURCE_CD | ||
RAD_REQ_CONTROLS | SERVICE_RESOURCE_CD | ||
RAD_SYS_CONTROLS | SERVICE_RESOURCE_CD | ||
RAD_TRACKING_CONTROLS | SERVICE_RESOURCE_CD | ||
REPORT_TASK | SERVICE_RESOURCE_CD | ||
RESOURCE_ACCESSION_R | SERVICE_RESOURCE_CD | ||
RESOURCE_ASSAY_CONTROL | SERVICE_RESOURCE_CD | ||
RESOURCE_GROUP | CHILD_SERVICE_RESOURCE_CD | ||
RESOURCE_GROUP | PARENT_SERVICE_RESOURCE_CD | ||
RESOURCE_LOT_R | SERVICE_RESOURCE_CD | ||
ROLE | SERVICE_RESOURCE_CD | ||
RXA_ORD_DISP_HP_OBS_ST | DISP_FROM_SR_CD | ||
RXA_WORK_LOAD_OBS_ST | DISP_FROM_SR_CD | ||
RXS_ALERT | RXS_DEVICE_SR_CD | ||
RXS_ITEM_COUNTBACK | SERVICE_RESOURCE_CD | ||
RXS_LOCATION_TASK | SERVICE_RESOURCE_CD | ||
RXS_LOC_SR_EVENT_RELTN | SERVICE_RESOURCE_CD | ||
RXS_TASK_SR_HX | SERVICE_RESOURCE_CD | ||
RX_HEALTH_PLAN_SERV_RES_R | SERVICE_RESOURCE_CD | ||
RX_LOC_RESOURCE_RELTN | SERVICE_RESOURCE_CD | ||
RX_SCRIPT_TRANSFER_HX | SERVICE_RESOURCE_CD | ||
RX_SCRIPT_TRANSFER_HX | XFER_SERVICE_RESOURCE_CD | ||
SCH_APPT | SERVICE_RESOURCE_CD | ||
SCH_RESOURCE | SERVICE_RESOURCE_CD | ||
SECTION | SERVICE_RESOURCE_CD | ||
SERVICE_RESOURCE_LAB_TYPE_R | SERVICE_RESOURCE_CD | ||
SERV_RES_EXT_PHARM | SERVICE_RESOURCE_CD | ||
SERV_RES_IDENTIFIER | SERVICE_RESOURCE_CD | ||
SUB_SECTION | SERVICE_RESOURCE_CD | ||
SUB_SECTION | TRANSCRIPT_QUE_CD | ||
SURG_RESOURCE_STATUS | SERVICE_RESOURCE_CD | ||
TECHNIQUE_DEFAULTS | DEPARTMENT_CD | ||
TECHNIQUE_DEFAULTS | EXAM_ROOM_CD | ||
TRACK_PT_LIBRARY | SERVICE_RESOURCE_CD | ||
VENDOR | SERVICE_RESOURCE_CD |
SERVICE_RESOURCE_LAB_TYPE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Service Resource Lab Type Relation |
Definition: | This table stores the Lab Type relationships to Service Resources |
Table Type: | REFERENCE |
Column Detail - SERVICE_RESOURCE_LAB_TYPE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
LAB_TYPE_CD | DOUBLE | N | A related Lab Type Code for the given Service Resource |
SERVICE_RESOURCE_CD | DOUBLE | N | The related Service Resource Code from the Service Resource 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 - SERVICE_RESOURCE_LAB_TYPE_R
Child Column in SERVICE_RESOURCE_LAB_TYPE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
SR_RESOURCE_GROUP_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Service Resource Resource Group History |
Definition: | History table used to track active relationships between parent and child service resources. |
Table Type: | REFERENCE |
Column Detail - SR_RESOURCE_GROUP_HIST
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. |
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. |
CHILD_SERVICE_RESOURCE_CD | DOUBLE | N | The "child" in a resource to resource relationship. If the relationship is Department to Section, Department is the "parent" and Section is the "child". It is a unique internal identifier. |
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_SERVICE_RESOURCE_CD | DOUBLE | N | The "parent" in a resource to resource relationship. If the relationship is Department to Section, Department is the "parent" and Section is the "child". It is a unique internal identifier. |
RESOURCE_GROUP_TYPE_CD | DOUBLE | N | The definition of the relationship. Generally it is the resource type associated with the parent's resource type. Each type has a Cerner defined cdf_meaning associated with it. |
ROOT_SERVICE_RESOURCE_CD | DOUBLE | N | Used when creating "views". It is the internal identifier for the highest resource node in the view. Used to programmatically retrieve all levels in a view quickly. If the view is the "Master", root code will be zero. |
SR_RESOURCE_GROUP_HIST_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
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 - SR_RESOURCE_GROUP_HIST
Child Column in SR_RESOURCE_GROUP_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_SERVICE_RESOURCE_CD | RESOURCE_GROUP | CHILD_SERVICE_RESOURCE_CD |
PARENT_SERVICE_RESOURCE_CD | RESOURCE_GROUP | PARENT_SERVICE_RESOURCE_CD | |
RESOURCE_GROUP_TYPE_CD | RESOURCE_GROUP | RESOURCE_GROUP_TYPE_CD | |
ROOT_SERVICE_RESOURCE_CD | RESOURCE_GROUP | ROOT_SERVICE_RESOURCE_CD |
SUB_SECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Sub Section |
Definition: | The Sub_Section table is a child of the service resource table and contains information specific to sub sections. |
Table Type: | REFERENCE |
Column Detail - SUB_SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
CQM_ALIAS_NAME | CHAR(48) | Y | The destination for inbound results. Applies to direct download and host query bidirectional interfaces. Similar to version 300's Transmit Queue (TQ) file. Used by the instrument interface team. |
CQM_APP_NAME | CHAR(12) | Y | The destination for inbound results. Applies to direct download and host query bidirectional interfaces. Similar to version 300's Transmit Queue (TQ) file. Used by the instrument interface team. |
ID_MAP_JULIAN | CHAR(18) | Y | This field represents which digits of the full Julian accession number should be used when generating the Instrument Id Number. The value should consist of a string of 0's and 1's with the 1's representing the digits that should be used to generate the Id number. Example for Vitek: "000000000011001111" This will generate an Id number with the last two digits of the Julian date and the last four digits of the sequence number. |
ID_MAP_PREFIX | CHAR(18) | Y | This field represents which digits of the full prefixed accession number should be used when generating the Instrument Id Number. The value should consist of a string of 0's and 1's with the 1's representing the digits that should be used to generate the Id number. |
ID_NBR_SIZE | CHAR(2) | Y | This field represents the size of the Id number that should be generated based on the limitations of the instrument. This does NOT include the isolate number when determining the size. For Vitek the value should be "06". |
ID_TYPE | CHAR(1) | Y | This field represents whether the Id number should be numeric or alpha numeric based on the instrument limitations. For Vitek it should be "N". |
INSTRU_TYPE | DOUBLE | Y | Indicates how the interface should write the outbound download record when duplicate procedures within an order. There are there option for the instrument type. 1 = insert download records with lock trigger and update logic turned on. This is normally use for direct download 2 = Insert download records with lock trigger and no update turned on. This is normally use for direct download 3 = Insert tq with no trigger but with update logic turned on. This is normally used with host query |
INSTR_ALIAS | VARCHAR(100) | Y | Description of the instrument. User defined. |
INSTR_NAME | CHAR(20) | Y | For future use with multiplexor logic. |
INTFC_PROGNAME | CHAR(15) | Y | Contains the interface program name for the service resource. |
ISOLATE_NBR_SIZE | CHAR(1) | Y | This field represents the length of the isolate number. The isolate number will be appended to the end of the id number making the full id number that gets generated at susceptibility order time. For Vitek it should be "1". |
ISOLATE_TYPE | CHAR(1) | Y | This field represents how the isolate number should be generated. If it is set to "0" then the isolate number will match with the organism number that the susceptibility is being ordered on. If the susceptibility is ordered on Organism number 2 then the isolate number will be 2. If it is set to "1" then the isolate number will be set to the number of susceptibilities that have been ordered for that accession. It will increment by one with each susceptibility order on the accession. |
MULTIPLEXOR_ALIAS | CHAR(20) | Y | Identifies the name/code that a multiplexor sends back to MDI via the MDI interface. |
MULTIPLEXOR_IND | DOUBLE | Y | Used to identity if the subsection is a multiplexor. Is 1 if the subsection is a multiplexor, 0 if it is not. |
OPER_MODE | CHAR(1) | Y | Identifies interface functionality with regards to bidirectional, unidirectional or Host Query. B, U, or Q respectively. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd is a foreign key to the Service_Resource table. It uniquely identifies a sub section. |
STATION | CHAR(4) | Y | Defines the VMS logical that the interface will use to connect to the analyzer. |
STRT_MODEL_ID | DOUBLE | Y | The internal identifier for the instrument's Model. These model id's are a Cerner defined reference database |
TRANSCRIPT_QUE_CD | DOUBLE | N | Used by RadNet. The Transcipt_Que_Cd identifies the transcription workgroup that reports, within this sub section, will be queued to. |
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. |
VERBOSITY | CHAR(1) | Y | Defines the level of journaling by the interface program to the capture files. Off, On, or Debug levels. |
Relationship Detail - SUB_SECTION
Child Column in SUB_SECTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
TRANSCRIPT_QUE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |