LM_LDGR_PYTU_VW (SQL View)	Index Back
TU Payment Detail View Sub-Ledger Training Unit Payment Detail page

LM_LDGR_PYTU_VW

(SQL View)

TU Payment Detail View

Sub-Ledger Training Unit Payment Detail page

SELECT A.LM_PYMT_ID , A.LM_ENRLMT_ID , A.LM_PYMT_MTHD , A.LM_TU_POOL_ID , B.LM_TU_POOL_NAME , B.LM_OWNER_ID , B.LM_TU_POOL_USED FROM PS_LM_ENPYMT_VW A , PS_LM_TU_POOL_VW B WHERE A.LM_PYMT_MTHD= 'TU' AND A.LM_TU_POOL_ID = B.LM_TU_POOL_ID

# 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_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

3 LM_PYMT_MTHD Character(4) VARCHAR2(4) NOT NULL Payment Method. The payment method can be ChargeBack, Training Units
CASH=Cash
CHCK=Check
CHGB=ChargeBack
CRCD=Credit Card
NOAP=Not Applicable
PO=Purchase Order
SEL=Select...
TU=Training Units

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_TU_POOL_NAME Character(20) VARCHAR2(20) NOT NULL Training Unit Pool

6 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

7 LM_TU_POOL_USED Character(1) VARCHAR2(1) NOT NULL Y/N value if a TU pool has been 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_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
3	LM_PYMT_MTHD	Character(4)	VARCHAR2(4) NOT NULL	Payment Method. The payment method can be ChargeBack, Training Units CASH=Cash CHCK=Check CHGB=ChargeBack CRCD=Credit Card NOAP=Not Applicable PO=Purchase Order SEL=Select... TU=Training Units
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_TU_POOL_NAME	Character(20)	VARCHAR2(20) NOT NULL	Training Unit Pool
6	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID
7	LM_TU_POOL_USED	Character(1)	VARCHAR2(1) NOT NULL	Y/N value if a TU pool has been used