LM_SRCH_DTTMV4

(SQL View)
 Index Back

Last update for CI Catogories

This has the last update for catalogi items with categories. Note: For DB2/MVS, the category is selected up to level 5 only. This is an issue on software vendor. A permanent solution is being evaluated to fix thie platform issue.

%Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_1) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_2) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_3) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_4) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_5) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_6) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_7) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_8) UNION %Sql(LM_SRCH_CATG_2_DTTM_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_9) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_1) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_2) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_3) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_4) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_5) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_6) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_7) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_8) UNION %Sql(LM_SRCH_CATG_2_DTTM_FL_SQL,LM_CI_ID,LM_CI_TBL,LM_CATG_CI_TBL,LM_CATG_ID_9)

# 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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
3 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP NOT NULL Row Maintainted DateTime