LM_PRG_KWRD_VW2(SQL View) |
Index Back |
---|---|
Keyword Ext ViewListing of Keywords associated with current, active Catalog Items |
SELECT LM_KWRD_TYPE_ID , LM_KWRD_ID , LM_KWRD FROM PS_LM_PRG_KWRD_TBL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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: 0 |
|
2 | Number(10,0) | DECIMAL(10) NOT NULL | Keyword ID - This is a system generated number used as a unique identifier for the keyword table. | |
3 | LM_KWRD | Character(30) | VARCHAR2(30) NOT NULL |
Keyword - Used to store all keywords
Prompt Table:
LM_KWRD_VW2
|