| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 2 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GP_CAL_PRD1_VW
|
| 3 |
OFF_CYCLE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GP_PG_PERS_SRCH
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table:
GP_PGRP_JOB_VW
|
| 6 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 7 |
GPBR_TERM_NOTIF |
Date(10) |
DATE |
Termination Notification
|
| 8 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
GPBR_TER_ACT_VW
|
| 9 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 10 |
GPBR_SOURCE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Source ID
BAT=Batch Source
USE=User Source
|
| 11 |
GPBR_TER_PROC_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payee Process Status for Mass Termination Process
NEW=New
OFF=Off Cycle Request
|
| 12 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
|
| 13 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 14 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 16 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 17 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 18 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 19 |
GPBR_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Process Time Stamp for Mass Termination
|
| 20 |
GPBR_ORD_CRITERIA |
Number(3,0) |
SMALLINT NOT NULL |
Order Criteria
|
| 21 |
SOURCE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
This is used to identify a defined input source for a Configurable Matrix. A Source is a named item with data type attributes and resolution rules. The resolution rules tell the Source how, given an orientation, the Source should dynamically determine it's own value for use in a Matrix lookup.
|
| 22 |
GPBR_TERM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Termination Reason for Termination Process Brazil
01=Employer Decision Fair Cause
02=Employer Decision Unfair Cause
03=Employee Decision Fair Cause
04=Employee Decision Unfair Cause
05=Transfer Without Onus
06=Transfer With Onus
07=Transfer Reform for Reserves
08=Death
09=Other Cause
10=Contract Termination
11=Retirement by Service Time
12=Retire by Disability, Work Acc
13=Retire by Disability, Sickness
14=Mutual Fault
15=Ret. by ServTime /Contract Ter
16=Retirement by Age
17=Compulsory Retirement
18=Work Regime Change
19=Death by Work Related Accident
20=Death by Professional Sickness
21=Ret. with Continued Employment
22=Indirect Termination
23=Payee's Anticipated Breach
24=Major Causes
25=Employer's Ant Breach - Unfair
26=Employer's Ant Breach - Fair
27=Closing Down of Establishment
|
| 23 |
GPBR_TERM_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Termination Version
|