PROCESS_INSTANCEOPRIDRUN_CNTL_IDREQUEST_IDFT_XTRCT_PROCESS01=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
FT_RPT_RUN_PARM(SQL Table) |
Index Back |
|---|---|
Process Run ParametersProcess Run Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | 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 |
| 6 | SELECTED | Character(1) | VARCHAR2(1) NOT NULL | Selected |