CS_TLEXP_OR_VW

(SQL View)
 Index Back

Explosion - Child level

SCC 09/01/04 - Used in Explosion processed as inner loop

SELECT A.OPRID , A.CS_OBJECT_TYPE_SRC , A.SETID , A.CS_TEMPLATE_ID , A.CS_KEYVALUE , C.CS_OBJECT_TYPE , C.CS_OBJECT_ID , 0 , A.SCM_ATTACH_ID , A.ATT_VERSION , C.CS_NUMBERING_FLG , C.CS_BODY_TYPE , A.LEVEL1 , A.LEVEL2 , A.LEVEL3 , A.LEVEL4 , A.LEVEL5 , A.LEVEL6 , A.LEVEL7 , A.LEVEL8 , A.LEVEL9 , A.LEVEL_NUM + 1 , CH.DESCR60 , ' ' , 'A' , D.NUM_CHILDREN , 'N' , 'N' , ' ' , 'N' , CH.CS_RULE_TYPE , D.EFFDT , D.EFF_STATUS , 'N' , '10' %Concat %Substring(C.CS_OBJECT_TYPE, 3, 2) , A.CS_KEYVALUE , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 'N' , A.CS_BODY , C.SEQ_NUMBER , C.CS_OBJ_TYPE_CHILD , C.CS_CHILD_OBJID FROM PS_CS_TLEXP_TMP A , PS_CS_OBJECTS_DTL B , PS_CS_OBJECT_CHILD C , PS_CS_RULES CH , PS_CS_RULE_DTLS D , PS_CS_TLEXP_DT_TMP G WHERE A.SETID=B.SETID AND A.CS_OBJECT_ID=B.CS_OBJECT_ID AND A.CS_OBJECT_TYPE=B.CS_OBJECT_TYPE AND A.CS_OBJECT_TYPE<>'0003' AND G.OPRID=A.OPRID AND G.SETID=A.SETID AND G.CS_TEMPLATE_ID=A.CS_TEMPLATE_ID AND G.CS_OBJECT_TYPE_SRC=A.CS_OBJECT_TYPE_SRC AND B.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_CS_OBJECTS_DTL F WHERE B.SETID=F.SETID AND B.CS_OBJECT_TYPE=F.CS_OBJECT_TYPE AND B.CS_OBJECT_ID=F.CS_OBJECT_ID AND F.EFFDT <= G.EFFDT) AND C.SETID=B.SETID AND C.CS_OBJECT_TYPE=B.CS_OBJECT_TYPE AND C.CS_OBJECT_ID=B.CS_OBJECT_ID AND C.EFFDT=B.EFFDT AND C.SETID=D.SETID AND C.CS_OBJ_TYPE_CHILD='0004' AND C.CS_CHILD_OBJID=D.CS_RULE_ID AND D.EFFDT = ( SELECT MAX(H.EFFDT) FROM PS_CS_RULE_DTLS H WHERE D.SETID=H.SETID AND D.CS_RULE_ID=H.CS_RULE_ID AND H.EFFDT <= G.EFFDT) AND C.SETID=CH.SETID AND C.CS_OBJ_TYPE_CHILD='0004' AND C.CS_CHILD_OBJID=CH.CS_RULE_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 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 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
27 ALTS_EXIST Character(1) VARCHAR2(1) NOT NULL cel - alternates exist flag in Contract Management
28 CS_BINDS_EXIST Character(1) VARCHAR2(1) NOT NULL Binds Exist
29 CS_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Section Style
30 CS_PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL Page Break
31 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
32 EFFDT Date(10) DATE Effective Date
33 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
34 CS_PROTECTED Character(1) VARCHAR2(1) NOT NULL Protected in Document Flag

Y/N Table Edit

35 CS_EXPL_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
1001=Sub Clause
1002=Sub Section
36 CS_KEYVALUE_ORIG Character(30) VARCHAR2(30) NOT NULL SCC 09/01/04
37 ADJLEVEL1 Number(5,0) INTEGER NOT NULL Level 1
38 ADJLEVEL2 Number(5,0) INTEGER NOT NULL Level 2
39 ADJLEVEL3 Number(5,0) INTEGER NOT NULL Level 3
40 ADJLEVEL4 Number(5,0) INTEGER NOT NULL Level 4
41 ADJLEVEL5 Number(5,0) INTEGER NOT NULL Level 5
42 ADJLEVEL6 Number(5,0) INTEGER NOT NULL Level 6
43 ADJLEVEL7 Number(5,0) INTEGER NOT NULL Level 7
44 ADJLEVEL8 Number(5,0) INTEGER NOT NULL Level 8
45 ADJLEVEL9 Number(5,0) INTEGER NOT NULL Level 9
46 ADJUST_FLAG Character(1) VARCHAR2(1) NOT NULL Adjustment Type

Default Value: N

47 CS_BODY Long Character CLOB stores the body text for clause/section.
48 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number
49 CS_OBJ_TYPE_CHILD Character(4) VARCHAR2(4) NOT NULL Clause/section dependent
0001=Clause
0002=Section
0004=Rule
50 CS_CHILD_OBJID Character(20) VARCHAR2(20) NOT NULL Child Object