FLAT

Flat table combines the SAMPLE, TEST, RESULTS, AND QC tables providing a flat version of the relational files. Table structure and example files are provided below:

 
FLAT - Table
Field Name Attrib Key Field Position
Start End
FIELD_PT_NAME C10   1 10
LOGDATE D8 PK 11 18
LOGTIME C4 PK 19 22
LOGCODE C4 PK 23 26
SAMPID C25 PK 27 51
MATRIX C2 PK 52 53
PROJNAME C25   54 78
LABWO C7   79 85
GLOBAL_ID C12   86 97
LABCODE C4 PK 98 101
LABSAMPID C12 PK 102 113
QCCODE C3 PK 114 116
ANMCODE C7 PK 117 123
MODPARLIST L1   124 124
EXMCODE C7 PK 125 131
LABLOTCTL C10 PK 132 143
LCHMETH C10   144 153
ANADATE D8 PK 154 161
EXTDATE D8   162 169
RUN_NUMBER N2 PK 170 171
RECDATE D8   172 179
COCNUM C16   180 195
BASIS C1   196 196
PRESCODE C15   197 211
SUB C4   212 215
REP_DATE D8   216 223
LAB_REPNO C20   224 243
APPRVD C3   244 246
TLNOTE C20   247 266
PVCCODE C2 PK 267 268
PARLABEL C12 PK 269 280
PARVAL N14   281 294
PARVQ C2   295 296
LABDL N9   297 305
REPDL N9   306 314
REPDLVQ C3   315 317
PARUN N12   318 329
UNITS N10   330 339
RT N7   340 346
DILFAC N10   347 356
CLREVDATE D8   357 364
SRM C12   365 376
EXPECTED N14   377 390
RLNOTE C20   391 410
USER_ADMIN_ID C25   411 435
COC_MATRIX C2   436 437
DQO_ID C25   438 462
REQ_METHOD_GRP C25   463 487
PROCEDURE_NAME C240   488 727
METH_DESIGN_ID C25   728 752
LAB_METH_GRP C25   753 777
CLEANUP C15   778 792
RES_FF_1 C25   793 817
RES_FF_2 C25   818 842
RES_FF_3 C25   844 868
RES_FF_4 C25   869 893
RES_FF_5 C25   894 918

PK = Primary Key     

Example Files
Version File Name
 
EDF 1.2i EDFFLAT.TXT

PK = Primary Key     

Excel Template
Version File Name
 
EDF 1.2i EDFFLAT_EXCEL.ZIP