ST_CLASS_ALLOC(SQL Table) |
Index Back |
|---|---|
Stock Class AllocationThe Stock Class Allocation record contains a history of shares that have been allocated and adjusted to stock classes. The Stock Class Allocation record is an effective dated child record of STOCK_CLASS_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
Default Value: STOCK_PLAN_TBL.STOCK_ID 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 | ALLOCATION_DT |
Date(10) | DATE NOT NULL |
Allocation Date
Default Value: %date |
| 5 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | ST_TREASURY_ID | Character(10) | VARCHAR2(10) NOT NULL |
Treasury ID
Prompt Table: STOCK_TREASURY |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | ST_ALLOCATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Allocation Type
A=Adjustment B=Board Approved H=Shareholder Approved I=Initial Allocation S=Stock Split |
| 9 | SHARES_ALLOCATED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shares Allocated |
| 10 | APPRVL_DT | Date(10) | DATE |
Approval Date
Default Value: %date |
| 11 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | COMMENTS | Long Character | CLOB | Comment |