FO_EMP_XREF_UPG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PBM_ASGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Assignment ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: JOB
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: JOB
4	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: BUS_UNIT_TBL_PC
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACTIVITY
7	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
8	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.
9	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
10	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
11	ASSIGN_STS	Character(2)	VARCHAR2(2) NOT NULL	Assignment Status A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel
12	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization
13	START_DT	Date(10)	DATE	Start Date
14	END_DT	Date(10)	DATE	End Date
15	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
16	DEFAULT_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Default Staffing Empl Record
17	MANAGER_CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Order Contact
18	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
19	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.