STOCK_IDPrompt Table: STOCK_TBL
FISCAL_YEARSTOCK_FISCAL_YR(SQL Table) |
Index Back |
|---|---|
Stock Fiscal Year tableContains the fiscal year, fiscal year from, and fiscal year to dates |
| # | 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 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 3 | FISCAL_BEGIN_DT | Date(10) | DATE NOT NULL | Fiscal Begin Date |
| 4 | FISCAL_END_DT | Date(10) | DATE NOT NULL | Fiscal End Date |