GVT_ACCR_SUMM(SQL Table) |
Index Back |
|---|---|
Accrual Summarry Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GVT_ERN_ACCR_CLASS |
Character(6) | VARCHAR2(6) NOT NULL | Earnings Accrual Class |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | GVT_EARN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Leave Type
AN=Annual BM=Bone Mar/Organ Donor CO=Compensatory Time CR=Credit Time DA=Deferred Annual DS=Deferred Sick FM=FMLA HO=Home LP=Leave Program LW=LWOP MA=Military (15 R) MB=Military (22 LE) MC=Military (44 MT) NP=Non-Pay RC=Religious Comp Time RE=Restored SH=Shore SI=Sick TO=Time-Off Award |
| 6 | HRS_CARRYOVER | Signed Number(13,6) | DECIMAL(11,6) NOT NULL | Hours Carried Over-Prev Year |
| 7 | GVT_SERVICE_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | YTD Service Hours |
| 8 | HRS_EARNED_YTD | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Hours Earned Year-to-Date |
| 9 | HRS_TAKEN_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Taken Year-to-Date |
| 10 | HRS_ADJUST_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Adjusted Year-to-Date |
| 11 | HRS_BOUGHT_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Bought Year-to-Date |
| 12 | HRS_SOLD_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Sold Year-to-Date |
| 13 | GVT_NONPAY_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Non-Pay YTD |
| 14 | GVT_CR_REDUC_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | YTD Credit Reduction Hours |
| 15 | GVT_FORFEIT_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | YTD Forfeit Hours |
| 16 | GVT_MUSTUSE_YTD | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | YTD Mustuse or Lose Hours |
| 17 | MAXIMUM_CARRYOVER | Number(9,3) | DECIMAL(8,3) NOT NULL | Max Leave Carryover |
| 18 | GVT_GFATH_CYOVER | Number(9,3) | DECIMAL(8,3) NOT NULL | Grandfathered Carryover |
| 19 | GVT_SVC_HRS_REMAIN | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Unprocessed Service Hours |
| 20 | GVT_R_HRS_1 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Restored Hours Balance |
| 21 | GVT_R_HRS_TAK_1 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Restored Hours Taken |
| 22 | GVT_R_EXPIRE_DT_1 | Date(10) | DATE | Expiration Date |
| 23 | GVT_R_HRS_2 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | |
| 24 | GVT_R_HRS_TAK_2 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | |
| 25 | GVT_R_EXPIRE_DT_2 | Date(10) | DATE | |
| 26 | GVT_R_HRS_3 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | |
| 27 | GVT_R_HRS_TAK_3 | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | |
| 28 | GVT_R_EXPIRE_DT_3 | Date(10) | DATE | |
| 29 | GVT_ADJ_APPLIED | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Applied
Y/N Table Edit Default Value: N |
| 30 | GVT_AUDITED | Character(1) | VARCHAR2(1) NOT NULL | Audited |
| 31 | GVT_HRS_BAL | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Balance |
| 32 | GVT_USE_OR_LOSE | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Max Carryover Excess |
| 33 | GVT_ANN_HRS_BAL | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Projected Annual Hours Bal |
| 34 | GVT_NEXT_HRS_BAL | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Projected Next Period Hrs Bal |