LM_CI_IDLM_ACTCI_SEC_VW(SQL View) |
Index Back |
|---|---|
CI Activity SecuritySelects the last modified date on changes on Activity Security table. |
| SELECT B.LM_CI_ID , A.LM_ROW_MAINT_DTTM FROM PS_LM_ACT_SEC A , PS_LM_ACT B WHERE A.LM_ACT_ID = B.LM_ACT_ID |
| # | 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 |
| 2 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |