LM_KWRD_TYP_TBL (SQL Table)	Index Back
Keyword Type Table This table is used to store the Types of Keywords that can exist in the database. Keywords are catagorized by the Keyword type.

LM_KWRD_TYP_TBL

(SQL Table)

Keyword Type Table

This table is used to store the Types of Keywords that can exist in the database. Keywords are catagorized by the Keyword type.

Related Language Record: LM_KWRD_TYP_LNG

Parent Record Of LM_KWRD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_KWRD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Keyword Type ID- System generated unique ID created with each new instance of a Keyword Type.
Default Value: 1

2 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

3 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object

4 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

5 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

6 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

7 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_KWRD_TYPE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Keyword Type ID- System generated unique ID created with each new instance of a Keyword Type. Default Value: 1
2	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
3	LM_CS_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Short Name - Describes the short name of an object
4	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
5	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
6	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
7	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid