| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GVT_SCHED_PREFIX |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
|
| 2 |
GVT_SCHED_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
A=PAMSALCHK
B=PAMSALEFT
C=PAMMISCHK
D=PAMMISEFT
|
| 3 |
GVT_CHECK_REF_NO |
Number(4,0) |
SMALLINT NOT NULL |
Paycheck Reference Number
|
| 4 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 5 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
|
| 6 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 7 |
GVT_SCHED_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identify the record type - D (Deduction), E (Earning), G (Garnishment) or T (Tax)
D=Deduction
E=Earning
G=Garnishment
T=Tax
|
| 8 |
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.
|
| 9 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 10 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 11 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 12 |
TAX_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Balance Class
|
| 13 |
GARNID |
Character(6) |
VARCHAR2(6) NOT NULL |
Garnishment id.
|
| 14 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 15 |
GARN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Type
A=Wage Assignment
B=Chapter 13 Bankruptcy
C=Child Support
D=Dependent Support
E=Social Security (AWG)
L=Tax Levy
S=Spousal Support
T=Student Loan Repayment
W=Writ of Garnishment
|
| 16 |
GVT_DED_DIST_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Deduction Distribution Code
|
| 17 |
GVT_REPORTING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reporting Code
|
| 18 |
GVT_PYMNT_RTNG |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT Payment Routing Code
D=Route on Distribution Code
E=Route on Employee Level
N=No External Routing Required
|
| 19 |
GVT_PYMNT_SUMM |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT Payment Summary Code
D=By Distribution Code
E=By Employee Level
N=No Summary - Ded Level Only
|
| 20 |
REMIT_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by the Federal Government to establish the frequency that a deduction will be remitted (per month).
B=Biweekly
M=Monthly
|
| 21 |
PAY_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
|
| 22 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 23 |
GVT_TAS_GWA |
Character(26) |
VARCHAR2(26) NOT NULL |
TAS GWA
|
| 24 |
GVT_BETC_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Business Event Type Code
|
| 25 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 26 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 27 |
ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
|
| 28 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 29 |
GVT_CR_REMIT_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Credit Remit Amount
|
| 30 |
GVT_DR_REMIT_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Debit Remit Amount
|
| 31 |
GVT_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Amount
|
| 32 |
GVT_SCHED_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Sequence represents last part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. Schedule may have multiple schedule sequences in case there is a schedule split due to processing requirements such as max TAS BETC amount or max number of TAS BETC per schedule.
|
| 33 |
PY_FED_BKACCCRYPT |
Character(100) |
VARCHAR2(100) NOT NULL |
Encrypted Bank Account
|