SUMLD_CF2ND_VW

(SQL View)
 Index Back

Selected Chartfield Tree Nodes

This View is used to prompt the valid values for certain Summary Ledger Chartfield. The values are from tree nodes selected and are stored in LED_SUMV_TBL table. The first three keys (SETID, LEDGER, CHARTFIELD) are matched with the values on the panel.

SELECT S.SETID ,S.LEDGER ,F.CHARTFIELD ,N.SETID ,N.EFFDT ,D.SETID ,%Sql(CHARTFIELD2, D.) ,D.DESCR FROM PS_LED_DEFN_TBL S ,PS_LED_FLDS_TBL F ,PS_LED_SUMV_TBL V ,PSTREENODE N ,PSTREELEAF L ,PS_%Sql(CHARTFIELD2_TBL, D) WHERE F.LEDGER=S.LEDGER AND F.SETID=S.SETID AND V.LEDGER=F.LEDGER AND V.SETID=F.SETID AND V.FIELD_SEQUENCE=F.FIELD_SEQUENCE AND N.TREE_NAME=F.TREE_NAME AND N.TREE_NODE=V.SELECT_VALUE AND L.TREE_NAME=N.TREE_NAME AND L.SETID=N.SETID AND L.EFFDT=N.EFFDT AND L.TREE_NODE_NUM>=N.TREE_NODE_NUM AND L.TREE_NODE_NUM<=N.TREE_NODE_NUM_END AND %Sql(CHARTFIELD2, D.) >=L.RANGE_FROM AND %Sql(CHARTFIELD2, D.) <=L.RANGE_TO AND D.EFFDT=( SELECT MAX(EFFDT) FROM PS_%Sql(CHARTFIELD2_TBL,) WHERE %Sql(CHARTFIELD2,) = %Sql(CHARTFIELD2, D.) AND SETID=D.SETID AND EFFDT<=S.EFFDT)

  • Related Language Record: SUMLD_CF2ND_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 TREE_NAME_SETID Character(5) VARCHAR2(5) NOT NULL TableSet
    5 EFFDT Date(10) DATE Effective Date
    6 DTL_SETID Character(5) VARCHAR2(5) NOT NULL Tree Structure Summary Detail Tree SetId
    7 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description