GL_KIB_TREE_VW

(SQL View)
 Index Back

GL Insights Tree Name

GL Insights Tree Prompt view

SELECT DISTINCT F.FIELDNAME ,A.SETID_TREE ,A.TREE_NAME_OTBI ,A.TREE_NAME ,A.TREE_EFFDT ,T.DESCR FROM PS_OI_TFLT_FIELDS F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_ACCOUNT) A WHERE (F.FIELDNAME = S.DTL_FIELDNAME OR F.FIELDNAME = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME AND T.EFFDT = A.TREE_EFFDT AND T.SETID = A.SETID_TREE UNION SELECT DISTINCT F.FIELDNAME ,A.SETID_TREE ,A.TREE_NAME_OTBI ,A.TREE_NAME ,A.TREE_EFFDT ,T.DESCR FROM PS_OI_TFLT_FIELDS F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_DEPT) A WHERE (F.FIELDNAME = S.DTL_FIELDNAME OR F.FIELDNAME = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME AND T.EFFDT = A.TREE_EFFDT AND T.SETID = A.SETID_TREE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
2 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
3 TREE_NAME_KIB Character(30) VARCHAR2(30) NOT NULL Tree Name
4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
5 TREE_EFFDT Date(10) DATE Effective date of the Tree
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description