| # |
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 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: A
|
| 4 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
Default Value: N
|
| 5 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 7 |
FMEV_RPT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fusion Migration Analyzer - Report Type
1=High Level Differences
2=Product Readiness Summary
3=Product Readiness Detail
|
| 8 |
USAGE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
This field will be used to identify the usage of a component as to if it is Coexistance or Fusion Migration
FI=Fusion Integration
FI=Fusion HCM Apps
FM=Fusion Migration
FM=Fusion Migration
TI=Taleo
Default Value: FI
|
| 9 |
FMEV_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Fusion Migration Analyzer - Product Groupings
Prompt Table:
FMEV_PRODUCT_VW
|
| 10 |
FMEV_PGM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Fusion Migration Analyzer - Report ID
Prompt Table:
FMEV_PGM_VW
|
| 11 |
FMEV_VER_PSFT |
Character(4) |
VARCHAR2(4) NOT NULL |
Fusion Migration Analyzer - PeopleSoft version numbers
89=PeopleSoft 8.9
90=PeopleSoft 9.0
91=PeopleSoft 9.1
92=PeopleSoft 9.2
ANY=Any Version
Default Value: ANY
|
| 12 |
FMEV_VER_FUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Fusion Migration Analyzer - Fusion version numbers
ANY=Any Version
F10=Fusion 1.0
Default Value: F10
|
| 13 |
FMEV_VER_TALEO |
Character(4) |
VARCHAR2(4) NOT NULL |
Fusion Migration Analyzer - Taleo version numbers
13A=13A
|