TL_OT_IDEFFDTTL_MONTH_LIMITTL_OT_MONTH_TBL(SQL Table) |
Index Back |
|---|---|
Overtime Limit ID - Month |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TL_OT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Overtime Limit ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | TL_MONTH_LIMIT |
Number(4,0) | SMALLINT NOT NULL | Number of Months |
| 4 | TL_OT_HOURS_LIMIT | Number(4,0) | SMALLINT NOT NULL | Overtime Hours |