| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GVT_ERN_ACCR_CLASS |
Character(6) |
VARCHAR2(6) NOT NULL |
Earnings Accrual Class
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
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
Default Value: AN
|
| 7 |
GVT_ADJ_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustments Allowed
Y/N Table Edit
Default Value: Y
|
| 8 |
ACCRUAL_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrual Rate Units
H=Hours per Hour
M=Hours per Month
P=Hours per Pay Period
W=Hours per Week
Y=Hours per Year
Default Value: P
|
| 9 |
GVT_ACCR_YEAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of designated year.
C=Calendar
F=Fiscal
L=Leave
P=Pay
Default Value: C
|
| 10 |
GVT_ACCR_PAY_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrual Pay Period
1=First
2=Second
3=Third
4=Fourth
5=Fifth
Default Value: 1
|
| 11 |
SERVICE_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Units
H=Hours
M=Months
P=Pay Period
Y=Years
Default Value: H
|
| 12 |
GVT_EFF_RATE_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Rate
C=Current Rate
P=Current Rate Percent
R=Rate Earned
Default Value: C
|
| 13 |
GVT_EFF_PAY_PER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Effective Rate of Pay Percent
|
| 14 |
HRS_GO_NEGATIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrued Balance Go Negative
Y/N Table Edit
Default Value: Y
|
| 15 |
GVT_CHK_NONPAY_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Non-pay Hours
Y/N Table Edit
Default Value: N
|
| 16 |
SPECIAL_CALCULATN |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Calculation Routine
Y/N Table Edit
Default Value: N
|
| 17 |
YEAR_BEGIN_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Calc at Year Begin
Y/N Table Edit
Default Value: N
|
| 18 |
GVT_EXP_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Expiration Disposition
C=Convert to Other
F=Forfeit
P=Convert to Pay
Default Value: P
|
| 19 |
GVT_ERNCD_EXPIRE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Expiration Indicator
Y/N Table Edit
Default Value: N
|
| 20 |
GVT_EXP_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Expiration Interval
H=Hours
M=Months
P=Pay Period
Y=Years
Default Value: H
|
| 21 |
GVT_EXP_INTERVALS |
Number(5,0) |
INTEGER NOT NULL |
Expiration Intervals
|
| 22 |
GVT_EXP_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Expiration Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 23 |
GVT_EOY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
End of Year Indicator
Y/N Table Edit
Default Value: N
|
| 24 |
GVT_RLV_INTERVAL |
Number(3,0) |
SMALLINT NOT NULL |
Months Until Expiration
|
| 25 |
GVT_CEILING_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling Set Indicator
Y/N Table Edit
Default Value: N
|
| 26 |
GVT_MAX_CEILING |
Number(5,0) |
INTEGER NOT NULL |
Maximum Ceiling
|
| 27 |
GVT_CEIL_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling Interval
H=Hours
M=Months
P=Pay Period
Y=Years
Default Value: H
|
| 28 |
GVT_CEIL_YEAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of designated year.
C=Calendar
F=Fiscal
L=Leave
P=Pay
Default Value: C
|
| 29 |
GVT_CEIL_PAY_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling Pay Period
1=First
2=Second
3=Third
4=Fourth
5=Fifth
Default Value: 1
|
| 30 |
GVT_CEIL_INTERVALS |
Number(5,0) |
INTEGER NOT NULL |
Ceiling Intervals
|
| 31 |
GVT_CEILING_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling Disposition
A=Allowed to Exceed
F=Forfeit
O=Convert to Other
P=Convert to Pay
U=Use or Lose
Default Value: P
|
| 32 |
GVT_CEILING_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Ceiling Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 33 |
GVT_MAX_CARRYOVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Max Carryover Indicator
Y/N Table Edit
Default Value: N
|
| 34 |
MAXIMUM_CARRYOVER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Max Leave Carryover
|
| 35 |
GVT_COORD_WITH_GF |
Character(1) |
VARCHAR2(1) NOT NULL |
Coordinate with Grandfather
Y/N Table Edit
Default Value: N
|
| 36 |
GVT_COVR_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Carryover Disposition
A=Allow to Exceed
F=Forfeit
O=Convert to Other
P=Convert to Pay
U=Use or Lose
Default Value: P
|
| 37 |
GVT_COVR_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Carryover Interval
H=Hours
M=Months
P=Pay Period
Y=Years
Default Value: H
|
| 38 |
GVT_COVR_YEAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of designated year.
C=Calendar
F=Fiscal
L=Leave
P=Pay
Default Value: C
|
| 39 |
GVT_COVR_PAY_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Carryover Pay Period to process
1=First
2=Second
3=Third
4=Fourth
5=Fifth
Default Value: 1
|
| 40 |
GVT_COVR_INTERVALS |
Number(5,0) |
INTEGER NOT NULL |
Carryover Intervals
|
| 41 |
GVT_MAX_COVR_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Carryover Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 42 |
PAY_TERM_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Pay at Termination Percent
|
| 43 |
GVT_PAY_TERM_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Termination Disposition
F=Forfeit
P=Convert to Pay
Default Value: P
|
| 44 |
GVT_PAY_TERM_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Termination Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 45 |
GVT_USE_OLD_FIRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Old First
Y/N Table Edit
Default Value: Y
|
| 46 |
GVT_TRK_NONPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Nonpay Hours Flag
Y/N Table Edit
Default Value: N
|
| 47 |
GVT_ANN_ENTITLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Entitlement
Y/N Table Edit
|