LMS_DSRC_LANG(SQL View) | 
Index Back | 
|---|---|
LMS Datasource Rel Lang VwRelated language view of the Datasources in the LMS Setup Table. | 
| SELECT LMS_DSRCTGT_CODE, DESCRSHORT1, LANGUAGE_CD, DESCR50 FROM PS_LMS_SETUP_LANG WHERE LMS_DSRCTGT_CODE = 'D' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(1) | VARCHAR2(1) NOT NULL | 
LMS setup table datasource, target, or type code
 D=Datasource P=Type T=Target  | 
|
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Descr Short One | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | LMS_DSRC_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Datasource description |