FT_GRADE_RATE

#	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	FT_REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
8	FT_GRADE_RATE_GUID	Character(36)	VARCHAR2(36) NOT NULL	Grade Rate GUID
9	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
10	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
11	FT_LEGDATAGRP_GUID	Character(36)	VARCHAR2(36) NOT NULL	Legislative Date Group GUID
12	FT_LEGISLATION_CD	Character(30)	VARCHAR2(30) NOT NULL	INTERNAL_EXTERNAL_FLAG
13	FT_ACTN_OCCUR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Action Occurrence ID
14	FT_SET_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	Set ID GUID
15	FT_RATE_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Rate Type
16	FT_RATE_OBJ_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Rate Object Type
17	FT_NAME	Character(240)	VARCHAR2(240) NOT NULL	Name
18	FT_CURRENCY_CODE	Character(15)	VARCHAR2(15) NOT NULL	Currency Code
19	FT_RATE_UOM	Character(30)	VARCHAR2(30) NOT NULL	Rate UOM
20	FT_RATE_FREQUENCY	Character(30)	VARCHAR2(30) NOT NULL	Rate Frequency
21	FT_ANNUAL_FACTOR	Number(31,5)	DECIMAL(30,5) NOT NULL	Annualization Factor
22	FT_ACTIVE_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Active Status
23	FT_ATTR_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Attribute Category
24	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
25	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
26	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
27	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
28	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key