LMS_TGT_VW (SQL View)	Index Back
LMS Targets This is a view of the Target strings in the LMS Setup Table.

LMS_TGT_VW

(SQL View)

LMS Targets

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

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

Related Language Record: LMS_TGT_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_TGT_DESCR Character(50) VARCHAR2(50) NOT NULL LMS target 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_TGT_DESCR	Character(50)	VARCHAR2(50) NOT NULL	LMS target descriptions