LM_CI_IDLM_CATG_IDLM_CATG_ID_1LM_CATG_ID_2LM_CATG_ID_3LM_CATG_ID_4LM_CI_CTG_04_VW(SQL View) |
Index Back |
|---|---|
Categories for Catalog ItemThis view will join each catalog item that has categories. For each category, it will build a row where the category exists. |
| SELECT DISTINCT T.LM_CI_ID , L.LM_CATG_ID , L.LM_CATG_ID_1 , L.LM_CATG_ID_2 , L.LM_CATG_ID_3 , L.LM_CATG_ID_4 , L.LM_CATG_NAME_LVL0 , L.LM_CATG_NAME_LVL1 , L.LM_CATG_NAME_LVL2 , L.LM_CATG_NAME_LVL3 , L.LM_CATG_NAME_LVL4 %Sql(LM_CI_CATG_LVL_SQL,LM_CATG_ID_4,PS_LM_CI_TBL,PS_LM_CATG_CI_TBL,LM_CI_ID,LM_CI_STATUS,LM_CATG_NAME_LVL4) UNION SELECT DISTINCT T.LM_CI_ID , L.LM_CATG_ID , L.LM_CATG_ID_1 , L.LM_CATG_ID_2 , L.LM_CATG_ID_3 , L.LM_CATG_ID_4 , L.LM_CATG_NAME_LVL0 , L.LM_CATG_NAME_LVL1 , L.LM_CATG_NAME_LVL2 , L.LM_CATG_NAME_LVL3 , L.LM_CATG_NAME_LVL4 %Sql(LM_CI_CATG_LVL_FL_SQL,LM_CATG_ID_4,PS_LM_CI_TBL,PS_LM_CATG_CI_TBL,LM_CI_ID,LM_CI_STATUS,LM_CATG_NAME_LVL4) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 2 | LM_CATG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Category ID - System generated number used to uniquely identify a Category. |
| 3 | LM_CATG_ID_1 |
Number(10,0) | DECIMAL(10) NOT NULL | Category ID |
| 4 | LM_CATG_ID_2 |
Number(10,0) | DECIMAL(10) NOT NULL | Category ID |
| 5 | LM_CATG_ID_3 |
Number(10,0) | DECIMAL(10) NOT NULL | Category ID |
| 6 | LM_CATG_ID_4 |
Number(10,0) | DECIMAL(10) NOT NULL | Category ID |
| 7 | LM_CATG_NAME_LVL0 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
| 8 | LM_CATG_NAME_LVL1 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
| 9 | LM_CATG_NAME_LVL2 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
| 10 | LM_CATG_NAME_LVL3 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
| 11 | LM_CATG_NAME_LVL4 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |