RA_PRFL_ORG_VW(SQL View) |
Index Back |
|---|---|
Profile Category ORGView that returns only the Profiles that are active, and are of type ORG. |
| SELECT RA_PROFILE_ID , RA_PROFILE_NAME FROM PS_RA_PROFILE WHERE RA_PROFILE_GROUP = 'ORG' AND RA_PROFILE_STATUS = 'ACT' AND RA_ONE_OR_MANY = 'N' AND RA_PROFILE_RECNAME <> 'BO_BASIC_ORG' |
| # | 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_PROFILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | Profile - Name |