LM_LSTUPDTM_VW1(SQL View) |
Index Back |
|---|---|
LstUpdDttm for ACT/CI/DM/DMTYPSES- View used to fetch lates Updated time stamp from Activities/ Catalog Items/ Delivery Methods and Delivery Method Types |
| SELECT A.LM_ACT_ID , A.LM_ROW_MAINT_DTTM FROM PS_LM_VER_DRV_VW A UNION SELECT B.LM_ACT_ID , B.LM_DMRW_MAINT_DTTM FROM PS_LM_VER_DRV_VW B UNION SELECT C.LM_ACT_ID , C.LM_CIRW_MAINT_DTTM FROM PS_LM_VER_DRV_VW C UNION SELECT D.LM_ACT_ID , D.LM_DMTRW_MANT_DTTM FROM PS_LM_VER_DRV_VW D |
| # | 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_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Row Maintainted DateTime |