CS_DOC_IDPrompt Table: OPRID_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
CS_EXT_USERS_VW(SQL View) |
Index Back |
|---|---|
External Document UsersDate Initials Issue Description ============================================ 06/2007 CEL F-AHAYT-25EQ8 List of External Contacts who are have userids. |
| SELECT CS_DOC_ID , OPRID_EXT , CONTACT_NAME , CONTACT_TITLE ,EXT_VIEW_ACCESS , EXT_PRIMARY_OWNER FROM PS_CS_CONTACT WHERE OPRID_EXT <> ' ' AND EXT_VIEW_ACCESS = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | OPRID_EXT | Character(30) | VARCHAR2(30) NOT NULL |
External user
Prompt Table: OPRID_VW |
| 3 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 4 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | The professional title for a given bank/counterparty contact person. |
| 5 | EXT_VIEW_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Document access bu external users
Y/N Table Edit Default Value: N |
| 6 | EXT_PRIMARY_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Primary owner for external collaboration
Y/N Table Edit Default Value: N |