PROCESS_INSTANCEPOS_LMT_CHK_SEQSETIDTREE_NAMETREE_NODE01=Long Limit Only
02=Short Limit Only
03=Short and Long Limit
E=External
I=Internal
POS_LMT_UTL_VW(SQL View) |
Index Back |
|---|---|
Limit Utilisation ViewGLE 11/5/97 - guy Fawkes day View that is used to display Limit utilisation AK 2/11/98 - include IS_DEAL_IN_LIMIT |
| SELECT C.PROCESS_INSTANCE , C.POS_LMT_CHK_SEQ , C.SETID , C.TREE_NAME , C.TREE_NODE , SUM( POS_IMPCT_ORIG ) , I.POSITION_CURRENCY , L.LIMIT_MAX , L.LIMIT_MIN , L.CURR_LIMIT , L.POSN_LONG_SHORT , L.INTERNAL_EXTERNAL , C.IS_DEAL_IN_LIMIT FROM PS_POS_LMT_TBL L , PS_POS_LMT_CHK_TBL C , PS_POS_IMPCT_HDR I WHERE L.LIMIT_CHK_DEAL_ENT = 'Y' AND L.SETID = C.SETID AND L.TREE_NAME = C.TREE_NAME AND L.TREE_NODE = C.TREE_NODE AND C.TREE_NAME = I.TREE_NAME AND C.TREE_NODE = I.TREE_NODE AND I.CALC_DT = %CurrentDateIn AND I.VALUE_DT = %CurrentDateIn GROUP BY I.POSITION_CURRENCY, L.LIMIT_MAX, L.LIMIT_MIN, L.CURR_LIMIT,L.POSN_LONG_SHORT, L.INTERNAL_EXTERNAL, C.PROCESS_INSTANCE, C.POS_LMT_CHK_SEQ, C.SETID, C.TREE_NAME, C.TREE_NODE, C.IS_DEAL_IN_LIMIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | POS_LMT_CHK_SEQ |
Number(18,0) | DECIMAL(18) NOT NULL | Used in POS_LMT_CHK_TBL. |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 5 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 6 | TOTAL_UTIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "Represents the total amount of exposure headroom utilized |
| 7 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 8 | 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 |
| 9 | 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 |
| 10 | CURR_LIMIT | Character(3) | VARCHAR2(3) NOT NULL | The currency in which a given position limit is defined in the Position tools. |
| 11 | 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 |
| 12 | 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 |
| 13 | IS_DEAL_IN_LIMIT | Character(1) | VARCHAR2(1) NOT NULL | An internal work field utilized for deal checking during position limit processing. |