PYER_ACKNOWLEDG

#	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	EX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Expense Line #
5	AWARD_DATE	Date(10)	DATE NOT NULL	Award Date
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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
13	SEPCHK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Separate check flag.
14	ACCEPTANCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Acceptance Status R=Rejected T=Taken
15	REJECTED_REASON	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the reason for rejecting a PI record from Variable Compensation. 01=Invalid Earning Code 02=Invalid Employee ID & Record# 03=Invalid Currency Code 04=Problem in loading to file 05=Transaction already exists 06=Amount Exceeds Payroll Maximum 07=Reject All - Requested by User 08=Cal closed. Retro not allowed. 09=Error populating Gen PI. 10=Error populating VC Plan tbl 11=Error Updating GPVC_ACK_PUB 12=Deleted from GP PI. 13=Invalid Pin Num 14=Calendar Finalized. 15=Negative Amount 99=Expenses Sheet in Error
16	DATE_ACKNOWLEDGE	DateTime(26)	TIMESTAMP	Date Acknowledge