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

POS_IMPCT_AVP_D

(SQL View)

Position Impacts Valu Dates VW

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

SELECT DISTINCT tree_name ,VALUE_DT ,descr50 FROM PS_POS_IMPCT_HDR WHERE value_dt<=%CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50