CS_DOC_IDCNTCT_SEQ_NUMPrompt Table: OPRID_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
CS_CONTACT_VW2(SQL View) |
Index Back |
|---|
| SELECT CS_DOC_ID , CNTCT_SEQ_NUM , CONTACT_NAME , CONTACT_TITLE , OPRID_EXT , EXT_VIEW_ACCESS , EXT_PRIMARY_OWNER FROM PS_CS_CONTACT WHERE 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 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 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 | OPRID_EXT | Character(30) | VARCHAR2(30) NOT NULL |
External user
Prompt Table: OPRID_VW |
| 6 | EXT_VIEW_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Document access bu external users
Y/N Table Edit Default Value: N |
| 7 | EXT_PRIMARY_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Primary owner for external collaboration
Y/N Table Edit Default Value: N |