LMS_TYPE_LANG (SQL View)	Index Back
LMS Type View Rel Lang Vw This is a view of theType strings in the LMS Setup Table.

LMS_TYPE_LANG

(SQL View)

LMS Type View Rel Lang Vw

This is a view of theType strings in the LMS Setup Table.

SELECT LMS_DSRCTGT_CODE , DESCRSHORT1 , LANGUAGE_CD , DESCR50 FROM PS_LMS_SETUP_LANG WHERE LMS_DSRCTGT_CODE = 'P'

Related Language Record for LMS_TYPE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LMS_DSRCTGT_CODE Character(1) VARCHAR2(1) NOT NULL LMS setup table datasource, target, or type code
D=Datasource
P=Type
T=Target

2 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One

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

4 LMS_TYPE_DESCR Character(50) VARCHAR2(50) NOT NULL LMS type descriptions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LMS_DSRCTGT_CODE	Character(1)	VARCHAR2(1) NOT NULL	LMS setup table datasource, target, or type code D=Datasource P=Type T=Target
2	DESCRSHORT1	Character(10)	VARCHAR2(10) NOT NULL	Descr Short One
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LMS_TYPE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	LMS type descriptions