CS_DOC_OWNERSCP_CS_ADMIN_VW(SQL View) |
Index Back |
|---|---|
Document Adminscel 10/2007 List of Document Owners -- for use on external side searching |
| SELECT DISTINCT A.CS_DOC_OWNER , B.OPRDEFNDESC , C.OPRID_EXT , 1 FROM PS_CS_DOC_HDR A , PSOPRDEFN B , PS_CS_CONTACT C WHERE A.CS_DOC_OWNER = B.OPRID AND A.CLOSE_FLAG <> 'Y' AND C.CS_DOC_ID = A.CS_DOC_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_OWNER |
Character(30) | VARCHAR2(30) NOT NULL | Document Administrator |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | OPRID_EXT | Character(30) | VARCHAR2(30) NOT NULL | External user |
| 4 | COUNT1 | Number(10,0) | DECIMAL(10) NOT NULL | Counter |