CS_DOC_IDC=Collaboration Completed
E=Ext Collab Started
I=Initial
N=Complete - No Changes
P=Collaboration in Process
CS_DOC_COLL_EXT(SQL Table) |
Index Back |
|---|---|
External Collab DetailsDate Initials Issue Description ============================================ 06/2007 CEL F-AHAYT-25EQ8 New record to store the external collaboration details. For 9.1 there will really only ever be one row in here since only collabing with the primary owner. The comments apply to the whole cycle. |
| # | 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 |
| 3 | CS_COLLAB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Collaboration Status
C=Collaboration Completed E=Ext Collab Started I=Initial N=Complete - No Changes P=Collaboration in Process |
| 4 | CS_CHECK_INOUT | Character(1) | VARCHAR2(1) NOT NULL | Edit/ Check In |
| 5 | COLLABED_DTTM | DateTime(26) | TIMESTAMP | Collaborated On |
| 6 | CS_COLLAB_MAIN | Character(1) | VARCHAR2(1) NOT NULL | Collaborate on Main Document |
| 7 | CS_COLLAB_AMEND | Character(1) | VARCHAR2(1) NOT NULL | Collaborate on Amendment File |
| 8 | CS_COLLAB_COMMENTS | Long Character | CLOB | Collaboration Comments |