FPMCONVTABL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_CONVERSION_ID	Character(20)	VARCHAR2(20) NOT NULL	Reclassification ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
4	FP_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade Prompt Table: FPMRANK_TBL
5	FP_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step Prompt Table: FPMSALSTEP_TBL
6	FP_ORD_NBR	Number(2,0)	SMALLINT NOT NULL	Serial Number
7	FP_COMMENT	Character(50)	VARCHAR2(50) NOT NULL	Comments
8	FP_EXORDER_DT	Date(10)	DATE NOT NULL	Order Date Default Value: %Date
9	FP_MIN_SEN_YY	Number(2,0)	SMALLINT NOT NULL	Actual Min Seniority
10	FP_MIN_SEN_MM	Number(2,0)	SMALLINT NOT NULL	Actual Min Seniority (Months)
11	FP_MAX_SEN_YY	Number(2,0)	SMALLINT NOT NULL	Actual Max Seniority
12	FP_MAX_SEN_MM	Number(2,0)	SMALLINT NOT NULL	Actual Max Seniority (Months)
13	FP_STP_SEN_YY	Number(2,0)	SMALLINT NOT NULL	Step Seniority
14	FP_STP_SEN_MM	Number(2,0)	SMALLINT NOT NULL	Step Seniority (M)
15	FP_HIRANTE_DT	Date(10)	DATE	Employment Date Before
16	FP_HIRPOST_DT	Date(10)	DATE	Employment Date After
17	FP_REQ_SKL	Character(1)	VARCHAR2(1) NOT NULL	Required Competencies Y/N Table Edit Default Value: N
18	FP_MIN_AGE_YY	Number(2,0)	SMALLINT NOT NULL	Minimum Age
19	FP_MIN_AGE_MN	Number(2,0)	SMALLINT NOT NULL	Minimum Age (Month)
20	FP_MIN_ASM	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Rating
21	FP_NX_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade Prompt Table: FPMRANK_TBL
22	FP_NX_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step Prompt Table: FPMSALSTEP_TBL
23	FP_NX_TRN_PD	Character(1)	VARCHAR2(1) NOT NULL	Probationary Period Y/N Table Edit
24	FP_MULT_COR	Number(8,3)	DECIMAL(7,3) NOT NULL	Multiplier Default Value: 1
25	FP_BON_COR_YY	Number(2,0)	SMALLINT NOT NULL	Year Bonus
26	FP_BON_COR_MM	Number(2,0)	SMALLINT NOT NULL	Month Bonus
27	FP_BON_COR_DD	Number(2,0)	SMALLINT NOT NULL	Day Bonus
28	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: FPAACTNCARE_VW
29	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
30	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update Default Value: %Date