POSTAL_ALT_CHE (SQL Table)	Index Back
Alt. Language Community Names This record holds the alternate language names for the communities with more than one language. It is also uploaded from the file provided by the Swiss Post.

POSTAL_ALT_CHE

(SQL Table)

Alt. Language Community Names

This record holds the alternate language names for the communities with more than one language. It is also uploaded from the file provided by the Swiss Post.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSTAL_KEY_CHE Character(5) VARCHAR2(5) NOT NULL This field is used by the Swiss Post as primary key in their postal code file. Ordnungsnummer Post

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

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

4 CITY Character(30) VARCHAR2(30) NOT NULL City

5 DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSTAL_KEY_CHE	Character(5)	VARCHAR2(5) NOT NULL	This field is used by the Swiss Post as primary key in their postal code file. Ordnungsnummer Post
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
5	DTTM_IMPORTED	DateTime(26)	TIMESTAMP	Imported Date Time