| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 3 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table:
WAGELS_PLAN_TBL
|
| 4 |
UI_PAYABLE_DT |
Date(10) |
DATE NOT NULL |
Date EI Payable
|
| 5 |
ROE_SEQ |
Number(1,0) |
SMALLINT NOT NULL |
ROE Sequence Number
|
| 6 |
ROE_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Process
C=Complete
D=Delete
F=XML File Failed
G=Generate
H=Hold
R=XML File Rejected
X=XML File Created
Default Value: H
|
| 7 |
ROE_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Internal ROE Number
|
| 8 |
ROE_NBR_REPL |
Character(8) |
VARCHAR2(8) NOT NULL |
ROE# Amended/Replaced
|
| 9 |
ROE_DT |
Date(10) |
DATE NOT NULL |
ROE Date Created/Completed
Default Value: %date
|
| 10 |
MULTIPLE_JOBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Has Multiple Jobs
Y/N Table Edit
Default Value: N
|
| 11 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 12 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 13 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 14 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 15 |
ROE_ISSUER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ROE Issuer ID
Prompt Table:
PERSON_NAME
|
| 16 |
ROE_CONTACT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ROE Contact ID
Prompt Table:
PERSON_NAME
|
| 17 |
FIRST_DATE_WORKED |
Date(10) |
DATE NOT NULL |
First Date Worked
|
| 18 |
LAST_DATE_WORKED |
Date(10) |
DATE NOT NULL |
Last Date Worked
|
| 19 |
PD_LEAVE_START_DT |
Date(10) |
DATE |
Paid Leave Start Date
|
| 20 |
PD_LEAVE_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Paid Leave Interval
D=Daily
W=Weekly
Default Value: D
|
| 21 |
PD_LEAVE_AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Paid Leave Amount
|
| 22 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 23 |
NOT_RETURNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Not Returning
Y/N Table Edit
Default Value: N
|
| 24 |
OVRD_HRS |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
ROE Override Hours
|
| 25 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: JOB.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|
| 26 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 27 |
ROE_SERIAL_NUM |
Character(9) |
VARCHAR2(9) NOT NULL |
ROE Serial Number
|
| 28 |
AMEND_ROE_SN |
Character(9) |
VARCHAR2(9) NOT NULL |
Amended ROE Serial Number
|
| 29 |
PD_LEAVE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Leave Type
P=Paid Sick Leave
W=Wage Loss Insurance
|
| 30 |
COMMENTS |
Long Character |
CLOB |
Comment
|