GPVC_RQT_SUB (SQL Table)	Index Back
VC Request Staging Table Staging (subscription) table which contains award request which have been published by Variable Compensation. This table is populated using subscription PeopleCode attached to Message GP_VC_PAYMENT_REQUEST.

GPVC_RQT_SUB

(SQL Table)

VC Request Staging Table

Staging (subscription) table which contains award request which have been published by Variable Compensation. This table is populated using subscription PeopleCode attached to Message GP_VC_PAYMENT_REQUEST.

# 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 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 PRD_BGN_DT Date(10) DATE Period Begin Date

11 PRD_END_DT Date(10) DATE Pay Period End Date

12 PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Pin Number Earning

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

14 SEPCHK_FLAG Character(1) VARCHAR2(1) NOT NULL Separate check flag.
Y/N Table Edit
Default Value: N

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 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 Rcd Nbr
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	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
11	PRD_END_DT	Date(10)	DATE	Pay Period End Date
12	PIN_ERN_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number Earning
13	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
14	SEPCHK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Separate check flag. Y/N Table Edit Default Value: N
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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance