PJSA View
Contains job scheme analyte-centric data for reports.
| Table | Field | Data Type | Description |
|---|---|---|---|
| PROFJOB_SCHEME |
LABCODE |
Variable string (10) |
Code of the laboratory for the job associated with the job scheme. |
| PROFJOB_SCHEME |
PRO_JOB |
Variable string (20) |
Code of the job associated with the job scheme. |
| PROFJOB_SCHEME |
SCH_CODE |
Variable string (20) |
Code of the scheme associated with the job scheme. |
| PROFJOB_SCHEME |
SCHVERSION |
Integer |
Version number of the scheme associated with the job scheme. |
| PROFJOB_SCHEME_ANALYTE |
ANALYTECODE |
Variable string (20) |
Code of the analyte associated with the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE | REPSEQUENCE | Variable string (4) | Report sequence of the analyte associated with the job scheme analyte, from 0001 to 9999, with respect to other analytes within the job scheme. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_REPUNITCODE |
Variable string (20) |
Code of the report unit for the analyte associated with the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_REPDETLIMIT |
Real |
Reportable detection limit for the analyte associated with the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_REPUPPERLIMIT |
Real |
Reportable upper limit for the analyte associated with the job scheme analyte. |
| PROFJOB_SCHEME |
PJS_SCHSEQUENCE |
Variable string (4) |
Sequence of the scheme within the job, from 0001 to 9999, with respect to other schemes within the job. |
| PROFJOB_SCHEME |
PJS_REQUIRED |
Date-time |
Date-time the report is required for the results of the job scheme. |
| PROFJOB_SCHEME |
PJS_STARTED |
Date-time |
Date-time the job scheme started analysis. |
| PROFJOB_SCHEME |
PJS_LASTREPORTED |
Date-time |
Date-time the job scheme was last reported. |
| PROFJOB_SCHEME |
PJS_FIRSTREPORTED |
Date-time |
Date-time the job scheme was first reported. |
| PROFJOB_SCHEME |
PJS_COMPLETED |
Date-time |
Date-time the job scheme completed analysis. |
| PROFJOB_SCHEME |
PJS_VALIDATED |
Date-time |
Date-time the job scheme was validated. |
| PROFJOB_SCHEME |
PJS_VALIDATEDBY |
Variable string (20) |
Code of the staff member who validated the job scheme. |
| PROFJOB_SCHEME |
PJS_NOHOURS |
Real |
Number of hours taken to complete the job scheme. |
| PROFJOB_SCHEME |
PJS_PAGESIZE |
Integer |
Number of samples seen on the screen or worksheet at one time during analysis. |
| PROFJOB_SCHEME |
PJS_FINALISED |
Date-time |
Date-time the job scheme was finalised. |
| PROFJOB_SCHEME |
PJS_FINALISEDBY |
Variable string (20) |
Code of the staff member who finalised the job scheme. |
| PROFJOB_SCHEME |
PJS_PRICECODE |
Variable string (20) |
Code of the price item associated with the job scheme. |
| PROFJOB_SCHEME |
PJS_PROCEDURECODE |
Variable string (20) |
Code of the procedure used to profile the job scheme. |
| PROFJOB_SCHEME |
PJS_USERFIELD1..USERFIELD5 |
Variable string (n) |
Extra site-specific fields for the job scheme. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_ANASEQUENCE |
Variable string (4) |
Sequence of the analyte within the job scheme, from 0001 to 9999, with respect to other analytes within the job schee. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_REQUIRED |
Date-time |
Date-time the report is required for the results of the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_STARTED |
Date-time |
Date-time the job scheme analyte started analysis. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_LASTREPORTED |
Date-time |
Date-time the job scheme analyte was last reported. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_FIRSREPORTED |
Date-time |
Date-time the job scheme analyte was first reported. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_COMPLETED |
Date-time |
Date-time the job scheme analyte completed analysis. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_VALIDATED |
Date-time |
Date-time the job scheme analyte was validated. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_VALIDATEDBY |
Variable string (20) |
Code of the staff member who validated the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_ANALYTESTATUS |
Variable string (3) |
Status of the analytical result across all samples in the job: Left empty (Not started), STA (Started), CPL (Completed). |
| PROFJOB_SCHEME_ANALYTE |
PJSA_REPORTACTIVE |
Boolean |
Indicates whether the job scheme analyte is reportable. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_PRICECODE |
Variable string (20) |
Code of the price item associated with the job scheme analyte. |
| PROFJOB_SCHEME_ANALYTE |
PJSA_USERFIELD1..USERFIELD5 |
Variable string (n) |
Extra site-specific fields on the job scheme analyte. |
| SCHEME |
S_SCHEMENAME |
Variable string (40) |
Name of the scheme associated with the job scheme. |
| SCHEME |
S_DESCRIPTION |
Variable string (40) |
Description of the scheme associated with the job scheme. |
| SCHEME | S_USERFIELD1..USERFIELD5 | Variable string (n) Unicode |
Extra site-specific fields on the scheme associated with the job scheme. |
| SCHEME_ANALYTE |
SA_ANALYTENAME |
Variable string (40) |
Name of the analyte associated with the job scheme analyte. |
| SCHEME_ANALYTE |
SA_DESCRIPTION |
Variable string (40) |
Description of the analyte associated with the job scheme analyte. |
| SCHEME_ANALYTE |
SA_USERDEFNAME |
Variable string (40) |
User-defined name for the analyte associated with the job scheme analyte. |
| SCHEME_ANALYTE |
SA_USERFIELD1..USERFIELD5 |
Variable string (n) |
Extra site-specific fields on the analyte associated with the job scheme analyte. |
| SECTION |
SC_DESCRIPTION |
Variable string (40) |
Description of the section linked to the scheme associated with the job scheme. |
| UNIT |
U_UNITNAME |
Variable string (40) |
Name of the unit for the analyte associated with the job scheme analyte. |
| UNIT |
U_USERFIELD1..USERFIELD5 |
Variable string (n) Unicode |
Extra site-specific fields on the unit associated with the job scheme analyte. |
View the script used to create the view during CCLAS installation
create view PJSA as
select
PROFJOB_SCHEME.LABCODE,
PROFJOB_SCHEME.PRO_JOB,
PROFJOB_SCHEME.SCH_CODE,
PROFJOB_SCHEME.SCHVERSION,
PROFJOB_SCHEME_ANALYTE.ANALYTECODE,
PROFJOB_SCHEME_ANALYTE.REPSEQUENCE,
PROFJOB_SCHEME_ANALYTE.REPUNITCODE as PJSA_REPUNITCODE,
PROFJOB_SCHEME_ANALYTE.REPDETLIMIT as PJSA_REPDETLIMIT,
PROFJOB_SCHEME_ANALYTE.REPUPPERLIMIT as PJSA_REPUPPERLIMIT,
PROFJOB_SCHEME.SCHSEQUENCE as PJS_SCHSEQUENCE,
PROFJOB_SCHEME.REQUIRED as PJS_REQUIRED,
PROFJOB_SCHEME.STARTED as PJS_STARTED,
PROFJOB_SCHEME.LASTREPORTED as PJS_LASTREPORTED,
PROFJOB_SCHEME.FIRSTREPORTED as PJS_FIRSTREPORTED,
PROFJOB_SCHEME.COMPLETED as PJS_COMPLETED,
PROFJOB_SCHEME.VALIDATED as PJS_VALIDATED,
PROFJOB_SCHEME.VALIDATEDBY as PJS_VALIDATEDBY,
PROFJOB_SCHEME.NOHOURS as PJS_NOHOURS,
PROFJOB_SCHEME.PAGESIZE as PJS_PAGESIZE,
PROFJOB_SCHEME.FINALISED as PJS_FINALISED,
PROFJOB_SCHEME.FINALISEDBY as PJS_FINALISEDBY,
PROFJOB_SCHEME.PRICECODE as PJS_PRICECODE,
PROFJOB_SCHEME.PROCEDURECODE as PJS_PROCEDURECODE,
PROFJOB_SCHEME.USERFIELD1 as PJS_USERFIELD1,
PROFJOB_SCHEME.USERFIELD2 as PJS_USERFIELD2,
PROFJOB_SCHEME.USERFIELD3 as PJS_USERFIELD3,
PROFJOB_SCHEME.USERFIELD4 as PJS_USERFIELD4,
PROFJOB_SCHEME.USERFIELD5 as PJS_USERFIELD5,
PROFJOB_SCHEME_ANALYTE.ANASEQUENCE as PJSA_ANASEQUENCE,
PROFJOB_SCHEME_ANALYTE.REQUIRED as PJSA_REQUIRED,
PROFJOB_SCHEME_ANALYTE.STARTED as PJSA_STARTED,
PROFJOB_SCHEME_ANALYTE.LASTREPORTED as PJSA_LASTREPORTED,
PROFJOB_SCHEME_ANALYTE.FIRSTREPORTED as PJSA_FIRSTREPORTED,
PROFJOB_SCHEME_ANALYTE.COMPLETED as PJSA_COMPLETED,
PROFJOB_SCHEME_ANALYTE.VALIDATED as PJSA_VALIDATED,
PROFJOB_SCHEME_ANALYTE.VALIDATEDBY as PJSA_VALIDATEDBY,
PROFJOB_SCHEME_ANALYTE.ANALYTESTATUS as PJSA_ANALYTESTATUS,
PROFJOB_SCHEME_ANALYTE.REPORTACTIVE as PJSA_REPORTACTIVE,
PROFJOB_SCHEME_ANALYTE.PRICECODE as PJSA_PRICECODE,
PROFJOB_SCHEME_ANALYTE.USERFIELD1 as PJSA_USERFIELD1,
PROFJOB_SCHEME_ANALYTE.USERFIELD2 as PJSA_USERFIELD2,
PROFJOB_SCHEME_ANALYTE.USERFIELD3 as PJSA_USERFIELD3,
PROFJOB_SCHEME_ANALYTE.USERFIELD4 as PJSA_USERFIELD4,
PROFJOB_SCHEME_ANALYTE.USERFIELD5 as PJSA_USERFIELD5,
SCHEME.SCHEMENAME as S_SCHEMENAME,
SCHEME.DESCRIPTION as S_DESCRIPTION,
SCHEME.USERFIELD1 as S_USERFIELD1,
SCHEME.USERFIELD2 as S_USERFIELD2,
SCHEME.USERFIELD3 as S_USERFIELD3,
SCHEME.USERFIELD4 as S_USERFIELD4,
SCHEME.USERFIELD5 as S_USERFIELD5,
SCHEME_ANALYTE.ANALYTENAME as SA_ANALYTENAME,
SCHEME_ANALYTE.DESCRIPTION as SA_DESCRIPTION,
SCHEME_ANALYTE.USERDEFNAME as SA_USERDEFNAME,
SCHEME_ANALYTE.USERFIELD1 as SA_USERFIELD1,
SCHEME_ANALYTE.USERFIELD2 as SA_USERFIELD2,
SCHEME_ANALYTE.USERFIELD3 as SA_USERFIELD3,
SCHEME_ANALYTE.USERFIELD4 as SA_USERFIELD4,
SCHEME_ANALYTE.USERFIELD5 as SA_USERFIELD5,
SECTION.DESCRIPTION as SC_DESCRIPTION,
UNIT.UNITNAME as U_UNITNAME,
UNIT.USERFIELD1 as U_USERFIELD1,
UNIT.USERFIELD2 as U_USERFIELD2,
UNIT.USERFIELD3 as U_USERFIELD3,
UNIT.USERFIELD4 as U_USERFIELD4,
UNIT.USERFIELD5 as U_USERFIELD5
from
PROFJOB_SCHEME_ANALYTE
LEFT OUTER JOIN PROFJOB_SCHEME ON
PROFJOB_SCHEME_ANALYTE.LABCODE = PROFJOB_SCHEME.LABCODE and
PROFJOB_SCHEME_ANALYTE.PRO_JOB = PROFJOB_SCHEME.PRO_JOB and
PROFJOB_SCHEME_ANALYTE.SCH_CODE = PROFJOB_SCHEME.SCH_CODE and
PROFJOB_SCHEME_ANALYTE.SCHVERSION = PROFJOB_SCHEME.SCHVERSION
LEFT OUTER JOIN SCHEME_ANALYTE ON
PROFJOB_SCHEME_ANALYTE.LABCODE = SCHEME_ANALYTE.LABCODE and
PROFJOB_SCHEME_ANALYTE.SCH_CODE = SCHEME_ANALYTE.SCH_CODE and
PROFJOB_SCHEME_ANALYTE.SCHVERSION = SCHEME_ANALYTE.SCHVERSION and
PROFJOB_SCHEME_ANALYTE.ANALYTECODE = SCHEME_ANALYTE.ANALYTECODE
LEFT OUTER JOIN SCHEME ON
PROFJOB_SCHEME_ANALYTE.LABCODE = SCHEME.LABCODE and
PROFJOB_SCHEME_ANALYTE.SCH_CODE = SCHEME.SCH_CODE and
PROFJOB_SCHEME_ANALYTE.SCHVERSION = SCHEME.SCHVERSION
LEFT OUTER JOIN SECTION ON
SCHEME.LABCODE = SECTION.LABCODE and
SCHEME.SECTIONCODE = SECTION.SECTIONCODE
LEFT OUTER JOIN UNIT ON
PROFJOB_SCHEME_ANALYTE.LABCODE = UNIT.LABCODE and
PROFJOB_SCHEME_ANALYTE.REPUNITCODE = UNIT.UNITCODE
