CS_CLSTXT_SVW (SQL View)	Index Back
PTSF Text for clause Text for clause for PTSF

CS_CLSTXT_SVW

(SQL View)

PTSF Text for clause

Text for clause for PTSF

SELECT SETID , CS_OBJECT_ID , EFFDT , CS_BODY_TYPE , CS_BODY FROM PS_CS_OBJECT_TEXT WHERE 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 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

5 CS_BODY Long Character CLOB stores the body text for clause/section.

#	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	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
5	CS_BODY	Long Character	CLOB	stores the body text for clause/section.