QS_UACC_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT ,A.QS_APP_CONTEXT ,A.STREAM_ROOT_ID ,A.DE_SETUP_NAME FROM PS_QS_STREAM_ROOT A WHERE A.DE_SETUP_NAME NOT LIKE ' %' |
| # | 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 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 4 | DE_SETUP_NAME | Character(48) | VARCHAR2(48) NOT NULL | Inspection setup name |