GVT_PAM_SAL_DTL

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