FT_VC_AWARD_STG (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_VC_AWARD_STG

(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 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 Rcd Nbr

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 SetID

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.

#	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 Rcd Nbr
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 SetID
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.