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

LMS_TYPE_VW

(SQL View)

LMS Type View

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

SELECT LMS_DSRCTGT_CODE , DESCRSHORT1 , DESCR50 FROM PS_LMS_SETUP_TBL WHERE LMS_DSRCTGT_CODE = 'P'

Related Language Record: LMS_TYPE_LANG

# 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 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	LMS_TYPE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	LMS type descriptions