R_PAYGL1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
2	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
3	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
4	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
5	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
6	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
7	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
8	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
9	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
10	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
11	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
12	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: JOB.BUSINESS_UNIT
14	SETID_HR	Character(5)	VARCHAR2(5) NOT NULL	SetID - HR
15	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
16	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Expense Doc ID
21	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Expense Doc Type
22	EX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Expense Line #
23	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
24	CHECK_DT	Date(10)	DATE	Check date.
25	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check