ERNCDEFFDTDefault Value: %date
GVT_EARN_PROC_TYPEBP=Danger Pay
CA=Pay Limit - Total Annual
CB=Pay Cap - Basic Pay
CP=Pay Limit - Premium Pay
OT=Overtime
GVT_EARN_LIMITS(SQL Table) |
Index Back |
|---|---|
Pay LimitsUsed in deriving Pay Limits |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GVT_EARN_PROC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Earning Process Type
BP=Danger Pay CA=Pay Limit - Total Annual CB=Pay Cap - Basic Pay CP=Pay Limit - Premium Pay OT=Overtime |