CS_OBJ_TYPE_VW1 (SQL View)	Index Back
Object Type view -- no Adhoc Object type view with no adhoc clause

CS_OBJ_TYPE_VW1

(SQL View)

Object Type view -- no Adhoc

Object type view with no adhoc clause

SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CS_OBJECT_TYPE' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE <> '0003' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

Related Language Record: CS_OBJ_TYPELVW1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name