LM_LRNTUP_HSTVW (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_HSTVW

(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.PSARCH_ID , A.PSARCH_BATCHNUM , 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_LRN_TUPL_HST 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 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

5 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.

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

7 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
4	LM_TU_POOL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training Unit Pool No. Unique key for Training Unit Pool Record.
5	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.
6	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
7	LM_NO_OF_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.