| PrimaryKey |
Primary key for the table |
| Cosmic_ID |
COSMICs unique ID for the order |
| SOC_ID |
Reference to the patient |
| ReqIdentity |
Identity for the order (RID) used as reference between Cosmic and labsystem |
| LabIdentity |
Identity for the analysis (RID) used as reference between Cosmic and labsystem |
| JournalReference |
Reference to the created journalreference |
| Contact_ID |
Reference to the Contact |
| Speciality |
ID for the speciality |
| Speciality_Name |
Name for the speciality |
| SubSpeciality |
SubSpeciality for the object in F_OMREQUEST |
| Status |
ID for the status of of the order |
| Status_Name |
Name for the status of the order |
| ServicePriority |
Requested priority (1-5) |
| ServicePriorityPhone |
Given phonenumber where answer is to be called in |
| ReqUnit_ID |
ID for requesting unit |
| SamplingUnit_ID |
ID for sampling unit |
| ReqRecUnit_ID |
ID for recieving unit |
| RepRecUnit_ID |
ID for answerrecieving unit |
| PayingUnit_ID |
ID for paying unit |
| ReqCareGiver_ID |
ID for requesting staff |
| SamplingCareGiver_ID |
ID for sampling staff |
| ReqRecCareGiver_ID |
ID for recieving staff |
| RepRecCareGiver_ID |
ID for answerrecieving staff |
| Creator |
User_ID for who created/changed the order |
| RequestTime |
Timestamp for when orderwas created |
| PlannedTime |
Timestamp for when order was planned to be executed |
| ArrivalTime |
Timestamp for when order arrived at lab |
| f_TimeStamp |
f_TimeStamp for the object in F_OMREQUEST |
| ReqCareGiver |
Name of requesting caregiver |
| ReqRecCareGiver |
Name of recieving caregiver |
| SamplType |
ID for type of sample |
| SamplDescription |
Sampletype in plain |
| SamplRoom |
Room where sample was taken |
| SamplBed |
Bed where sample was taken |
| SamplPlannedTime |
SamplPlannedTime for the object in F_OMREQUEST |
| SamplStartTime |
Timestamp for when sampling started |
| SamplEndTime |
Timestamp for when sampling ended |
| SamplVolume |
Samplingvolume |
| SamplUnit |
Samplingunit |
| RequestReason |
Given reason for sample |
| Anamnesis |
Given anamneasis |
| Diagnosis |
Given diagnosis |
| InvestigationText |
Comments from lab |
| ReqComment |
Comments from requester |
| CollComment |
Commets from samplecollector |
| LocationText |
Description for where, anatomicly, samples was taken |
| Side |
Side for the object in F_OMREQUEST |
| Interpretor |
Indicates with tru/false if need for intrepretor |
| InterpretorLang |
Intrepretorlanguage |
| PreliminaryReport |
Indicates with true/false if preliminaryanswer is requested |
| RegistrationDate |
Timestamp for when registration was done |
| Contamination |
Indicates with true/false if sample is tagged as contagiuos |
| Counter |
Counter for the object in F_OMREQUEST |
| Sysdate |
Date when record got loaded/updated in CI |
| referralID |
referralID for the object in F_OMREQUEST |
| activityID |
activityID for the object in F_OMREQUEST |
| accessionNo |
accessionNo for the object in F_OMREQUEST |
| location |
location for the object in F_OMREQUEST |