FT_EL_ENTRY_USG

(SQL Table)
Index Back

Element Entry Usage

# 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 Record
3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
4 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
6 FT_FUSION_EU_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Elntry Usage GUID
7 FT_EL_USAGE_GUID Character(36) VARCHAR2(36) NOT NULL Entry Usage GUID
8 FT_EL_ENTR_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry GUID
9 FT_FUSION_ENT_GUID Character(36) VARCHAR2(36) NOT NULL Fusion Element Entry ID
10 FT_DATE_FROM Date(10) DATE Date From
11 FT_DATE_TO Date(10) DATE Date To
12 FT_EARNED_DATE Date(10) DATE Date Earned
13 FT_USAGE_LEVEL Character(30) VARCHAR2(30) NOT NULL Usage Level
14 FT_PAY_ASSGNMNT_ID Character(18) VARCHAR2(18) NOT NULL Payroll Assignment ID
15 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID
16 FT_PAY_RLTNSHP_ID Character(18) VARCHAR2(18) NOT NULL Payroll Relationship ID
17 FT_PAY_TERM_GUID Character(36) VARCHAR2(36) NOT NULL Work Term ID
18 FT_ASSIGNED_PAY_ID Character(18) VARCHAR2(18) NOT NULL Assigned Payroll ID
19 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
20 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

22 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
23 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key