POS_PRD_WRK_TBL (SQL Table)	Index Back
Position Impact work

POS_PRD_WRK_TBL

(SQL Table)

Position Impact work

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 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

4 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_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	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
4	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.