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