FPMACTION_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	FP_KIND	Character(2)	VARCHAR2(2) NOT NULL	Action Type AA=Absence Authorized AC=Other Leaves AF=Assignment AN=Unauthorized Absence CA=Career CD=Change of Personal Dta CP=Paid Leave CR=Parental Leave DE=Secondment DI=Other DP=Availability EL=Elections EN=Hiring FM=Training MA=Sick Leave PB=Bonus PR=Compensation RE=Reclassification SA=Sanction SN=National Service SO=Exit TT=Work Time
7	FP_LEGALSTAT_CD	Character(3)	VARCHAR2(3) NOT NULL	Civil Service Position Code Prompt Table: FPMLEGALSTA_TBL
8	FP_SCNDMT_POS	Character(1)	VARCHAR2(1) NOT NULL	Secondment Position Y/N Table Edit Default Value: N
9	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
10	FP_EDITIDVDEC	Character(1)	VARCHAR2(1) NOT NULL	Edit Individual Order Y/N Table Edit Default Value: N
11	FP_EDITCOLDEC	Character(1)	VARCHAR2(1) NOT NULL	Edit Collective Order Y/N Table Edit Default Value: N
12	FP_AUTH_MUT	Character(1)	VARCHAR2(1) NOT NULL	Assignment Data Authorized Y/N Table Edit Default Value: N
13	FP_AUTH_CARE	Character(1)	VARCHAR2(1) NOT NULL	Career Data Authorized Y/N Table Edit Default Value: N
14	FP_AUTH_SAL	Character(1)	VARCHAR2(1) NOT NULL	Compensation Dta Authorized Y/N Table Edit Default Value: N
15	FP_AUTH_BONUS	Character(1)	VARCHAR2(1) NOT NULL	Bonus Data Authorized Y/N Table Edit Default Value: N
16	FP_AUTH_WORK	Character(1)	VARCHAR2(1) NOT NULL	Working Time Data Auth. Y/N Table Edit Default Value: N
17	FP_AUTH_DIV	Character(1)	VARCHAR2(1) NOT NULL	EE Categorization Authorized Y/N Table Edit Default Value: N
18	FP_AUTH_PERS	Character(1)	VARCHAR2(1) NOT NULL	Personal Data Authorized Y/N Table Edit Default Value: N
19	FP_AUTH_ABSEN	Character(1)	VARCHAR2(1) NOT NULL	Absence Data Authorized Y/N Table Edit Default Value: N
20	FP_AUTH_LEGSTA	Character(1)	VARCHAR2(1) NOT NULL	Civil Service Positn Data Auth Y/N Table Edit Default Value: N
21	FP_AUTH_PREMIUM	Character(1)	VARCHAR2(1) NOT NULL	Premium Data Authorized Y/N Table Edit Default Value: N
22	FP_CRT_DOSSIER	Character(1)	VARCHAR2(1) NOT NULL	Action Hire/Re-hire Y/N Table Edit Default Value: N
23	FP_RATIFY_REQ	Character(1)	VARCHAR2(1) NOT NULL	To Be Confirmed Y/N Table Edit Default Value: N
24	FP_AUTH_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Select Updating B=None R=Grade/Step S=Step Default Value: B
25	FP_REQ_DTCBCK	Character(1)	VARCHAR2(1) NOT NULL	Mandatory Expect Dt of Return Y/N Table Edit Default Value: N
26	FP_DEPART_CD	Character(1)	VARCHAR2(1) NOT NULL	Action Terminate Record Y/N Table Edit Default Value: N
27	FP_PR_SENTY_XFR	Character(1)	VARCHAR2(1) NOT NULL	Previous Instance Sen Carry Ov Y/N Table Edit Default Value: N
28	FP_SANCTION_CD	Character(1)	VARCHAR2(1) NOT NULL	Sanction Action Y/N Table Edit Default Value: N
29	FP_DOWNGRADE_CD	Character(1)	VARCHAR2(1) NOT NULL	Demotion Action Y/N Table Edit Default Value: N
30	FP_SCRTY_ACCS	Character(6)	VARCHAR2(6) NOT NULL	Action Group Prompt Table: FPMACTNGRP_TBL
31	FP_CRT_JOBTBL	Character(1)	VARCHAR2(1) NOT NULL	Code Action to create in JOB Y/N Table Edit Default Value: N
32	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update Default Value: %date