FCLTY_DEAL_VW

(SQL View)
 Index Back

Facility Deal Condition View

12/11/97 AK - Created. View to display deal conditions tied with a facility 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,10), DEFN.TREE_NAME, NODE2.TREE_NODE_NUM, TBL.DESCR, NODE2.TREE_NODE, HDR.POS_SOURCE_ID, HDR.ALIAS_NAME, S.FIELDTYPE, HDR.RELATIVE_DATE, F.META_FIELD, HDR.COMP_OPERATOR, HDR.FIELD_VALUE_STR, HDR.FIELD_VALUE_NBR, HDR.FIELD_VALUE_DATE FROM PSTREEDEFN DEFN, PSTREENODE NODE1, PSTREENODE NODE2, PS_POS_SOURCE_TBL2 S, PS_POS_FIELD_TYPE F, PS_POS_WHERE_TBL W, PS_POS_WHERE_TBL HDR, 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 W.ALIAS_NAME = F.ALIAS_NAME AND HDR.WHERE_TYPE = '02' 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

# 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 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.
6 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
7 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset
8 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym
9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
10 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days
11 META_FIELD Character(2) VARCHAR2(2) NOT NULL Allows the user to create a specialized data variable that can be utilized in building a position data source.
12 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With
13 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du
14 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
15 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b