FPAEENOTICE

(SQL Table)
Index Back

Employee Orders

This record contains the information related to FPS orders. It is updated by the system

# 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 FP_NOTIF_REF Character(8) VARCHAR2(8) NOT NULL Order reference
4 FP_RETURN_R Character(1) VARCHAR2(1) NOT NULL Return=R
5 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: N

6 FP_EDITIDVDEC Character(1) VARCHAR2(1) NOT NULL Edit Individual Order

Y/N Table Edit

Default Value: N

7 FP_EDITCOLDEC Character(1) VARCHAR2(1) NOT NULL Edit Collective Order

Y/N Table Edit

Default Value: N

8 FP_IDV_ON_REQ Character(1) VARCHAR2(1) NOT NULL Edt Indiv Order (Request)

Y/N Table Edit

Default Value: N

9 FP_COL_ON_REQ Character(1) VARCHAR2(1) NOT NULL Edit Coll Order (Request)

Y/N Table Edit

Default Value: N

10 FP_IDVEDIT_DT Date(10) DATE Individual Order Edit Date
11 FP_COLEDIT_DT Date(10) DATE Collective Order Edit Date
12 FP_COLDEC_NBR Character(12) VARCHAR2(12) NOT NULL Collective Order Nbr
13 FP_REFCOL_PS Number(8,0) INTEGER NOT NULL PSoft Ref Collective Order
14 FP_DEC_ABROG Character(1) VARCHAR2(1) NOT NULL Abrogation of Order

Y/N Table Edit

Default Value: N

15 FP_DEC_ABROG_DT Date(10) DATE Order Abrogation Date
16 FP_EDIT_ABROG Character(1) VARCHAR2(1) NOT NULL Edit Order Abrogation

Y/N Table Edit

Default Value: N

17 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

18 FP_EDT_TMP Character(1) VARCHAR2(1) NOT NULL Provisional Editing

Y/N Table Edit

Default Value: N

19 FP_EDT_FNL Character(1) VARCHAR2(1) NOT NULL Final Editing

Y/N Table Edit

Default Value: N

20 FP_IDVDEC_NBR Character(12) VARCHAR2(12) NOT NULL Individual Order Nbr
21 LAST_UPDATE_DATE Date(10) DATE Date of last update

Default Value: %Date