| # |
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 |
GP_PSLP_PRCSNAME |
Character(4) |
VARCHAR2(4) NOT NULL |
Payslip Calling Process Name
COPY=Reprint Payslip Copy
GEN=Generate Payslip
RGEN=Regenerate Payslip
RNUM=Renumber Payslip
|
| 4 |
GP_PSLP_PRCS_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payslip Batch Pusrocess Sta
I=In Process
N=New
P=Processed
X=No Data Extracted for Process
Default Value: N
|
| 5 |
GP_PSLP_PROCNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
ePay Procedure Name
COPY=Reprint Payslip Copy
GEN=Generate Payslip
RGEN=Regenerate Payslip
RNUM=Renumber Payslip
|
| 6 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GP_PSLP_CAL2_VW
|
| 7 |
GP_CNTRY_PSLP_ASET |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
|
| 8 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 9 |
GP_PSLP_ASGN_SET |
Character(12) |
VARCHAR2(12) NOT NULL |
Assignment Set
Prompt Table:
GP_PSLP_ASGN_ST
|
| 10 |
GP_CNTRY_PSLP_SORT |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
|
| 11 |
GP_PSLP_SORT |
Character(12) |
VARCHAR2(12) NOT NULL |
Payslip Sort
Prompt Table:
GP_PSLP_SORT
|
| 12 |
GP_PSLP_POPUL_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Payslip Population Selection
A=All Payees
E=Payee
F=Formula Element
G=Human Resources Group
O=Other Criteria
P=Global Payroll Payee List
Default Value: A
Prompt Table:
GP_PSLP_POP2_VW
|
| 13 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_SEC_VW
|
| 14 |
GROUP_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group List ID
Prompt Table:
GP_GRP_LIST_VW
|
| 15 |
GP_PSLP_PRT_CAT |
Character(4) |
VARCHAR2(4) NOT NULL |
This field contains the different detailed criteria choices for a population of payees to receive a printed payslip
COMP=Company
DEPT=Department
ESTA=Establishment
LOCN=Location
PAYG=Pay Group
PYEE=Payee
PYEN=Pay Entity
STRM=Stream Number
|
| 16 |
GP_PSLP_PRT_DRAFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print payslip draft flag
Y/N Table Edit
Default Value: N
|
| 17 |
GP_PSLP_OVRD_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Language control for the payees language
Y/N Table Edit
Default Value: N
|
| 18 |
GP_PSLP_FROM_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Beginning Payslip ID in a range
Prompt Table:
GP_PSLP_GDE_VW
|
| 19 |
GP_PSLP_TO_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Payslip ID in a range
Prompt Table:
GP_PSLP_GDE_VW
|
| 20 |
GP_PSLP_ORIG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payslip print indicator that this is an original printing
Y/N Table Edit
Default Value: N
|
| 21 |
PYMT_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Payment Identification
Prompt Table:
GP_PYMT_ID_DEFN
|
| 22 |
PYMT_NBR |
Number(18,0) |
DECIMAL(18) NOT NULL |
Payment Number
Prompt Table:
GP_PYMT_BNK_VW
|
| 23 |
PYMT_NBR_FROM |
Number(18,0) |
DECIMAL(18) NOT NULL |
from payment number
Prompt Table:
GP_PYMT_BNK_VW
|
| 24 |
PYMT_NBR_TO |
Number(18,0) |
DECIMAL(18) NOT NULL |
to payment number
Prompt Table:
GP_PYMT_BNK_VW
|
| 25 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 26 |
RECON_STAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Reconciliation Status
01=Unreconciled
02=Reconciled
03=Date Difference
04=Not Found
05=Amount Difference
06=Duplicate
07=Expired
08=Stop Payment
09=Unclaimed
10=Different Pay Method
11=Void
12=Re-Numbered
|
| 27 |
GP_PSLP_TMPL_PRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Templates to be Processed
A=All Templates in Set
S=Specific Template
Default Value: A
|
| 28 |
GP_CNTRY_PSLP_TMPL |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
|
| 29 |
GP_PSLP_TMPL |
Character(12) |
VARCHAR2(12) NOT NULL |
This field is used to uniquely identify a payslip template.
Prompt Table:
GP_PSLP_TPL1_VW
|
| 30 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
Prompt Table:
GP_STRM
|
| 31 |
GP_PSLP_RGEN_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Regenerate Payslip option
BOTH=Payslip and ePay
EPAY=ePay only
PSLP=Payslip only
Default Value: BOTH
|
| 32 |
GP_PSLP_RGEN_PRT |
Character(4) |
VARCHAR2(4) NOT NULL |
Regenerate Payslip print option
CURR=Use current payee option
ORIG=Use option on original payslip
PRNT=Issue paper copy for all
Default Value: ORIG
|