PAY_ACKNOWLEDGE

(SQL Table)
 Index Back

Pay Acknowledge Messsage

Message definition which contains payments published to Expenses for acknowledgment.

# 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 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID
4 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type
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 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
10 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
11 ACCEPTANCE_STATUS Character(1) VARCHAR2(1) NOT NULL Acceptance Status
R=Rejected
T=Taken
12 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
13 DATE_ACKNOWLEDGE DateTime(26) TIMESTAMP Date Acknowledge