OPRIDRD_GROUP_IDLANGUAGE_CDRD_GROUP_VW_LNG(SQL View) |
Index Back |
|---|---|
Contact Group View Rel LangRelated Language record for My Contacts - Contact Group View. |
| SELECT A.OPRID , A.RD_GROUP_ID , B.LANGUAGE_CD , A.DESCR FROM PS_RD_GROUP_VW A , PS_RD_CNTCT_GRP_LN B WHERE A.OPRID = B.OPRID AND A.RD_GROUP_ID = B.RD_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RD_GROUP_ID |
Number(6,0) | INTEGER NOT NULL | Contact Group ID used to identify a group of Contacts. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |