DEFC_ATTRLVL

(SQL View)
Index Back

DEFC Attribu Tree Level Prompt

Tree Level Prompt for Attribute field

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 DEFC_FUND_TREE Character(18) VARCHAR2(18) NOT NULL Disaster Emergency FundCode Tr
3 EFFDT Date(10) DATE Effective Date
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DEFC_FUND_LEVEL Character(10) VARCHAR2(10) NOT NULL DisasterEmergencyFundCodeLevel
6 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record