LM_SRCH_DTTMVW3

(SQL View)
Index Back

Last update for Programs

Join 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