SEVCIPCODEVWLNG (SQL View)	Index Back
Reld Lng SEVIS Cip Code View SEVCIPCODEVWLNG is the language record related to SEV_CIP_CODE_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SEVCIPCODEVWLNG

(SQL View)

Reld Lng SEVIS Cip Code View

SEVCIPCODEVWLNG is the language record related to SEV_CIP_CODE_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT %Substring(A.CIP_CODE, 1, 8) , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_CIP_CODE_LANG A WHERE rtrim(A.CIP_CODE) LIKE ('__.____')

Related Language Record for SEV_CIP_CODE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUBJ_FIELD_CODE Character(8) VARCHAR2(8) NOT NULL Subj/Field Code

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBJ_FIELD_CODE	Character(8)	VARCHAR2(8) NOT NULL	Subj/Field Code
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description