GTAS_TPRTLVL_VW

(SQL View)
Index Back

GTAS tree level prompt vw

Used to prompt for GTAS Accts requiring Fund Attr tree level

SELECT DISTINCT A.SETID , A.TREE_NAME , A.EFFDT , B.EFF_STATUS , A.TREE_LEVEL , A.TREE_LEVEL_NUM FROM PSTREELEVEL A , PSTREEDEFN B WHERE A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TR_PARTNER_TREE Character(18) VARCHAR2(18) NOT NULL Trading Partner Tree
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 TR_PARTNER_LVL Character(10) VARCHAR2(10) NOT NULL Trading Partner Level
6 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record