SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
B=Biweekly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 7
Default Value: Y
BUS_UNIT_OPT_FC(SQL Table) |
Index Back |
|---|---|
FC Forecasting Business UnitsForecasting Business Unit Setup for Forecasting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | FORECAST_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Frequency
B=Biweekly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 3 | FORECAST_HORIZON | Number(3,0) | SMALLINT NOT NULL | Forecast Horizon |
| 4 | END_DAY_OF_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 7 |
| 5 | CHANGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No indicator
Default Value: Y |