CS_SECTTYPE_VW (SQL View)	Index Back
Clause Type Xlat VW

CS_SECTTYPE_VW

(SQL View)

Clause Type Xlat VW

SELECT %Substring(B.FIELDVALUE ,1 ,1) , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'CS_SECTION_TYPE' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.EFF_STATUS = 'A'

# 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 CS_SECTTYP_DESC Character(30) VARCHAR2(30) NOT NULL Section Type

#	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	CS_SECTTYP_DESC	Character(30)	VARCHAR2(30) NOT NULL	Section Type