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