FOEMPLXREF_UPG (SQL Table)	Index Back
FO Employee XREF Table

FOEMPLXREF_UPG

(SQL Table)

FO Employee XREF Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: JOB

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: JOB

3 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: BUS_UNIT_TBL_PC

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACTIVITY

6 SETID_CUST Character(5) VARCHAR2(5) NOT NULL Customer SetID

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: JOB
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: JOB
3	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: BUS_UNIT_TBL_PC
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACTIVITY
6	SETID_CUST	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
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.