RSEC_MEMBER_IDRSEC_PROFILE_IDLANGUAGE_CDRSEC_PRFM_LNGVW(SQL View) |
Index Back |
|---|---|
Member list associated profileRelated language of the membership list descriptions that are associated to a security profile. |
| SELECT MEM.RSEC_MEMBER_ID , PM.RSEC_PROFILE_ID , MLNG.LANGUAGE_CD , MLNG.DESCR FROM %Table(RSEC_PROFILEMDM) PM , %Table(RSEC_MEMBERDEFN) MEM , %Table(RSEC_MEMBER_LNG) MLNG WHERE PM.RSEC_MEMBER_ID = MEM.RSEC_MEMBER_ID AND MLNG.RSEC_MEMBER_ID = MEM.RSEC_MEMBER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RSEC_MEMBER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Security Membership ID for application security membership definition. |
| 2 | RSEC_PROFILE_ID |
Character(30) | VARCHAR2(30) NOT NULL | A unique identifier of security profile for application security. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |