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 | 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 |