QS_QCP_PTYPE_VW

(SQL View)
Index Back

Prod Types used in QCPlans

rre

SELECT DISTINCT a.business_unit , a.qs_app_context , a.production_type FROM PS_QS_STREAM_ROOT a

# 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 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown