FT_GRD_RATE_VAL

(SQL Table)
Index Back

Fusion Exract Grade Rate Value

Fusion Exract Grade Rate Value

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 FT_GRDRT_VAL_GUID Character(36) VARCHAR2(36) NOT NULL Grade Rate Value GUID
6 FT_EFF_START_DATE Date(10) DATE Effective Start Date
7 FT_EFF_END_DATE Date(10) DATE Effective End Date
8 FT_LEGISLATION_CD Character(30) VARCHAR2(30) NOT NULL INTERNAL_EXTERNAL_FLAG
9 FT_ACTN_OCCUR_GUID Character(36) VARCHAR2(36) NOT NULL Action Occurrence ID
10 FT_GRADE_RATE_GUID Character(36) VARCHAR2(36) NOT NULL Grade Rate GUID
11 FT_RATE_OBJ_TYPE Character(30) VARCHAR2(30) NOT NULL Rate Object Type
12 FT_RATE_OBJ_GUID Character(36) VARCHAR2(36) NOT NULL Rate Object GUID
13 FT_SEQUENCE Number(18,0) DECIMAL(18) NOT NULL Sequence
14 FT_MINIMUM Character(20) VARCHAR2(20) NOT NULL Minimum
15 FT_MAXIMUM Character(20) VARCHAR2(20) NOT NULL Maximum
16 FT_MID_VALUE Character(20) VARCHAR2(20) NOT NULL Mid Value
17 FT_RATE_VALUE Character(20) VARCHAR2(20) NOT NULL Rate Value
18 FT_ATTR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
19 FT_INFO_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
20 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
21 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

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