Navigation: SPC >

Collection characteristics

Overview

This command will display the list of the characteristics of a collection.

Related tables

TABLE

Description

Primary key (PK)

Connection tables

SCCHARACITEMCOLL

Data collection characteristics record

CDCOLLECT

CDCHARACTERISTIC

SCCOLLECT

Data collection configuration record

CDCOLLECT

SCCHARACITEMCOLL

Oracle/Postgres/SQL Server

SELECT
   SCCHARITCOLL.FGSTATUS,
   SCCHARITCOLL.NRSEQUENCE,
   SCCHARITCOLL.IDCHARACTERISTIC,
   SCCHARITCOLL.NMCHARACTERISTIC,
   SCCHARITCOLL.FGCHARACTYPE
FROM
   SCCHARACITEMCOLL SCCHARITCOLL
   INNER JOIN SCCOLLECT COL ON (SCCHARITCOLL.CDCOLLECT = COL.CDCOLLECT)
WHERE
   COL.IDCOLLECT = 'COLLECTION ID'
   ORDER BY SCCHARITCOLL.NRSEQUENCE

Notes

▪1: Collection ID #.

Fields used on the view screen

cep-02

#	Field ID	Type	Description
1	FGSTATUS	NUMERIC(2)	Data collection status: 1 - Enabled 2 - Do not collect 3 - Finished
2	FGCHARACTYPE	NUMERIC(2)	Indicates the characteristic type: 0 - Attribute 1 - Variable
3	NRSEQUENCE	NUMERIC(10)	Sequence
4	IDCHARACTERISTIC	VARCHAR(50)	Characteristic ID #
5	NMCHARACTERISTIC	VARCHAR(255)	Characteristic name