FT_VCAWD_STG_VW

(SQL View)
 Index Back

Variable Comp STG Table

This record stores all Variable Compensation awards for an employee. This is the record that serves as input to NA Payroll and Stock Administration for integration purposes, as well as the source record when VC awards are published for any 3rd-party subscriber. This table will be used for Fusion CWB Integration

SELECT FT_RUN_ID , PROCESS_INSTANCE , FT_EL_ENTR_VL_GUID , FT_EFF_START_DATE , FT_EFF_END_DATE , FT_EFF_SEQUENCE , FT_EL_ENTR_GUID , FT_EL_TYPE_GUID , FT_PERSON_GUID , FT_FUSION_ENT_GUID , FT_FUSION_VL_GUID , FT_FUSION_EU_GUID , FT_ASSIGNMENT_GUID , VC_PLAN_ID , VC_PAYOUT_PRD_ID , GB_GROUP_ID , EMPLID , EMPL_RCD , EFFDT , EFFSEQ , FT_WT_EFFDT_PSFMT , FT_WT_EFFSEQ , AS_OF_DATE , VC_ELIG_STATUS , CURRENCY_CD , FT_CURRENCY_CODE , VC_MODIFIER , VC_AWARD_VALUE , FT_VC_AWARD_VALUE , VC_AWARD_DT , FT_EARNED_DATE , FT_DATE_FROM , VC_AWARD_STATUS , VC_CALC_SOURCE , ERNCD , PIN_ERN_NUM + 50000000 , SETID_JOBCODE , JOBCODE , COMPANY , FT_VALUE_CHANGED , FT_RUN_PROC_STATUS , FT_PROC_STATUS , FT_PROC_MARKER , FT_ERROR_FLAG , FT_BYPASS_FLAG , FT_ALTERNATE_REC , FT_ALTERNATE_KEY , LASTUPDDTTM , LASTUPDOPRID FROM PS_FT_VC_AWARD_STG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 FT_EL_ENTR_VL_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry Value Guid
4 FT_EFF_START_DATE Date(10) DATE Effective Start Date
5 FT_EFF_END_DATE Date(10) DATE Effective End Date
6 FT_EFF_SEQUENCE Number(4,0) SMALLINT NOT NULL Effective Sequence
7 FT_EL_ENTR_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry GUID
8 FT_EL_TYPE_GUID Character(36) VARCHAR2(36) NOT NULL Element Type Guid
9 FT_PERSON_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
10 FT_FUSION_ENT_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Element Entry ID
11 FT_FUSION_VL_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Entry Value ID
12 FT_FUSION_EU_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Elntry Usage GUID
13 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID
14 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

Prompt Table: VC_PLAN_TBL

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

Prompt Table: VC_PAYPRD_TBL

16 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

18 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
19 EFFDT Date(10) DATE Effective Date

Default Value: %date

20 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
21 FT_WT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Term Eff Date
22 FT_WT_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Term Eff Seq
23 AS_OF_DATE Date(10) DATE As of Date
24 VC_ELIG_STATUS Character(2) VARCHAR2(2) NOT NULL Eligibility Status
AE=Auto Eligible
AI=Auto Ineligible
EP=Eligible with Proration
ME=Manual Eligible
MI=Manual Ineligble
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: VC_PLAN_TBL.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

26 FT_CURRENCY_CODE Character(15) VARCHAR2(15) NOT NULL Currency Code
27 VC_MODIFIER Number(6,2) DECIMAL(5,2) NOT NULL Modifier (%)
28 VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value
29 FT_VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value
30 VC_AWARD_DT Date(10) DATE Award Date
31 FT_EARNED_DATE Date(10) DATE Date Earned
32 FT_DATE_FROM Date(10) DATE Date From
33 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

34 VC_CALC_SOURCE Character(2) VARCHAR2(2) NOT NULL Calculation Source
M=Manual Calculation
N=System - Minimum
S=System Calculated
X=System - Maximum
35 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: EARNINGS_TBL

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

Prompt Table: GP_ERN_SRCH

37 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
38 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
39 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
40 FT_VALUE_CHANGED Character(1) VARCHAR2(1) NOT NULL Value Changed
N=No
Y=Yes
41 FT_RUN_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted
42 FT_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted
43 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
44 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

45 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

46 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
47 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
48 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
49 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.