LM_PRG_ORG_LVW (SQL View)	Index Back
Payment Detail View Sub-Ledger Payment Detail page

LM_PRG_ORG_LVW

(SQL View)

Payment Detail View

Sub-Ledger Payment Detail page

SELECT A.LM_PRG_REG_ID , B.LANGUAGE_CD , B.LM_ORG_DESCR FROM PS_LM_PRG_REG A , PS_LM_ORG_LANG_VW B WHERE A.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID

Related Language Record for LM_PRG_ORG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_ORG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Customer Description