| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
TO_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Revalue Currency
|
| 5 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 6 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 7 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 8 |
ASOF_DT |
Date(10) |
DATE |
As of Date
|
| 9 |
PROC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Uniquely identifies a Currency Conversion Process Group
|
| 10 |
PROD_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
This is an XLAT field listing all PeopleSoft 7.5 Product codes.
AM=Asset Management
AP=Payables
AR=Receivables
BD=Budgets
BI=Billing
CA=Contracts
CE=Cost Management
CP=Product Configurator
DM=Deduction Management
DP=Demand Planning
EN=Manufactuing Bills and Routing
EO=Enterprise Components
EP=Enterprise Planning
EX=Expenses
FG=Federal Government
GF=Global Financials
GL=General Ledger
HP=HRMS Education & Government
IN=Inventory
MG=Manufacturing
OM=Order Management
OP=Order Promising
PC=Projects
PL=Production Planning
PO=Purchasing
QS=Quality
SF=Production Management
TR=Treasury
Prompt Table:
EO_PS_PRODUCT
|
| 11 |
RULE_INSTNC_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Rule Occurrence Number
|
| 12 |
FLD_INSTNC_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Conversion Field Instance Nbr
|
| 13 |
RECON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Flag
|
| 14 |
COMPLETE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Switch
|
| 15 |
CHECK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 16 |
RECON_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reconciliation Method
1=Convert and Adjust
5=Adjust Only
6=Sum-Based Value
7=Sum-Based, Reverse Sign
8=No Reconciliation
|
| 17 |
EFFDT_PROC_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Processing Method
1=No Effective Date Processing
3=Effective Date, No Eff Seq
4=Effective Date with Eff Seq
|
| 18 |
SEL_DISTINCT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distinct
|
| 19 |
FIELD_SQLID |
Character(23) |
VARCHAR2(23) NOT NULL |
Field SQLID
|
| 20 |
RULE_SQLID |
Character(23) |
VARCHAR2(23) NOT NULL |
Rule SQLID
|
| 21 |
AE_RCN_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 22 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 23 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 24 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 25 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 26 |
RECON_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Reconciliation Record Name
|
| 27 |
RUN_ALL_AUDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Processing
1=Audit Processing
2=Bypass All Audits
3=As Defined on Rule/Exception
|
| 28 |
EO_AUDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Flag
1=Before
2=After
|
| 29 |
LAST_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 30 |
RECNAME_AUDIT |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 31 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 32 |
TEO1_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Record 1 Name
|
| 33 |
TEO2_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Record 2 Name
|
| 34 |
TEO3_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Record 3 Name
|
| 35 |
TEOA_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Owned by the Currency Conversion Utility. Used by the Utility on the State Record to dynamically keep track, during conversion, of the audit work record created for each conversion record. This functionality is new in Release 8.0 and will be retrofitted to Release 7.5.
|
| 36 |
EXCP_PROC_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
|
| 37 |
BYPASS_DTL_AUDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by the Currency Conversion Utility. Any exceptions process that has been coded to write before and after images to the audit table should check this flag before writing to the audit table. Note: Use this flag in conjuntion with the flag on the run control (see Run Control for the Currency Conversion Utility). This flas has been added to the state record.
|
| 38 |
PROCGRP_TIMING_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception Timing
1=Before Process Group
2=After Process Group
3=In Place Of Process Group
|
| 39 |
CCR_TIMING_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception Timing
1=Before Conversion Rule
2=After Conversion Rule
3=In Place Of Conversion Rule
|
| 40 |
SELECT_OPER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 2
|
| 41 |
SELECT_OPER3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 3
|
| 42 |
SELECT_OPER4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 4
|
| 43 |
SELECT_OPER5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 5
|
| 44 |
SELECT_OPER6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 6
|
| 45 |
SELECT_OPER7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 7
|
| 46 |
SELECT_OPER8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 8
|
| 47 |
SELECT_OPER9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 9
|
| 48 |
SELECT_OPER10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Operator 10
|
| 49 |
FLDC2A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 2 CHAR Field, Value A
|
| 50 |
FLDC2B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 2 CHAR Field, Value B
|
| 51 |
FLDC3A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 3 CHAR Field, Value A
|
| 52 |
FLDC3B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 3 CHAR Field, Value B
|
| 53 |
FLDC4A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 4 CHAR Field, Value A
|
| 54 |
FLDC4B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 4 CHAR Field, Value B
|
| 55 |
FLDC5A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 5 CHAR Field, Value A
|
| 56 |
FLDC5B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 5 CHAR Field, Value B
|
| 57 |
FLDC6A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 6 CHAR Field, Value A
|
| 58 |
FLDC6B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 6 CHAR Field, Value B
|
| 59 |
FLDC7A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 7 CHAR Field, Value A
|
| 60 |
FLDC7B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 7 CHAR Field, Value B
|
| 61 |
FLDC8A |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp 8 CHAR Field, Value A
|
| 62 |
FLDC8B |
Character(35) |
VARCHAR2(35) NOT NULL |
Created by MLE
|
| 63 |
FLDC9A |
Character(35) |
VARCHAR2(35) NOT NULL |
Created by MLE
|
| 64 |
FLDC9B |
Character(35) |
VARCHAR2(35) NOT NULL |
Created by MLE
|
| 65 |
FLDC10A |
Character(35) |
VARCHAR2(35) NOT NULL |
SelComp 10 CHAR Field, Value A
|
| 66 |
FLDC10B |
Character(35) |
VARCHAR2(35) NOT NULL |
Sel Comp10 CHAR Field, Value B
|
| 67 |
FLDD2A |
Date(10) |
DATE |
Sel Comp 2 DATE Field, Value A
|
| 68 |
FLDD2B |
Date(10) |
DATE |
Sel Comp 2 DATE Field, Value B
|
| 69 |
FLDD3A |
Date(10) |
DATE |
Sel Comp 3 DATE Field, Value A
|
| 70 |
FLDD3B |
Date(10) |
DATE |
Sel Comp 3 DATE Field, Value B
|
| 71 |
FLDD4A |
Date(10) |
DATE |
Sel Comp 4 DATE Field, Value A
|
| 72 |
FLDD4B |
Date(10) |
DATE |
Sel Comp 4 DATE Field, Value B
|
| 73 |
FLDD5A |
Date(10) |
DATE |
Sel Comp 5 DATE Field, Value A
|
| 74 |
FLDD5B |
Date(10) |
DATE |
Sel Comp 5 DATE Field, Value B
|
| 75 |
FLDD6A |
Date(10) |
DATE |
Sel Comp 6 DATE Field, Value A
|
| 76 |
FLDD6B |
Date(10) |
DATE |
Sel Comp 6 DATE Field, Value B
|
| 77 |
FLDD7A |
Date(10) |
DATE |
Sel Comp 7 DATE Field, Value A
|
| 78 |
FLDD7B |
Date(10) |
DATE |
Sel Comp 7 DATE Field, Value B
|
| 79 |
FLDD8A |
Date(10) |
DATE |
Sel Comp 8 DATE Field, Value A
|
| 80 |
FLDD8B |
Date(10) |
DATE |
Sel Comp 8 DATE Field, Value B
|
| 81 |
FLDD9A |
Date(10) |
DATE |
Sel Comp 9 DATE Field, Value A
|
| 82 |
FLDD9B |
Date(10) |
DATE |
Sel Comp 9 DATE Field, Value B
|
| 83 |
FLDD10A |
Date(10) |
DATE |
Sel Comp10 DATE Field, Value A
|
| 84 |
FLDD10B |
Date(10) |
DATE |
Sel Comp10 DATE Field, Value B
|
| 85 |
BNDV2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 2
|
| 86 |
BNDV3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 3
|
| 87 |
BNDV4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 4
|
| 88 |
BNDV5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 5
|
| 89 |
BNDV6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 6
|
| 90 |
BNDV7 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 7
|
| 91 |
BNDV8 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 8
|
| 92 |
BNDV9 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 9
|
| 93 |
BNDV10 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 10
|
| 94 |
COUNT_PAIRS |
Number(2,0) |
SMALLINT NOT NULL |
Count of Rate Pairs
|
| 95 |
CURRENT_PAIR |
Number(2,0) |
SMALLINT NOT NULL |
Current Rate Pair
|
| 96 |
USER_CHAR1 |
Character(35) |
VARCHAR2(35) NOT NULL |
User Character Field 1
|
| 97 |
USER_CHAR2 |
Character(35) |
VARCHAR2(35) NOT NULL |
User Character Field 2
|
| 98 |
USER_CHAR3 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 3
|
| 99 |
USER_CHAR4 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 4
|
| 100 |
USER_CHAR5 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 5
|
| 101 |
USER_CHAR6 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 6
|
| 102 |
USER_CHAR7 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 7
|
| 103 |
USER_CHAR8 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Char 8
|
| 104 |
USER_CHAR9 |
Character(5) |
VARCHAR2(5) NOT NULL |
User char 9
|
| 105 |
USER_CHAR10 |
Character(5) |
VARCHAR2(5) NOT NULL |
User Char 10
|
| 106 |
USER_CHAR11 |
Character(5) |
VARCHAR2(5) NOT NULL |
User Char 11
|
| 107 |
USER_CHAR12 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Char 12
|
| 108 |
USER_CHAR13 |
Character(35) |
VARCHAR2(35) NOT NULL |
User Character Field 13
|
| 109 |
USER_COUNT1 |
Number(6,0) |
INTEGER NOT NULL |
User Count 1
|
| 110 |
USER_COUNT2 |
Number(6,0) |
INTEGER NOT NULL |
User Count 2
|
| 111 |
USER_COUNT3 |
Number(6,0) |
INTEGER NOT NULL |
User Count 3
|
| 112 |
USER_COUNT4 |
Number(6,0) |
INTEGER NOT NULL |
User Count 4
|
| 113 |
USER_DATE1 |
Date(10) |
DATE |
User Date Field 1
|
| 114 |
USER_DATE2 |
Date(10) |
DATE |
User Date Field 2
|
| 115 |
USER_DATE3 |
Date(10) |
DATE |
User Date Field 3
|
| 116 |
USER_DTTM1 |
DateTime(26) |
TIMESTAMP |
User DateTime Field 1
|
| 117 |
USER_NBR1_7V8 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Human Resources uses this field on record EO_CURRENCY_AET in a Currency Conversion exception process (HR_ASNHMHS1).
|
| 118 |
USER_NBR1_12V6 |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
User Number Field 1, 12.6
|
| 119 |
USER_NBR1_15V3 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Number Field 1, 15.3
|
| 120 |
USER_NBR1_16V2 |
Number(19,2) |
DECIMAL(18,2) NOT NULL |
User Number Field 1, 16.2
|
| 121 |
USER_NBR1_S12V6 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
User Signed Nbr Field 1, 12.6
|
| 122 |
USER_NBR1_S7V8 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Human Resources uses this field on record EO_CURRENCY_AET in a Currency Conversion exception process (HR_ASNHMHS1).
|
| 123 |
USER_NBR2_S7V8 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Human Resources uses this field on record EO_CURRENCY_AET in a Currency Conversion exception process (HR_ASNHMHS1).
|
| 124 |
USER_NBR1_S13V2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
User Signed Nbr Field 1, 13.2
|
| 125 |
USER_NBR2_S13V2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
User Signed Nbr Field 2, 13.2
|
| 126 |
USER_NBR3_S13V2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
User Signed Nbr Field 3, 13.2
|
| 127 |
USER_NBR1_S15V3 |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
User Signed Nbr Field 1, 15.3
|
| 128 |
USER_NBR1_S16V2 |
Signed Number(20,2) |
DECIMAL(18,2) NOT NULL |
User Signed Nbr Field 1, 16.2
|