RB_AMPCTST_VLNG(SQL View) |
Index Back |
---|---|
View to select CategoriesView to select Categories on AMP Rule Definition |
SELECT TMPLT_CATEGRY_ID , LANGUAGE_CD , TMPLT_CATEGRY_NAME FROM PS_RBC_CAT_LNG WHERE TMPLT_CATEGRY_ID IN (20,22,23,24,28) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL | Template Category ID |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | TMPLT_CATEGRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase. |