PROCESS_INSTANCEE=Purchase Plan
O=Option Plan
B=Broker
C=Certificate
B=Broker
C=Certificate
ST_ISSUUPD_AET(SQL Table) |
Index Back |
|---|---|
State Table For ESPP_ISUUPDState Table For ESPP_ISUUPD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 6 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan |
| 7 | EFFDT | Date(10) | DATE | Effective Date |
| 8 | ASOFDATE | Date(10) | DATE | As of Date |
| 9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 10 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 11 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 12 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 13 | ISSUANCE_TYPE_FROM | Character(1) | VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker C=Certificate |
| 14 | ISSUANCE_TYPE_TO | Character(1) | VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker C=Certificate |
| 15 | ST_BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | Branch Identification |
| 16 | ST_BRANCH_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Branch ID |
| 17 | ST_BROKERAGE_ID | Character(10) | VARCHAR2(10) NOT NULL | Brokerage ID |
| 18 | ST_BROKERAGE_ID_TO | Character(10) | VARCHAR2(10) NOT NULL | Brokerage ID |
| 19 | INITIAL_ISSUANCE | Character(1) | VARCHAR2(1) NOT NULL | Initial Issuance |
| 20 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 21 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 22 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 23 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 24 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 25 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 26 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 27 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 28 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 29 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 30 | REGISTRATION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Registration Name |
| 31 | ST_ACCOUNT_NBR | Character(17) | VARCHAR2(17) NOT NULL | This field contains the account number to use when issuing the shares. |
| 32 | ESPP_QUICK_SALES | Character(1) | VARCHAR2(1) NOT NULL | Quick Sales Allowed |
| 33 | LEGEND_ID | Character(10) | VARCHAR2(10) NOT NULL | This field indicates what issuance instructions are to be sent to the broker. |
| 34 | ST_KEEP_ACCNT_NBR | Character(1) | VARCHAR2(1) NOT NULL | Used as a flag. |
| 35 | SQL_ID | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 36 | SQL_ID1 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 37 | SQL_ID2 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 38 | SQL_ID3 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 39 | SQL_ID4 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 40 | SQL_ID5 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 41 | SQL_ID6 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 42 | SQL_ID7 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 43 | SQL_ID8 | Character(30) | VARCHAR2(30) NOT NULL | TL |