LM_MOP_OWNR_VW (SQL View)	Index Back
Method of Payment Owner MOP owner stores the association of MOP with their owners. A particular MOP can be used by only those who are associated with the MOP in this record.

LM_MOP_OWNR_VW

(SQL View)

Method of Payment Owner

MOP owner stores the association of MOP with their owners. A particular MOP can be used by only those who are associated with the MOP in this record.

SELECT LM_MOP_ID , LM_MOP_TYPE , LM_MOP_OWNER_ID , LM_MOP_OWNER_TYPE FROM PS_LM_MOP_OWNR_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_MOP_ID Number(10,0) DECIMAL(10) NOT NULL Method of Payment Id. This id in 8.9 release can be LM_PO_ID or LM_TU_POOL_ID.

2 LM_MOP_TYPE Character(3) VARCHAR2(3) NOT NULL Method of Payment Type. In 8.9, It could be PO or Training Unit
PUO=Purchase Order
TUP=Training Unit Pool

3 LM_MOP_OWNER_ID Number(10,0) DECIMAL(10) NOT NULL Method of Payment Owner. Owner could be Organization, Person, Learning Environment etc.

4 LM_MOP_OWNER_TYPE Character(3) VARCHAR2(3) NOT NULL Method of Payment Owner Type. In 8.9, it could be organization, LE, Person etc.
LEV=Learning Environment
ORG=Organization
PER=Person

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_MOP_ID	Number(10,0)	DECIMAL(10) NOT NULL	Method of Payment Id. This id in 8.9 release can be LM_PO_ID or LM_TU_POOL_ID.
2	LM_MOP_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Method of Payment Type. In 8.9, It could be PO or Training Unit PUO=Purchase Order TUP=Training Unit Pool
3	LM_MOP_OWNER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Method of Payment Owner. Owner could be Organization, Person, Learning Environment etc.
4	LM_MOP_OWNER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Method of Payment Owner Type. In 8.9, it could be organization, LE, Person etc. LEV=Learning Environment ORG=Organization PER=Person