Navigation:  SPC >

Collection data

 Previous  Top  Next

Overview

This command will list the data displayed in the collection data screen.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

SCCOLLECT

Data collection configuration record

CDCOLLECT

OBCHARTPROFILE

DCCATEGORY

OBCHARTPROFILE

Charts view profile

CDCHARTPROFILE

SCCOLLECT

DCCATEGORY

Document category

CDCATEGORY

SCCOLLECT

 

Oracle/Postgres/SQL Server

SELECT
   COL.IDCOLLECT,
   COL.DTSTARTCOLL,
   COL.FGPROCMAPPING,
   COL.QTSAMPLEEND,
   CONTROLPROFILE.IDCHARTPROFILE,
   CONTROLPROFILE.NMCHARTPROFILE,
   CATG.IDCATEGORY,
   CATG.NMCATEGORY
FROM
   SCCOLLECT COL
   LEFT JOIN OBCHARTPROFILE CONTROLPROFILE ON (COL.CDCTRLPANELPROFILE = CONTROLPROFILE.CDCHARTPROFILE)
   LEFT JOIN DCCATEGORY CATG ON (COL.CDCATEGORY = CATG.CDCATEGORY)
WHERE
   COL.IDCOLLECT = 'COLLECTION ID' /* NOTE 1 */

 

Notes

▪1: Collection ID #.

 

Fields used on the view screen

cep-01

 

#

Field ID

Type

Description

1

IDCOLLECT

VARCHAR(50)

Collection ID #

2

DTSTARTCOLL

DATETIME

Collection start date

3

FGPROCMAPPING

NUMERIC(2)

Type of object to be collected:

1 - Product in progress with SE Process integration

2 - Product in progress without SE Process

3 - Finished product

4 - Process

5 - Process activity

6 - Workflow

7 - Workflow activity

8 - Free object

4

QTSAMPLEEND

NUMERIC(10)

# of samples

5

IDCHARTPROFILE

VARCHAR(50)

View profile ID #

5

NMCHARTPROFILE

VARCHAR(255)

View profile name

6

IDCATEGORY

VARCHAR(50)

Document category ID #

6

NMCATEGORY

VARCHAR(255)

Document category name