FPAEENOTICE(SQL Table) |
Index Back |
---|---|
Employee OrdersThis 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 |