SETIDR_COMPONENT_IDR_OTHER_COMP_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_CHIL_CDFN_VW(SQL View) |
Index Back |
|---|---|
Child Node ComponentQuality Component Definition view |
| SELECT A.SETID , A.R_OTHER_COMP_ID , A.R_COMPONENT_ID , B.R_COMPONENT_TYPE , B.R_COMPONENT_NAME , B.R_COMPONENT_CLASS FROM PS_RQ_COMP_LNK A , PS_RQ_COMP_DFN 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_OTHER_COMP_ID |
Character(15) | VARCHAR2(15) NOT NULL | other component id |
| 4 | R_COMPONENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Component Type |
| 5 | R_COMPONENT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Component Name |
| 6 | 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 |