RA_PROFILE_IDRA_ATTRIBUTE_IDRA_PUPD_ATTR_VW(SQL View) |
Index Back |
|---|---|
Profile Field Prompt ViewThis view returns active profile fields for use by the Manage Profile Updates page. |
| SELECT RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_ATTRIB_NAME , DESCR100 , DESCR254 FROM PS_RA_ATTRIBUTE WHERE RA_ATTRIB_STATUS = 'ACT' AND RA_ATTRIB_TYPE <> 'LT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_PROFILE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
| 2 | RA_ATTRIBUTE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID |
| 3 | RA_ATTRIB_NAME | Character(90) | VARCHAR2(90) NOT NULL | Profile - Attribute name |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |