OPRIDRUN_CNTL_IDPROC_GRP_IDPROD_IDRULE_INSTNC_NBRFLD_INSTNC_NBRAE_APPLIDAE_SECTIONAE_STEP1=Before
2=After
RUN_CNTL_CC3_EO(SQL Table) |
Index Back |
|---|---|
Currency Conversion Run Cntrl |
| # | 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 | PROC_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Uniquely identifies a Currency Conversion Process Group |
| 4 | PROD_ID |
Character(2) | VARCHAR2(2) NOT NULL | This is an XLAT field listing all PeopleSoft 7.5 Product codes. |
| 5 | RULE_INSTNC_NBR |
Number(3,0) | SMALLINT NOT NULL | Rule Occurrence Number |
| 6 | FLD_INSTNC_NBR |
Number(3,0) | SMALLINT NOT NULL | Conversion Field Instance Nbr |
| 7 | AE_APPLID |
Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 8 | AE_SECTION |
Character(8) | VARCHAR2(8) NOT NULL | Section |
| 9 | AE_STEP |
Character(8) | VARCHAR2(8) NOT NULL | Name |
| 10 | EO_AUDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Audit Flag
1=Before 2=After |
| 11 | COMPLETE_SW | Character(1) | VARCHAR2(1) NOT NULL | Complete Switch |
| 12 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |