SCC_SEASAD3_AET

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