| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 4 |
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
|
| 5 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 6 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GP_PSLP_CAL_VW
|
| 7 |
GP_CNTRY_PSLP_ASET |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 8 |
GP_PSLP_DLVRY_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Payslip Delivery Option
ADDR=Address Type
DEPT=Department
DROP=Mail Drop
LOCN=Location
MAIL=Mailing Address
NONE=None
OTHL=Other Location
OTHM=Other Mail Drop
|
| 9 |
GP_PSLP_ASGN_SET |
Character(12) |
VARCHAR2(12) NOT NULL |
Assignment Set
|
| 10 |
GP_PSLP_DFLT_HDCPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Payslip Hard Copy Option
|
| 11 |
GP_CNTRY_PSLP_ASGN |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 12 |
GP_PSLP_ASGN_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Assignment Code
|
| 13 |
GP_CNTRY_PSLP_TMPL |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 14 |
GP_PSLP_TMPL |
Character(12) |
VARCHAR2(12) NOT NULL |
This field is used to uniquely identify a payslip template.
|
| 15 |
GP_PSLP_SORT |
Character(12) |
VARCHAR2(12) NOT NULL |
Payslip Sort
|
| 16 |
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
|
| 17 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 18 |
GROUP_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group List ID
|
| 19 |
GP_PSLP_PRT_DRAFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print payslip draft flag
Y/N Table Edit
Default Value: N
|
| 20 |
GP_PSLP_OVRD_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Language control for the payees language
Y/N Table Edit
|
| 21 |
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
|
| 22 |
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
|
| 23 |
GP_PSLP_ASGN_POP |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment Set Population for State Record
|
| 24 |
SQL_ID1 |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
|
| 25 |
SQL_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
|
| 26 |
SQL_ID3 |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
|
| 27 |
GP_CNTRY_PSLP_ELN |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 28 |
GP_ELN_SET |
Character(15) |
VARCHAR2(15) NOT NULL |
Element Set
|
| 29 |
IF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If flag
|
| 30 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 31 |
SEQ_NO3 |
Number(3,0) |
SMALLINT NOT NULL |
7/23/03 Lee - ICE 608075000 - This is a generic sequence number field, with three integer positions.
|
| 32 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 33 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
|
| 34 |
GP_CNTRY_PSLP_DFTM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to retrieve the Default Template Country for an assignment
|
| 35 |
GP_PSLP_DFLT_TMPL |
Character(12) |
VARCHAR2(12) NOT NULL |
This field is used to retrieve the default payslip template for an assignment
|
| 36 |
PAYMENT_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
|
| 37 |
GP_CNTRY_PSLP_TMSS |
Character(3) |
VARCHAR2(3) NOT NULL |
ePay Template Country
|
| 38 |
GP_PSLP_TMPL_SS |
Character(12) |
VARCHAR2(12) NOT NULL |
ePay Template (Self Service)
|
| 39 |
GP_CNTRY_PSLP_MSG |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 40 |
GP_PSLP_MSG_NBR |
Number(5,0) |
INTEGER NOT NULL |
This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,
|
| 41 |
GP_PSLP_MSG_AVAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Availability
A=Always Active
C=Calendar Group ID
D=Date Range
|
| 42 |
DEFN_ASOFDT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
DEFN_ASOFDT_OPTN
B=Calendar Period Begin Date
E=Calendar Period End Date
N=Not Applicable
P=Payment Date
R=Process Begin Date
S=Process End Date
|
| 43 |
GP_FROM_DT |
Date(10) |
DATE |
From Date
|
| 44 |
GP_TO_DT |
Date(10) |
DATE |
To Date
|
| 45 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 46 |
GP_PSLP_FROM_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Beginning Payslip ID in a range
|
| 47 |
GP_PSLP_TO_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Payslip ID in a range
|
| 48 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 49 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 50 |
GP_PSLP_DATAINST |
Number(10,0) |
DECIMAL(10) NOT NULL |
This field is the job instance used internally by the processes in the Payslip Job Definition
|
| 51 |
GP_PSLP_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control Name
|
| 52 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
|
| 53 |
GP_PSLP_TMPL_PRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Templates to be Processed
A=All Templates in Set
S=Specific Template
|
| 54 |
GP_CNTRY_PSLP_TMSP |
Character(3) |
VARCHAR2(3) NOT NULL |
Specific Template Country
|
| 55 |
GP_PSLP_TMPL_SPC |
Character(12) |
VARCHAR2(12) NOT NULL |
This field is used to select specific templates
|
| 56 |
SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|
| 57 |
PMT_GRP_ID |
Number(3,0) |
SMALLINT NOT NULL |
Group Id for grouping payment
|
| 58 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 59 |
GP_PSLP_RGEN_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Regenerate Payslip option
BOTH=Payslip and ePay
EPAY=ePay only
PSLP=Payslip only
|
| 60 |
GP_PSLP_ISSUEHDCPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Issue Hard Copy of payslip posed in the form of to Suppress the paper copy or to print it. Y means to suppress (do not print). N means to not suppress (print it).
N=Do Not Issue Paper Copies
Y=Issue Paper Copies
|
| 61 |
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
|
| 62 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|