HRS_AWARD_PUB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
4	AWARD_DATE	Date(10)	DATE	Award Date
5	EX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Expense Line #
6	MONETARY_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Monetary Amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
11	SEPCHK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Separate check flag.
12	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
13	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
14	CHECK_DT	Date(10)	DATE	Check date.
15	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
18	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
19	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
20	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id