R_CONTRIB_PART

(SQL Table)
Index Back

Contributions Temp Table

This view is for the SQR Report STES003

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
4 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
E=Purchase Plan
O=Option Plan
5 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
6 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID
7 PERIOD_END_DT Date(10) DATE Period End Date
8 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
10 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
11 ESPP_CONTRIB_SRC Character(4) VARCHAR2(4) NOT NULL Contribution Source
CF=Carry-Forward Contribution
D=Data Entered
GP=Global Payroll
I=Import
MA=Manual Contributions
NAP=North American Payroll
OFF=Offset Contribution Balance
PI=Payroll Interface Contribution
REF=Stock Purchase Refund
12 NAME Character(50) VARCHAR2(50) NOT NULL Name
13 CARRYOVER_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Carryover Amount
14 ESPP_CONTRIB_AMT Signed Number(17,6) DECIMAL(15,6) NOT NULL Contribution Amount
15 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
16 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
17 EXCHANGE_DT Date(10) DATE Exchange Date
18 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
19 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
20 CNVRTED_CARRY_FRWD Signed Number(20,6) DECIMAL(18,6) NOT NULL Converted Carry Forward Amount
21 ESPP_STOCK_CONTRIB Signed Number(20,6) DECIMAL(18,6) NOT NULL ESPP Stock Contribution Amount
22 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code