PY_AUDITS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROGRAM_SRC	Character(8)	VARCHAR2(8) NOT NULL	Audit report program source.
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	PAY_END_DT	Date(10)	DATE	Pay Period End Date
5	MESSAGE_ID	Character(30)	VARCHAR2(30) NOT NULL	Message ID
6	AUDIT_SEQNUM	Number(5,0)	INTEGER NOT NULL	WorkCenter audit report sequence number.
7	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
8	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
9	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
10	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line Nbr
11	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
12	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year
13	BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Balances for Period
14	MSGDATA1	Character(30)	VARCHAR2(30) NOT NULL	Message Data
15	MSGDATA2	Character(30)	VARCHAR2(30) NOT NULL	Message Data
16	MSGDATA3	Character(30)	VARCHAR2(30) NOT NULL	Message Data
17	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
20	EMPL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Employee Name
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
23	OK_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	Okay to pay indicator.
24	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
25	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
26	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
27	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code
28	INDUSTRY_SECTOR	Character(4)	VARCHAR2(4) NOT NULL	Industry Sector CORE=Core PBSC=Public Sector USFG=US Federal Government