| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CS_DOC_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Document ID
|
| 2 |
CS_DOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
stores the file type -- main file, amendment, preview, throwaway
Date Initials Issue Description
==========================================
06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types
7/2008 cel Added new executive summary file type.
9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
005=Document Attachment
006=Transaction Attachment
007=Config Selector
008=Main Signature Document
009=Amendment Signature File
010=Executive Summary
011=Exec-Sign
095=Document Attachment
096=Transaction Attachment
101=Main Document
102=Amendment Document
998=Main Document - ext collab
999=Amendment External Collab
|
| 3 |
CS_KEYVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
SCC 09/01/04
|
| 4 |
CS_OBJECT_TYPE_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Object Type
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0010=All
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 7 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 8 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 9 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 10 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 11 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 12 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 13 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 14 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 15 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 16 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 17 |
CS_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
I=Initial
P=Pending Approval
|
| 18 |
CS_BIND_SEQ_END |
Number(15,0) |
DECIMAL(15) NOT NULL |
End Bind Sequence
|
| 19 |
CS_BIND_SEQ_STRT |
Number(3,0) |
SMALLINT NOT NULL |
Start Bind Sequence
|
| 20 |
CS_BINDS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Binds Exist
|
| 21 |
CS_BODY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates body type -- full or by ref for clause/section
F=Full Text
R=By Reference Text
|
| 22 |
CS_CLAUSE_LEAD |
Character(30) |
VARCHAR2(30) NOT NULL |
Lead Clause ID
|
| 23 |
CS_CLAUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
New with 9.1 to indicate if Table Clause or other
G=General Clause
T=Table Clause
|
| 24 |
CS_DUMMY_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy code used for contract document explosion
1=Repeating Section
2=Rule Section
3=SLA Header Section
4=SLA Line Section
5=Alternate Section
N=Not a dummy record
|
| 25 |
CS_LAST_KEY_COL |
Number(3,0) |
SMALLINT NOT NULL |
Last Key Column
|
| 26 |
CS_LIST_STYLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Override Section Style
|
| 27 |
CS_NUMBERING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Numbering
Y/N Table Edit
Default Value: N
|
| 28 |
CS_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Protected in Document Flag
Default Value: N
|
| 29 |
CS_OBJ_GROUP |
Character(20) |
VARCHAR2(20) NOT NULL |
Object Group
|
| 30 |
CS_OBJ_GROUP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Working doc object grouping type
0001=Repeating Clause
0002=Repeating Section
0004=Rule
0005=SLA Header
0006=SLA Line
|
| 31 |
CS_OBJECT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Object id -- clause, section
|
| 32 |
CS_OBJECT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0015=Word Template
1000=All
|
| 33 |
CS_PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Page Break
Y/N Table Edit
Default Value: N
|
| 34 |
CS_RPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y means this is a repeating object.
|
| 35 |
CS_RULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Placeholder
|
| 36 |
CS_RULE_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule was used
|
| 37 |
CS_SECTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
CEL 01/2008 Adding SLA category placeholders
RMK 12/11/2007
Amendment Placeholder - enhancement to update 2nd amendment file with changes in amended document. Indicator to the system where to drop the changes in the amendment file
CEL 5/1/2005
SH and SL types are hidden from all pages/etc. Purely used internally in the table. So that is why they are marked inactive here .. to stop them from showing up on the pages. BUT we still need them as codes cause we use internally in code .. just didn't want to remove them and have them get accidentally used.
A=Amendment Placeholder
G=General
SC=Placeholder-Category Agreement
SH=Placeholder-Header Agreement
SL=Placeholder-Line Agreement
T=Introduction/Title
|
| 38 |
CS_SLA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Level Agreement Flag
|
| 39 |
CS_SUPPRESS_DUPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Duplicate Keys
|
| 40 |
CS_TITLE |
Character(254) |
VARCHAR2(254) NOT NULL |
title
|
| 41 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 42 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 43 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 44 |
CS_WORDML |
Long Character |
CLOB |
WordML
|