FO_PtLocations

Most key elements are loaded from LIS. The update process might update all available fields or only add new definitions depending on the site’s needs.

 

Field Type Notes

PtLocations_ID

int

ID field, a counter. Unique

PtLocCode

varchar(20)

Patient location code.

Enter a valid LIS patient location code.

PtLocDescription

varchar(80)

Description of patient location code.

PtLocType

varchar(20)

Patient location type.

Enter a valid patient location type for LIS systems.

Sunquest values are 1,2,3,4

LocStatus

varchar(50)

Location status for LIS.

Enter an allowed value.

Allowed values:

A = Active

I = Inactive

FacilityID

varchar(50)

Default facility ID for this patient location.

Enter a valid facility ID.

LocAccount

varchar(50)

Default account for this location.

Enter a valid account.

Tel

varchar(50)

Phone number for location.

Fax

varchar(50)

Fax number for location.

Active

varchar(50)

Location status for FAST.

Enter an allowed value.

Allowed values:

A = Active

I = Inactive

ClientPopup

varchar(255)

Location specific message for client use only.

This text is presented by FASTas a message when the client user orders a test.

LabPopup

varchar(255)

Location specific message for lab use only.

This text is presented by FASTas a message when the user orders a test.

AutoOrderTests

varchar(255)

Defines the list of test codes the system will automatically order when the user places the first order on the order screen and this location code is present.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test codes separated by pipes.

RptTriggerSubscriptionID

varchar(50)

Default RptTriggerSubscriptionID for location.

Enter a valid RptTriggerSubscriptionID.

Used in report delivery.

Email

varchar(80)

Email address for location.

Pager

varchar(80)

Pager number.

Add1

varchar(80)

First address line. Informational

Add2

varchar(80)

Second address line. Informational

City

varchar(80)

City. Informational

St

varchar(80)

State. Informational

ZipCode

varchar(50)

Zip code. Informational

CreateDate

datetime

System timestamp when record is first created.

EditDate

datetime

System timestamp when record is edited.

RequiresRoomBedEntry

bit

Bit field to indicate if room / bed information is required.

Enter 0 or 1

0 = no room / bed required

1 = room / bed required

FINCompanyCode

varchar(50)

Company code sent to FIN for orders from this location.

Enter a valid FIN Company code.

Country

varchar(50)

Country. Informational

LabCode

varchar(80)

Default lab code for this location.

Enter a valid lab code.

SourceSystem

varchar(80)

Default system/vendor/version ID for this location.

Enter a valid ID.

Connects to the organization source system definitions.