FPMSALMATRX_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_MATRIX_TYP	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Table Type GEC=Under Contract Grid GES=Statutory Grid GFP=Public Service Grid Prompt Table: FPMMATXTYP_TBL
2	FP_MATRIX_CD	Character(4)	VARCHAR2(4) NOT NULL	Salary Grade Table Code
3	FP_SCALE_CD	Character(4)	VARCHAR2(4) NOT NULL	Scale Prompt Table: FPMSCALE_TBL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
8	FP_PBSEC_MTRX	Character(1)	VARCHAR2(1) NOT NULL	Public Sector Sal Grd Tbl N=Outside Public Service Grid Y=Public Service Grid Default Value: Y
9	FP_NONE_MATRX	Character(1)	VARCHAR2(1) NOT NULL	Off-Scale Y/N Table Edit Default Value: N
10	FP_COMMENT	Character(50)	VARCHAR2(50) NOT NULL	Comments
11	FP_UPDTREASON	Character(4)	VARCHAR2(4) NOT NULL	Updating Reason
12	FP_EXORDER_DT	Date(10)	DATE	Order Date
13	FP_APPL_DT	Date(10)	DATE	Application Date
14	FP_APPL_AREA	Character(4)	VARCHAR2(4) NOT NULL	Application Sector A100=Finance B100=Culture Prompt Table: FPMAPPLAREA_TBL
15	FP_POINTYP_CD	Character(2)	VARCHAR2(2) NOT NULL	Point Type Code Prompt Table: FPMPOINTYP_TBL
16	FP_FIRST_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	1st Step Code in SalaryGdTbl Prompt Table: FPMSALSTEP_TBL
17	FP_LAST_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Last Step Code in SalaryGdTbl Prompt Table: FPMSALSTEP_TBL
18	FP_ENTBONYR	Number(2,0)	SMALLINT NOT NULL	Bonus for Entering SalaryGdTbl
19	FP_ENTBONMNTH	Number(2,0)	SMALLINT NOT NULL	Bonus for Entering Grid (Mths)
20	FP_ENTBONDAY	Number(2,0)	SMALLINT NOT NULL	Bonus for Entering Grid (Days)
21	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update Default Value: %Date