PYVC_ACK_PUB (SQL Table)	Index Back
PY Acknowledge Staging Table Staging table which contains award acknowledgements published from North American Payroll to Variable Compensation.

PYVC_ACK_PUB

(SQL Table)

PY Acknowledge Staging Table

Staging table which contains award acknowledgements published from North American Payroll to Variable Compensation.

# 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 Record

3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

4 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

6 VC_AWARD_STATUS Character(2) VARCHAR2(2) NOT NULL Award Status
A=Approved
C=Cancelled
D=Ready to Submit
E=Error
I=Initial Calculation
J=Rejected
P=Paid/Granted
R=Recommended
S=Submitted
T=Accepted

7 VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

9 VC_AWARD_DT Date(10) DATE Award Date

10 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

11 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up

12 SEPCHK_FLAG Character(1) VARCHAR2(1) NOT NULL Separate check flag.

13 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

14 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

15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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 Record
3	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
4	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
5	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
6	VC_AWARD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Award Status A=Approved C=Cancelled D=Ready to Submit E=Error I=Initial Calculation J=Rejected P=Paid/Granted R=Recommended S=Submitted T=Accepted
7	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	VC_AWARD_DT	Date(10)	DATE	Award Date
10	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
11	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
12	SEPCHK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Separate check flag.
13	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
14	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
15	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance