GPCH_POST_LD_VW (SQL View)	Index Back
Postal Codes Per Load This new view will select all the postal code data from the postal code table based on the time when they were loaded. It will serve as base record for the subpage that shows all postal codes loaded by one run.

GPCH_POST_LD_VW

(SQL View)

Postal Codes Per Load

This new view will select all the postal code data from the postal code table based on the time when they were loaded. It will serve as base record for the subpage that shows all postal codes loaded by one run.

SELECT DTTM_IMPORTED , POSTAL_KEY_CHE , EFFDT , POSTAL_CD_TYPE_CHE , POSTAL , POSTAL_CD_EXT_CHE , CITY , STATE , LANGUAGE_CD , OTH_LANGUAGE_CHE , GPCH_TX_VILLAGE_CD FROM PS_POSTAL_CD_CHE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time

2 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

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

4 POSTAL_CD_TYPE_CHE Character(2) VARCHAR2(2) NOT NULL Postal Code Type These categories indicate what type of address the postal code can be used in.
10=Domestic Address or Postbox
20=Domestic Address
30=Postbox
40=Company Address
80=Swiss Post Internal Use

5 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

6 POSTAL_CD_EXT_CHE Character(2) VARCHAR2(2) NOT NULL Postal Code Extension Serves for rendering the Postal Code unambiguous, may not be used for addressing

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

8 STATE Character(6) VARCHAR2(6) NOT NULL State

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

10 OTH_LANGUAGE_CHE Character(3) VARCHAR2(3) NOT NULL Other (non-primary) language spoken in a community. Uses the same codes as language_cd
Prompt Table: LANGUAGE_CD_VW

11 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DTTM_IMPORTED	DateTime(26)	TIMESTAMP	Imported Date Time
2	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
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	POSTAL_CD_TYPE_CHE	Character(2)	VARCHAR2(2) NOT NULL	Postal Code Type These categories indicate what type of address the postal code can be used in. 10=Domestic Address or Postbox 20=Domestic Address 30=Postbox 40=Company Address 80=Swiss Post Internal Use
5	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
6	POSTAL_CD_EXT_CHE	Character(2)	VARCHAR2(2) NOT NULL	Postal Code Extension Serves for rendering the Postal Code unambiguous, may not be used for addressing
7	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
9	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
10	OTH_LANGUAGE_CHE	Character(3)	VARCHAR2(3) NOT NULL	Other (non-primary) language spoken in a community. Uses the same codes as language_cd Prompt Table: LANGUAGE_CD_VW
11	GPCH_TX_VILLAGE_CD	Character(4)	VARCHAR2(4) NOT NULL	Municipality Code