BUSINESS_UNITQS_APP_CONTEXTQS_MFDS_PLAN_IDSTREAM_ROOT_IDQS_SETUP_RT_VW(SQL View) |
Index Back |
|---|---|
DE_Setup via stream root view |
| select DISTINCT business_unit, qs_app_context, qs_mfds_plan_id, stream_root_id, de_setup_name from PS_QS_STREAM_ROOT |
| # | 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 | STREAM_ROOT_ID |
Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 5 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |