COMP_EMAIL_ADDR (SQL Table)	Index Back
Email Addresses Stores non effective dated electronic addresses.

COMP_EMAIL_ADDR

(SQL Table)

Email Addresses

Stores non effective dated electronic addresses.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 COMPANY_ADDR_TYPE Character(3) VARCHAR2(3) NOT NULL Company email Address Type
ADM=Administration
HRC=HR
LEG=Legal
MAI=Main

4 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	COMPANY_ADDR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Company email Address Type ADM=Administration HRC=HR LEG=Legal MAI=Main
4	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address