| # |
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 Rcd Nbr
|
| 3 |
FP_STATUSEE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee status
Prompt Table:
FPMSTATUSEE_TBL
|
| 4 |
FP_TRNE_SVT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee / civil servant code
B=Other
F=Civil Servant
S=Trainee
|
| 5 |
FP_TENURE_DT |
Date(10) |
DATE |
Tenure Date
|
| 6 |
FP_SCNDMT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee on Secondment
Y/N Table Edit
Default Value: N
|
| 7 |
FP_CA_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
CAESetID
|
| 8 |
FP_COMM_ACNT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Commitment Acctng Entity ID
Prompt Table:
FPA_CA_TBL
|
| 9 |
FP_CA_SETID2 |
Character(5) |
VARCHAR2(5) NOT NULL |
CAE SetID2
|
| 10 |
FP_CA_ID2 |
Character(11) |
VARCHAR2(11) NOT NULL |
CAE 2
|
| 11 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 12 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 13 |
FP_CA_CATG_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
CAE Category
Prompt Table:
FPM_CA_CTG_TBL
|
| 14 |
FP_CA_CTG_ID2 |
Character(6) |
VARCHAR2(6) NOT NULL |
CAE Category 2
|
| 15 |
FP_SHR_TM_RT |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Proration Ratio
|
| 16 |
FP_CA_PCT2 |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Reusable Proration Factor
|
| 17 |
FP_CA_C_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
CAE Creation Flag
A=Grade Adv Refused
B=%PT Change Refused
C=Cancel Current Grade
D=Cancel Current PT%
J=Gd Changed, Next PT%
K=Grade and %PTto Delete
P=Create CAE on Hold
Q=New CAE On Hold
R=Last CAE Rejected
S=Reset new Ppsition
T=New CAE Approved
V=CAE Stamped
Y=CAE Approved
Z=CAECancelled or Rejected
|
| 18 |
FP_CA_D_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
CAE Deallocation Flag
P=Deallocation to Process
R=Cancelling Deallocation
V=Deallocation of Stamped CAE
Y=Deallocation of Approved CAE
Z=Deallocation Rejected
|
| 19 |
FP_CA_M_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Procedure Flag
B=Rehiring with %PT change
C=Grade Advancement
D=Deallocation
E=Hiring
F=%PT Change
H=Rehiring with Grade Adv
K=Changing Grade / %PT
R=Re-hiring
Z=Re-hiring Grade/%PT Changed
|
| 20 |
FP_CA_X_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
State 2 in Complex Procedure
A=Chg 1 or Hiring to Valid
B=Change 2 to valid
C=Change 3 to valid
G=CAE Mgt Short-circuited
H=CAE Short-circuit no Message
I=CAE Temporary Inhibition
J=Execute Delete 1
K=Execute Delete 2
L=Execute Delete 3
M=Wait for Other Changes
Q=Wait %PT Change
|
| 21 |
FP_CA_W_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Flag
A=Change Grade and %PT
G=CAE Mgt Short-Circuited
H=CAE Short-circuit No Message
I=CAE Temporary Inhibition
|
| 22 |
FP_CA_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag is used to track the CAE procedure and suppress events and CAE
B=Return with Wrk Time Chng
C=Grade Change
D=Deallocation
E=Hiring
F=Wrk Time Chng
H=Return with Grade Change
K=Grade and Wrk Time Chng
R=Return
Z=Return + Gr + Wrk T chng
|
| 23 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|