BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
1=One Month
2=Three Months
3=Six Months
4=One Year
5=From Specific Date
Default Value: 2
1=Average
2=Weighted Average
Default Value: 1
HIST_LD_SET_INV(SQL Table) |
Index Back |
|---|---|
Hist Lead Calc Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | CALC_TIME_FRAME | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Time Frame
1=One Month 2=Three Months 3=Six Months 4=One Year 5=From Specific Date Default Value: 2 |
| 3 | HIST_DATE | Date(10) | DATE | Hist Lead Start Date |
| 4 | CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Method
1=Average 2=Weighted Average Default Value: 1 |
| 5 | NUM_PERIODS | Number(2,0) | SMALLINT NOT NULL | Number of Time Periods |