EARNINGS_ACCRL(SQL Table) |
Index Back |
|---|---|
Ern Code Effect On AccrualsThis record stores the effect of an earnings type on leave accruals. |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 3 | PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 4 | HRS_TAKEN_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Hours Taken
Y/N Table Edit Default Value: N |
| 5 | SERVICE_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Service Hours
Y/N Table Edit Default Value: N |
| 6 | ADJUST_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Adjust Hours
Y/N Table Edit Default Value: N |
| 7 | BOUGHT_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Hours Bought
Y/N Table Edit Default Value: N |
| 8 | SOLD_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Hours Sold
Y/N Table Edit Default Value: N |
| 9 | GVT_R_ADJ_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Restored Hours Adjust
Y/N Table Edit Default Value: N |
| 10 | GVT_R_TAK_HRS_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add to Restored Hours Taken
Y/N Table Edit Default Value: N |