R_CONTRIB_PART(SQL Table) |
Index Back |
---|---|
Contributions Temp TableThis view is for the SQR Report STES003 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Stock ID | |
4 | Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan |
|
5 | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan | |
6 | Character(10) | VARCHAR2(10) NOT NULL | Offering ID | |
7 | Date(10) | DATE | Period End Date | |
8 | Character(10) | VARCHAR2(10) NOT NULL | Process Group | |
9 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
10 | Character(3) | VARCHAR2(3) NOT NULL | Pay Group | |
11 | 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 |