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 Record

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 Number Key

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

7 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL HFR
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 Code

21 FP_FOREND_DT Date(10) DATE Position Expected End Date for FPS

22 FP_END_DT Date(10) DATE Position Actual End Date

23 FP_SCNDMT_CD Character(1) VARCHAR2(1) NOT NULL Secondment for FPS

24 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type for FPS
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 for FPS

28 FP_FOR_PROM_DT Date(10) DATE From Date for FPS

29 FP_STEP_END_DT Date(10) DATE Step Actual End Date for FPS

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

31 FP_NOMINATION_DT Date(10) DATE Nomination Date for FPS

32 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Date for FPS

33 FP_RK_PD_END_DT Date(10) DATE Expected Date for FPS

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

35 FP_DOWN_GRA Character(1) VARCHAR2(1) NOT NULL Grade for FPS
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 Advancment for FPS

43 FP_RETROSPECT Character(1) VARCHAR2(1) NOT NULL Retro Activity for FPS

44 FP_RK_ENT_DT Date(10) DATE Date Entry for FPS

45 FP_CHG_COR_DT Date(10) DATE Change Date for FPS

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

47 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category level for FPS

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

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

50 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position for FPS

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

52 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Nbr for FPS

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

54 FP_ROW_END_DT Date(10) DATE Job Instance End date for FPS

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 Record
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 Number Key
6	SSN_FRA	Character(13)	VARCHAR2(13) NOT NULL	Social Security #
7	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	HFR 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 Code
21	FP_FOREND_DT	Date(10)	DATE	Position Expected End Date for FPS
22	FP_END_DT	Date(10)	DATE	Position Actual End Date
23	FP_SCNDMT_CD	Character(1)	VARCHAR2(1) NOT NULL	Secondment for FPS
24	FP_SCND_TYP	Character(1)	VARCHAR2(1) NOT NULL	Secondment Type for FPS 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 for FPS
28	FP_FOR_PROM_DT	Date(10)	DATE	From Date for FPS
29	FP_STEP_END_DT	Date(10)	DATE	Step Actual End Date for FPS
30	FP_CORPS_CD	Character(6)	VARCHAR2(6) NOT NULL	Corps
31	FP_NOMINATION_DT	Date(10)	DATE	Nomination Date for FPS
32	FP_RK_TRIALPD	Character(1)	VARCHAR2(1) NOT NULL	Probation Date for FPS
33	FP_RK_PD_END_DT	Date(10)	DATE	Expected Date for FPS
34	FP_SANCTION	Character(1)	VARCHAR2(1) NOT NULL	Sanction for FPS N= S=Sanction Extension Y=Sanction
35	FP_DOWN_GRA	Character(1)	VARCHAR2(1) NOT NULL	Grade for FPS 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 Advancment for FPS
43	FP_RETROSPECT	Character(1)	VARCHAR2(1) NOT NULL	Retro Activity for FPS
44	FP_RK_ENT_DT	Date(10)	DATE	Date Entry for FPS
45	FP_CHG_COR_DT	Date(10)	DATE	Change Date for FPS
46	FP_CATG_FP	Character(2)	VARCHAR2(2) NOT NULL	Category for FPS A=A B=B C=C D=D X=No Existing Category
47	FP_CATG_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Category level for FPS
48	FP_TRAINEE	Character(1)	VARCHAR2(1) NOT NULL	Trainee for FPS
49	FP_TRNE_POSN	Character(1)	VARCHAR2(1) NOT NULL	Probationary Period state for FPS A=Rejected B=None E=In progress V=Validated
50	FP_PR_LEGSTA	Character(3)	VARCHAR2(3) NOT NULL	Position for FPS
51	FP_HDCNT_NBR	Number(1,0)	SMALLINT NOT NULL	Headcount for FPS
52	FP_BUDGET_NBR	Number(1,0)	SMALLINT NOT NULL	Budget Nbr for FPS
53	FP_HIR_DOS_SIT	Character(2)	VARCHAR2(2) NOT NULL	Hire Status for FPS 00=Contract Signed 01=Hiring Done 02=Hiring Validated
54	FP_ROW_END_DT	Date(10)	DATE	Job Instance End date for FPS
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