CS_CLSTYPE_LVW (SQL View)	Index Back
Clause Type Xlat Lang VW

CS_CLSTYPE_LVW

(SQL View)

Clause Type Xlat Lang VW

SELECT %Substring(A.FIELDVALUE ,1 ,1) , B.LANGUAGE_CD , A. XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'CS_CLAUSE_TYPE' AND %EffdtCheck(PSXLATITEM C, A, %CURRENTDATEIN) AND A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND A.EFFDT = B.EFFDT AND A.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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	CS_CLSTYP_DESC	Character(30)	VARCHAR2(30) NOT NULL	Clause Type