DEFINITION_NAMESUB_ADJUSTMENTARITH_SEQPA_DFN_AGE_TBL(SQL Table) |
Index Back |
|---|---|
Early/Late AdjustmentsThis is a setup table containing Early/Late Adjustment parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | SUB_ADJUSTMENT |
Character(10) | VARCHAR2(10) NOT NULL | Subadjustment |
| 3 | ARITH_SEQ |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Order for Processing |
| 5 | PERIOD_PCT | Number(10,6) | DECIMAL(9,6) NOT NULL | Percent per Period |
| 6 | FRACTION1 | Number(3,0) | SMALLINT NOT NULL | Fraction per Period |
| 7 | FRACTION2 | Number(3,0) | SMALLINT NOT NULL | Denominator |
| 8 | PERIODS | Number(3,0) | SMALLINT NOT NULL | over Periods |