FT_VCAWD_DTL_VW (SQL View)	Index Back
Variable Comp Awards 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.

FT_VCAWD_DTL_VW

(SQL View)

Variable Comp Awards

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.

SELECT STG.FT_RUN_ID , STG.FT_EL_ENTR_VL_GUID , STG.FT_EFF_START_DATE , STG.FT_EFF_END_DATE , STG.FT_EFF_SEQUENCE , STG.FT_EL_ENTR_GUID , STG.EMPLID , STG.EMPL_RCD , STG.COMPANY , STG.VC_PLAN_ID , STG.VC_PAYOUT_PRD_ID , STG.FT_CURRENCY_CODE , STG.FT_VC_AWARD_VALUE , STG.CURRENCY_CD , STG.SETID_JOBCODE , STG.JOBCODE , STG.FT_ERROR_FLAG , STG.FT_PROC_STATUS , STG.FT_VALUE_CHANGED , STG.VC_AWARD_VALUE , STG.VC_AWARD_DT , STG.LASTUPDOPRID , STG.LASTUPDDTTM , STG.FT_DATE_FROM , STG.FT_EARNED_DATE FROM %Table(FT_VC_AWARD_STG) 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 FT_EL_ENTR_VL_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry Value Guid

3 FT_EFF_START_DATE Date(10) DATE Effective Start Date

4 FT_EFF_END_DATE Date(10) DATE Effective End Date

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

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

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

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

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

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

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

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

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

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

15 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

17 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

18 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

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

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

21 VC_AWARD_DT Date(10) DATE Award Date

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

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

24 FT_DATE_FROM Date(10) DATE Date From

25 FT_EARNED_DATE Date(10) DATE Date Earned

#	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	FT_EL_ENTR_VL_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Entry Value Guid
3	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
4	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
5	FT_EFF_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Effective Sequence
6	FT_EL_ENTR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Entry GUID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
11	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
12	FT_CURRENCY_CODE	Character(15)	VARCHAR2(15) NOT NULL	Currency Code
13	FT_VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
15	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
16	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
17	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes
18	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
19	FT_VALUE_CHANGED	Character(1)	VARCHAR2(1) NOT NULL	Value Changed N=No Y=Yes
20	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
21	VC_AWARD_DT	Date(10)	DATE	Award Date
22	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.
23	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.
24	FT_DATE_FROM	Date(10)	DATE	Date From
25	FT_EARNED_DATE	Date(10)	DATE	Date Earned