Overview

This command will list the FMEA type data.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
FMFMEATYPE	FMEA type data	CDFMEATYPE	GNGENTYPE
GNGENTYPE	FMEA type data	CDGENTYPE	FMFMEATYPE GNMASK GNREVCONFIG
GNMASK	Identification mask data	CDMASK	GNGENTYPE
GNREVCONFIG	Revision configurations	CDREVCONFIG	GNGENTYPE

Oracle/Postgres/SQL Server

SELECT
   GNTY.IDGENTYPE,
   GNTY.NMGENTYPE,
   GNTYOWNER.IDGENTYPE AS IDGENTYPEOWNER,
   GNTYOWNER.NMGENTYPE AS NMGENTYPEOWNER,
   FMTY.FGVERSION,
   FMTY.FGFMEATYPE,
   GNMASK.IDMASK,
   GNMASK.NMMASK,
   GNTY.FGEDITID,
   REVCONF.FGUSEREVISION,
   REVCONF.FGTYPEREVISION
FROM
   FMFMEATYPE FMTY
   INNER JOIN GNGENTYPE GNTY ON (FMTY.CDFMEATYPE = Gnty.Cdgentype)
   LEFT JOIN GNGENTYPE GNTYOWNER ON (GNTYOWNER.CDGENTYPE = Gnty.Cdgentypeowner)
   LEFT JOIN GNMASK GNMASK ON (GNMASK.CDMASK = GNTY.CDMASK)
   LEFT JOIN GNREVCONFIG REVCONF ON (REVCONF.CDREVCONFIG = GNTY.CDREVCONFIG)
WHERE
   GNTY.IDGENTYPE LIKE 'TYPE_ID' /* NOTE1 */

Notes

▪1: FMEA type ID #.

Fields used on the view screen

fmea-06

fmea-07

#	Field ID	Type	Description
1	IDGENTYPE	VARCHAR(50)	FMEA type ID #
2	NMGENTYPE	VARCHAR(255)	FMEA type name
3	IDGENTYPEOWNER	VARCHAR(50)	Upper level FMEA type ID #
3	NMGENTYPEOWNER	VARCHAR(255)	Upper level FMEA type name
4	FGVERSION	NUMERIC(2)	FMEA version: 1 - 4th edition 2 - AIAG&VDA
5	FGFMEATYPE	NUMERIC(2)	FMEA type: 1 - Design (DFMEA) 2 - Process (PFMEA) 3 - Asset 4 - Project structure (Schedule) 5 - Object
6	IDMASK	VARCHAR(50)	Identification mask ID #
6	NMMASK	VARCHAR(255)	Identification mask name
7	FGEDITID	NUMERIC(2)	Enable ID # change: 1 - Yes 2 - No
8	FGUSEREVISION	NUMERIC(2)	Control revision: 1 - Yes 2 - No
9	FGTYPEREVISION	NUMERIC(2)	Revision type: 1 - ISO9000 based 2 - Revision via workflow