FT_PSJOB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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
3	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.
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	EFFDT	Date(10)	DATE	Effective Date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	FT_NEW_START_DATE	Date(10)	DATE	Effective Start Date
8	FT_MIN_START_DATE	Date(10)	DATE	Effective Start Date
9	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
10	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
11	FT_EFF_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Effective Sequence
12	FT_EFF_LATEST_CHG2	Character(30)	VARCHAR2(30) NOT NULL	Effective Latest Change (30)
13	FT_PROC_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Process Sequence
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_RCD_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	RCD Sequence
17	FT_CREATE_WR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Work Relationship
18	FT_CREATE_WT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Work Term
19	FT_CREATE_SPV_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Assignment Supervisor
20	FT_CREATE_MSR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Assignment Measure
21	FT_CREATE_PTU_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create Person Type Usage
22	FT_WR_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Work Relationship RCD
23	FT_WR_EFFDT	Date(10)	DATE	Work Relationship Eff Date
24	FT_WR_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Work Relationship Eff Date
25	FT_WR_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Work Relationship Eff Seq
26	FT_WR_GUIDSEQ	Number(4,0)	SMALLINT NOT NULL	Sequence
27	FT_WT_EFFDT	Date(10)	DATE	Work Term Effective Date
28	FT_WT_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Work Term Eff Date
29	FT_WT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Work Term Eff Seq
30	FT_WT_GUIDSEQ	Number(4,0)	SMALLINT NOT NULL	Sequence
31	FT_SPV_END_DATE	Date(10)	DATE	Assignment Supervisor End Date
32	FT_MSR_END_DATE	Date(10)	DATE	Assignment Measure End Date
33	FT_PTU_END_DATE	Date(10)	DATE	Person Type Usage End Date
34	FT_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Effective Date in PS Format
35	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
36	FT_PREV_HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Previous HR Status
37	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
38	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key
39	FT_PERSON_GUID	Character(36)	VARCHAR2(36) NOT NULL	Person GUID
40	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag
41	SERVICE_DT	Date(10)	DATE	Service Date
42	CMPNY_SENIORITY_DT	Date(10)	DATE	Company Seniority Date
43	TERMINATION_DT	Date(10)	DATE	Termination Date
44	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
45	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
46	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
47	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
48	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
49	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
50	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
51	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
52	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
53	FT_DEPTID_PARENT	Character(20)	VARCHAR2(20) NOT NULL	Parent Department