FT_POSITION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	FT_POSITION_GUID	Character(36)	VARCHAR2(36) NOT NULL	Position GUID
3	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
4	JOB_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Job Sharing Permitted
5	DEFAULT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Default Set ID
6	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
7	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
8	FT_SETID_GRADE	Character(5)	VARCHAR2(5) NOT NULL	Grade SetID
9	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
10	FT_SET_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	Set ID GUID
11	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
12	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
13	FT_BUS_UNIT_GUID	Character(36)	VARCHAR2(36) NOT NULL	ORGANIZATION_ID GUID
14	FT_POSITION_CODE	Character(30)	VARCHAR2(30) NOT NULL	Position Code
15	FT_BUS_GROUP_GUID	Character(36)	VARCHAR2(36) NOT NULL	Business Group ID
16	FT_ORG_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	ORGANIZATION_ID GUID
17	FT_JOB_GUID	Character(36)	VARCHAR2(36) NOT NULL	Job GUID
18	FT_LOCATION_GUID	Character(36)	VARCHAR2(36) NOT NULL	Location GUID
19	FT_GRADE_GUID	Character(36)	VARCHAR2(36) NOT NULL	Grade GUID
20	FT_ENTRY_STEP_ID	Character(18)	VARCHAR2(18) NOT NULL	Entry Step Id
21	FT_ACTIVE_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Active Status
22	FT_SUPERVISOR_ID	Character(18)	VARCHAR2(18) NOT NULL	Supervisor ID
23	FT_SPR_ASSGNMT_ID	Character(18)	VARCHAR2(18) NOT NULL	Supervisor Assignment ID
24	FT_ACTN_OCCUR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Action Occurrence ID
25	FT_REGULAR_TEMP	Character(30)	VARCHAR2(30) NOT NULL	Regular or Temporary
26	FT_FTE	Number(2,0)	SMALLINT NOT NULL	FTE
27	FT_HIRING_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Hiring Status
28	FT_FULL_PART_TIME	Character(30)	VARCHAR2(30) NOT NULL	Full Part Time
29	FT_FREQUENCY	Character(30)	VARCHAR2(30) NOT NULL	Frequency
30	FT_TIME_START	Character(5)	VARCHAR2(5) NOT NULL	Time Normal Start
31	FT_TIME_FINISH	Character(5)	VARCHAR2(5) NOT NULL	Time Normal Finish
32	FT_POSITION_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Position Type
33	FT_PRB_PRD_UNIT_CD	Character(30)	VARCHAR2(30) NOT NULL	Porbation Period Unit Code
34	FT_BARG_UNIT_CODE	Character(30)	VARCHAR2(30) NOT NULL	Bargaining Unit Code
35	FT_MAX_HEAD_COUNT	Number(4,0)	SMALLINT NOT NULL	Max Head Count
36	FT_WORKING_HOURS	Character(22)	VARCHAR2(22) NOT NULL	Working Hours
37	FT_OVERLAP_ALLOWED	Character(30)	VARCHAR2(30) NOT NULL	Overlap Alllowed
38	FT_SEASONAL_FLAG	Character(30)	VARCHAR2(30) NOT NULL	Seasonal Flag
39	FT_PROBATION_PRD	Character(2)	VARCHAR2(2) NOT NULL	Probation Period
40	FT_SEASON_START_DT	Date(10)	DATE	Seasonal Start Date
41	FT_SECURITY_CLAER	Character(30)	VARCHAR2(30) NOT NULL	Security Clearance
42	FT_SEASON_END_DT	Date(10)	DATE	Seasonal End Date
43	FT_ATTR_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Attribute Category
44	FT_NAME	Character(240)	VARCHAR2(240) NOT NULL	Name
45	FT_LANGUAGE	Character(4)	VARCHAR2(4) NOT NULL	Language
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