IT_RULE_ATT2_LG(SQL View) |
Index Back |
---|---|
Rule Attributes |
SELECT LG.ATTRIBUTE_ID ,LG.LANGUAGE_CD , LG.ATTRIBUTE_DESCR FROM %Table(IT_RULE_ATTR_LG) LG , %Table(IT_RULE_ATTR) A WHERE A.ATTRIBUTE_ID = LG.ATTRIBUTE_ID AND A.ACTIVE_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ATTRIBUTE_ID2 | Character(20) | VARCHAR2(20) NOT NULL | Attribute ID |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | ATTRIBUTE_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Description |