| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
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
|
| 3 |
CS_OBJECT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Object id -- clause, section
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
NUM_CHILDREN |
Number(3,0) |
SMALLINT NOT NULL |
Number of children
|
| 7 |
ALTS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
cel - alternates exist flag in Contract Management
Y/N Table Edit
|
| 8 |
CS_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
I=Initial
P=Pending Approval
|
| 9 |
CS_TITLE |
Character(254) |
VARCHAR2(254) NOT NULL |
title
|
| 10 |
CS_LIST_STYLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Override Section Style
Prompt Table:
CS_WORDLIST_STL
|
| 11 |
CS_CHLD_LIST_STYLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Override Child Style
Prompt Table:
CS_WORDLIST_STL
|
| 12 |
CS_PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Page Break
Y/N Table Edit
Default Value: N
|
| 13 |
CS_NUMBERING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Numbering
Y/N Table Edit
Default Value: Y
|
| 14 |
CS_WORD_MODIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Word Modified
Y/N Table Edit
Default Value: N
|
| 15 |
CHECKED_OUT_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Checked Out By
|
| 16 |
DATETIME_CHECKOUT |
DateTime(26) |
TIMESTAMP |
Checked Out On
|
| 17 |
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.
|
| 18 |
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.
|
| 19 |
LAST_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Data Time Stamp - Old
|
| 20 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 21 |
APPROVED_DTTM |
DateTime(26) |
TIMESTAMP |
SCC 09/16/04 - Approved Date and time
|
| 22 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 23 |
CS_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Protected in Document Flag
Y/N Table Edit
Default Value: N
|
| 24 |
CS_CONVERTXML_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert 2003 XML
|
| 25 |
CS_SUPPRESS_DUPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Duplicate Keys
Y/N Table Edit
Default Value: N
|
| 26 |
CS_LAST_KEY_COL |
Number(3,0) |
SMALLINT NOT NULL |
Last Key Column
|