GVT_PAM_SAL_WRK

#	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	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
8	GVT_DIST_SEQ	Number(3,0)	SMALLINT NOT NULL	Distribute Sequence
9	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
10	GVT_TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	TAS GWA
11	GVT_BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	Business Event Type Code
12	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
13	ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Account Number
14	ACCOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Account Type $=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense
15	GVT_CR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Credit Remit Amount
16	GVT_DR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Debit Remit Amount
17	GVT_FOREIGN_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Foreign Address Indicator
18	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.
19	PY_FED_BKACCCRYPT	Character(100)	VARCHAR2(100) NOT NULL	Encrypted Bank Account