FOEMPLURLS_UPG

(SQL Table)
Index Back

Employee Internet Websites

Store any websites associated with the Employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 URL_TYPE Character(4) VARCHAR2(4) NOT NULL Website Type
1=Business 1
2=Home
3=Business 2
3 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
4 PRIMARY_URL Character(1) VARCHAR2(1) NOT NULL Primary Web Addr

Y/N Table Edit

Default Value: N