FOEMPREFERS_UPG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPRDEFTBL_UPG.SETID Prompt Table: SP_SETID_NONVW
4	FO_TEMPLATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Form Type Prompt Table: %EDITTABLE
5	TEMPLATE_CODE	Character(6)	VARCHAR2(6) NOT NULL	Form Code Prompt Table: FO_TEMPLATE_HDR
6	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer Prompt Table: FO_PRIORWRK_VW
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPRDEFTBL_UPG.OPRID Prompt Table: OPRID_VW
9	REFERENCE_DT	Date(10)	DATE	Reference Date
10	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty. Prompt Table: FO_CONT_ORDR_VW
11	CONTACT_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Contact Name 1
12	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
13	REFERENCE_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Reference Check By C=Customer R=Recruiter T=Third Party Service
14	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
15	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
16	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text