POS_IMPCT_CLC_V (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_CLC_V

(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 ,descr50 FROM PS_POS_IMPCT_HDR WHERE 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 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	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50