FT_WORK_RLAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
7	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
8	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
9	TERMINATION_DT	Date(10)	DATE	Termination Date
10	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
11	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
12	ORG_INSTANCE_ERN	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
13	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
14	FT_PER_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Assignment Seq Within Person
15	FT_ERN_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	ERN Sequence
16	FT_WR_GUIDSEQ	Number(4,0)	SMALLINT NOT NULL	Sequence
17	FT_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Effective Date in PS Format
18	FT_ACC_TERM_DATE	Date(10)	DATE	Accepted Termination Date
19	FT_ACTN_OCCUR_ID	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
20	FT_ACT_TERM_DATE	Date(10)	DATE	Accepted Termination Date
21	FT_ADJ_SVC_DATE	Date(10)	DATE	Adjusted Service Date
22	FT_BUS_GROUP_ID	Number(18,0)	DECIMAL(18) NOT NULL	Business Group ID
23	FT_EMPL_VRFD_DATE	Date(10)	DATE	Employee Data Verified Date
24	FT_START_DATE	Date(10)	DATE	Start Date
25	FT_FAST_TRACK_EMPL	Character(30)	VARCHAR2(30) NOT NULL	Fast Track Employee
26	FT_LAST_WORK_DATE	Date(10)	DATE	Last Working Date
27	FT_LEGALENTY_GUID	Character(36)	VARCHAR2(36) NOT NULL	ORGANIZATION_ID GUID
28	FT_LEGISLATION_CD2	Character(150)	VARCHAR2(150) NOT NULL	Legislation Code
29	FT_NTFY_TERM_DATE	Date(10)	DATE	Notified Termination Date
30	FT_ON_MIL_SERVICE	Character(30)	VARCHAR2(30) NOT NULL	On Military Service
31	FT_ORIG_HIRE_DATE	Date(10)	DATE	Original Hire Date
32	FT_PER_OF_SVC_GUID	Character(36)	VARCHAR2(36) NOT NULL	Period of Service ID
33	FT_PERIOD_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Period Type
34	FT_PERSON_GUID	Character(36)	VARCHAR2(36) NOT NULL	Person GUID
35	FT_PRIMARY_FLAG	Character(30)	VARCHAR2(30) NOT NULL	Primary Work Relationship Flag
36	FT_LSD	Character(1)	VARCHAR2(1) NOT NULL	Used by Fusion Coexistence
37	FT_LED	Character(1)	VARCHAR2(1) NOT NULL	Used by Fusion Coexistence
38	FT_PROJ_TERM_DATE	Date(10)	DATE	Projected Termination Date
39	FT_REHIRE_AUTH	Character(30)	VARCHAR2(30) NOT NULL	Rehire Authorizor
40	FT_REHIRE_REASON	Character(60)	VARCHAR2(60) NOT NULL	Rehire Reason
41	FT_REHIRE_RCMNDTN	Character(30)	VARCHAR2(30) NOT NULL	Rehire Recommendation
42	FT_PERS_TERM_GUID	Character(36)	VARCHAR2(36) NOT NULL	Termination Accepted Person ID
43	FT_COMMENTS	Long Character(1000)	VARCHAR2(1000)	Comments
44	FT_PERS_RHAU_GUID	Character(36)	VARCHAR2(36) NOT NULL	Rehire Authorization Persion I
45	FT_WORKER_NUMBER	Character(30)	VARCHAR2(30) NOT NULL	Worker Number
46	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
47	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
48	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
49	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
50	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key