| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
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
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
CS_TEMPLATE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
SCC 09/01/04
|
| 5 |
CS_KEYVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
SCC 09/01/04
|
| 6 |
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
|
| 7 |
CS_OBJECT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Object id -- clause, section
Prompt Table:
%EDITTABLE
|
| 8 |
SEQ_ID |
Number(4,0) |
SMALLINT NOT NULL |
Mapping Unique Sequence ID
|
| 9 |
SCM_ATTACH_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
|
| 10 |
ATT_VERSION |
Number(3,0) |
SMALLINT NOT NULL |
The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
|
| 11 |
CS_NUMBERING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Numbering
Y/N Table Edit
Default Value: Y
|
| 12 |
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
|
| 13 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 14 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 15 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 16 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 17 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 18 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 19 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 20 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 21 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 22 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 23 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 24 |
CS_TITLE |
Character(254) |
VARCHAR2(254) NOT NULL |
title
|
| 25 |
CS_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
I=Initial
P=Pending Approval
|
| 26 |
CS_BODY |
Long Character |
CLOB |
stores the body text for clause/section.
|
| 27 |
NUM_CHILDREN |
Number(3,0) |
SMALLINT NOT NULL |
Number of children
|
| 28 |
ALTS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
cel - alternates exist flag in Contract Management
|
| 29 |
CS_BINDS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Binds Exist
|
| 30 |
CS_LIST_STYLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Override Section Style
|
| 31 |
CS_PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Page Break
|
| 32 |
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
|
| 33 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 34 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 35 |
CS_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Protected in Document Flag
Y/N Table Edit
|
| 36 |
CS_KEYVALUE_ORIG |
Character(30) |
VARCHAR2(30) NOT NULL |
SCC 09/01/04
|