RPC_ATTR_LNG_VW(SQL View) |
Index Back |
|---|---|
Attributes languagesView to retreive language related information for attributes. |
| SELECT a.MARKET , a.ATTRIBUTE_ID , a.LANGUAGE_CD , a.ATTR_NAME , a.DESCR60 , b.ATTR_GROUP_ID , b.DESCR60 FROM PS_RB_ATTR_LNG a , PS_RB_ATTR_GRP_LNG b , PS_RB_ATTRIBUTE c WHERE a.MARKET = c.MARKET AND a.ATTRIBUTE_ID = c.ATTRIBUTE_ID AND b.MARKET = c.MARKET AND b.ATTR_GROUP_ID = c.ATTR_GROUP_ID AND EXISTS ( SELECT 1 FROM PS_RPC_PROD_ATTR d WHERE a.market = d.market AND a.attribute_id = d.attribute_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | ATTRIBUTE_ID | Character(15) | VARCHAR2(15) NOT NULL | Attribute Label, Name or Properties |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | ATTR_NAME | Character(30) | VARCHAR2(30) NOT NULL | Attribute name |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | ATTR_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | attribute group id field used by applications |
| 7 | DESCR60_1 | Character(60) | VARCHAR2(60) NOT NULL | Field used for storing attribute groups description |