| # |
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 Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
FP_ACTION_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Request Reference
|
| 6 |
FP_NOTIF_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Order reference
|
| 7 |
FP_CNL_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled row indicator in case a row is deleted.
Y/N Table Edit
|
| 8 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
|
| 9 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
%RECNAME_EDIT
|
| 10 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 11 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 12 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 13 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
Y/N Table Edit
Default Value: N
|
| 14 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 15 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table:
HR_BARG_UNIT
|
| 16 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 17 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 18 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
HR_LABOR_AGRMNT
|
| 19 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1_VW
|
| 20 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2_VW
|
| 21 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3_VW
|
| 22 |
SETID_LBR_AGRMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Labor Agreement SetID
|
| 23 |
WPP_STOP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
Y/N Table Edit
Default Value: N
|
| 24 |
LABOR_FACILITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Labor Facility ID
Prompt Table:
HR_LBR_FAC_VW
|
| 25 |
LBR_FAC_ENTRY_DT |
Date(10) |
DATE |
Date the Person was added to this Labor Facility.
|
| 26 |
LAYOFF_EXEMPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.
Y/N Table Edit
Default Value: N
|
| 27 |
LAYOFF_EXEMPT_RSN |
Character(11) |
VARCHAR2(11) NOT NULL |
Reason for the Exemption from Layoff
Prompt Table:
HR_LAY_EXEM_TBL
|
| 28 |
ACCDNT_CD_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
HFR
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office
|
| 29 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 30 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 31 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 32 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HCR
|
| 33 |
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
|
| 34 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|