CS_TLCPY_O_VW

(SQL View)
 Index Back

Template with Object details

SCC 09/01/04 - View of template details that contains description, title from object tables.

SELECT E.OPRID , '0007' , A.SETID , A.CS_TEMPLATE_ID , A.CS_KEYVALUE , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , A.SEQ_ID , B.SCM_ATTACH_ID , B.ATT_VERSION , B.CS_NUMBERING_FLG , A.CS_BODY_TYPE , A.LEVEL1 , A.LEVEL2 , A.LEVEL3 , A.LEVEL4 , A.LEVEL5 , A.LEVEL6 , A.LEVEL7 , A.LEVEL8 , A.LEVEL9 , A.LEVEL_NUM , B.DESCR60 , B.CS_TITLE , B.CS_APPROVAL_STATUS , B.CS_BODY , B.NUM_CHILDREN , B.ALTS_EXIST , B.CS_BINDS_EXIST , B.CS_LIST_STYLE , B.CS_PAGE_BREAK , B.CS_SECTION_TYPE , B.EFFDT , B.EFF_STATUS , B.CS_PROTECTED FROM PS_CS_TMPL_DTL A , PS_CS_TLOBJ_O_VW B , PSOPRDEFN E WHERE A.SETID=B.SETID AND A.CS_OBJECT_TYPE=B.CS_OBJECT_TYPE AND A.CS_OBJECT_ID=B.CS_OBJECT_ID AND A.CS_BODY_TYPE=B.CS_BODY_TYPE AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_CS_TLEXP_DT_TMP Y , PS_CS_OBJECTS_DTL Z WHERE Y.OPRID=E.OPRID AND Y.SETID=A.SETID AND Y.CS_TEMPLATE_ID=A.CS_TEMPLATE_ID AND Y.CS_OBJECT_TYPE_SRC='0007' AND B.SETID=Z.SETID AND B.CS_OBJECT_TYPE=Z.CS_OBJECT_TYPE AND B.CS_OBJECT_ID=Z.CS_OBJECT_ID AND Z.EFFDT <= Y.EFFDT)

# 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 CS_BODY Long Character CLOB stores the body text for clause/section.
27 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
28 ALTS_EXIST Character(1) VARCHAR2(1) NOT NULL cel - alternates exist flag in Contract Management
29 CS_BINDS_EXIST Character(1) VARCHAR2(1) NOT NULL Binds Exist
30 CS_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Section Style
31 CS_PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL Page Break
32 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
33 EFFDT Date(10) DATE Effective Date
34 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
35 CS_PROTECTED Character(1) VARCHAR2(1) NOT NULL Protected in Document Flag

Y/N Table Edit