QS_QCP_CHSET_VW (SQL View)	Index Back
Meas Plans used in QCPlans rre rre 05/31/00 -- Created to replace prompt table views used in drop down lists due to errors Gromit #999001

QS_QCP_CHSET_VW

(SQL View)

Meas Plans used in QCPlans

rre rre 05/31/00 -- Created to replace prompt table views used in drop down lists due to errors Gromit #999001

select DISTINCT a.business_unit, a.qs_app_context, a.qs_mfds_plan_id, b.qs_mfds_plan_name from PS_QS_STREAM_ROOT a, ps_qs_mfds_plan b where a.qs_mfds_plan_id = b.qs_mfds_plan_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 QS_APP_CONTEXT Character(18) VARCHAR2(18) NOT NULL QC application context identifier

3 QS_MFDS_PLAN_ID Number(8,0) INTEGER NOT NULL ADDED label field name for display purposes

4 QS_MFDS_PLAN_NAME Character(38) VARCHAR2(38) NOT NULL Measurement plan identifier Note: replaces qc_step_id for release 8.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	QS_APP_CONTEXT	Character(18)	VARCHAR2(18) NOT NULL	QC application context identifier
3	QS_MFDS_PLAN_ID	Number(8,0)	INTEGER NOT NULL	ADDED label field name for display purposes
4	QS_MFDS_PLAN_NAME	Character(38)	VARCHAR2(38) NOT NULL	Measurement plan identifier Note: replaces qc_step_id for release 8.