LM_LRNTUP_VW (SQL View)	Index Back
Training Unit Pool Item Training Unit Pool Items are owned by Training Unit Pool. A TU Pool can own multiple TU Pool Items. Its a 1-many relationship.

LM_LRNTUP_VW

(SQL View)

Training Unit Pool Item

Training Unit Pool Items are owned by Training Unit Pool. A TU Pool can own multiple TU Pool Items. Its a 1-many relationship.

SELECT A.LM_PYMT_ID , A.LM_TU_POOL_ID , A.LM_POOL_ITEM_ID , B.LM_ENRLMT_ID ,A.LM_NO_OF_TUS FROM PS_LM_LRNR_TUPL_IT A , PS_LM_ENRLMT_PYMT B WHERE A.LM_PYMT_ID = B.LM_PYMT_ID

Parent record: LM_ENRLMT_PYMT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PYMT_ID Number(10,0) DECIMAL(10) NOT NULL Payment ID

2 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.

3 LM_POOL_ITEM_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool Item No is a unique key for Training unit Pool Item Record.

4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

5 LM_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
2	LM_TU_POOL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training Unit Pool No. Unique key for Training Unit Pool Record.
3	LM_POOL_ITEM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training Unit Pool Item No is a unique key for Training unit Pool Item Record.
4	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
5	LM_NO_OF_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.