FT_XTRCT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
4	BASE_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
7	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
8	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
9	FT_RECNAME_PS	Character(15)	VARCHAR2(15) NOT NULL	PS Source Record Name
10	FT_RECNAME_FT	Character(15)	VARCHAR2(15) NOT NULL	Fusion Data Record Name
11	FT_RECNAME_LOOKUP	Character(15)	VARCHAR2(15) NOT NULL	Dvm/Xref Lookup Table
12	FT_FIELDNAME_K	Character(18)	VARCHAR2(18) NOT NULL	Key Field Name
13	FT_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Field Name
14	FT_FIELDNAME_S	Character(18)	VARCHAR2(18) NOT NULL	Source Field Name
15	FT_FIELDNAME_GUID	Character(18)	VARCHAR2(18) NOT NULL	Guid Field Name
16	FT_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Value
17	FT_LENGTH	Number(5,0)	INTEGER NOT NULL	Length
18	FT_ELEMENT_NAME_FR	Character(30)	VARCHAR2(30) NOT NULL	Element Name
19	FT_ELEMENT_NAME_TO	Character(30)	VARCHAR2(30) NOT NULL	Element Name
20	FT_DOMAIN_TARGET	Character(30)	VARCHAR2(30) NOT NULL	Target Domain Name
21	FT_DOMAIN_SOURCE	Character(30)	VARCHAR2(30) NOT NULL	Source Domain Name
22	FT_MAP_NAME	Character(150)	VARCHAR2(150) NOT NULL	Map Name
23	FT_EFF_DATED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Effective Dated
24	FT_REQUIRED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Required Field N=No Y=Yes
25	FT_COUNT_1	Number(10,0)	DECIMAL(10) NOT NULL	Count
26	FT_COUNT_2	Number(10,0)	DECIMAL(10) NOT NULL	Count
27	FT_SQL_WHERE	Character(254)	VARCHAR2(254) NOT NULL	Where clause
28	FT_SQL_LONG	Long Character(4096)	CLOB	SQL String
29	FT_CONFIG_ID	Character(30)	VARCHAR2(30) NOT NULL	Configuration ID
30	FT_DEPT_TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
31	FT_FILE_NAME	Character(254)	VARCHAR2(254) NOT NULL	Output Zip File Override
32	FT_XTRCT_BUS_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Assignment
33	FT_XTRCT_LOCATION	Character(1)	VARCHAR2(1) NOT NULL	Location
34	FT_XTRCT_DEPARTMNT	Character(1)	VARCHAR2(1) NOT NULL	Department
35	FT_XTRCT_JOBCODE	Character(1)	VARCHAR2(1) NOT NULL	Job Code
36	FT_XTRCT_JOBGRADE	Character(1)	VARCHAR2(1) NOT NULL	Job Grade
37	FT_XTRCT_PERSON	Character(1)	VARCHAR2(1) NOT NULL	Person
38	FT_XTRCT_DEPT_TREE	Character(1)	VARCHAR2(1) NOT NULL	Department Tree
39	FT_XTRCT_POSITION	Character(1)	VARCHAR2(1) NOT NULL	Position
40	FT_XTRCT_LANGUAGE	Character(1)	VARCHAR2(1) NOT NULL	Related Language
41	FT_XTRCT_JOBGRDRT	Character(1)	VARCHAR2(1) NOT NULL	Job Grade Rate
42	FT_XTRCT_SALARY	Character(1)	VARCHAR2(1) NOT NULL	Salary
43	FT_XTRCT_BONUS	Character(1)	VARCHAR2(1) NOT NULL	Bonus
44	FT_POINT_IN_TIME	Date(10)	DATE	Point in Time
45	FT_FILTER_COMP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Company Data Filter Option 0=All 1=Specify...
46	FT_FILTER_REG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Reg Region Data Filter Option 0=All 1=Specify...
47	FT_FILTER_SET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Set ID Data Filter Option 0=All 1=Specify...
48	FT_FILTER_GRP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Group Data Filter Option 0=All 1=Specify... Default Value: 0
49	AE_SQLROWS	Number(10,0)	DECIMAL(10) NOT NULL	Rows affected by last SQL stmt
50	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field
51	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
52	GB_EFFDT	Date(10)	DATE	Group As Of Date
53	GB_REFINE_DATE	Date(10)	DATE	Refinement Date
54	FT_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
55	FT_ERL_ADOPT_PREGA	Character(1)	VARCHAR2(1) NOT NULL	8.9 Pre-GA Early Adopter
56	FT_MIGR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Fusion Migration Flag
57	FT_FBL_DEPT_TREE	Character(1)	VARCHAR2(1) NOT NULL	Fusion Loader F=File Based Loader H=HR2HR Loader