BUSINESS_UNITQS_APP_CONTEXTMFDS_NAMEDEF=Defects
DEFS=Defectives
DFTV=Defectives
VAR=Variables
QS_MFDS_NAME_VW(SQL View) |
Index Back |
|---|---|
Characteristic Names |
| SELECT DISTINCT a. business_unit , a.qs_app_context , a.mfds_name , a.mfds_class_type_cd , a.mfds_data_type_cd FROM PS_QS_MFDS_MST 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 | MFDS_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Characteristic |
| 4 | MFDS_CLASS_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | characteristic - class type code |
| 5 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |