GVT_PAM_VEN_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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.
3	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
4	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.
5	GVT_PYMNT_SEQ	Number(6,0)	INTEGER NOT NULL	Payment Sequence
6	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
7	GVT_TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	TAS GWA
8	GVT_BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	Business Event Type Code
9	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
10	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.
11	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
12	GVT_DED_DIST_CD	Character(10)	VARCHAR2(10) NOT NULL	Deduction Distribution Code
13	GVT_REPORTING_CD	Character(2)	VARCHAR2(2) NOT NULL	Reporting Code
14	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
15	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
16	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
17	PAY_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Pay Frequency A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly
18	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnishment id.
19	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
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
21	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
22	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class
23	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
24	ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Account Number
25	ACCOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Account Type $=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense
26	GVT_CR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Credit Remit Amount
27	GVT_DR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Debit Remit Amount
28	GVT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Amount
29	PY_FED_BKACCCRYPT	Character(100)	VARCHAR2(100) NOT NULL	Encrypted Bank Account