OPRIDPAGELET_CONFIG_IDFSPC_GROUP_IDFSPC_LINK_IDLANGUAGE_CDEOWC_WRKLST_LVW(SQL View) |
Index Back |
|---|---|
My Work Link User Level ConfigUser level configuration for My Work link language view |
| SELECT A.OPRID , A.PAGELET_CONFIG_ID , A.FSPC_GROUP_ID , A.FSPC_LINK_ID , C.LANGUAGE_CD , C.FSPC_DESCR FROM PS_FSPC_USR_WRKLST A , PS_FSPC_MST_WRKLST B , PS_FSPC_MST_WLST_L C WHERE A.PAGELET_CONFIG_ID = B.PAGELET_CONFIG_ID AND A.EOWC_MST_GROUP_ID = B.FSPC_GROUP_ID AND A.FSPC_LINK_ID = B.FSPC_LINK_ID AND B.PAGELET_CONFIG_ID = C.PAGELET_CONFIG_ID AND B.FSPC_GROUP_ID = B.FSPC_GROUP_ID AND B.FSPC_LINK_ID = C.FSPC_LINK_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 | PAGELET_CONFIG_ID |
Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
| 3 | FSPC_GROUP_ID |
Character(36) | VARCHAR2(36) NOT NULL | Group ID |
| 4 | FSPC_LINK_ID |
Character(36) | VARCHAR2(36) NOT NULL | Link ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | FSPC_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Group Label |