SCP_FAQ_GRP_LN(SQL View) |
Index Back |
---|---|
Content Group Language ViewContent Group View |
SELECT DISTINCT L.LANGUAGE_CD , A.OPRID , L.SCP_FAQ_GROUP , L.DESCR60 FROM PS_SCP_USRFAQGP_VW A , PS_SCP_FAQ_GRP_LNG L WHERE A.SCP_FAQ_GROUP = L.SCP_FAQ_GROUP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | SCP_FAQ_GROUP | Character(4) | VARCHAR2(4) NOT NULL | FAQ Group |
4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |