INCENTIVE_IDMSTONE_SEQDefault Value: 1
MSTONE_TYPEA=Amount
D=Date
P=Percent
Default Value: PC_GNT.CURRENCY_CD
S=Eligible Resources
T=Incentive Resources
A=Incentive Authorization
F=Project Funding
Default Value: /
PC_GNT_SCHED2(SQL Table) |
Index Back |
|---|---|
Investment Incentve MilestonesUsed to enter milestone information for Investment Incentives. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCENTIVE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Investment Incentive ID |
| 2 | MSTONE_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Milestone Sequence
Default Value: 1 |
| 3 | MSTONE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Milestone Type
A=Amount D=Date P=Percent |
| 4 | LABEL_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PC_GNT.CURRENCY_CD |
| 7 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 8 | MILESTONE_DATE | Date(10) | DATE | Milestone Date |
| 9 | NUMERATOR | Character(1) | VARCHAR2(1) NOT NULL |
Numerator
S=Eligible Resources T=Incentive Resources |
| 10 | DIVISOR | Character(1) | VARCHAR2(1) NOT NULL |
Divisor
A=Incentive Authorization F=Project Funding |
| 11 | DIVISION_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
Division Field
Default Value: / |