COMBO_TRCF1_VW

(SQL View)
Index Back

NEW FOR 9

DYNAMIC VIEW FOR NON-ANCHOR CF

SELECT A.SETCNTRLVALUE ,A.COMBO_CHARTFIELD ,A.TREE_NAME ,A.EFFDT_TREE ,A.EFF_STATUS FROM PS_TREE_CHRTFD2_VW A UNION SELECT B.SETCNTRLVALUE ,B.COMBO_CHARTFIELD ,B.TREE_NAME ,B.EFFDT_TREE ,B.EFF_STATUS FROM PS_TREE_CF2PW_VW B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
2 COMBO_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Non-Anchor ChartField
3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
4 EFFDT_TREE Date(10) DATE Tree Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive