POS_LMT_NFY_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
4	POSN_LONG_SHORT	Character(2)	VARCHAR2(2) NOT NULL	"Represents whether a given position tree node reflects a short 01=Long Limit Only 02=Short Limit Only 03=Short and Long Limit
5	INTERNAL_EXTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given defined bank account is utilized for internal or ext E=External I=Internal
6	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
7	LAST_CHKED_DTTM	DateTime(26)	TIMESTAMP	The last datetime when a given position limit underwent processing.
8	LAST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The status of a given position limit when the same last underwent processing. O=Over U=Under
9	NOTIFED_DTTM	DateTime(26)	TIMESTAMP	The date and time a designated person was notified of a given position limit violation
10	USER_RESPONDED	Character(1)	VARCHAR2(1) NOT NULL	Represents an indication that a designated user has review a deal transaction workflow worklist item t Y/N Table Edit Default Value: N
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	RESPONDED_DTTM	DateTime(26)	TIMESTAMP	Represents the date and time a designated operator reviewed and acknowledged an exposure limit vi
13	NOTIFY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Notification Method 1=Notification Framework 2=Workflow