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 |