POS_IMPCT_HD_VW (SQL View)	Index Back
Position Impacts Header Record

POS_IMPCT_HD_VW

(SQL View)

Position Impacts Header Record

SELECT DISTINCT tree_name , tree_node , source_set , value_dt , calc_dt , pos_hist_flag , position_currency FROM PS_POS_IMPCT_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

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

4 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

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

6 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
Y/N Table Edit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
3	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
5	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
6	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 Y/N Table Edit
7	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.