TREE_SETIDIT_TREE_SETID(SQL View) |
Index Back |
|---|---|
IT Asset Group SetID |
| SELECT DISTINCT %Substring(C.SETCNTRLVALUE,1,5) FROM PS_FS_FLD_PROMPT F , PSTREESTRCT S , PSTREEDEFN T , PS_SET_CNTRL_TBL C WHERE F.FIELDNAME IN (%Sql(IT_ASSETGRP_FIELDS)) AND (F.FIELDNAME = S.DTL_FIELDNAME OR F.FIELDNAME = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND S.TREE_STRCT_TYPE = 'D' AND (C.SETID = T.SETID OR (EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_TREE WHERE SETCNTRLVALUE = C.SETCNTRLVALUE AND SETID = T.SETID AND TREE_NAME = T.TREE_NAME))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |