You are here: Revised Table Definitions > FO_LabInfo

FO_LabInfo

This table contains a single row.

 

Field

Type

Notes

labinfo_id

INT

Identity (counter) field

labname

varchar(50)

Laboratory name on the login screen and reports

labcode

varchar(20)

Code value for this lab.

labaddress1

varchar(50)

Address field on reports .

labaddress2

varchar(50)

Second address field on reports .

labaddress3

varchar(50)

Third address field on reports.

labaddress4

varchar(50)

Fourth address field on reports

labdirector

varchar(50)

Name of lab director on reports.

misc1

varchar(50)

Login screen user defined field #1.

misc2

varchar(50)

Login screen user defined field #2.

misc3

varchar(50)

Login screen user defined field #3.

misc4

varchar(50)

Login screen user defined field #4.

misc5

varchar(50)

Login screen user defined field #5.

useverify

int

Use 1

Do NOT change without Rhodes Group approval.

usemandatorysteps

int

Use 1

Do NOT change without Rhodes Group approval.

barcode_security

decimal(18, 2)

Use 1

Do NOT change without Rhodes Group approval.

barcode_xunit

decimal(18, 2)

Use 150.00

Do NOT change without Rhodes Group approval.

barcode_yunit

decimal(18, 2)

Use 5.00

Do NOT change without Rhodes Group approval.

def_ptloccode

varchar(20)

Default patient location code on the order screen.

Use valid patient location code.

def_epi_days

int

Use 30

Do NOT change without Rhodes Group approval.

epi_ins_options

varchar(100)

Populates insurance option drop-down list on the episode definition screen.

Multidimensional pipe delimited value.

Use valid insurance options separated by pipes with leading and trailing pipes.

IE: |INS1|INS2|INS3|

epi_billto_options

varchar(100)

Populates billto option drop-down list on the episode definition screen.

Multidimensional pipe delimited value.

Use valid bill to options separated by pipes with leading and trailing pipes.

IE: |P|C|I|

SO_review_days

int

Default number of days before a standing order expires and requires review.

Use an integer.

Used to calculate the number of days until standing order expiration.

IE: 180

resultsysurl

varchar(255)

URL to connect to a client-provided lab result portal.

Use a valid URL.

The URL may contain place holders for user name and password for the lab system.

IE: HTTP://LabPortal.com /#USERNAME#/#PASSWORD#

blockmrlength

varchar(80)

Mask for MRN entry value.

Multidimensional pipe delimited value.

Use integers separated by pipes with leading and trailing pipes.

Each number represents a MRN entry length that is NOT supported by the system.

IE: |1|2|3|4|5|6|7|9|10|11|12|13|14|

In this example, the MRN entry must be either 8 characters long or longer than 14 characters.

ADT_Interface

varchar(255)

Default value for the Outbound ADT system interface.

Use Rhodes Group recommended value.

OE_Interface

varchar(255)

Default value for the Outbound OE system interface.

Use Rhodes Group recommended value.

Result_Interface

varchar(255)

Default value for the Outbound RE system interface.

Use Rhodes Group recommended value.

logoimagefile

varchar(255)

The network path and file name for the logo file used on screen and report displays.

Use a valid network path and file name.

The file must be a GIF or JPG image approximately 100x125 pixels.

defaultfacilityid

varchar(50)

Default system facility ID code.

Use a valid facility ID code.

defaultspeciescode

varchar(50)

Default species code.

H = HUMAN

defaultspeciesname

varchar(50)

Default species name corresponding to the default species code.

HUMAN

def_clientcode

varchar(50)

Default system client ID code.

Use a valid client ID code.

defOrdScreenReq

varchar(80)

Default requisition report name used when the REQ button on the order screen is clicked.

Default used when the user-level value is not defined.

Required value.

Use Rhodes Group recommended value.

callback_callcode

varchar(50)

Value for “Call” for callback systems.

Used when the CALL button on the order screen phone definitions is clicked.

callback_faxcode

varchar(50)

Value for “Fax” for callback systems.

Used when the Fax button on the order screen phone definitions is clicked.

mrnumgenerationroutine

varchar(50)

Automatically generates an MRN number on the patient data screen.

Use Rhodes Group recommended value.

Typical value: ALPHA4NUMBER4

PasswordExpirationDays

int

Number of days before a user password expires and must be reset.

Use an integer.

Def_Areacode

varchar(50)

Default for area code.

Use an integer, a valid area code.

Used on the patient demographic screen if area code is not provided.

AutoOrderCodeWhenCCDoc

varchar(50)

Used to order tests automatically when copy to physician is used on the order screen.

Multidimensional pipe delimited value.

Use valid order test codes separated by pipes with leading and trailing pipes.

MrNumMask

varchar(50)

Medical record number mask used to validate the MRN field on the order screen.

Use “#” to represent numbers and “@” to represent alpha characters.

Typical setting: @@@@####

CallToOrderCode

varchar(50)

Used in the mini window for call/fax to automatically order a test code when the CALL button is clicked on the order screen.
Use a valid order code.

FaxToOrderCode

varchar(50)

Used in the mini window for call/fax to automatically order a test code when the FAX button is clicked on the order screen.
Use a valid order code.

FastingOrderCode

varchar(50)

Used to automatically order a test if the fasting priority is selected at the order level on the order screen. The rule is activated at the time the VERIFY button is clicked.

Use a valid order code.

PastOrderDays

int

Number of days back that the system will allow a user to create a new order.

Use an integer.

The collection date is evaluated and if the order is too old, a warning message will be displayed.

FutureOrderDays

int

Number of days in the future that the system will allow a user to create a new order.

Use an integer.

The collection date is evaluated and if the order is too far in the future, a warning message will be displayed.

ReqID_Mask

varchar(50)

Mask used to validate the requisition ID on the order screen.

Use “#” to represent numbers and “@” to represent alpha characters.

Typical setting: ########

This setting requires an 8 character numeric only entry.

ReqID_Exclude_Characters

varchar(80)

Defines the characters to exclude from the requisition ID value.

Multidimensional COMMA delimited value.

Use the characters, separated by commas, that should be excluded from the requisition ID value on the order screen.

ReqID_Length_Range

varchar(50)

Represents the minimum and maximum number of characters allowed in the requisition ID field on the order screen.

Use an integer then a dash then an integer.

Do not enter a value here if an edit mask is defined for the requisition ID field.

IE: 10-15

If the value is "10-15", then an entry between 10 and 15 characters long is allowed.

DefaultPerformingLab

varchar(50)

Default performing lab code value.

Use a valid performing lab code value.

Used to supply a performing lab code to the system when one is required and not provided by rules.

DefaultBatchDestination

varchar(50)

Default batch destination code.

Use a valid batch destination code.

Used if not provided by rules for transport logic.

AccessionFormat

varchar(50)

Drives the routines that creates unique FP accessions and container IDs.

Use Rhodes Group recommended value.

Allowed values:

ENTRYGROUPCODE = use entry group code to derive format.

7SEQ = create a 7 character unique number

8SEQ = create a 8 character unique number

9SEQ = create a 9 character unique number

10SEQ = create a 10 character unique number

11SEQ = create a 11 character unique number

12SEQ = create a 12 character unique number

TestCompDupExcludeDept

varchar(50)

Excludes tests from certain departments from being evaluated for overlapping test codes if they are a battery.

Multidimensional pipe delimited value.

Use valid department codes separated by pipes with leading and trailing pipes.

Used to order tests automatically when copy to physician is used on the order screen.

IE: |BB|MC|CY|PATH|

If this field is blank, the system will default to |MC|BB|CY| and will exclude those departments from test overlap/duplication logic.

DisplayBDEFields

varchar(50)

Determines which fields to display in the blind duplicate entry screen.

Multidimensional pipe delimited value.

Use allowed values shown below separated by pipes with leading and trailing pipes.

The default value of |ALL| may be used to display all fields.

Allowed values:

M = MRN

N = pt name

D = DOB

S = gender

T = telephone

C = client

L = location

P = physician

E = test related fields

CC1 = copy to 1

CC2 = copy to 2

CC3 = copy to 3

CC4 = copy to 4

ADD = address fields

TestCompDupExcludeTests

varchar(500)

Defines the test codes to exclude from the test overlap/duplication logic during order entry.

Multidimensional pipe delimited value.

Use valid battery test codes separated by pipes with leading and trailing pipes.

Any battery test codes in this list will not be evaluated for test overlap.

SalesTaxUserLoc

varchar(100)

Defines the user locations and their corresponding sales tax to be used for price calculations on the payments screen.

Multidimensional pipe delimited value.

Use valid user location code - sales tax percent pairs. Include a leading and trailing pipe.

Each value in a pair is separated by a dash.

IE: |USERLOC1-6.5|USERLOC2-6|

LabAccessionAlphaCharacters

varchar(50)

Represents the letters used in the lab accession generation when FP will pre-generate it and send it to the LIS.

Multidimensional pipe delimited value.

Use single capital letters separated by pipes with leading and trailing pipes.

IE: |A|Q|Z|

LabAccessionFormat

varchar(50)

Defines format for creation of lab accession values.

Use Rhodes Group recommended value.

IE: 1A,8N

The format "1A,8N" generates lab accessions that are one alpha character followed by 8 numeric characters.

PaymentTypes

varchar(100)

Populates the payment type drop-down on the payment screen.

Multidimensional pipe delimited value.

Use valid payment type codes separated by pipes with leading and trailing pipes.

IE: |CARD|CHECK|CASH|

PaymentCardTypes

varchar(100)

Multidimensional pipe delimited value.

Use valid credit card type codes separated by pipes with leading and trailing pipes.

Populates the credit type drop-down on the payment screen.

IE: |AMEX|VISA|DINNERS|DEBIT|

AutoCCORDCode

varchar(50)

Default test code for the ordering physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes.

The system will automatically enter the physician code for the order if the answer test code matches this value.

Use a valid test code.

Used to send the ordering physician values to a client as a test code in a lab report.

AutoCCccCode

varchar(50)

Default test code for copy to physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes.

The system will automatically enter the copy to codes for the order if the answer test code matches this value.

Use a valid test code.

Used to send the copy to physician values to a client as a test code in a lab report.

CollectionLocations

varchar(500)

Default for collection location if not defined at the user level.

Use a valid collection location.

Used to evaluate the collection location entered on the order screen.

CDCOrderEvalHours

int

Represents a number of hours.

Use an integer. Default is 0.

Used to validate the collection date/time on the order screen when a previously created order is opened.

If the order collection date/time is older than this value, the collection date/time field is cleared to allow the user to enter a new one.

PtRaceEntries

varchar(255)

Populates the race drop-down on the patient demographics screen.

Multidimensional pipe delimited value.

Use valid race codes separated by pipes with leading and trailing pipes.

PtEthnicityEntries

varchar(255)

Populates the ethnicity drop-down on the patient demographics screen.

Multidimensional pipe delimited value.

Use valid ethnicity codes separated by pipes with leading and trailing pipes.

FutureOrderSecsNotTriggerLabels

int

Represents a number of seconds.

Use an integer.

If the collect date/time is in the future by more than this number of seconds, no label is produced

FutureOrderSecsAutoReceive

int

Represents a number of seconds.

Use an integer.

If the collect date/time is in the future by more than this number of seconds, the accession is excluded from auto receive processes.

CID_Prefix

varchar(50)

Prefix characters for ContainerID.

ExceptionExecFolder

varchar(255)

Pathway for CSTools installation.

ExceptionExecutable

varchar(80)

Filename for CSTools executable. Include ".exe" in the file name.

OrderActionPhoneNumbers

varchar(255)

Designed for use in TEST area.

Multidimensional pipe delimited value.

Use phone numbers, separated by pipes, to limit user’s choice of entry. Include leading and trailing pipes.

RecognizedPrefixes

varchar(255)

Defines the prefixes to remove from patient last name in patient matching rules.

Storage of prefix depends on permission.

Multidimensional pipe delimited value.

Use acceptable patient last name prefixes separated by pipes with leading and trailing pipes.

RecognizedSuffixes

varchar(255)

Defines the suffixes to remove from patient last name in patient matching rules.

Storage of suffixes depends on permission.

Multidimensional pipe delimited value.

Use acceptable patient last name suffixes separated by pipes with leading and trailing pipes.

OrderCollectLocationTypes

varchar(255)

Populates the collection type drop-down on the patient collection location screen.

Multidimensional pipe delimited value.

Use valid collection type codes separated by pipes with leading and trailing pipes.

SendOrderForFPCancelToLIS

bit

Bit flag to indicate if FAST should trigger a new order message before a cancel message when sending cancellation to LIS.

This would only be true for orders that have not been previously sent to the LIS or have originated in LIS.

The system will evaluate both of these conditions by checking to see if the IFTriggerUpdate field has been filled at the test level.

0 = do not trigger NW order before cancel

1 = trigger NW Order before sending cancel

TriggerCancelCDCOutbound

bit

Bit flag to indicate if FAST should trigger cancellation messages to the outbound CDC interface for orders where FO_Accessions.Origin equals ‘C’ or ‘T’.

0 = do not trigger cancellation messages to outbound CDC

1 = trigger cancellation messages to outbound CDC

TDC_In_Interfaces

varchar(255)

Interface code for Trusted Data Concentrator inbound interface

Code is used by FAST to write to trigger table and must match what is expected for interface to function.

TDC_Out_Interfaces

varchar(255)

Interface code for Trusted Data Concentrator outbound interface.

Code is used by FAST to write to trigger table and must match what is expected for interface to function.

CDC_In_Interfaces

varchar(255)

Interface code for Client Data Concentrator inbound interface.

Code is used by FAST to write to trigger table and must match what is expected for interface to function.

CDC_Out_Interfaces

varchar(255)

Interface code for Client Data Concentrator outbound interface.

Code is used by FAST to write to trigger table and must match what is expected for interface to function.

CDC_OUT_Cancel_Order_Control

((Please check this definition))

varchar(50)

Use OC or CA

OC = OrderControl when FAST writes a cancellation trigger

CA = Cancellation order control to be used in FO_IF_Trigger_CDCOutbound

RecentPatientSearchType

varchar(50)

Default RECENT PTS search type.

Allowed values:

USERLOCATION

ENTRYGROUPCODE

PTACCESSGROUP

MPI

RecentPatientSearchDays

varchar(50)

Default number of days to evaluate for recent activity.

Use an integer.

Used with RECENT PTS search option.

Based on edit date not create date.

UseInterfaceTriggerService

bit

Bit flag to indicate if FAST should enable FAST Interface Trigger Layer.

Used in conjunction with FAST Interface Trigger Process Service.

0 = do not use trigger layer (FAST will continue to write to trigger table)

1 = use FAST Interface Trigger Layer and FAST Interface Trigger Process Service (started configured and separately)

(New background service for creating application to interface subsystem triggers.

When this is set the application writes general triggers for the background job to process in the table FO_IF_AppTrigger_Queue.

The background job then creates the explicit table updates and the triggering to the FO_ID_Trigger table.)

ProvCodesTriggerFreeText

varchar(255)

Defines provider codes for which a freetext provider name is allowed.

Multidimensional pipe delimited value.

Use valid provider codes separated by pipes with leading and trailing pipes.

UseClientDrivenOrderScreen

bit

Bit flag to indicate if client-driven order screen is default order screen.

0 = use original FAST order screen

1 = use client-driven order screen

UnknownCollectDate

date

Date sent to LIS when Unknown Collection box is checked.

Enter collect date as MM/DD/YYYY format.

UnknownCollectTime

varchar(50)

Time sent to LIS when Unknown Collection box is checked.

Enter collect time as HH:MM 24-hour format.

SpecimenPresentsDefTechCode

varchar(50)

Default tech code for collection tech in the Specimen Presents mode.

Use a valid tech code.

MaxOrderCopyToProvs

varchar(50)

Defines the maximum number of 'Copy To' providers allowed per order.

Use an integer from 0 to 10.

FPtoRREInterfaceCode

varchar(50)

Interface code for the Fast to RRE interface service.

LabRegionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Use a valid region code as defined in an organizations chart.

LabDivisionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Use a valid division code as defined in an organizations chart.

LabSubDivisionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Use a valid sub-division code as defined in an organizations chart.

DefaultFeeSchedule

varchar(80)

Default fee schedule for multiple fee schedule implementations.

DefaultFeeScheduleOption

varchar(80)

Default option in the default fee schedule for multiple fee schedule implementations.

WorkFlowMethods

varchar(255)

Workflow methods used by the site.

Populates the workflow method drop-down on the integrated search page.

Multidimensional pipe delimited value.

Use allowed values as shown below separated by pipes with leading and trailing pipes.

Allowed values:

PATIENT PRESENTS

SPECIMEN PRESENTS

INDUSTRIAL TOX

DefaultWorkFlowMethod

varchar(50)

System default workflow.

Overridden by a user location or user-defined default workflow.

Allowed values:

PATIENT PRESENTS

SPECIMEN PRESENTS

INDUSTRIAL TOX

ITOXDefProviderCode

varchar(50)

Default provider code for orders placed while in ITOX workflow.

Use valid provider code.

ITOXDefICDCodeq

varchar(50)

Default diagnosis code for orders placed while in ITOX workflow.

Use valid diagnosis code.

PatientFeeSchedule

varchar(80)

Default fee schedule code applied to Fast accessions labeled with a billto value of 'Patient/Guarantor'.

Use valid fee schedule code.

PatientFeeScheduleOption

varchar(80)

Default fee schedule option applied to Fast accessions labeled with a billto value of 'Patient/Guarantor'.

Use valid fee schedule option.

CashFeeSchedule

varchar(80)

Default fee schedule code applied to Fast accessions labeled as 'Bill to Cash'.

Use valid fee schedule code.

CashFeeScheduleOption

varchar(80)

Default fee schedule option applied to Fast accessions labeled as 'Bill to Cash'.

Use valid fee schedule option.

PaymentReceiptExternalFormCode

varchar(50)

The form code from FO_External_Form_Definition.

ExternalFormCode that can be used to show a user customized SSRS-based payment receipt form.

PtDefaultDOB

date

Default DOB.

Enter DOB as MM/DD/YYYY format.

BatchListRPTExteranlFormCode

varchar(50)

The form code from FO_External_Form_Definition.

ExternalFormCode that can be used to show a user customized SSRS-based Batch List form.

Leave blank to use the default report.

DispatchListRPTExternalFormCode

varchar(50)

The external form code for the dispatch list user custom report.