CS_SECT_TYPELVW (SQL View)	Index Back
Source Trans view -- main ones Source trans view .. only the main ones ..excludes the two invisible ones needed.

CS_SECT_TYPELVW

(SQL View)

Source Trans view -- main ones

Source trans view .. only the main ones ..excludes the two invisible ones needed.

SELECT %Substring(X.FIELDVALUE, 1, 2) , L.LANGUAGE_CD , L.XLATSHORTNAME , L.XLATLONGNAME FROM PSXLATITEM X , PSXLATITEMLANG L WHERE X.FIELDNAME = 'CS_SECTION_TYPE' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE <> 'SH' AND X.FIELDVALUE <> 'SL' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM X, PSXLATITEMLANG L, EFFDT)

Related Language Record for CS_SECT_TYPE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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

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