FT_VCAWD_STG_AD (SQL Table)	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

FT_VCAWD_STG_AD

(SQL Table)

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID

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

4 FT_EL_ENTR_VL_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry Value Guid

5 FT_EFF_START_DATE Date(10) DATE Effective Start Date

6 FT_EFF_END_DATE Date(10) DATE Effective End Date

7 FT_EFF_SEQUENCE Number(4,0) SMALLINT NOT NULL Effective Sequence

8 FT_EL_ENTR_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry GUID

9 FT_EL_TYPE_GUID Character(36) VARCHAR2(36) NOT NULL Element Type Guid

10 FT_PERSON_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID

11 FT_FUSION_ENT_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Element Entry ID

12 FT_FUSION_VL_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Entry Value ID

13 FT_FUSION_EU_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Elntry Usage GUID

14 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID

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

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

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

18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

19 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

20 EFFDT Date(10) DATE Effective Date
Default Value: %date

21 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

22 FT_WT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Term Eff Date

23 FT_WT_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Term Eff Seq

24 AS_OF_DATE Date(10) DATE As of Date

25 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

26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: VC_PLAN_TBL.CURRENCY_CD

27 FT_CURRENCY_CODE Character(15) VARCHAR2(15) NOT NULL Currency Code

28 VC_MODIFIER Number(6,2) DECIMAL(5,2) NOT NULL Modifier (%)

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

30 FT_VC_AWARD_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Variable Comp Award Value

31 VC_AWARD_DT Date(10) DATE Award Date

32 FT_EARNED_DATE Date(10) DATE Date Earned

33 FT_DATE_FROM Date(10) DATE Date From

34 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

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

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

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

38 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

39 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

40 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

41 FT_VALUE_CHANGED Character(1) VARCHAR2(1) NOT NULL Value Changed
N=No
Y=Yes

42 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

43 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

44 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field

45 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes
Default Value: N

46 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag
Default Value: N

47 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record

48 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key

49 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.

50 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	FT_RUN_ID	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	FT_EL_ENTR_VL_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Entry Value Guid
5	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
6	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
7	FT_EFF_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Effective Sequence
8	FT_EL_ENTR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Entry GUID
9	FT_EL_TYPE_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Type Guid
10	FT_PERSON_GUID	Character(36)	VARCHAR2(36) NOT NULL	Person GUID
11	FT_FUSION_ENT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Fusion Element Entry ID
12	FT_FUSION_VL_GUID	Character(36)	VARCHAR2(36) NOT NULL	Fusion Entry Value ID
13	FT_FUSION_EU_GUID	Character(36)	VARCHAR2(36) NOT NULL	Fusion Elntry Usage GUID
14	FT_ASSIGNMENT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Assignment ID
15	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
16	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
17	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
20	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
21	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
22	FT_WT_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Work Term Eff Date
23	FT_WT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Work Term Eff Seq
24	AS_OF_DATE	Date(10)	DATE	As of Date
25	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
26	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: VC_PLAN_TBL.CURRENCY_CD
27	FT_CURRENCY_CODE	Character(15)	VARCHAR2(15) NOT NULL	Currency Code
28	VC_MODIFIER	Number(6,2)	DECIMAL(5,2) NOT NULL	Modifier (%)
29	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
30	FT_VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
31	VC_AWARD_DT	Date(10)	DATE	Award Date
32	FT_EARNED_DATE	Date(10)	DATE	Date Earned
33	FT_DATE_FROM	Date(10)	DATE	Date From
34	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
35	VC_CALC_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Calculation Source M=Manual Calculation N=System - Minimum S=System Calculated X=System - Maximum
36	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
37	PIN_ERN_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number Earning
38	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
39	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
40	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
41	FT_VALUE_CHANGED	Character(1)	VARCHAR2(1) NOT NULL	Value Changed N=No Y=Yes
42	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
43	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
44	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
45	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
46	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
47	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
48	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key
49	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.
50	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.