FT_XTRCT_PRCS(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
4 | FT_XTRCT_PROCESS | 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 |