SETIDR_COMPONENT_IDDOC=Doc
HW=HW
SER=Service
TDOC=Third Party Documentation
TEST=Test
THW=Third Party HW
TSER=Thrid Party Service
TSW=Third Party SW
RQ_ROOT_CDFN_VW(SQL View) |
Index Back |
|---|---|
Highest Node ComponentQuality root node in Hierarchy Component view |
| SELECT A.SETID , A.R_COMPONENT_ID , A.R_COMPONENT_TYPE , A.R_COMPONENT_NAME , A.R_COMPONENT_CLASS FROM PS_RQ_COMP_DFN A WHERE NOT EXISTS ( SELECT 'x' FROM PS_RQ_COMP_LNK B WHERE A.SETID = B.SETID AND A.R_COMPONENT_ID = B.R_COMPONENT_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | R_COMPONENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | COMPONENT ID |
| 3 | R_COMPONENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Component Type |
| 4 | R_COMPONENT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Component Name |
| 5 | R_COMPONENT_CLASS | Character(4) | VARCHAR2(4) NOT NULL |
Component Class
DOC=Doc HW=HW SER=Service TDOC=Third Party Documentation TEST=Test THW=Third Party HW TSER=Thrid Party Service TSW=Third Party SW |