ST_BLACKOUT_TBL(SQL Table) |
Index Back |
|---|---|
Stock BlackoutThe Stock Blackout record defines blackout periods for each stock when company insiders are unable to buy or sell company stock. The Stock Blackout 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 |
Stock ID
Prompt Table: STOCK_TBL |
| 2 | BLACKOUT_BEGIN_DT |
Date(10) | DATE NOT NULL |
Start Date
Default Value: %date |
| 3 | BLACKOUT_END_DT |
Date(10) | DATE NOT NULL | Blackout End Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | BLACKOUT_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Stock Blackout All
Y/N Table Edit Default Value: N |
| 6 | COMPANY_INSIDER | Character(1) | VARCHAR2(1) NOT NULL |
Company Insider
Y/N Table Edit Default Value: N |
| 7 | REPORTING_PERSON | Character(1) | VARCHAR2(1) NOT NULL |
Reporting Person
Y/N Table Edit Default Value: N |
| 8 | ST_DIRECTOR | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Director
Y/N Table Edit Default Value: N |
| 9 | ST_OFFICER | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Officer
Y/N Table Edit Default Value: N |
| 10 | ST_BEN_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Beneficial Owner
Y/N Table Edit Default Value: N |