FT_XTRCT_PRCS(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | 
A user's ID (see PSOPRDEFN).
 Prompt Table: OPRID_VW  | 
|
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Request ID | |
| 4 | Character(2) | VARCHAR2(2) NOT NULL | 
Process
 01=Location 02=HR Business Unit 03=Department 04=Job Grade 05=Job Code 06=Position 07=Person/Job 08=Department Tree 09=Related Language 10=Job Grade Rate 11=Salary 12=Bonus  | 
|
| 5 | FT_DEPENDENCY | Character(254) | VARCHAR2(254) NOT NULL | Process Dependency | 
| 6 | SELECTED | Character(1) | VARCHAR2(1) NOT NULL | 
Selected
 Y/N Table Edit Default Value: N  | 
| 7 | FT_FTM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
Fusion Talent Management
 Y/N Table Edit  | 
| 8 | FT_CWB_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
Workforce Compensation
 Y/N Table Edit  |