ST_PARTIC_VW(SQL View) |
Index Back |
---|---|
Purch Pd/Manual Contrib VwUnion of the purchase period participation records and the manual contributions which have been entered for people for which there are no participation rows. |
SELECT DISTINCT B.OPRID , A.EMPLID , A.EMPL_RCD , A.STOCK_ID , A.STOCK_PLAN_TYPE , A.STOCK_PLAN , A.OFFERING_ID , A.PERIOD_END_DT , B.NAME FROM PS_ST_PURCH_PARTIC A , PS_PERS_SRCH_ST_PR B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
5 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan |
6 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: STOCK_PLAN_TBL |
7 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table: ST_OFFERING_PD |
8 | PERIOD_END_DT | Date(10) | DATE |
Period End Date
Prompt Table: ST_PURCHASE_PD |
9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |