FPAEEPOST_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	FP_CNL_ROW	Character(1)	VARCHAR2(1) NOT NULL	Canceled row indicator in case a row is deleted. Y/N Table Edit Default Value: N
6	FP_INST_STAT	Character(1)	VARCHAR2(1) NOT NULL	Instance Status D=Request R=Actual Default Value: R
7	FP_ACTION_REF	Character(8)	VARCHAR2(8) NOT NULL	Request Reference
8	FP_NOTIF_REF	Character(8)	VARCHAR2(8) NOT NULL	Order reference
9	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: FPAACTNPOST_VW
10	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
12	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
13	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data Y/N Table Edit Default Value: N
14	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
15	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
16	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
17	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
18	FP_INSTALL_DT	Date(10)	DATE	Installation Date
19	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
20	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_COMP_VW
21	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
22	FP_BUSINESS_CD	Character(4)	VARCHAR2(4) NOT NULL	Occupation Code Prompt Table: FPMBUISNESS_TBL
23	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
24	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
25	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
26	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_HR.SETID
27	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID Default Value: OPR_DEF_TBL_HR.SETID
28	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID Default Value: OPR_DEF_TBL_HR.SETID
29	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
30	FP_CHG_SAL	Character(1)	VARCHAR2(1) NOT NULL	Forced Salary Y/N Table Edit Default Value: N
31	FP_APPL_DT	Date(10)	DATE	Application Date
32	FP_CHG_SAL_GEN	Character(1)	VARCHAR2(1) NOT NULL	New Compensation Generation Y/N Table Edit Default Value: N
33	FP_STEP_CD	Character(4)	VARCHAR2(4) NOT NULL	Step Prompt Table: FPMSALSTEP_TBL
34	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
35	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
36	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
37	GP_DFLT_ELIG_GRP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
38	GP_ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	Eligibility Group
39	GP_DFLT_CURRTTYP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
40	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
41	GP_DFLT_EXRTDT	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
42	GP_ASOF_DT_EXG_RT	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a flag to determine whether to use a default exchange rate or not. B=Pay Period Begin Date E=Pay Period End Date P=Payment Date
43	FP_RETROSPECT	Character(1)	VARCHAR2(1) NOT NULL	Retroactivity Code Y/N Table Edit Default Value: N
44	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 Default Value: A
45	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update Default Value: %Date