| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MASS_RETRO_RQST_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table:
MASS_RETRO_RQST
|
| 2 |
MASS_RETRO_SEQ_NO |
Number(8,0) |
INTEGER NOT NULL |
Mass Retro Sequence Number
|
| 3 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 4 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 5 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 6 |
JOBCODE_ELIG_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Job Eligibility Days
|
| 7 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 8 |
LOCATION_ELIG_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Location Eligibility Days
|
| 9 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 10 |
UNION_CD_ELIG_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Union Code Eligibility Days
|
| 11 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 12 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 13 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 14 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
Prompt Table:
EMPL_CL_STD_VW
|
| 15 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 16 |
MASS_PRCS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Retro Pay Process Flag
C=Calculated
D=Request Deleted
L=Loaded To Retro Pay Request
N=Not Processed
P=Loaded to Paysheets
X=Extracted
Default Value: N
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: JOB.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|