POS_LMT_CHK_TBL (SQL Table)	Index Back
Limit Check Table Used to store the list of nodes that are to have their limits checked.

POS_LMT_CHK_TBL

(SQL Table)

Limit Check Table

Used to store the list of nodes that are to have their limits checked.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 POS_LMT_CHK_SEQ Number(18,0) DECIMAL(18) NOT NULL Used in POS_LMT_CHK_TBL.

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

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

6 EFFDT Date(10) DATE Effective Date

7 IS_DEAL_IN_LIMIT Character(1) VARCHAR2(1) NOT NULL An internal work field utilized for deal checking during position limit processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	POS_LMT_CHK_SEQ	Number(18,0)	DECIMAL(18) NOT NULL	Used in POS_LMT_CHK_TBL.
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
6	EFFDT	Date(10)	DATE	Effective Date
7	IS_DEAL_IN_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	An internal work field utilized for deal checking during position limit processing.