LM_CI_IDDefault Value: 0
EFFDTDefault Value: %date
LM_KWRD_TYPE_IDDefault Value: 0
Prompt Table: LM_KWRD_TYP_VW
LM_KWRD_IDDefault Value: 0
Prompt Table: LM_KWRD_VW2
LM_KWRD_CI_TBL(SQL Table) |
Index Back |
|---|---|
Keyword - Catalog Item Rel TblThis table is relates Keywords to Catalog Items |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
Default Value: 0 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | 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: 0 Prompt Table: LM_KWRD_TYP_VW |
| 4 | LM_KWRD_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Keyword ID - This is a system generated number used as a unique identifier for the keyword table.
Default Value: 0 Prompt Table: LM_KWRD_VW2 |