GVT_SCHED_EXHST (SQL Table)	Index Back
Schedule Extract History Schedule Extract History

GVT_SCHED_EXHST

(SQL Table)

Schedule Extract History

# 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_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.

4 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

5 GVT_REPORTING_CD Character(2) VARCHAR2(2) NOT NULL Reporting Code

6 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

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 GVT_TASBETC_ADJSEQ Number(3,0) SMALLINT NOT NULL TAS BETC Adjustment Sequence

10 GVT_ADJ_TAS_GWA Character(26) VARCHAR2(26) NOT NULL New GWA TAS String

11 GVT_ADJ_BETC_CD Character(8) VARCHAR2(8) NOT NULL New Business Event Type Code

12 GVT_TOTAL_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Schedule Amount

13 GVT_ADJ_NOTE Character(90) VARCHAR2(90) NOT NULL TAS BETC Adjustment Note

#	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_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.
4	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
5	GVT_REPORTING_CD	Character(2)	VARCHAR2(2) NOT NULL	Reporting Code
6	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
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	GVT_TASBETC_ADJSEQ	Number(3,0)	SMALLINT NOT NULL	TAS BETC Adjustment Sequence
10	GVT_ADJ_TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	New GWA TAS String
11	GVT_ADJ_BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	New Business Event Type Code
12	GVT_TOTAL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Schedule Amount
13	GVT_ADJ_NOTE	Character(90)	VARCHAR2(90) NOT NULL	TAS BETC Adjustment Note