CS_CLSTYPE_VW (SQL View)	Index Back
Clause Type Xlat VW

CS_CLSTYPE_VW

(SQL View)

Clause Type Xlat VW

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_CLAUSE_TYPE Character(2) VARCHAR2(2) NOT NULL New with 9.1 to indicate if Table Clause or other
G=General Clause
T=Table Clause
Default Value: G

2 CS_CLSTYP_DESC Character(30) VARCHAR2(30) NOT NULL Clause Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_CLAUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	New with 9.1 to indicate if Table Clause or other G=General Clause T=Table Clause Default Value: G
2	CS_CLSTYP_DESC	Character(30)	VARCHAR2(30) NOT NULL	Clause Type