CS_CLSDET_SVW(SQL View) |
Index Back |
|---|---|
Clause Detail for PTSFClause Detail for PTSF |
| SELECT A.SETID , A.CS_OBJECT_ID , A.EFFDT , A.EFF_STATUS , A.NUM_CHILDREN , A.ALTS_EXIST , A.CS_APPROVAL_STATUS , A.CS_TITLE , A.CS_LIST_STYLE , A.CS_CHLD_LIST_STYLE , A.CS_PAGE_BREAK , A.CS_NUMBERING_FLG , A.CS_WORD_MODIFIED , A.CHECKED_OUT_BY , A.DATETIME_CHECKOUT , A.SCM_ATTACH_ID , A.ATT_VERSION , A.LAST_DTTM_STAMP , A.LASTUPDOPRID , A.APPROVED_DTTM , A.APPROVAL_OPRID , A.CS_PROTECTED , A.CS_SUPPRESS_DUPS , A.CS_LAST_KEY_COL FROM PS_CS_OBJECTS_DTL A WHERE A.CS_OBJECT_TYPE = '0001' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CS_OBJECT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Object id -- clause, section |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | NUM_CHILDREN | Number(3,0) | SMALLINT NOT NULL | Number of children |
| 6 | ALTS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
cel - alternates exist flag in Contract Management
Y/N Table Edit |
| 7 | CS_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved I=Initial P=Pending Approval |
| 8 | CS_TITLE | Character(254) | VARCHAR2(254) NOT NULL | title |
| 9 | CS_LIST_STYLE | Character(20) | VARCHAR2(20) NOT NULL |
Override Section Style
Prompt Table: CS_WORDLIST_STL |
| 10 | CS_CHLD_LIST_STYLE | Character(20) | VARCHAR2(20) NOT NULL |
Override Child Style
Prompt Table: CS_WORDLIST_STL |
| 11 | CS_PAGE_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Page Break
Y/N Table Edit Default Value: N |
| 12 | CS_NUMBERING_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Numbering
Y/N Table Edit Default Value: Y |
| 13 | CS_WORD_MODIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Word Modified
Y/N Table Edit Default Value: N |
| 14 | CHECKED_OUT_BY | Character(30) | VARCHAR2(30) NOT NULL | Checked Out By |
| 15 | DATETIME_CHECKOUT | DateTime(26) | TIMESTAMP | Checked Out On |
| 16 | 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. |
| 17 | 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. |
| 18 | LAST_DTTM_STAMP | DateTime(26) | TIMESTAMP | Data Time Stamp - Old |
| 19 | 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. |
| 20 | APPROVED_DTTM | DateTime(26) | TIMESTAMP | SCC 09/16/04 - Approved Date and time |
| 21 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 22 | CS_PROTECTED | Character(1) | VARCHAR2(1) NOT NULL |
Protected in Document Flag
Y/N Table Edit Default Value: N |
| 23 | CS_SUPPRESS_DUPS | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Duplicate Keys
Y/N Table Edit Default Value: N |
| 24 | CS_LAST_KEY_COL | Number(3,0) | SMALLINT NOT NULL | Last Key Column |