FPAEEFLAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Row Origin A=Order Abrogation C=Collective Orders I=Individual Orders (Single) J=Individual Orders (Mass) R=Retroactivity Abrogation
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	FP_NOTIF_REF	Character(8)	VARCHAR2(8) NOT NULL	Order reference
4	FP_ACTION_REF	Character(8)	VARCHAR2(8) NOT NULL	Request Reference
5	EFFDT	Date(10)	DATE	Effective Date
6	FP_TBL_CD	Character(1)	VARCHAR2(1) NOT NULL	Step increment indicator A=Assignment Table C=CareerTable D=Request Table E=Absence Table F=Assignment History G=Statutory Position History H=Carrer History I=Other DataTable J=Premium Hist K=Work Time History L=Compensaton History M=Premium N=Order Table O=Contract Table P=Bonus Table R=Compensation Table S=Statutory Position Table T=Other Data History U=Bonus History W=Work Time Table
7	FP_WORD	Character(6)	VARCHAR2(6) NOT NULL	Document
8	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: FPMACTION_TBL
9	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
10	FP_REFCOL_PS	Number(8,0)	INTEGER NOT NULL	PSoft Ref Collective Order
11	FP_RETURN_R	Character(1)	VARCHAR2(1) NOT NULL	Return=R
12	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
13	FP_CONTRACT_RSN	Character(3)	VARCHAR2(3) NOT NULL	Contract reason AEC=Waiting Open-Ended Contract CRP=Establishment of Post RSA=Leave-of-Absence Replacement RSP=Resign Repalcement SAI=Seasonal Operation SUR=Temporary Extra Work
14	PROBATION_DT	Date(10)	DATE	Probation Date
15	FP_STATUSEE_CD	Character(1)	VARCHAR2(1) NOT NULL	Employee status Prompt Table: FPMSTATUSEE_TBL
16	FP_TRNE_SVT_CD	Character(1)	VARCHAR2(1) NOT NULL	Trainee / civil servant code B=Other F=Civil Servant S=Trainee
17	FP_TENURE_DT	Date(10)	DATE	Tenure Date
18	FP_TENURE_NO_DT	Date(10)	DATE	Tenure rejected date
19	FP_FIRST_PRO_DT	Date(10)	DATE	Probation period end date
20	FP_FIRST_DUR	Number(3,0)	SMALLINT NOT NULL	Duration of the probation period
21	FP_FIRST_TYP	Character(1)	VARCHAR2(1) NOT NULL	Probation period type
22	FP_TENPD_BRK	Character(1)	VARCHAR2(1) NOT NULL	Tenure probation period suspension
23	FP_TEN_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Access mode : recruitment, promotion C=Competition R=Recruitment
24	FP_SETID_RANK	Character(5)	VARCHAR2(5) NOT NULL	SetID
25	FP_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade Prompt Table: FPMRANK_TBL
26	FP_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step
27	FP_SENTOSTPDY	Number(2,0)	SMALLINT NOT NULL	Career Sen Step Incrmnt (D)
28	FP_SENTOSTPMN	Number(2,0)	SMALLINT NOT NULL	Career Sen Step Incrmnt (M)
29	FP_SENTOSTPYR	Number(2,0)	SMALLINT NOT NULL	Career Sen Step Incrmnt (Y)
30	FP_SENINSTPDY	Number(2,0)	SMALLINT NOT NULL	Career Seniority in Scale (D)
31	FP_SENINSTPMN	Number(2,0)	SMALLINT NOT NULL	Career Seniority in Scale (M)
32	FP_SENINSTPYR	Number(2,0)	SMALLINT NOT NULL	Career Seniority in Scale (Y)
33	FP_CORPS_CD	Character(6)	VARCHAR2(6) NOT NULL	Corps Prompt Table: FPMCORPS_TBL
34	FP_CHG_COR_DT	Date(10)	DATE	Corps Change Date
35	FP_CATG_FP	Character(2)	VARCHAR2(2) NOT NULL	Civil Service Category A=A B=B C=C D=D X=No Existing Category
36	FP_TRAINEE	Character(1)	VARCHAR2(1) NOT NULL	Trainee
37	FP_CATG_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Category Level
38	FP_NOMINATION_DT	Date(10)	DATE	Appointment Date
39	FP_SANCTION	Character(1)	VARCHAR2(1) NOT NULL	Sanction N= S=Sanction Extension Y=Sanction
40	FP_DOWN_GRA	Character(1)	VARCHAR2(1) NOT NULL	Demotion N= Y=Downgrading
41	FP_PROPD_BRK	Character(1)	VARCHAR2(1) NOT NULL	Promo Prob Period Suspension
42	FP_PRO_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Access Mode C=Competition P=Advancement
43	FP_SETID_RK_PREC	Character(5)	VARCHAR2(5) NOT NULL	Previous Grade SetID
44	FP_RANK_CD_PRV	Character(6)	VARCHAR2(6) NOT NULL	Previous Grade
45	FP_STEP_CD_PRV	Character(4)	VARCHAR2(4) NOT NULL	Previous Step
46	FP_LEGALSTAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Civil Service Position Code Prompt Table: FPMLEGALSTA_TBL
47	FP_SCNDMT_CD	Character(1)	VARCHAR2(1) NOT NULL	Employee on Secondment
48	FP_SCND_TYP	Character(1)	VARCHAR2(1) NOT NULL	Secondment Type (Int,Ext) B=No Effect E=External Secondment I=Internal Secondment
49	FP_CAREFRZPCT	Number(3,0)	SMALLINT NOT NULL	Career Advancement %
50	FP_RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return
51	FP_PR_LEGSTA	Character(3)	VARCHAR2(3) NOT NULL	Position before Return Prompt Table: FPMLEGALSTA_TBL
52	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
53	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
54	FP_INSTALL_DT	Date(10)	DATE	Installation Date
55	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
56	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
57	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
58	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
59	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
60	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
61	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
62	FP_GROSS_IND	Number(4,0)	SMALLINT NOT NULL	Gross Index
63	FP_INCS_IND	Number(4,0)	SMALLINT NOT NULL	Increased Index
64	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
65	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
66	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
67	FP_RES_FIELD1	Character(3)	VARCHAR2(3) NOT NULL	Grid Type Prompt Table: FPMMATXTYP_TBL
68	FP_RES_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Grid
69	FP_RES_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Scale
70	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
71	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
72	FP_PT_PCT	Character(3)	VARCHAR2(3) NOT NULL	Working Time Percentage 050=50 060=60 070=70 080=80 090=90 100=100