RA_PRFL_FLD_RL(SQL View) |
Index Back |
---|---|
Profile Field RelLang ViewGet Profile Fields, for field picking and assigning to profile groups. |
SELECT A.RA_PROFILE_ID , A.RA_ATTRIBUTE_ID , L.LANGUAGE_CD , L.RA_ATTRIB_NAME FROM PS_RA_ATTRIBUTE A , PS_RA_ATTR_LNG L WHERE A.RA_ATTRIB_STATUS = 'ACT' AND A.RA_PROFILE_ID = L.RA_PROFILE_ID AND A.RA_ATTRIBUTE_ID = L.RA_ATTRIBUTE_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID | |
2 | Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | RA_ATTRIB_NAME | Character(90) | VARCHAR2(90) NOT NULL | Profile - Attribute name |