CS_OBJS_TEXT_VW(SQL View) |
Index Back |
|---|---|
Full TextUsed by Fluid Approval PUM #22 |
| SELECT D.SETID , D.CS_OBJECT_TYPE , D.CS_OBJECT_ID , D.EFFDT , D.EFF_STATUS , D.NUM_CHILDREN , D.ALTS_EXIST , D.CS_APPROVAL_STATUS , D.CS_TITLE , D.CHECKED_OUT_BY , D.DATETIME_CHECKOUT , D.SCM_ATTACH_ID , D.ATT_VERSION , D.LAST_DTTM_STAMP , D.LASTUPDOPRID , D.APPROVED_DTTM , D.APPROVAL_OPRID ,H.DESCR60 ,H.CS_CLASS ,H.CS_LIBRARY ,H.CS_NOTES , T.CS_BODY , H.CS_APPROVAL_TYPE , ' ' FROM ps_cs_objects_dtl D , ps_cs_object_text T , PS_CS_OBJECTS_HDR H WHERE D.SETID = T.SETID AND D.CS_OBJECT_TYPE = T.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = T.CS_OBJECT_ID AND D.EFFDT = T.EFFDT AND T.CS_BODY_TYPE = 'F' AND D.SETID = H.SETID AND D.CS_OBJECT_TYPE = H.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = H.CS_OBJECT_ID |
| # | 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 | CHECKED_OUT_BY | Character(30) | VARCHAR2(30) NOT NULL | Checked Out By |
| 11 | DATETIME_CHECKOUT | DateTime(26) | TIMESTAMP | Checked Out On |
| 12 | 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. |
| 13 | 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. |
| 14 | LAST_DTTM_STAMP | DateTime(26) | TIMESTAMP | Data Time Stamp - Old |
| 15 | 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. |
| 16 | APPROVED_DTTM | DateTime(26) | TIMESTAMP | SCC 09/16/04 - Approved Date and time |
| 17 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 18 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 19 | CS_CLASS | Character(20) | VARCHAR2(20) NOT NULL | Class |
| 20 | CS_LIBRARY | Character(20) | VARCHAR2(20) NOT NULL | Library |
| 21 | CS_NOTES | Long Character | CLOB | Notes |
| 22 | CS_BODY | Long Character | CLOB | stores the body text for clause/section. |
| 23 | CS_APPROVAL_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Approval Type |
| 24 | CS_DATE_STRING1 | Character(50) | VARCHAR2(50) NOT NULL | Created Date |