EFFDTTL_SEQ_NUMPA_TL_EARLY_TBL(SQL Table) |
Index Back |
|---|---|
User Table for PensionThis is a demo user table for Pension. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE | Effective Date |
| 2 | TL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Table Lookup Sequence Number |
| 3 | MHABCD_DD | Number(6,1) | DECIMAL(5,1) NOT NULL | LOOKUP VALUE |
| 4 | EARLY_ADJ_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | EARLY PERCENT |