ST_CONTRIB_MANL(SQL Table) |
Index Back |
---|---|
Manual ContributionsThis table stores Stock Purchase Plan Manual Contributions either by import or online data entry. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
4 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan Default Value: E |
5 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: STOCK_PLAN_TBL |
6 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table: ST_OFFERING_PD |
7 | PERIOD_END_DT | Date(10) | DATE NOT NULL |
Period End Date
Prompt Table: ST_PURCHASE_PD |
8 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
9 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
10 | ESPP_CONTRIB_DT | Date(10) | DATE NOT NULL |
Gather Contributions Date
Default Value: %Date |
11 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
12 | ESPP_CONTRIB_AMT | Signed Number(17,6) | DECIMAL(15,6) NOT NULL | Contribution Amount |
13 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL |
From Currency Code
Prompt Table: CURRENCY_CD_TBL |
14 | ESPP_CONTRIB_STS | Character(1) | VARCHAR2(1) NOT NULL |
Contribution Status
N=New Contribution P=Processed Contribution R=Refunded V=Reversed Default Value: N |
15 | ESPP_REFUND_STS | Character(1) | VARCHAR2(1) NOT NULL |
Refund Status
P=Processed R=Refunded U=UnProcessed V=Reversed Default Value: N |
16 | ESPP_MANUAL_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Manual Source
C=ESPP - Carry Forward D=Data Entry I=Import R=ESPP - Refund |
17 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %Date |
18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
19 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |
20 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
21 | ST_IMPORT_NBR | Number(3,0) | SMALLINT NOT NULL | Import Number |
22 | ST_IMPORT_DT | Date(10) | DATE | Import Date |