LM_SRCH_DTTMVW3(SQL View) |
Index Back |
---|---|
Last update for ProgramsJoin all tables to get the last update date stamp for all the program related tables.. |
SELECT A1.LM_PRG_ID , A1.LM_ROW_MAINT_DTTM FROM PS_LM_PRG_CATG A1 UNION SELECT B1.LM_PRG_ID , B1.LM_ROW_MAINT_DTTM FROM PS_LM_PRG_OBJV B1 UNION SELECT C1.LM_PRG_ID , C1.LM_ROW_MAINT_DTTM FROM PS_LM_PRG_KWRD C1 UNION SELECT D1.LM_PRG_ID , D1.LM_ROW_MAINT_DTTM FROM PS_LM_SRCH_DTTMVW5 D1 UNION SELECT E1.LM_PRG_ID , E1.LM_ROW_MAINT_DTTM FROM PS_LM_SRCH_DTTMVW4 E1 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
2 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Row Maintainted DateTime |