LM_ACT_IDLM_CI_IDLM_SRCH_CI_LNVW(SQL View) |
Index Back |
|---|---|
Search Launch ViewThis is a placeholder only that is used for component LM_SRCH_CI_LAUNCH. |
| SELECT LM_ACT_ID , LM_CI_ID FROM PS_LM_ACT UNION SELECT 0 , C2.LM_CI_ID FROM PS_LM_CI_TBL C2 WHERE %CurrentDateIn BETWEEN C2.EFFDT AND C2.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |