LM_SRCH_DTTMVW4

(SQL View)
 Index Back

Last update for Programs

Join all tables to get the last update date stamp for all the program related tables.

%Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_1) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_2) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_3) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_4) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_5) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_6) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_7) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_8) UNION %Sql(LM_SRCH_CATG_DTTM_SQL,LM_PRG_ID,LM_PRG,LM_PRG_CATG,LM_CATG_ID_9)

# 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