TREE_FLDNAME_VW

(SQL View)
 Index Back

Tree Fieldname View for alloc


SELECT C.SETCNTRLVALUE ,F.FIELDNAME ,T.TREE_NAME ,T.EFFDT ,T.EFF_STATUS ,T.DESCR FROM PS_FS_FLD_PROMPT F ,PSTREESTRCT S ,PSTREEDEFN T ,PS_SET_CNTRL_TBL C WHERE (S.DTL_FIELDNAME = F.FIELDNAME OR S.NODE_FIELDNAME = F.FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND (C.SETID = T.SETID OR (EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_TREE WHERE SETCNTRLVALUE = C.SETCNTRLVALUE AND SETID = T.SETID AND TREE_NAME = T.TREE_NAME)))

  • Related Language Record: TREE_FLD_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description