FPA_EMPLOYEES (SQL Table)	Index Back
Personnel Data-Current Date-FP EMPLOYEES is a table created by running an SQR program named PER099. It's a snapshot of employees' personal/demographic data, employment data, and job/salary data as of the date indicated when the program is run. This table is used primarily for reporting.

FPA_EMPLOYEES

(SQL Table)

Personnel Data-Current Date-FP

EMPLOYEES is a table created by running an SQR program named PER099. It's a snapshot of employees' personal/demographic data, employment data, and job/salary data as of the date indicated when the program is run. This table is used primarily for reporting.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security # Key

6 SSN_FRA Character(13) VARCHAR2(13) NOT NULL Social Security #

7 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL Work Accident Type Code
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office

8 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
Prompt Table: EMPL_CTG_L1

9 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
Prompt Table: EMPL_CTG

10 INSEE_CD_FRA Character(4) VARCHAR2(4) NOT NULL Insee Code - FRA

11 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

12 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager

13 EMP_CATEGRY_FRA Character(3) VARCHAR2(3) NOT NULL Employee Category
CAD=Executive
ETA=Manager
OUV=Workman

14 ACTIVITY_TYPE_FRA Character(3) VARCHAR2(3) NOT NULL Activity Type
ATE=WorkShop Personnel
AUT=Other
BUR=Office Personnel
CHA=Shoulder Worker
SIE=Corporate Personnel

15 FP_STATUSEE_CD Character(1) VARCHAR2(1) NOT NULL Employee status

16 FP_TRNE_SVT_CD Character(1) VARCHAR2(1) NOT NULL Trainee / civil servant code
B=Other
F=Civil Servant
S=Trainee

17 FP_TEN_ACCESS Character(1) VARCHAR2(1) NOT NULL Access mode : recruitment, promotion
C=Competition
R=Recruitment

18 RETIREMENT_DT Date(10) DATE Projected Retirement Date

19 FP_INST_STAT Character(1) VARCHAR2(1) NOT NULL Instance Status
D=Request
R=Actual

20 FP_RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return

21 FP_FOREND_DT Date(10) DATE Position Expected End Date

22 FP_END_DT Date(10) DATE Position Actual End Date

23 FP_SCNDMT_CD Character(1) VARCHAR2(1) NOT NULL Employee on Secondment

24 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment

25 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade

26 FP_STEP_CD Character(4) VARCHAR2(4) NOT NULL Step

27 FP_CLD_INST Character(1) VARCHAR2(1) NOT NULL Instance Terminated

28 FP_FOR_PROM_DT Date(10) DATE Expected Advancement Date

29 FP_STEP_END_DT Date(10) DATE (Sub)Step Actual End Date

30 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

31 FP_NOMINATION_DT Date(10) DATE Appointment Date

32 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Period Grade

33 FP_RK_PD_END_DT Date(10) DATE PPd Expected End Date

34 FP_SANCTION Character(1) VARCHAR2(1) NOT NULL Sanction
N=
S=Sanction Extension
Y=Sanction

35 FP_DOWN_GRA Character(1) VARCHAR2(1) NOT NULL Demotion
N=
Y=Downgrading

36 FP_INSTALL_DT Date(10) DATE Installation Date

37 FP_BUSINESS_CD Character(4) VARCHAR2(4) NOT NULL Occupation Code

38 FP_GROSS_IND Number(4,0) SMALLINT NOT NULL Gross Index

39 FP_INCS_IND Number(4,0) SMALLINT NOT NULL Increased Index

40 FP_POINTYP_CD Character(2) VARCHAR2(2) NOT NULL Point Type Code

41 FP_LEGALSTAT_CD Character(3) VARCHAR2(3) NOT NULL Civil Service Position Code

42 FP_CAREFRZPCT Number(3,0) SMALLINT NOT NULL Career Advancement %

43 FP_RETROSPECT Character(1) VARCHAR2(1) NOT NULL Retroactivity Code

44 FP_RK_ENT_DT Date(10) DATE Grade Entry Date

45 FP_CHG_COR_DT Date(10) DATE Corps Change Date

46 FP_CATG_FP Character(2) VARCHAR2(2) NOT NULL Civil Service Category
A=A
B=B
C=C
D=D
X=No Existing Category

47 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category Level

48 FP_TRAINEE Character(1) VARCHAR2(1) NOT NULL Trainee

49 FP_TRNE_POSN Character(1) VARCHAR2(1) NOT NULL Probationary Period State
A=Rejected
B=None
E=In progress
V=Validated

50 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position before Return

51 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Statutory Headcount

52 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Headcount

53 FP_HIR_DOS_SIT Character(2) VARCHAR2(2) NOT NULL Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated

54 FP_ROW_END_DT Date(10) DATE JOB Instance End Date

55 FP_RANK_DESCR Character(30) VARCHAR2(30) NOT NULL Grade Description

56 FP_CORPS_DESCR Character(30) VARCHAR2(30) NOT NULL Corps Description

57 FP_ACTION_DESCR Character(30) VARCHAR2(30) NOT NULL Action Description

58 FP_STATUSEE_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description

59 FP_LEGALSTAT_DESCR Character(30) VARCHAR2(30) NOT NULL LEGALSTAT Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	SSN_KEY_FRA	Character(2)	VARCHAR2(2) NOT NULL	Social Security # Key
6	SSN_FRA	Character(13)	VARCHAR2(13) NOT NULL	Social Security #
7	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	Work Accident Type Code 0=Do not Pay 1=Building 2=Waterproofing 3=Floor Surface 4=Factory Making 5=Laboratory 6=WorkShop 7=Office
8	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category Prompt Table: EMPL_CTG_L1
9	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: EMPL_CTG
10	INSEE_CD_FRA	Character(4)	VARCHAR2(4) NOT NULL	Insee Code - FRA
11	JOB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Job Function Code
12	MANAGER_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Manager Level 0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager
13	EMP_CATEGRY_FRA	Character(3)	VARCHAR2(3) NOT NULL	Employee Category CAD=Executive ETA=Manager OUV=Workman
14	ACTIVITY_TYPE_FRA	Character(3)	VARCHAR2(3) NOT NULL	Activity Type ATE=WorkShop Personnel AUT=Other BUR=Office Personnel CHA=Shoulder Worker SIE=Corporate Personnel
15	FP_STATUSEE_CD	Character(1)	VARCHAR2(1) NOT NULL	Employee status
16	FP_TRNE_SVT_CD	Character(1)	VARCHAR2(1) NOT NULL	Trainee / civil servant code B=Other F=Civil Servant S=Trainee
17	FP_TEN_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Access mode : recruitment, promotion C=Competition R=Recruitment
18	RETIREMENT_DT	Date(10)	DATE	Projected Retirement Date
19	FP_INST_STAT	Character(1)	VARCHAR2(1) NOT NULL	Instance Status D=Request R=Actual
20	FP_RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return
21	FP_FOREND_DT	Date(10)	DATE	Position Expected End Date
22	FP_END_DT	Date(10)	DATE	Position Actual End Date
23	FP_SCNDMT_CD	Character(1)	VARCHAR2(1) NOT NULL	Employee on Secondment
24	FP_SCND_TYP	Character(1)	VARCHAR2(1) NOT NULL	Secondment Type (Int,Ext) B=No Effect E=External Secondment I=Internal Secondment
25	FP_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade
26	FP_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step
27	FP_CLD_INST	Character(1)	VARCHAR2(1) NOT NULL	Instance Terminated
28	FP_FOR_PROM_DT	Date(10)	DATE	Expected Advancement Date
29	FP_STEP_END_DT	Date(10)	DATE	(Sub)Step Actual End Date
30	FP_CORPS_CD	Character(6)	VARCHAR2(6) NOT NULL	Corps
31	FP_NOMINATION_DT	Date(10)	DATE	Appointment Date
32	FP_RK_TRIALPD	Character(1)	VARCHAR2(1) NOT NULL	Probation Period Grade
33	FP_RK_PD_END_DT	Date(10)	DATE	PPd Expected End Date
34	FP_SANCTION	Character(1)	VARCHAR2(1) NOT NULL	Sanction N= S=Sanction Extension Y=Sanction
35	FP_DOWN_GRA	Character(1)	VARCHAR2(1) NOT NULL	Demotion N= Y=Downgrading
36	FP_INSTALL_DT	Date(10)	DATE	Installation Date
37	FP_BUSINESS_CD	Character(4)	VARCHAR2(4) NOT NULL	Occupation Code
38	FP_GROSS_IND	Number(4,0)	SMALLINT NOT NULL	Gross Index
39	FP_INCS_IND	Number(4,0)	SMALLINT NOT NULL	Increased Index
40	FP_POINTYP_CD	Character(2)	VARCHAR2(2) NOT NULL	Point Type Code
41	FP_LEGALSTAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Civil Service Position Code
42	FP_CAREFRZPCT	Number(3,0)	SMALLINT NOT NULL	Career Advancement %
43	FP_RETROSPECT	Character(1)	VARCHAR2(1) NOT NULL	Retroactivity Code
44	FP_RK_ENT_DT	Date(10)	DATE	Grade Entry Date
45	FP_CHG_COR_DT	Date(10)	DATE	Corps Change Date
46	FP_CATG_FP	Character(2)	VARCHAR2(2) NOT NULL	Civil Service Category A=A B=B C=C D=D X=No Existing Category
47	FP_CATG_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Category Level
48	FP_TRAINEE	Character(1)	VARCHAR2(1) NOT NULL	Trainee
49	FP_TRNE_POSN	Character(1)	VARCHAR2(1) NOT NULL	Probationary Period State A=Rejected B=None E=In progress V=Validated
50	FP_PR_LEGSTA	Character(3)	VARCHAR2(3) NOT NULL	Position before Return
51	FP_HDCNT_NBR	Number(1,0)	SMALLINT NOT NULL	Statutory Headcount
52	FP_BUDGET_NBR	Number(1,0)	SMALLINT NOT NULL	Budget Headcount
53	FP_HIR_DOS_SIT	Character(2)	VARCHAR2(2) NOT NULL	Hire Status 00=Contract Signed 01=Hiring Done 02=Hiring Validated
54	FP_ROW_END_DT	Date(10)	DATE	JOB Instance End Date
55	FP_RANK_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Grade Description
56	FP_CORPS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Corps Description
57	FP_ACTION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Action Description
58	FP_STATUSEE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Status Description
59	FP_LEGALSTAT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	LEGALSTAT Description