FC_HORIZON_VW(SQL View) |
Index Back |
|---|---|
FC Forecast Horizons |
| SELECT business_unit_gl ,begin_dt ,end_dt ,status FROM PS_FC_CTRL_TBL WHERE period = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 3 | END_DT | Date(10) | DATE | End Date |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |