AUC_CLSEXPL_VW(SQL View) |
Index Back |
|---|---|
View of exploded child clauses |
| SELECT A.OPRID , A.SETID , '0001' , A.CS_OBJECT_ID , A.CS_TEMPLATE_ID , A.CS_TITLE , A.DESCR60 , A.NUM_CHILDREN , A.CS_BODY FROM PS_CS_TLEXP_TMP A WHERE A.CS_OBJECT_ID <> A.CS_TEMPLATE_ID |
| # | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | 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 |
| 4 | CS_OBJECT_ID | Character(20) | VARCHAR2(20) NOT NULL | Object id -- clause, section |
| 5 | AUC_PARENT_CLS_ID | Character(20) | VARCHAR2(20) NOT NULL | Parent Clause ID |
| 6 | CS_TITLE | Character(254) | VARCHAR2(254) NOT NULL | title |
| 7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 8 | NUM_CHILDREN | Number(3,0) | SMALLINT NOT NULL | Number of children |
| 9 | CS_BODY | Long Character | CLOB | stores the body text for clause/section. |