Navigation:  APQP >

APQP/PPAP forms

 Previous  Top  Next

Overview

The view displays the forms that compose the APQP/PPAP.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PAAPQP

APQP/PPAP data

CDAPQP

CDREVISION

GNREVISION

PAAPQPTASK

GNREVISION

Revision data

CDREVISION

PAAPQP

PAAPQPTASK

PAAPQPTASK

APQP/PPAP form data

CDAPQPTASK

PAAPQP

GNREVISION

PACUSTOMFORM

ADALLUSERS

ADTEAM

ADAPPROVALROUTE

PACUSTOMFORM

Customized form data

CDCUSTOMFORM

PAAPQPTASK

ADALLUSERS

User data (draft and approval)

CDUSER

PAAPQPTASK

ADTEAM

Team data (draft and approval)

CDTEAM

PAAPQPTASK

ADAPPROVALROUTE

Approval route

CDAPPROVALROUTE

PAAPQPTASK

 

Oracle/Postgres/SQL Server

SELECT
    A.IDAPQP,
    R.IDREVISION,
    T.FGSTATUS,
    CASE
        WHEN T.CDCUSTOMFORM > 31 THEN NULL
        ELSE T.CDCUSTOMFORM
    END AS CDCUSTOMFORM,
    CF.IDCUSTOMFORM,
    CF.NMCUSTOMFORM,
    T.DTSTARTPLAN,
    T.DTFINISHPLAN,
    T.QTDURATIONPLAN,
    T.DTSTARTREAL,
    T.DTFINISHREAL,
    T.QTDURATIONREAL,
    T.FGELABTYPE,
    CASE
        WHEN T.FGELABTYPE = 1 THEN ELABUSER.IDUSER
        WHEN T.FGELABTYPE = 2 THEN ELABTEAM.IDTEAM
        ELSE NULL
    END AS IDELAB,
    CASE
        WHEN T.FGELABTYPE = 1 THEN ELABUSER.NMUSER
        WHEN T.FGELABTYPE = 2 THEN ELABTEAM.NMTEAM
        ELSE NULL
    END AS NMELAB,
    T.FGAPROVTYPE,
    CASE
        WHEN T.FGAPROVTYPE = 1 THEN APROVUSER.IDUSER
        WHEN T.FGAPROVTYPE = 2 THEN APROVTEAM.NMTEAM
        WHEN T.FGAPROVTYPE = 3 THEN APROVROUTE.IDAPPROVALROUTE
        ELSE NULL
    END AS IDAPROV,
    CASE
        WHEN T.FGAPROVTYPE = 1 THEN APROVUSER.NMUSER
        WHEN T.FGAPROVTYPE = 2 THEN APROVTEAM.NMTEAM
        WHEN T.FGAPROVTYPE = 3 THEN APROVROUTE.NMAPPROVALROUTE
        ELSE NULL
    END AS NMAPROV
FROM PAAPQP A
    INNER JOIN GNREVISION R ON (R.CDREVISION = A.CDREVISION)
    INNER JOIN PAAPQPTASK T ON (T.CDAPQP = A.CDAPQP AND T.CDREVISION = A.CDREVISION)
    LEFT JOIN PACUSTOMFORM CF ON (CF.CDCUSTOMFORM = T.CDCUSTOMFORM AND CF.FGFORMTYPE <> 3)
    LEFT JOIN ADALLUSERS ELABUSER ON (ELABUSER.CDUSER = T.CDELABUSER)
    LEFT JOIN ADTEAM ELABTEAM ON (ELABTEAM.CDTEAM = T.CDELABTEAM)
    LEFT JOIN ADALLUSERS APROVUSER ON (APROVUSER.CDUSER = T.CDAPROVUSER)
    LEFT JOIN ADTEAM APROVTEAM ON (APROVTEAM.CDTEAM = T.CDAPROVTEAM)
    LEFT JOIN ADAPPROVALROUTE APROVROUTE ON (APROVROUTE.CDAPPROVALROUTE = T.CDAPROVROUTE)
WHERE
    A.IDAPQP LIKE 'APQP_ID' /* NOTE1 */
    AND R.IDREVISION LIKE 'APQP_REVISION_ID' /* NOTE2 */

 

Notes

▪NOTE1: APQP/PPAP ID #.

▪NOTE2: APQP/PPAP revision ID #.

 

Fields used on the view screen

apqp-01

 

#

Field ID

Type

Description

1

IDAPQP

VARCHAR(50)

APQP/PPAP ID #

2

IDAPQPREV

VARCHAR(50)

APQP/PPAP revision ID #

3

FGSTATUS

NUMERIC(2)

Form status:

1 - Planning

2 - To be started

3 - Execution

4 - Approval

5 - Finished

4

CDCUSTOMFORM

NUMERIC(10)

Form code:

1 - Team feasibility commitment

2 - Process FMEA

3 - Design FMEA

4 - Control plan

5 - Design FMEA checklist

6 - Equipment, tools, and test equipment checklist

7 - Design information checklist

8 - Product/process quality checklist

9 - Flow chart

10 - Installation checklist

11 - Characteristics matrix

12 - Process flowchart checklist

13 - Process FMEA checklist

14 - Control plan checklist

16 - Dimensional test

17 - Material test

18 - Performance test

19 - Appearance approval

20 - Submission certificate

21 - Planning summary and sign-offs

22 - Capability study

23 - Symbol x customer matrix

24 - GM1411 - Interim recovery worksheet

25 - VDA - Cover sheet

26 - VDA - Initial sample inspection

27 - SPC study

28 - Process control plan

29 - Manufacturing Quality Control (MQC)

31 - MSA study

4

IDCUSTOMFORM

VARCHAR(50)

Customized form ID #

4

NMCUSTOMFORM

VARCHAR(255)

Customized form name

5

DTSTARTPLAN

DATETIME

Planned start date

5

DTFINISHPLAN

DATETIME

Planned end date

6

QTDURATIONPLAN

NUMERIC(10)

Planned number of days

7

DTSTARTREAL

DATETIME

Execution start date

7

DTFINISHREAL

DATETIME

Execution end date

8

QTDURATIONREAL

NUMERIC(10)

Number of execution days

9

FGELABTYPE

NUMERIC(2)

Drafter type:

1 - User

2 - Team

10

IDELAB

VARCHAR(50)

Drafter ID #

10

NMELAB

VARCHAR(255)

Drafter name

11

FGAPROVTYPE

NUMERIC(2)

Approver type

1 - User;

2 - Team;

3 - Approval route;

4 - No approval

12

IDAPROV

VARCHAR(50)

Approver ID #

12

NMAPROV

VARCHAR(255)

Approver name