HR_VT_JCTREEVW

(SQL View)
 Index Back

SP360 Job Code Tree View

Record used on Setup Pages for Configurable Dashboard and Progression Chart (Search Setup)

SELECT a.SETID ,a.TREE_NAME ,a.EFFDT ,a.VERSION ,b.TREE_STRCT_ID ,b.NODE_RECNAME ,a.DESCR FROM PSTREEDEFN a , pstreestrct b WHERE a.TREE_STRCT_ID = b.TREE_STRCT_ID AND b.NODE_RECNAME = 'JOBCODE_TBL' AND a.EFF_STATUS = 'A'

  • Related Language Record: HR_VT_JTREELGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    5 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).
    6 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description