FPAADDR_TYPE_VW (SQL View)	Index Back
FPS Address Type used when employee has been deleted ADDRESS_TYPE holds the different types of addresses for each person. It is a child of PERSONAL_DATA, and a parent to ADDRESSES.

FPAADDR_TYPE_VW

(SQL View)

FPS Address Type

used when employee has been deleted ADDRESS_TYPE holds the different types of addresses for each person. It is a child of PERSONAL_DATA, and a parent to ADDRESSES.

SELECT DISTINCT A.EMPLID , B.ORDER_BY_SEQ , A.ADDRESS_TYPE FROM PS_FPAADDRS_HIST A , PS_ADDRESS_TYP_TBL B WHERE A.ADDRESS_TYPE = B.ADDRESS_TYPE

Parent record: FPAPERSON_HIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence

3 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Prompt Table: ADDRESS_TYP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ORDER_BY_SEQ	Number(2,0)	SMALLINT NOT NULL	Order by Sequence
3	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL