RA_PRFL_IND_VW(SQL View) |
Index Back |
---|---|
Profile Group DisplayProfiles that are of IND, active, and are not from basic tables. |
SELECT RA_PROFILE_ID , RA_PROFILE_NAME FROM PS_RA_PROFILE WHERE RA_PROFILE_GROUP = 'IND' AND RA_PROFILE_STATUS = 'ACT' AND RA_ONE_OR_MANY = 'N' AND RA_PROFILE_RECNAME <> 'BO_BASIC_IND' |
# | 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 |