| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUNCONTROLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 5 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 6 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 7 |
AMT_AVAILABLE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Available Amount
|
| 8 |
APPLY_RATES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Burden Rates
|
| 9 |
BALANCING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Balancing
N=No
Y=Yes
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 11 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 12 |
BUSINESS_UNIT2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 13 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_SC_VW
|
| 14 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_SC_VW
|
| 15 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_SC_VW
|
| 16 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_SC_VW
|
| 17 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_SC_VW
|
| 18 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_SC_VW
|
| 19 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 20 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 21 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 22 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_SC_VW
|
| 23 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_SC_VW
|
| 24 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_SC_VW
|
| 25 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_SC_VW
|
| 26 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 27 |
DETAIL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Detail Number
|
| 28 |
DIST_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Distribution Transaction ID
|
| 29 |
DISTRIB_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Distributed amount
|
| 30 |
DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete task
|
| 31 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 32 |
FIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used during Funds Distribution processing. Identifies whether there are sufficient funds to fit all transactions being processed.
A=All Fit
O=Over Distribution Limit
S=Split Processing
|
| 33 |
FUND_CALL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifier used in Funds Distribution processing to determine the type of call being made.
F=Feeder
R=Redistribute
U=Process Undistributed
|
| 34 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 35 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
|
| 36 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 37 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 38 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 39 |
LINE_NO |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 40 |
NUM_ERRORS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Errors in Data
|
| 41 |
NUM_ROWS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Number of Rows
|
| 42 |
ONE_TARGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group target definitions
N=No
Y=Yes
|
| 43 |
PC_FND_FEED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Run for Incoming Transactions
|
| 44 |
PC_PRICING_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Pricing
|
| 45 |
PRIORITY_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception Type Priority Level
1=First
2=Second
3=Third
4=Fourth
5=Fifth
6=Sixth
|
| 46 |
PROCESS_ORDER |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 47 |
PROCESS_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Results
D=Copy original/create discount
S=Create new sharing row
|
| 48 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 49 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 50 |
RATE_DATE_FIELD |
Character(25) |
VARCHAR2(25) NOT NULL |
Rate Date Field
|
| 51 |
RATE_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Acct Dt
T=Trans Dt
|
| 52 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 53 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 54 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 55 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 56 |
ROW_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Row Complete
|
| 57 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 58 |
ROWCOUNT1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row Count
|
| 59 |
ROWCOUNT2 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row Count
|
| 60 |
ROWCOUNT3 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row Count
|
| 61 |
ROWS_RETRIEVED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Rows Retrieved
|
| 62 |
ROWS_IN_STAGE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Total Rows in Staging Table
|
| 63 |
RULE_ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Funds Distribution Rule Activity ID
|
| 64 |
RUN_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
An indicator that determines order in which transactions are to be processed.
|
| 65 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 66 |
SEQ_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 67 |
SEQ_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Transaction ID
|
| 68 |
SOURCE_TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Table Name
|
| 69 |
TABLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 70 |
TARGET_GROUP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Group ID
|
| 71 |
TGT_DETAIL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Target Detail Number
|
| 72 |
THRESHOLD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Threshold Amount
|
| 73 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 74 |
TO_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
To Interface ID
|
| 75 |
TO_INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
To Interface Line Number
|
| 76 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 77 |
WEIGHT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Field used to store Weight Points.
|
| 78 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 79 |
YES |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 80 |
LOOP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Looping
|
| 81 |
LOOP_KEY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Loop Key
|
| 82 |
WORK_CNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 1
|
| 83 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 84 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 85 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 86 |
SUM1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sum Amount 1
|
| 87 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist
|
| 88 |
RESOURCE_ID_TRIM |
Character(40) |
VARCHAR2(40) NOT NULL |
Resource ID Trimmed
|
| 89 |
SUM2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sum 2 Amount
|
| 90 |
TOTAL_AMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total Amount
|
| 91 |
TOTAL_AMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total Amount
|