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

QS_MFDSDROP_VW

(SQL View)

Meas Plan drop down list

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

SELECT BUSINESS_UNIT , QS_APP_CONTEXT , QS_MFDS_PLAN_NAME , QS_MFDS_PLAN_ID FROM PS_QS_MFDS_PLAN

# 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_NAME Character(38) VARCHAR2(38) NOT NULL Measurement plan identifier Note: replaces qc_step_id for release 8.

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

#	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_NAME	Character(38)	VARCHAR2(38) NOT NULL	Measurement plan identifier Note: replaces qc_step_id for release 8.
4	QS_MFDS_PLAN_ID	Number(8,0)	INTEGER NOT NULL	ADDED label field name for display purposes