FCLTY_LIMIT_VW

(SQL View)
 Index Back

Facility Limits View

3/98 AK - changed view to include language code logic 3/24/98 AK - Changed. Included %SUBSTRING in select clause becasue Sybase couldn't handle differnet lengths.

SELECT DISTINCT NODE1.SETID , %Substring(W.FIELD_VALUE_STR,1,12) , DEFN.TREE_NAME , NODE2.TREE_NODE_NUM , TBL.CURR_POSITION , TBL.DESCR , NODE2.TREE_NODE , HDR.POSN_LONG_SHORT , X.XLATLONGNAME , HDR.INTERNAL_EXTERNAL , HDR.LIMIT_MAX ,HDR.LIMIT_MIN FROM PSTREEDEFN DEFN , PSTREENODE NODE1 , PSTREENODE NODE2 , PS_POS_SOURCE_TBL2 S , PS_POS_WHERE_TBL W , PS_POS_LMT_TBL HDR , PSXLATITEM X , PS_POS_HDR_TBL TBL 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 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 TBL.SETID = NODE2.SETID AND TBL.TREE_NAME = NODE2.TREE_NAME AND TBL.TREE_NODE = NODE2.TREE_NODE

  • Related Language Record: FCLTY_LIMIT_LG

    • # 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    6 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.
    7 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    8 POSN_LONG_SHORT Character(2) VARCHAR2(2) NOT NULL "Represents whether a given position tree node reflects a short
    01=Long Limit Only
    02=Short Limit Only
    03=Short and Long Limit
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given defined bank account is utilized for internal or ext
    E=External
    I=Internal
    11 LIMIT_MAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the maximum amount of exposure established by the treasury for a given tree node (position or cash wo
    12 LIMIT_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the minimum amount of exposure established by the treasury for a given tree node (position or cash wo