QS_MFDSPLAN_VW

(SQL View)
 Index Back

Measurement Plan Parent View

12/28/00 RRE Added Description. Added DESCR to view and set it as the update/display mode search record for measurement plan component (because it needed a view with no required fields). Additiionally, added prompt tables for bu and app context, default for Business unit as well as search init code to pick up default business unit. At the time of this edit- Find object references did not produce any results so I am assuming that these changes do not affect other areas.

SELECT BUSINESS_UNIT , QS_APP_CONTEXT , QS_MFDS_PLAN_NAME , QS_MFDS_PLAN_ID , DESCR 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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUQS_NONVW

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

Prompt Table: QS_APP_DEF

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
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description