PY_KB_US_CAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	PY_CAT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Category Type D=Deductions E=Earnings O=Other Earnings T=Taxes V=Overtime
9	PY_CAT_ID	Character(6)	VARCHAR2(6) NOT NULL	Category ID
10	CHECK_DT	Date(10)	DATE	Check date.
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	PY_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	PY_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Employee Record
15	PY_EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
16	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
17	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
18	PY_CAT_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category Type Description
19	PY_CAT_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category ID Description
20	PY_TOT_CAT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Total by Category
21	PY_COMPANY_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Company description
22	PY_PAYGROUP_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Paygroup Description
23	PY_BUS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Business Unit description
24	PY_DEPT_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Department description
25	PY_STATE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	State Description