STOCK_IDPrompt Table: STOCK_TBL
STOCK_CLASS_TYPEC=Common Shares
P=Preferred Shares
W=Warrants
STOCK_CLASSDefault Value: STOCK_CLASS_TBL.DESCR
STOCK_CLASS_TBL(SQL Table) |
Index Back |
|---|---|
Stock ClassThe Stock Class record defines various classes of equity securities. The Stock Class record is a child record of STOCK_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
| 2 | STOCK_CLASS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Stock Class Type
C=Common Shares P=Preferred Shares W=Warrants |
| 3 | STOCK_CLASS |
Character(10) | VARCHAR2(10) NOT NULL | Stock Class ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: STOCK_CLASS_TBL.DESCR |
| 6 | APPRVL_DT | Date(10) | DATE | Approval Date |