IT_AG_TREE_NAME (SQL View)	Index Back
IT Asset Group Tree Name

IT_AG_TREE_NAME

(SQL View)

IT Asset Group Tree Name

SELECT %Substring(C.SETCNTRLVALUE,1,5) ,F.FIELDNAME ,T.TREE_NAME ,T.EFFDT ,T.EFF_STATUS ,T.DESCR 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 (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

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description