FLDREQ_TREE_VW

(SQL View)
 Index Back

Field Request Tree Detail

Field Request Detail - Trees

SELECT A.FLD_REQUEST_ID , A.TREE_NAME , ' ' , A.TREE_EFFDT , A.TREE_NODE , A.GL_NEW_NODE_FLG , A.GL_NEW_NODE_DESCR , A.TREE_NODE_TO , A.NODE_OR_LEAF_FLAG , A.AUTO_UPD_FLG , A.FLD_REQ_TRE_STATUS FROM %Table(FLD_REQ_TRE_DTL) A

  • Parent record: FLD_REQUEST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FLD_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Field Request ID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: FLD_REQ_TREE_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree
    5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: FLD_REQ_NODE_VW

    6 GL_NEW_NODE_FLG Character(1) VARCHAR2(1) NOT NULL New Tree Node

    Y/N Table Edit

    Default Value: N

    7 GL_NEW_NODE_DESCR Character(30) VARCHAR2(30) NOT NULL New Node Description
    8 TREE_NODE_TO Character(20) VARCHAR2(20) NOT NULL Move/Add Node to Parent Node

    Prompt Table: FLD_REQ_NODE_VW

    9 NODE_OR_LEAF_FLAG Character(4) VARCHAR2(4) NOT NULL Node/Leaf
    LEAF=Find Detail Value
    NODE=Find Node

    Default Value: LEAF

    10 AUTO_UPD_FLG Character(1) VARCHAR2(1) NOT NULL Auto Update

    Y/N Table Edit

    Default Value: Y

    11 FLD_REQ_TRE_STATUS Character(1) VARCHAR2(1) NOT NULL Field Request Tree Update Status
    D=Saved as Draft
    F=Failed
    N=None
    S=Success

    Default Value: N