LM_CATG_ALL_LNG(SQL Table) |
Index Back |
---|---|
Category Levels Related LangThis view has all the primary categories and their corresponding sub-categories. This will populate the category name only if exists. This is the related language table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID - System generated number used to uniquely identify a Category. | |
2 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
3 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
4 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
5 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
6 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
7 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
8 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
9 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
10 | Number(10,0) | DECIMAL(10) NOT NULL | Category ID | |
11 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
12 | LM_CATG_NAME_LVL0 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
13 | LM_CATG_NAME_LVL1 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
14 | LM_CATG_NAME_LVL2 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
15 | LM_CATG_NAME_LVL3 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
16 | LM_CATG_NAME_LVL4 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
17 | LM_CATG_NAME_LVL5 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
18 | LM_CATG_NAME_LVL6 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
19 | LM_CATG_NAME_LVL7 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
20 | LM_CATG_NAME_LVL8 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |
21 | LM_CATG_NAME_LVL9 | Character(200) | VARCHAR2(200) NOT NULL | Category Name |