POS_IMPCT_CL_V2 (SQL View)	Index Back
Position Impacts Calc Dates VW View of position impact calc dates. Used as an edit table for Calc Dt.

POS_IMPCT_CL_V2

(SQL View)

Position Impacts Calc Dates VW

View of position impact calc dates. Used as an edit table for Calc Dt.

SELECT DISTINCT tree_name ,tree_node ,calc_dt ,pos_hist_flag ,descr50 FROM PS_POS_IMPCT_HDR WHERE pos_hist_flag='Y' AND calc_dt <=%CurrentDateIn

# 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 CALC_DT Date(10) DATE The calculation date for a given data set within the Position tools.

4 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

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
4	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
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50