CS_DOC_OWNERPrompt Table: CS_DOCADMIN_VW
CS_DOCOWNER_VW(SQL View) |
Index Back |
|---|---|
Supplier Cntrct Mgmt Users5/2/2019 JIRA PSFTSCMT-258 New record to use with new component to delete SCMT user preferences |
| SELECT DISTINCT A.CS_DOC_OWNER , B.OPRDEFNDESC FROM PS_CS_SEC_USER A , PSOPRDEFN B WHERE A.CS_DOC_OWNER = B.OPRID AND A.CS_DOC_OWNER <> ' ' UNION ( SELECT C.OPRID , B.OPRDEFNDESC FROM PS_OPR_DEF_TBL_CS C , PSOPRDEFN B WHERE C.OPRID = B.OPRID AND C.CS_ADMIN_ACCESS = 'Y' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_OWNER |
Character(30) | VARCHAR2(30) NOT NULL |
Document Administrator
Prompt Table: CS_DOCADMIN_VW |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |