| # |
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 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 5 |
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
Default Value: 1
|
| 6 |
FMEV_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Fusion Migration Analyzer - Product Groupings
|
| 7 |
FMEV_PGM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Fusion Migration Analyzer - Report ID
Prompt Table:
FMEV_PGM
|
| 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
|
| 9 |
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
|
| 10 |
FMEV_VER_FUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Fusion Migration Analyzer - Fusion version numbers
ANY=Any Version
F10=Fusion 1.0
|
| 11 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 12 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
Prompt Table:
FMEV_AEP_VW
|
| 13 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
Prompt Table:
FMEV_AES_VW
|
| 14 |
AE_SQLROWS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Rows affected by last SQL stmt
|
| 15 |
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.
|
| 16 |
EXECUTE_PROD_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Execution Product ID
|
| 17 |
HR |
Character(1) |
VARCHAR2(1) NOT NULL |
Human Resources
Y/N Table Edit
|
| 18 |
BENEFIT_ADMINISTRN |
Character(1) |
VARCHAR2(1) NOT NULL |
Benefits Administration
Y/N Table Edit
|
| 19 |
PA |
Character(1) |
VARCHAR2(1) NOT NULL |
PS/Pension Administration
Y/N Table Edit
|
| 20 |
ST |
Character(1) |
VARCHAR2(1) NOT NULL |
PS/Stock Administration
Y/N Table Edit
|
| 21 |
TL |
Character(1) |
VARCHAR2(1) NOT NULL |
PS/Time and Labor Product
Y/N Table Edit
|
| 22 |
HGA |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Absence Flag
Y/N Table Edit
|
| 23 |
INSTALLED_PAY_NA |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll for North America
Y/N Table Edit
|
| 24 |
INSTALLED_PAY_INT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Interface
Y/N Table Edit
|
| 25 |
INSTALLED_PAY_GBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Payroll Core
Y/N Table Edit
|