FCLTY_LIMIT_LG

(SQL View)
 Index Back

Facility Limits View

3/98 AK - Created

SELECT DISTINCT NODE1.SETID , %Substring(W.FIELD_VALUE_STR, 1, 12) , DEFN.TREE_NAME , NODE2.TREE_NODE_NUM , XLNG.LANGUAGE_CD , TBL.DESCR , XLNG.XLATLONGNAME FROM PSTREEDEFN DEFN , PSTREENODE NODE1 , PSTREENODE NODE2 , PS_POS_SOURCE_TBL2 S , PS_POS_WHERE_TBL W , PS_POS_LMT_TBL HDR , PS_POS_HDR_TBL TBL , PSXLATITEM X , PSXLATITEMLANG XLNG WHERE DEFN.TREE_STRCT_ID = 'TR_POSITION' AND NODE1.SETID = DEFN.SETID AND NODE1.TREE_NAME = DEFN.TREE_NAME AND NODE2.SETID = NODE1.SETID AND NODE2.TREE_NAME = NODE1.TREE_NAME AND NODE2.TREE_NODE_NUM BETWEEN NODE1.TREE_NODE_NUM AND NODE1.TREE_NODE_NUM_END AND S.FIELDNAME = 'FCLTY_ID' AND S.ALIAS_NAME = W.ALIAS_NAME AND W.COMP_OPERATOR = '=' AND W.SETID = NODE1.SETID AND W.TREE_NAME = NODE1.TREE_NAME AND W.TREE_NODE = NODE1.TREE_NODE AND HDR.SETID = NODE2.SETID AND HDR.TREE_NAME = NODE2.TREE_NAME AND HDR.TREE_NODE = NODE2.TREE_NODE AND TBL.SETID = NODE2.SETID AND TBL.TREE_NAME = NODE2.TREE_NAME AND TBL.TREE_NODE = NODE2.TREE_NODE AND X.FIELDNAME = 'POSN_LONG_SHORT' AND X.FIELDVALUE = HDR.POSN_LONG_SHORT AND X.EFF_STATUS = 'A' AND X.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PSXLATITEM Z WHERE X.FIELDNAME = Z.FIELDNAME AND Z.EFF_STATUS = 'A' AND Z.EFFDT <= %CurrentDateIn) AND X.FIELDNAME = XLNG.FIELDNAME AND X.FIELDVALUE = XLNG.FIELDVALUE AND X.EFFDT = XLNG.EFFDT

  • Related Language Record for FCLTY_LIMIT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

    Prompt Table: FCLTY_DFN

    3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description