GP_NRP_VCAWD_VW

(SQL View)
 Index Back

Variable Comp Awards - NRP Vw

This record is used to transfer VC_AWARD records from one database to another through the use of a non rule packager.

SELECT EMPLID ,EMPL_RCD ,VC_PLAN_ID ,VC_PAYOUT_PRD_ID ,GB_GROUP_ID ,VC_TARGET_VALUE ,VC_CALC_AWARD ,VC_ADJ_AWARD ,VC_PERF_FACTOR ,VC_MODIFIEr ,VC_ACTUAL_AWD_AMT ,VC_ACTUAL_AWD_UNIT ,VC_AWARD_VALUE ,VC_ORIG_AWD_UNIT ,VC_ORIG_AWD_VALUE ,CURRENCY_CD ,VC_AWARD_DT ,VC_AWARD_STATUS ,VC_CARRYOVER_ACCUM ,VC_CARRYOVER_BAL ,VC_CALC_SOURCE ,GRANT_NBR ,ST_PR_DT ,ERNCD ,GROSSUP ,SEPCHK_FLAG ,REJECTED_REASON ,PIN_ERN_NUM + 50000000 FROM PS_VC_AWARD

# 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

Prompt Table: VC_PLAN_TBL

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

Prompt Table: VC_PAYPRD_TBL

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

Prompt Table: GB_GROUP_TBL

6 VC_TARGET_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Target Value
7 VC_CALC_AWARD Number(19,6) DECIMAL(18,6) NOT NULL Calculated Award
8 VC_ADJ_AWARD Number(19,6) DECIMAL(18,6) NOT NULL Adjusted Award
9 VC_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Performance Factor
10 VC_MODIFIER Number(6,2) DECIMAL(5,2) NOT NULL Modifier (%)
11 VC_ACTUAL_AWD_AMT Number(19,6) DECIMAL(18,6) NOT NULL Actual Award as amount
12 VC_ACTUAL_AWD_UNIT Number(15,6) DECIMAL(14,6) NOT NULL Actual Award
13 VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value
14 VC_ORIG_AWD_UNIT Number(15,6) DECIMAL(14,6) NOT NULL Original Award (Units)
15 VC_ORIG_AWD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Original Award Value
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: VC_PLAN_TBL.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

17 VC_AWARD_DT Date(10) DATE Award Date
18 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

Default Value: I

Prompt Table: %RECNAME_EDIT

19 VC_CARRYOVER_ACCUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulated Carryover
20 VC_CARRYOVER_BAL Number(19,6) DECIMAL(18,6) NOT NULL Carryover Balance
21 VC_CALC_SOURCE Character(2) VARCHAR2(2) NOT NULL Calculation Source
M=Manual Calculation
N=System - Minimum
S=System Calculated
X=System - Maximum
22 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
23 ST_PR_DT Date(10) DATE This field is the date that a transaction was sent to payroll.
24 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: EARNINGS_TBL

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

27 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
28 PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Pin Number Earning

Prompt Table: GP_ERN_SRCH