Home » RDBMS Server » Server Utilities » how to import .csv file into oracle database using a not null column (oracle 10g)
how to import .csv file into oracle database using a not null column [message #393746] Tue, 24 March 2009 04:45 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
i am having an excel file with some records in it.now i want to import .csv file into the oracle database using sql*loader which is possible.but my problem is my table having 5 columns out of which one is a not null column and the records of the column are in a sequential order like form 1000 onwards.i can make that colukn null and later make it as not null and manually insert the records into that.but there are around 5000 records in it.can u please explain me how to do the entire procedure?
Re: how to import .csv file into oracle database using a not null column [message #393751 is a reply to message #393746] Tue, 24 March 2009 04:57 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post DDL details.

Post same data's we try to help you.

Babu
Re: how to import .csv file into oracle database using a not null column [message #393768 is a reply to message #393746] Tue, 24 March 2009 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic on csv file:
Michel Cadot wrote on Mon, 23 March 2009 09:08
The documentation is still at the same place.

Regards
Michel


Read section "Setting a Column to a Unique Sequence Number".

Regards
Michel
Re: how to import .csv file into oracle database using a not null column [message #393781 is a reply to message #393768] Tue, 24 March 2009 05:51 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
My table is like this.

desc emrlabtestlkup
TEST_ID                        NOT NULL NUMBER(20)                                                                                                                                                                                    
TEST_NAME                               VARCHAR2(255)                                                                                                                                                                                 
LAB_NAME                                VARCHAR2(255)                                                                                                                                                                                 
PARENT_TEST_ID                          NUMBER(20)                                                                                                                                                                                    
TEST_CDC_CODE                           VARCHAR2(50)                                                                                                                                                                                  
IS_ACTIVE                               NUMBER(1)                                                                                                                                                                                     
IS_AOE                         NOT NULL NUMBER(1)                                                                                                                                                                                     
AOE_TEST_PRERESULT                      VARCHAR2(255)                                                                                                                                                                                 
AOE_RESULT_FILTER                       VARCHAR2(4000)                                                                                                                                                                                
SPECIMEN_CONTAINER                      VARCHAR2(500)                                                                                                                                                                                 
SPECIMEN_STORAGE                        VARCHAR2(10)                                                                                                                                                                                  
METHODOLOGY                             VARCHAR2(1000)                                                                                                                                                                                
SPECIMEN_REQUIREMENTS                   VARCHAR2(1000)                                                                                                                                                                                
SPECIMEN_CONDITIONS                     VARCHAR2(1000)                                                                                                                                                                                
SPECIMEN_VOLUME                         VARCHAR2(1000)                                                                                                                                                                                
GROUP_ID                                NUMBER(10)                                                                                                                                                                                    
TEST_SPECIMEN                           NUMBER(20)                                                                                                                                                                                    
CATEGORY                                NUMBER(1) 

select * from emrlabtestlkup;
50279	FACTOR V ACTIVITY AND HUMAN INHIBITOR	QUEST	0	17844	1	2			(%344RQEZ)  FACTOR V ACTIVITY, CLOTTING
PLASTIC SCREW CAP VIAL	FZ	(%10297RQEZ)  FACTOR V HUMAN INHIBITOR
CLOT BASED
(%344RQEZ)  FACTOR V ACTIVITY, CLOTTING
PHOTOMETRIC CLOT DETECTION	(%10297RQEZ)  FACTOR V HUMAN INHIBITOR
2 ML X2 PLASMA
3.2% SODIUM CITRATE (LIGHT BLUE-TOP)
MIX GENTLY; DO NOT SHAKE. DOUBLE CENTRIFUGATION IS
RECOMMENDED.
QUICK FREEZE IS RECOMMENDED.
(%344RQEZ)  FACTOR V ACTIVITY, CLOTTING
3 ML PLASMA COLLECTED IN A 3.2% SODIUM CITRATE
(LIGHT BLUE-TOP)
DO NOT THAW	(%10297RQEZ)  FACTOR V HUMAN INHIBITOR
ROOM TEMP  1 DAY
REFRIG     1 DAY
FROZEN     3 WEEKS
(%344RQEZ)  FACTOR V ACTIVITY, CLOTTING
FROZEN 2 WEEKS -20 C
1 YEAR  -70 C	(%10297RQEZ)  FACTOR V HUMAN INHIBITOR
1 ML X2
(%344RQEZ)  FACTOR V ACTIVITY, CLOTTING
1 ML	0	6179	0
50286	ER/PR/MIB 1 (Ki 67), PARAFFIN BLOCK	QUEST	0	19070	1	2			(7037RQEZ=)  ER/PR, PARAFFIN BLOCK
PARAFFIN BLOCK BAG
(29914RQEZ=)  KI 67, IHC WITH  INTERPRETATION
PARAFFIN BLOCK BAG	RT	(7037RQEZ=)  ER/PR, PARAFFIN BLOCK
IMMUNOHISTOCHEMISTRY (IHC)

(29914RQEZ=)  KI 67, IHC WITH  INTERPRETATION
IMMUNOHISTOCHEMICAL ASSAY

ASR1
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE.
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S. FOOD AND
DRUG ADMINISTRATION.  THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY.  PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE OF
THE TEST.	(7037RQEZ=)  ER/PR, PARAFFIN BLOCK
FORMALIN FIXED PARAFFIN EMBEDDED TISSUE.
INVASIVE OR METASTATIC BREAST CANCER FORMALIN FIXED
PARAFFIN EMBEDDED TISSUE OR SLIDES FROM FORMALIN
FIXED PARAFFIN EMBEDDED TISSUE. SPECIMEN MUST BE
FIXED IN 10% NEUTRAL BUFFERED FORMALIN. FIXATION
BETWEEN 6 AND 48 HOURS IS RECOMMENDED. PATHOLOGY
REPORT MUST ACCOMPANY PARAFFIN BLOCK OR SLIDES.
INFORMATION REQUIRED IN THIS REPORT INCLUDE
PHYSICIAN IDENTIFICATION, SPECIMEN IDENTIFIERS
(CASE AND BLOCK NUMBER), SPECIMEN SITE AND TYPE,
TISSUE PROCESSING USED (ROUTINE OR MICROWAVE),
TYPE OF FIXATIVE, TIME AND DURATION OF FIXATION,
PATHOLOGIC DIAGNOSIS, AND IHC SCORE, IF PERFORMED
ELSEWHERE. SHIP AT ROOM TEMPERATURE. DO NOT FREEZE.
HER-2 TESTING WILL NOT BE PERFORMED ON NON-INVASIVE
TUMORS.
(29914RQEZ=)  KI 67, IHC WITH  INTERPRETATION
FORMALIN FIXED, PARAFFIN EMBEDDED TISSUE BLOCK

TUMOR PARAFFIN BLOCK (FORMALIN-FIXED ONLY) OR THREE
4-MICRON UNSTAINED SECTIONS ON PLOY-L-LYSINE OR
SILANE COATED SLIDES.	(7037RQEZ=)  ER/PR, PARAFFIN BLOCK
ROOM TEMPERATURE UNLIMITED
REFRIGERATED UNACCEPTABLE
FROZEN UNACCEPTABLE		0	6187	0
50297	AUTOIMMUNE HEPATITIS DIAGNOSTIC PANEL	QUEST	0	19873	1	2			(15038RQEZ=)  LIVER KIDNEY MICROSOME (LKM-1) AB (IGG)
PLASTIC SCREW-CAP VIAL
(15043RQEZ=)  ACTIN (SMOOTH MUSCLE) ANTIBODY (IGG)
PLASTIC SCREW-CAP VIAL
(%36205RQEZ)  ANTIMITOCHONDRIAL  ANTIBODY TITER
PLASTIC SCREW CAP VIAL
(%38318RQEZ)  ANA SCREEN IFA
PLASTIC SCREW-CAP VIAL
(%259RQEZ)  ANTIMITOCHONDRIAL ANTIBODY SCREEN
PLASTIC SCREW-CAP VIAL
(%36209BRQEZ)  ANA, TITER AND PATTERN
PLASTIC SCREW-CAP VIAL		(15038RQEZ=)  LIVER KIDNEY MICROSOME (LKM-1) AB (IGG)
ENZYME LINKED IMMUNOSORBENT IMMUNOASSAY (ELISA)

(15043RQEZ=)  ACTIN (SMOOTH MUSCLE) ANTIBODY (IGG)
ENZYME LINKED IMMUNOSORBENT IMMUNOASSAY (ELISA)
(%36205RQEZ)  ANTIMITOCHONDRIAL  ANTIBODY TITER
IMMUNOFLUORESCENCE ASSAY
(%38318RQEZ)  ANA SCREEN IFA
IMMUNOFLUORESCENT ASSAY (IFA)
(%259RQEZ)  ANTIMITOCHONDRIAL ANTIBODY SCREEN
IMMUNOFLUORESCENCE (IFA)
(%36209BRQEZ)  ANA, TITER AND PATTERN
IMMUNOFLUORESCENT ASSAY (IFA)	(15038RQEZ=)  LIVER KIDNEY MICROSOME (LKM-1) AB (IGG)
1 ML SERUM
(15043RQEZ=)  ACTIN (SMOOTH MUSCLE) ANTIBODY (IGG)
0.5 ML SERUM
(%36205RQEZ)  ANTIMITOCHONDRIAL  ANTIBODY TITER
0.5 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)
(%38318RQEZ)  ANA SCREEN IFA
1 ML SERUM
(%259RQEZ)  ANTIMITOCHONDRIAL ANTIBODY SCREEN
0.5 ML SERUM
(%36209BRQEZ)  ANA, TITER AND PATTERN
1 ML SERUM	(15038RQEZ=)  LIVER KIDNEY MICROSOME (LKM-1) AB (IGG)
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 2 WEEKS
FROZEN 1 MONTH
(15043RQEZ=)  ACTIN (SMOOTH MUSCLE) ANTIBODY (IGG)
ROOM TEMPERATURE 8 HOURS
REFRIGERATED 2 WEEKS
FROZEN 1 MONTH
(%36205RQEZ)  ANTIMITOCHONDRIAL  ANTIBODY TITER
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 2 WEEKS
FROZEN 6 MONTHS
(%38318RQEZ)  ANA SCREEN IFA
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG C    1 MONTH
-70 DEG C    INDEFINITELY
(%259RQEZ)  ANTIMITOCHONDRIAL ANTIBODY SCREEN
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 14 DAYS
FROZEN -20 DEGREES 30 DAYS
-70 DEGREES INDEFINITE
(%36209BRQEZ)  ANA, TITER AND PATTERN
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG C    1 MONTH
-70 DEG C    INDEFINITELY	(15038RQEZ=)  LIVER KIDNEY MICROSOME (LKM-1) AB (IGG)
0.3 ML
(15043RQEZ=)  ACTIN (SMOOTH MUSCLE) ANTIBODY (IGG)
0.1 ML
(%36205RQEZ)  ANTIMITOCHONDRIAL  ANTIBODY TITER
0.1 ML
(%38318RQEZ)  ANA SCREEN IFA
0.2 ML
(%259RQEZ)  ANTIMITOCHONDRIAL ANTIBODY SCREEN
0.1 ML
(%36209BRQEZ)  ANA, TITER AND PATTERN
0.2 ML	0	6206	0
50319	METHYLMALONIC ACID AND HOMOCYSTEINE (NUTRITIONAL AND CONGENITAL)	QUEST	0	30517	1	2			(36362SB=)  HOMOCYSTEINE, NUTRITIONAL AND CONGENITAL
PLASTIC SCREW-CAP VIAL
(34879SB=)  METHYLMALONIC ACID
PLASTIC SCREW-CAP VIAL		(36362SB=)  HOMOCYSTEINE, NUTRITIONAL AND CONGENITAL
IMMUNOASSAY
(34879SB=)  METHYLMALONIC ACID
GAS CHROMATOGRAPHY/MASS SPECTROMETRY (GC/MS)	(36362SB=)  HOMOCYSTEINE, NUTRITIONAL AND CONGENITAL
1 ML SERUM

RED TOP TUBES PLACE THE SPECIMEN IN THE REFRIGERATOR OR
ICE BATH FOR 30 MINUTES AFTER COLLECTION. CENTRIFUGE THE
SPECIMEN AS SOON AS POSSIBLE AFTER COMPLETE CLOT FORMATION.
TRANSFER THE SERUM TO A PLASTIC SPECIMEN TRANSPORT TUBE.
MARK THE SPECIMEN TYPE AS SERUM ON THE TRANSPORT TUBE.

BARRIER GEL SEPARATOR TUBE PLACE THE SPECIMEN IN A
REFRIGERATOR FOR 30  MINUTES AFTER COLLECTION. DO NOT
PLACE BARRIER TUBES IN AN ICE BATH AS FREEZING MAY
PREVENT THE BARRIER GEL FROM ADEQUATELY SEPARATING SERUM
FROM CELLS. CENTRIFUGE SPECIMEN AS SOON AS POSSIBLE AFTER
COMPLETE CLOT FORMATION, ENSURING THAT THE BARRIER GEL
COMPLETELY SEPARATES SERUM FROM CELLS.

NOTE IT IS VERY IMPORTANT TO CENTRIFUGE AND SEPARATE
SERUM OR PLASMA FROM RED BLOOD CELLS AS SOON AS POSSIBLE
TO AVOID FALSELY ELEVATED RESULTS.
(34879SB=)  METHYLMALONIC ACID
2 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)	(36362SB=)  HOMOCYSTEINE, NUTRITIONAL AND CONGENITAL
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 14 DAYS
FROZEN  6 MONTHS
(34879SB=)  METHYLMALONIC ACID
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
FROZEN 10 MONTHS	(36362SB=)  HOMOCYSTEINE, NUTRITIONAL AND CONGENITAL
0.5 ML
(34879SB=)  METHYLMALONIC ACID
0.6 ML	0	6231	0
50320	CANAVAN DISEASE MUTATION ANALYSIS	QUEST	50320	31650	1	2			(%31650RQEZ)  CANAVAN DISEASE
FOR WHOLE BLOOD, SHIP IN ORIGINAL TUBE; OTHER SPECIMENS,
SEE PREFERRED SPECIMEN REQUIREMENTS	RT	(%31650RQEZ)  CANAVAN DISEASE
POLYMERASE CHAIN REACTION (PCR), ALLELE SPECIFIC PRIMER
EXTENSION, FLUORESCENT DETECTION USING COLOR CODED
MICROSPHERES.

ASR1
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE.
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S. FOOD AND
DRUG ADMINISTRATION. THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY. PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE
THE TEST.	(%31650RQEZ)  CANAVAN DISEASE
5 ML LAVENDER-TOP (EDTA) TUBE OR YELLOW-TOP (ACD) WHOLE
BLOOD.
INSTRUCTIONS
SPECIMEN STABILITY IS CRUCIAL. STORE AT ROOM TEMPERATURE
AND SHIP IMMEDIATELY. DO NOT FREEZE.

FOR PRENATAL DIAGNOSIS WITH FETAL SPECIMEN 1) PARENTS MUST
BE DOCUMENTED CARRIERS OF ONE OF THE MUTATIONS LISTED;
2) MATERNAL BLOOD OR DNA MUST BE AVAILABLE; 3) CONTACT THE
LABORATORY GENETIC COUNSELOR BEFORE SUBMISSION.

AMNIOTIC FLUID SPECIMEN STABILITY IS CRUCIAL. STORE AT
ROOM TEMPERATURE AND SHIP IMMEDIATELY. DO NOT REFRIGERATE
OR FREEZE.

AMNIOCYTE CULTURE STERILE T25 FLASK, FILLED WITH CULTURE
MEDIUM. SPECIMEN STABILITY IS CRUCIAL. STORE AT ROOM
TEMPERATURE AND SHIP IMMEDIATELY. DO NOT REFRIGERATE OR
FREEZE.

DISSECTED CHORIONIC VILLUS (CVS) BIOPSY 10-20 MG DISSECTED
CHORIONIC VILLI COLLECTED IN STERILE TUBE FILLED WITH
STERILE CULTURE MEDIA. SPECIMEN STABILITY IS CRUCIAL. STORE
AT ROOM TEMPERATURE AND SHIP IMMEDIATELY. DO NOT REFRIGERATE
OR FREEZE.	(%31650RQEZ)  CANAVAN DISEASE
ROOM TEMP  8 DAYS
REFRIG     8 DAYS WHOLE BLOOD ONLY
FROZEN    UNACCEPTABLE	(%31650RQEZ)  CANAVAN DISEASE
3 ML	0	6233	0
50340	HTLV I II ANTIBODY, EIA WITH POSITIVES REFLEXED TO WESTERN BLOT	QUEST	0	36175	1	2			(%8511RQEZ)  ANTI HTLV I/II WESTERN BLOT
PLASTIC SCREW-CAP VIAL
(%34311RQEZ)  HTLV I/II ANTIBODY, EIA
PLASTIC SCREW-CAP VIAL	RF	(%8511RQEZ)  ANTI HTLV I/II WESTERN BLOT
WESTERN BLOT
NON-FDA APPROVED
(%34311RQEZ)  HTLV I/II ANTIBODY, EIA
IMMUNOASSAY (EIA)

RESEARCH USE ONLY (RUO)
THIS TEST WAS PERFORMED USING A KIT THAT HAS NOT BEEN
CLEARED OR APPROVED BY THE FDA. THE ANALYTICAL PERFORMANCE
CHARACTERISTICS OF THIS TEST HAVE BEEN DETERMINED BY NICHOLS
INSTITUTE. THIS TEST SHOULD NOT BE USED FOR DIAGNOSIS
WITHOUT CONFIRMATION BY OTHER MEDICALLY ESTABLISHED MEANS.	(%8511RQEZ)  ANTI HTLV I/II WESTERN BLOT
1 ML SERUM

INSTRUCTIONS
SERUM SHOULD BE REMOVED FROM CELLS PROMPTLY AFTER
COLLECTION AND TRANSFERRED TO A PLASTIC SCREW-CAP VIAL.
(%34311RQEZ)  HTLV I/II ANTIBODY, EIA
1 ML SERUM

INSTRUCTIONS
SERUM SHOULD BE REMOVED FROM CELLS PROMPTLY AFTER
COLLECTION AND TRANSFERRED TO A PLASTIC SCREW-CAP VIAL.	(%8511RQEZ)  ANTI HTLV I/II WESTERN BLOT
ROOM TEMPERATURE 8 HOURS
REFRIGERATED 7 DAYS
FROZEN      30 DAYS
(%34311RQEZ)  HTLV I/II ANTIBODY, EIA
ROOM TEMPERATURE 8 HOURS
REFRIGERATED 14 DAYS
FROZEN      30 DAYS	(%8511RQEZ)  ANTI HTLV I/II WESTERN BLOT
0.1 ML
(%34311RQEZ)  HTLV I/II ANTIBODY, EIA
0.6 ML	0	6256	0
50348	ISLET CELL ANTIBODY SCREEN WITH REFLEX TO TITER	QUEST	50348	36741	1	2			(%37534RQEZ)  ISLET CELL ANTIBODY TITER
PLASTIC SCREW CAP VIAL
(%36741RQEZ)  ISLET CELL ANTIBODY  SCREEN
PLASTIC SCREW CAP VIAL	RF	(%37534RQEZ)  ISLET CELL ANTIBODY TITER
IMMUNOFLUORESCENCE ASSAY

ASR I
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE.
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S. FOOD AND
DRUG ADMINISTRATION. THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY. PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE OF THE
TEST.
(%36741RQEZ)  ISLET CELL ANTIBODY  SCREEN
IMMUNOFLUORESCENCE ASSAY

ASR CLASS I
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S. FOOD AND
DRUG ADMINISTRATION. THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY. PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE OF THE
TEST.	(%37534RQEZ)  ISLET CELL ANTIBODY TITER
2 ML SERUM COLLECTED IN A NO ADDITIVE (RED-TOP) TUBE
(%36741RQEZ)  ISLET CELL ANTIBODY  SCREEN
2 ML SERUM COLLECTED IN A NO ADDITIVE (RED-TOP) TUBE	(%37534RQEZ)  ISLET CELL ANTIBODY TITER
ROOM TEMPERATURE 2 DAYS
REFRIGERATED 2 WEEKS
FROZEN 6 MONTHS
(%36741RQEZ)  ISLET CELL ANTIBODY  SCREEN
ROOM TEMPERATURE 2 DAYS
REFRIGERATED 2 WEEKS
FROZEN 6 MONTHS	(%37534RQEZ)  ISLET CELL ANTIBODY TITER
0.5 ML
(%36741RQEZ)  ISLET CELL ANTIBODY  SCREEN
0.5 ML	0	6265	0
50352	ANGIOEDEMA PROFILE 2	QUEST	0	37082	1	2			(297RQEZ=)  C1 INHIBITOR, FUNCTIONAL
PLASTIC SCREW-CAP VIAL
(298RQEZ=)  C1 INHIBITOR, PROTEIN
PLASTIC SCREW-CAP VIAL		(297RQEZ=)  C1 INHIBITOR, FUNCTIONAL
ENZYME IMMUNOASSAY (EIA)
(298RQEZ=)  C1 INHIBITOR, PROTEIN
FIXED RATE TIME NEPHELOMETRY

FDA STATUS-ASR 1
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE.
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S. FOOD AND
DRUG ADMINISTRATION. THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY. PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE OF THE
TEST.	(297RQEZ=)  C1 INHIBITOR, FUNCTIONAL
1 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)

INSTRUCTIONS
FREEZE SERUM WITHIN ONE HOUR OF TIME DRAWN.
DO NOT USE GEL BARRIER TUBES. DO NOT SUBMIT THE SAMPLE IN A
GLASS TUBE. DO NOT THAW.
(298RQEZ=)  C1 INHIBITOR, PROTEIN
PATIENT PREPARATION OVERNIGHT FASTING IS PREFERRED.

1 ML SERUM

INSTRUCTIONS
COLLECT ON ICE. CHILL IN ICE BATH DURING CLOTTING.
SEPARATE FROM CLOT WITH MINIMUM CENTRIFUGATION. REFRIGERATE
SERUM IMMEDIATELY. AVOID HEMOLYSIS.	(297RQEZ=)  C1 INHIBITOR, FUNCTIONAL
ROOM TEMPERATURE FROZEN ONLY
REFRIGERATED FROZEN ONLY
FROZEN       1 MONTH
(298RQEZ=)  C1 INHIBITOR, PROTEIN
ROOM TEMPERATURE 24 HOURS
REFRIGERATED 8 DAYS
FROZEN 28 DAYS	(297RQEZ=)  C1 INHIBITOR, FUNCTIONAL
0.2 ML
(298RQEZ=)  C1 INHIBITOR, PROTEIN
0.5 ML	0	6270	0
50362	IMMUNOFIXATION IGA,IGG,IGM QT.IMMUNOFIXATION SERUM IMMUNOGLOBULIN	QUEST	0	37669	1	2			(549SB=)  IMMUNOFIXATION, SERUM
PLASTIC SCREW-CAP VIAL
(7083SB=)  IMMUNOGLOBULINS
PLASTIC SCREW-CAP VIAL	RT	(549SB=)  IMMUNOFIXATION, SERUM
AGAROSE GEL ELECTROPHORESIS WITH IMMUNOFIXATION
(7083SB=)  IMMUNOGLOBULINS
IMMUNOTURBIDIMETRIC	(549SB=)  IMMUNOFIXATION, SERUM
1 ML SERUM
(7083SB=)  IMMUNOGLOBULINS
2 ML SERUM	(549SB=)  IMMUNOFIXATION, SERUM
ROOM TEMPERATURE 2 DAYS
REFRIGERATED 1 WEEK
FROZEN 6 MONTHS
(7083SB=)  IMMUNOGLOBULINS
ROOM TEMPERATURE 3 DAYS
REFRIGERATED 1 WEEK
FROZEN 3 MONTHS	(549SB=)  IMMUNOFIXATION, SERUM
0.5 ML
(7083SB=)  IMMUNOGLOBULINS
0.5 ML	0	6280	0
50342	AMYLASE ISOENZYMES WITH REFLEX TO MACROAMYLASE	QUEST	50342	36187	1	2			(%5499RQEZ)  MACROAMYLASE, SERUM
PLASTIC SCREW-CAP VIAL
(%36187RQEZ)  AMYLASE ISOENZYMES
PLASTIC SCREW-CAP VIAL	RF	(%5499RQEZ)  MACROAMYLASE, SERUM
GEL FILTRATION
(%36187RQEZ)  AMYLASE ISOENZYMES
GEL FILTRATION	(%5499RQEZ)  MACROAMYLASE, SERUM
2 ML SERUM COLLECTED IN A TUBE WITH NO ADDITIVES
(RED-TOP TUBE)
(%36187RQEZ)  AMYLASE ISOENZYMES
2 ML SERUM COLLECTED IN A TUBE WITH NO ADDITIVES (RED-TOP)	(%5499RQEZ)  MACROAMYLASE, SERUM
ROOM TEMPERATURE UNSTABLE
REFRIGERATED 1 MONTH
FROZEN 1 MONTH
(%36187RQEZ)  AMYLASE ISOENZYMES
ROOM TEMPERATURE UNSTABLE
REFRIGERATED 30 DAYS
FROZEN 30 DAYS	(%5499RQEZ)  MACROAMYLASE, SERUM
1 ML SERUM COLLECTED IN A TUBE WITH NO ADDITIVES (RED-TOP)
(%36187RQEZ)  AMYLASE ISOENZYMES
1 ML SERUM COLLECTED IN A TUBE WITH NO ADDITIVES (RED-TOP)	0	6258	0
50418	FSH AND LH	QUEST	0	7137	1	2			(470SB=)  FSH
PLASTIC SCREW-CAP VIAL
(615SB=)  LH
PLASTIC SCREW-CAP VIAL	RT	(470SB=)  FSH
IMMUNOASSAY
(615SB=)  LH
IMMUNOASSAY	(470SB=)  FSH
1 ML SERUM
(615SB=)  LH
1 ML SERUM	(470SB=)  FSH
ROOM TEMPERATURE 7 DAYS
REFRIGERATED 7 DAYS
FROZEN 28 DAYS
(615SB=)  LH
ROOM TEMPERATURE 7 DAYS
REFRIGERATED 7 DAYS
FROZEN 28 DAYS	(470SB=)  FSH
0.5 ML
(615SB=)  LH
0.5 ML	0	6345	0
50413	ANTITHROMBIN III ACTIVITY AND ANTIGEN	QUEST	0	7017	1	2			(5158RQEZ=)  ANTITHROMBIN III ANTIGEN
PLASTIC SCREW-CAP VIAL
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
PLASTIC SCREW-CAP VIAL	FZ	(5158RQEZ=)  ANTITHROMBIN III ANTIGEN
FIXED RATE TIME NEPHELOMETRY
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
CHROMOGENIC SUBSTRATE	(5158RQEZ=)  ANTITHROMBIN III ANTIGEN
PATIENT PREPARATION PATIENT SHOULD ABSTAIN FROM
ANABOLIC STEROIDS, GEMFIBROZIL, WARFARIN (COUMADIN (R)),
HEPARIN THERAPY, ASPARAGINASE, ESTROGENS, GESTODENE
AND ORAL CONTRACEPTIVES OPTIMALLY FOR 3 DAYS PRIOR
TO SPECIMEN COLLECTION. OVERNIGHT FASTING IS PREFERRED.

1 ML PLASMA COLLECTED IN A LIGHT BLUE-TOP
(3.2% SODIUM CITRATE) TUBE

AVOID REPEATED FREEZE-THAW CYCLES.
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
1 ML PLASMA COLLECTED IN 3.2% SODIUM CITRATE (LIGHT
BLUE-TOP).

DO NOT THAW.	(5158RQEZ=)  ANTITHROMBIN III ANTIGEN
ROOM TEMPERATURE UNACCEPTABLE
REFRIGERATED UNACCEPTABLE
FROZEN 21 DAYS
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
ROOM TEMPERATURE  6 HOURS
REFRIGERATED     48 HOURS
FROZEN            1 MONTH	0.5 ML
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
0.5 ML PLASMA *FROZEN*	0	6340	0
50417	HEPATITIS B IMMUNITY PANEL	QUEST	0	7105	1	2			(499SB=)  HEPATITIS B SURFACE ANTIBODY QL
PLASTIC SCREW-CAP VIAL
(501SB=)  HEPATITIS B CORE AB TOTAL
PLASTIC SCREW-CAP VIAL	RT	(499SB=)  HEPATITIS B SURFACE ANTIBODY QL
IMMUNOASSAY
(501SB=)  HEPATITIS B CORE AB TOTAL
IMMUNOASSAY	(499SB=)  HEPATITIS B SURFACE ANTIBODY QL
1 ML SERUM
(501SB=)  HEPATITIS B CORE AB TOTAL
1 ML SERUM	(499SB=)  HEPATITIS B SURFACE ANTIBODY QL
ROOM TEMPERATURE 5 DAYS
REFRIGERATED 14 DAYS
-20 DEG C    INDEFINITELY
-70 DEG C    INDEFINITELY
(501SB=)  HEPATITIS B CORE AB TOTAL
ROOM TEMPERATURE 5 DAYS
REFRIGERATED    14 DAYS
-20 DEG C    INDEFINITELY
-70 DEG C    INDEFINITELY	(499SB=)  HEPATITIS B SURFACE ANTIBODY QL
0.5 ML
(501SB=)  HEPATITIS B CORE AB TOTAL
0.5 ML	0	6344	0
50449	POTASSIUM, RANDOM URINE (W/ CREATININE)	QUEST	50449	8347	1	2			(%8347SB)  POTASSIUM, RANDOM URINE (W/ CREATININE)
PLASTIC SCREW-CAP CONTAINER
(8459SB=)  CREATININE, RANDOM URINE
PLASTIC SCREW-CAP CONTAINER	RT	(%8347SB)  POTASSIUM, RANDOM URINE (W/ CREATININE)
ION SELECTIVE ELECTRODE (ISE)
(8459SB=)  CREATININE, RANDOM URINE
COLORIMETRIC, KINETIC	(%8347SB)  POTASSIUM, RANDOM URINE (W/ CREATININE)
10 ML ALIQUOT OF A RANDOM URINE; NO PRESERVATIVE.
(8459SB=)  CREATININE, RANDOM URINE
10 ML RANDOM URINE, NO PRESERVATIVE	(%8347SB)  POTASSIUM, RANDOM URINE (W/ CREATININE)
ROOM TEMPERATURE 7 DAYS
REFRIGERATED     7 DAYS
FROZEN           7 DAYS
(8459SB=)  CREATININE, RANDOM URINE
ROOM TEMPERATURE 1 WEEK
REFRIGERATED  1 MONTH
-20 DEG. C  3 MONTHS
-70 DEG. C  NOT AVAILABLE	(%8347SB)  POTASSIUM, RANDOM URINE (W/ CREATININE)
2 ML
(8459SB=)  CREATININE, RANDOM URINE
2 ML	0	6377	0
50457	PROTEIN C ACTIVITY AND ANTIGEN	QUEST	0	8757	1	2			(1777RQEZ=)  PROTEIN C ACTIVITY
PLASTIC SCREW-CAP VIAL
(4948RQEZ=)  PROTEIN C ANTIGEN
PLASTIC SCREW-CAP VIAL	FZ	(1777RQEZ=)  PROTEIN C ACTIVITY
CLOTTING ASSAY
(4948RQEZ=)  PROTEIN C ANTIGEN
ENZYME IMMUNOASSAY (EIA)		(1777RQEZ=)  PROTEIN C ACTIVITY
ROOM TEMPERATURE UNACCEPTABLE
REFRIGERATED UNACCEPTABLE
FROZEN -70 DEGREES 1 YEAR
(4948RQEZ=)  PROTEIN C ANTIGEN
ROOM TEMPERATURE NOT STABLE
REFRIGERATED  NOT STABLE
-20 C  2 WEEKS
-70 C  1 YEAR	(1777RQEZ=)  PROTEIN C ACTIVITY
0.5 ML
(4948RQEZ=)  PROTEIN C ANTIGEN
0.4 ML	0	6384	0
50277	LUPUS ACTIVITY PANEL 2	QUEST	0	17725	1	2			(5704RQEZ=)  C4 AND C3 COMPLEMENT GROUP
PLASTIC SCREW-CAP VIAL
(16093RQEZ=)  DNA(DS) AB, HIGH AVIDITY
PLASTIC SCREW-CAP VIAL	RF	(5704RQEZ=)  C4 AND C3 COMPLEMENT GROUP
RATE NEPHELOMETRY
(16093RQEZ=)  DNA(DS) AB, HIGH AVIDITY
ENZYME LINKED IMMUNOSORBENT IMMUNOASSAY (ELISA)	(5704RQEZ=)  C4 AND C3 COMPLEMENT GROUP
1 ML SERUM

OVERNIGHT FASTING IS PREFERRED.

SERUM SHOULD BE SEPARATED IMMEDIATELY FROM CLOT AND SHIPPED
REFRIGERATED.
FREEZE THAW CYCLES SHOULD BE AVOIDED AS IT CAUSES FALSE
ELEVATION OF C3 VALUES.
(16093RQEZ=)  DNA(DS) AB, HIGH AVIDITY
1 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)	(5704RQEZ=)  C4 AND C3 COMPLEMENT GROUP
ROOM TEMPERATURE 3 DAYS
REFRIGERATED 7 DAYS
FROZEN 1 MONTH  @ -20 C.
3 MONTHS @ -70 C.
(16093RQEZ=)  DNA(DS) AB, HIGH AVIDITY
ROOM TEMPERATURE   1 WEEK
REFRIGERATED       2 WEEKS
FROZEN             1 MONTH	(5704RQEZ=)  C4 AND C3 COMPLEMENT GROUP
0.5 ML
(16093RQEZ=)  DNA(DS) AB, HIGH AVIDITY
0.5 ML	0	6171	0
50283	FACTOR V HR2 ALLELE DNA MUTATION ANALYSIS	QUEST	50283	17902	1	2			(%17902RQEZ)  FACTOR V HR2 ALLELE
STERILE SCREW-CAP VIAL	RT	(%17902RQEZ)  FACTOR V HR2 ALLELE
POLYMERASE CHAIN REACTION (PCR), OLIGONUCLEOTIDE LIGATION
ASSAY, FLUORESCENT MICROSPHERES

FDA STATUS ASR1
THIS TEST WAS DEVELOPED AND ITS PERFORMANCE CHARACTERISTICS
HAVE BEEN DETERMINED BY QUEST DIAGNOSTICS NICHOLS INSTITUTE.
IT HAS NOT BEEN CLEARED OR APPROVED BY THE U.S.FOOD AND
DRUG ADMINISTRATION. THE FDA HAS DETERMINED THAT SUCH
CLEARANCE OR APPROVAL IS NOT NECESSARY. PERFORMANCE
CHARACTERISTICS REFER TO THE ANALYTICAL PERFORMANCE
OF THE TEST.		(%17902RQEZ)  FACTOR V HR2 ALLELE
ROOM TEMP  8 DAYS
REFRIG     8 DAYS
FROZEN     UNACCEPTABLE	(%17902RQEZ)  FACTOR V HR2 ALLELE
3 ML	0	6183	0
41432	XYLOSE, URINE, FASTING	QUEST	0	34739	1	0			FLUORIDE OXALATE URINE TUBE	RT	COLORIMETRY	5 ML URINE COLLECTED IN A FLUORIDE OXALATE URINE TUBE
(GRAY-TOP)

1. AT THE START OF THE TEST, WHEN THE PATIENT EMPTIES THE
BLADDER, RETAIN AN ALIQUOT OF THE URINE.

2. AN ALIQUOT OF THE URINE SPECIMEN COLLECTED SHOULD BE
TRANSFERRED TO AN EMPTY GRAY-TOP BLOOD COLLECTION TUBE;
THE OXALATE/FLUORIDE WILL SERVE AS A PRESERVATIVE FOR
THE URINE. IF GRAY-TOP TUBE IS GLASS, PLEASE TRANSFER
URINE TO A PLASTIC TUBE BEFORE SHIPPING. IF ADDITIONAL
TEST ARE NEEDED SEND SEPARATE SPECIMEN.

ADULT PATIENTS AND CHILDREN SHOULD BE KEPT FASTING OVER-
NIGHT AND DURING TEST PERIOD (INFANTS ARE FASTED FOR 4
HOURS).	ROOM TEMPERATURE 7 DAYS
REFRIGERATED 7 DAYS
FROZEN      30 DAYS	1 ML URINE COLLECTED IN A FLUORIDE OXALATE URINE TUBE
(GRAY-TOP)	0	5760	0
41626	ARBOVIRUS ANTIBODY PANEL, IFA (CSF)	QUEST	0	3621	1	0			(%39566SB)  EASTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL, IFA
PLASTIC SCREW CAP VIAL
(%39567SB)  CALIFORNIA ENCEPHALITIS  VIRUS AB PNL, IFA
PLASTIC SCREW CAP VIAL
(%39568SB)  ST.LOUIS ENCEPHALITIS VIRUS AB PNL, IFA
PLASTIC SCREW CAP VIAL
(%39569SB)  WESTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL,IFA
PLASTIC SCREW CAP VIAL	RF	(%39566SB)  EASTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL, IFA
IFA
(%39567SB)  CALIFORNIA ENCEPHALITIS  VIRUS AB PNL, IFA
IFA
(%39568SB)  ST.LOUIS ENCEPHALITIS VIRUS AB PNL, IFA
IFA
(%39569SB)  WESTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL,IFA
IFA	(%39566SB)  EASTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL, IFA
1 ML CSF
(%39567SB)  CALIFORNIA ENCEPHALITIS  VIRUS AB PNL, IFA
1 ML CSF
(%39568SB)  ST.LOUIS ENCEPHALITIS VIRUS AB PNL, IFA
1 ML CSF
(%39569SB)  WESTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL,IFA
1 ML CSF		(%39566SB)  EASTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL, IFA
0.2 ML
(%39567SB)  CALIFORNIA ENCEPHALITIS  VIRUS AB PNL, IFA
0.2 ML
(%39568SB)  ST.LOUIS ENCEPHALITIS VIRUS AB PNL, IFA
0.2 ML
(%39569SB)  WESTERN EQUINE ENCEPHAL- ITIS VIRUS AB PNL,IFA
0.2 ML	0	6259	0
42022	ELECTROPHORESIS, PROTEIN 24-HOUR URINE AND IMMUNOFIXATION STUDIES	QUEST	0	38944	1	2			(213SB=)  IMMUNOFIXATION, URINE
PLASTIC SCREW-CAP VIAL
(%750SB)  ELECTROPHORESIS (U)
24 HOUR URINE CONTAINER
(757SB=)  PROTEIN, TOTAL, 24 HOUR URINE (W/ CREATININE)
PLASTIC SCREW-CAP CONTAINER	RT	(213SB=)  IMMUNOFIXATION, URINE
AGAROSE GEL ELECTROPHORESIS WITH IMMUNOFIXATION
(%750SB)  ELECTROPHORESIS (U)
ELECTROPHORESIS
(757SB=)  PROTEIN, TOTAL, 24 HOUR URINE (W/ CREATININE)
SPECTROPHOTOMETRY-COLORIMETRIC	(213SB=)  IMMUNOFIXATION, URINE
50 ML ALIQUOT OF RANDOM OR 24 HOUR URINE IN A PLASTIC
CONTAINER.
NO PRESERVATIVE
(%750SB)  ELECTROPHORESIS (U)
25 ML ALIQUOT OF 24 HOUR URINE (NO PRESERVATIVES).

INSTRUCTIONS TOTAL VOLUME REQUIRED.
RECORD ON BOTH THE SPECIMEN CONTAINER
AND THE REQUEST FORM.
(757SB=)  PROTEIN, TOTAL, 24 HOUR URINE (W/ CREATININE)
10 ML ALIQUOT FROM A WELL-MIXED, 24 HOUR COLLECTION
NO PRESERVATIVES
INSTRUCTIONS
RECORD VOLUME ON REQUISITION AND ALIQUOT BOTTLE

NOTE THE URINALYSIS TRANSPORT TUBE (YELLOW-TOP, BLUE FILL
LINE, PRESERVATIVE TUBE) CANNOT BE USED FOR PROTEIN
ELECTROPHORESIS ON URINE. PLEASE SUBMIT 25 ML ALIQUOT OF
24 HOUR URINE (NO PRESERVATIVES).	(213SB=)  IMMUNOFIXATION, URINE
ROOM TEMPERATURE  5 DAYS
REFRIGERATED      7 DAYS
FROZEN           30 DAYS
(757SB=)  PROTEIN, TOTAL, 24 HOUR URINE (W/ CREATININE)
ROOM TEMPERATURE 4 DAYS
REFRIGERATED     5 DAYS
-20 DEG. C       1 MONTH
-70 DEG. C       NOT AVAILABLE	(213SB=)  IMMUNOFIXATION, URINE
10 ML.
IF TEST NEEDS TO BE REPEATED FOR ANY REASON,
WE MAY BE UNABLE TO GIVE YOU A RESULT.
(%750SB)  ELECTROPHORESIS (U)
10 ML
(757SB=)  PROTEIN, TOTAL, 24 HOUR URINE (W/ CREATININE)
2 ML	0		0
39548	THROMBOSIS PANEL	QUEST	39548	11051	1	2			(22RQEZ=)  ACTIVATED PROTEIN C-RESISTANCE
PLASTIC SCREW CAP VIAL
(1777RQEZ=)  PROTEIN C ACTIVITY
PLASTIC SCREW-CAP VIAL
(1779RQEZ=)  PROTEIN S ACTIVITY
PLASTIC SCREW-CAP VIAL
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
PLASTIC SCREW-CAP VIAL	FZ	(22RQEZ=)  ACTIVATED PROTEIN C-RESISTANCE
RVVT BASED CLOT ASSAY
(1777RQEZ=)  PROTEIN C ACTIVITY
CLOTTING ASSAY
(1779RQEZ=)  PROTEIN S ACTIVITY
CLOT DETECTION
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
CHROMOGENIC SUBSTRATE		(22RQEZ=)  ACTIVATED PROTEIN C-RESISTANCE
ROOM TEMPERATURE 1 HOUR
REFRIGERATED 4 HOURS
FROZEN       6 MONTHS AT -70c
(1777RQEZ=)  PROTEIN C ACTIVITY
ROOM TEMPERATURE UNACCEPTABLE
REFRIGERATED UNACCEPTABLE
FROZEN -70 DEGREES 1 YEAR
(1779RQEZ=)  PROTEIN S ACTIVITY
ROOM TEMPERATURE NOT STABLE
REFRIGERATED NOT STABLE
-20 C 2 WEEKS
-70 C 1 YEAR
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
ROOM TEMPERATURE  6 HOURS
REFRIGERATED     48 HOURS
FROZEN            1 MONTH	(22RQEZ=)  ACTIVATED PROTEIN C-RESISTANCE
1 ML PLASMA
(1777RQEZ=)  PROTEIN C ACTIVITY
0.5 ML
(1779RQEZ=)  PROTEIN S ACTIVITY
0.2 ML 3.2% SODIUM CITRATE (LIGHT BLUE-TOP)
(216RQEZ=)  ANTITHROMBIN III ACTIVITY
0.5 ML PLASMA *FROZEN*	0		0
39549	LATEX SPECIFIC IGE PANEL	QUEST	0	11055	1	0			STERILE SCREW CAP VIAL	RT	RADIOIMMUNOASSAY	2 ML SERUM
THE SERA CAN BE SHIPPED AT ROOM TEMPERATURE	ROOM TEMPERATURE   28 DAYS
REFRIGERATED       28 DAYS
FROZEN              1 YEAR		0	5762	0
50298	SYSTEMIC LUPUS ERYTHEMATOSUS (SLE) DIAGNOSTIC PANEL, DRUG INDUCED	QUEST	0	19874	1	2			(37056RQEZ=)  HISTONE ANTIBODIES
PLASTIC SCREW CAP VIAL
(%38318RQEZ)  ANA SCREEN IFA
PLASTIC SCREW-CAP VIAL
(%36209BRQEZ)  ANA, TITER AND PATTERN
PLASTIC SCREW-CAP VIAL		(37056RQEZ=)  HISTONE ANTIBODIES
ENZYME IMMUNOASSAY
(%38318RQEZ)  ANA SCREEN IFA
IMMUNOFLUORESCENT ASSAY (IFA)
(%36209BRQEZ)  ANA, TITER AND PATTERN
IMMUNOFLUORESCENT ASSAY (IFA)	(37056RQEZ=)  HISTONE ANTIBODIES
1 ML SERUM COLLECTED IN A NO ADDITIVE (RED-TOP) TUBE

AVOID HEMOLYSIS
OVERNIGHT FASTING PREFERRED
(%38318RQEZ)  ANA SCREEN IFA
1 ML SERUM
(%36209BRQEZ)  ANA, TITER AND PATTERN
1 ML SERUM	(37056RQEZ=)  HISTONE ANTIBODIES
ROOM TEMPERATURE 8 HOURS
REFRIGERATED; 1 WEEK
FROZEN 1 MONTH
(%38318RQEZ)  ANA SCREEN IFA
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG C    1 MONTH
-70 DEG C    INDEFINITELY
(%36209BRQEZ)  ANA, TITER AND PATTERN
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG C    1 MONTH
-70 DEG C    INDEFINITELY	(37056RQEZ=)  HISTONE ANTIBODIES
0.3 ML
(%38318RQEZ)  ANA SCREEN IFA
0.2 ML
(%36209BRQEZ)  ANA, TITER AND PATTERN
0.2 ML	0	6207	0
41920	CASEIN/COW MILK (AGF78) IGG	QUEST	0	38100	1	0			PLASTIC SCREW-CAP VIAL	RT	FLUORENZYME IMMUNOASSAY (FEIA)	1 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)	ROOM TEMPERATURE 2 WEEKS
REFRIGERATED     2 WEEKS
FROZEN     1 MONTH	0.3 ML	0	5762	0
50291	RHEUMATOID FACTOR (IGA, IGG, IGM)	QUEST	0	19705	1	2			(15683RQEZ=)  RHEUMATOID FACTOR (IGG)
PLASTIC SCREW-CAP VIAL
(15682RQEZ=)  RHEUMATOID FACTOR (IGA)
PLASTIC SCREW-CAP VIAL
(%17743RQEZ)  RHEUMATOID FACTOR (IGM)
PLASTIC SCREW-CAP VIAL	RF	(15683RQEZ=)  RHEUMATOID FACTOR (IGG)
IMMUNOASSAY
(15682RQEZ=)  RHEUMATOID FACTOR (IGA)
IMMUNOASSAY
(%17743RQEZ)  RHEUMATOID FACTOR (IGM)
IMMUNOASSAY	(15683RQEZ=)  RHEUMATOID FACTOR (IGG)
1 ML SERUM
(15682RQEZ=)  RHEUMATOID FACTOR (IGA)
1 ML SERUM
(%17743RQEZ)  RHEUMATOID FACTOR (IGM)
1 ML SERUM	(15683RQEZ=)  RHEUMATOID FACTOR (IGG)
ROOM TEMPERATURE 48 HOURS
REFRIGERATED 8 DAYS
FROZEN 28 DAYS
(15682RQEZ=)  RHEUMATOID FACTOR (IGA)
ROOM TEMPERATURE 48 HOURS
REFRIGERATED 8 DAYS
FROZEN 28 DAYS
(%17743RQEZ)  RHEUMATOID FACTOR (IGM)
ROOM TEMPERATURE 48 HOURS
REFRIGERATED 8 DAYS
FROZEN 28 DAYS	(15683RQEZ=)  RHEUMATOID FACTOR (IGG)
0.3 ML
(15682RQEZ=)  RHEUMATOID FACTOR (IGA)
0.3 ML
(%17743RQEZ)  RHEUMATOID FACTOR (IGM)
0.3 ML	0	6199	0
50330	SENSORY NEUROPATHY PROFILE 262	QUEST	0	34501	1	2				RT		(34200SB=)  SENSORIMOTOR NEUROPATHY PROFILE
THIS TEST IS PERFORMED AT ATHENA

2 ML SERUM
SHIP ROOM TEMPERATURE *IF DELAYED, REFRIGERATE*
ROOM TEMPERATURE IS PREFERRED
(34500SB=)  GALOP ANTIBODY TEST
THIS TEST IS PERFORMED AT ATHENA

2 ML SERUM COLLECTED IN A RED-TOP TUBE (NO GEL)
IF SENT REFRIGERATED, SHIP ON COLD PACKS
IF RECEIVED FROZEN, DO NOT THAW	(34200SB=)  SENSORIMOTOR NEUROPATHY PROFILE
ROOM TEMPERATURE 2 WEEKS
REFRIGERATED 2 WEEKS
-70 DEG.C 6-12 MONTHS
(34500SB=)  GALOP ANTIBODY TEST
ROOM TEMPERATURE 72 HOURS
REFRIGERATED  2 WEEKS
FROZEN NOT PREFERRED, BUT IF RECEIVED FROZEN DO
NOT THAW		0	6246	0
50358	ANTI SMOOTH MUSCLE MITO AB	QUEST	0	37466	1	2			(259SB=)  MITOCHONDRIAL AB W/REFL TITER
PLASTIC SCREW-CAP VIAL
(263SB=)  SMOOTH MUSCLE AB W/REFL TITER
PLASTIC SCREW-CAP VIAL	RT	(259SB=)  MITOCHONDRIAL AB W/REFL TITER
IMMUNOFLUORESCENT ASSAY (IFA)
(263SB=)  SMOOTH MUSCLE AB W/REFL TITER
IMMUNOFLUORESCENT ASSAY (IFA)	(259SB=)  MITOCHONDRIAL AB W/REFL TITER
1 ML SERUM
(263SB=)  SMOOTH MUSCLE AB W/REFL TITER
1 ML SERUM	(259SB=)  MITOCHONDRIAL AB W/REFL TITER
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG. C   1 MONTH
-70 DEG. C   INDEFINITELY
(263SB=)  SMOOTH MUSCLE AB W/REFL TITER
ROOM TEMPERATURE 4 DAYS
REFRIGERATED 7 DAYS
-20 DEG. C   1 MONTH
-70 DEG. C   INDEFINITELY	(259SB=)  MITOCHONDRIAL AB W/REFL TITER
0.2 ML
(263SB=)  SMOOTH MUSCLE AB W/REFL TITER
0.2 ML	0	6276	0
50373	ELECTROPHORESIS, PROTEIN 24-HOUR URINE AND IMMUNOFIXATION STUDIES	QUEST	0	38944	1	0				RT	

				0	6293	0
iam having excel sheet columns like 
70010@MYELOGRAPHY; INTERPRETATION ONLY @@70015@CISTERNOGRAPHY
like wise some records are there now i have to import this into above table as 700010 is TEST_CDC_CODE AND MYELOGRAPHY; INTERPRETATION ONLY IS TEST_NAME; CAN ANYONE HELP ME HOW TO DO THIS


Re: how to import .csv file into oracle database using a not null column [message #393784 is a reply to message #393781] Tue, 24 March 2009 05:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Totally useless, in addition it scrambles the topic.

Regards
Michel
Previous Topic: recordlength & buffer parameter in IMP
Next Topic: Exp "Export terminated successfully with warnings"
Goto Forum:
  


Current Time: Sun Dec 04 16:54:35 CST 2016

Total time taken to generate the page: 0.04303 seconds