ADDRESSES_SA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: HCR_ADDR_TYP_I
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	LOC_ADDR	Character(10)	VARCHAR2(10) NOT NULL	Location Address Name Prompt Table: LOC_ADDR_TBL
5	LOC_ADDR_DATA	Character(10)	VARCHAR2(10) NOT NULL	Location Address Data
6	LOC_ADDR_LINE	Character(1)	VARCHAR2(1) NOT NULL	Location Address Print Line 1=Print as Line 1 2=Print As Line 2 3=Print as Line 3 4=Print As Line 4
7	LOC_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Location Address Type MLBX=Mailbox ROOM=Room
8	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
9	ORG_LOCATION	Number(3,0)	SMALLINT NOT NULL	Location Nbr Prompt Table: ORG_LOCATION
10	DESCR_EXT_ORG	Character(30)	VARCHAR2(30) NOT NULL	Org Name
11	DESCR_ORG_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Org Location
12	MAINT_ADDR_MANUAL	Character(1)	VARCHAR2(1) NOT NULL	Maintain Address Manually Y/N Table Edit Default Value: N
13	MAINT_OTHER_MANUAL	Character(1)	VARCHAR2(1) NOT NULL	Maintain Other Data Manually Y/N Table Edit Default Value: N
14	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr Prompt Table: ORG_CONTACT
15	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
16	DATA_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Data Source AE=Ad-Hoc Employee AO=Ad-Hoc Organizational E=Extract
17	SEASONAL_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Seasonal Address