| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GPGB_CAL_ID_VW
|
| 5 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPARTMENT_SRCH
|
| 6 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table:
GP_PYENT
|
| 7 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 8 |
FREQUENCY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table:
GPGB_FREQ_VW
|
| 9 |
GPGB_TAX_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Tax Period
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%RECNAME_EDIT
|
| 11 |
GPGB_TAX_BGN_YR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year Begins In This Calendar Year
|
| 12 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
Y/N Table Edit
Default Value: N
|
| 13 |
DESCR20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Description
Prompt Table:
GPGB_REPPROF_VW
|
| 14 |
GPGB_SELECTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Selection Criteria
CRI=Calendar Run ID
PE=Pay Entity
PG=Pay Group
Default Value: CRI
|
| 15 |
GPGB_FMLA_OPER |
Character(2) |
VARCHAR2(2) NOT NULL |
Operation
*=Multiply
+=Add
-=Subtract
/=Divide
<=Less Than
==Equals
>=Greater Than
G=Greater Than Or Equal To
L=Less Than Or Equal To
^=Not Equal
|
| 16 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
Prompt Table:
GPGB_PIN_VW
|
| 17 |
GPGB_GROSS |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Gross Pay
Default Value: 0
|
| 18 |
GPGB_TC_ACT_AIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate value for Tax Credit
|
| 19 |
GPGB_P60_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
P60 Indicator
Y/N Table Edit
Default Value: N
|
| 20 |
GPGB_P45_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
P45 - Draft or Final print
Y/N Table Edit
Default Value: N
|
| 21 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 22 |
GPGB_EDI_RTI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
EDI/RTI Indicator
E=EDI Indicator
R=RTI Indicator
|
| 23 |
GPGB_EP60_P60_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
electronic-P60 /P60 Indicator
E=electronic P60
N=P60
|