OPRIDRUN_CNTL_IDPrompt Table: IDO_ORGPLAN_JPN
Prompt Table: BUSUNIT_HR_VW
Prompt Table: SETID_TBL
Prompt Table: ACTION_TBL
Prompt Table: ACTN_REASON_TBL
Prompt Table: TREE1_VW
Prompt Table: IDO_TN1_JPN_VW
Prompt Table: IDO_EDT_JPN_VW
RC_IDO_JPN(SQL Table) |
Index Back |
|---|---|
Ido Run Control recordRun Control record used for Ido SQR and AE processes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ORG_PLAN_JPN | Character(3) | VARCHAR2(3) NOT NULL |
Tracks one possible view of the employees in a company.
Prompt Table: IDO_ORGPLAN_JPN |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUSUNIT_HR_VW |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 7 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 8 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: TREE1_VW |
| 9 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: IDO_TN1_JPN_VW |
| 10 | EFFDT_JPN | Date(10) | DATE |
This field is used as a second Effective Date field on a page.
Prompt Table: IDO_EDT_JPN_VW |