ST_DAILY_PRICES(SQL Table) |
Index Back |
|---|---|
Daily Prices TableData Entry Panel for Stock Prices |
| # | 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 | ST_FMV_DT |
Date(10) | DATE NOT NULL | Fair Market Value Date |
| 3 | ST_DAY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Stock Day Type
HOL=Holiday SAT=Saturday SUN=Sunday TRD=Trading Day Default Value: TRD |
| 4 | ST_TRADING_DAY | Character(3) | VARCHAR2(3) NOT NULL |
Trading Day
FRI=Friday HOL=Holiday MON=Monday SAT=Saturday SUN=Sunday THU=Thursday TUE=Tuesday WED=Wednesday |
| 5 | BID_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Bid Price
Default Value: 0 |
| 6 | ASK_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Ask Price
Default Value: 0 |
| 7 | OPEN_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Open Price
Default Value: 0 |
| 8 | CLOSE_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Close Price
Default Value: 0 |
| 9 | LOW_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Low Price
Default Value: 0 |
| 10 | HIGH_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
High Price
Default Value: 0 |
| 11 | PRIVATE_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL |
Private Price
Default Value: 0 |
| 12 | STOCK_VOLUME | Number(10,0) | DECIMAL(10) NOT NULL |
Stock Volume
Default Value: 0 |