TRDASH_SRC_VW (SQL View)	Index Back
TR Dash Source Set View TR Dash Source Set View

TRDASH_SRC_VW

(SQL View)

TR Dash Source Set View

SELECT SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , VALUE_DT , POSITION_CURRENCY , SUM(POS_IMPCT_ORIG) , MAX(CALC_DT) , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET FROM PS_CSH_FCST_SUM GROUP BY SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , VALUE_DT , POSITION_CURRENCY , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

3 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

4 GROUP_BY_FIELD_SRC Character(3) VARCHAR2(3) NOT NULL Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account
BNK=Bank
BU=Business Unit
GP1=Group By Field 1
GP2=Group By Field 2
GP3=Group By Field 3
GP4=Group By Field 4
GP5=Group By Field 5
GP6=Group By Field 6
GP7=Group By Field 7
POS=Position Currency
SRC=Source Set
TIM=Time set
TRC=Transaction Currency

5 VALUE_DATE Date(10) DATE VALUE DATE

6 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.

7 POS_IMPCT_ORIG Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the calculated monetary value for a specific position tree node; the result

8 CALC_DT Date(10) DATE The calculation date for a given data set within the Position tools.

9 LINE_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash
2=Non-Cash

10 POS_HIST_FLAG Character(1) VARCHAR2(1) NOT NULL An internal field utilized in order to determine whether the subject cash position worksheet is based up
Y=History-based

11 POS_DEF_SRC_SET Character(1) VARCHAR2(1) NOT NULL a checkbox that identifies the default position source set.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	GROUP_BY_FIELD_SRC	Character(3)	VARCHAR2(3) NOT NULL	Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values. BAC=Bank Account BNK=Bank BU=Business Unit GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 POS=Position Currency SRC=Source Set TIM=Time set TRC=Transaction Currency
5	VALUE_DATE	Date(10)	DATE	VALUE DATE
6	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
7	POS_IMPCT_ORIG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result
8	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
9	LINE_ITEM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals. 1=Cash 2=Non-Cash
10	POS_HIST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An internal field utilized in order to determine whether the subject cash position worksheet is based up Y=History-based
11	POS_DEF_SRC_SET	Character(1)	VARCHAR2(1) NOT NULL	a checkbox that identifies the default position source set.