RTBL_TREEDEFN

(SQL View)
 Index Back

RTBL PSTREEDEFN View

PSTREEDEFN View for RTBL

SELECT 'N' ,DEFN.TREE_NAME ,DEFN.SETID ,DEFN.SETCNTRLVALUE ,DEFN.EFFDT ,DEFN.EFF_STATUS ,DEFN.DESCR ,DEFN.TREE_CATEGORY ,DEFN.VALID_TREE ,STRCT.TREE_STRCT_ID ,STRCT.SETCNTRL_IND ,STRCT.NODE_FIELDNAME ,STRCT.DTL_FIELDNAME ,STRCT.NODE_RECNAME ,STRCT.DTL_RECNAME ,STRCT.LEVEL_RECNAME FROM PSTREEDEFN DEFN ,PSTREESTRCT STRCT WHERE (DEFN.TREE_STRCT_ID <> 'ACCESS_GROUP' AND DEFN.TREE_CATEGORY NOT IN ('CASH_POS_TREES', 'DEALING_TREES')) AND DEFN.TREE_STRCT_ID = STRCT.TREE_STRCT_ID AND STRCT.SETCNTRL_IND IN ('S', 'B')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BTN_SELECT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
5 EFFDT Date(10) DATE Effective Date
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 TREE_CATEGORY Character(18) VARCHAR2(18) NOT NULL Category name for the Tree
9 VALID_TREE Character(1) VARCHAR2(1) NOT NULL Valid Tree
N=Draft Tree
Y=Valid Tree
10 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).
11 SETCNTRL_IND Character(1) VARCHAR2(1) NOT NULL Tree Structure User Key Field Type Indicator
B=Business Unit
N=None
S=SetId Indirection
U=User Defined
12 NODE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Field name
13 DTL_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Record name
14 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name
15 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name
16 LEVEL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Level Record name