QS_OP_SEQ (SQL Table)	Index Back
Prompt Table for Op Seq This record with values 1-9999 for op_seq is shipped with quality. It is used as a drop down list for the OP SEQ hierarchy field. It exists because we require a drop down list for each hierarchy field, however, OP SEQ values are from more than one record in manufacturing and a UNION is needed to get values from both records. A UNION is not supported on all platforms. This prompt table is set as defaul in field catalog, used in Quality Control Plan. Default can be overriden by user in Quality Function.

QS_OP_SEQ

(SQL Table)

Prompt Table for Op Seq

This record with values 1-9999 for op_seq is shipped with quality. It is used as a drop down list for the OP SEQ hierarchy field. It exists because we require a drop down list for each hierarchy field, however, OP SEQ values are from more than one record in manufacturing and a UNION is needed to get values from both records. A UNION is not supported on all platforms. This prompt table is set as defaul in field catalog, used in Quality Control Plan. Default can be overriden by user in Quality Function.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 QS_KEY Character(1) VARCHAR2(1) NOT NULL Set Number
1=1
Default Value: 1

2 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	QS_KEY	Character(1)	VARCHAR2(1) NOT NULL	Set Number 1=1 Default Value: 1
2	COMPL_OP_SEQ	Number(4,0)	SMALLINT NOT NULL	Completion Operation Sequence