| # |
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 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
PAY_RUN_TBL
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 5 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 6 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
Prompt Table:
PAY_CALENDAR
|
| 7 |
CYCLE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle
Default Value: B
|
| 8 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 9 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
Prompt Table:
PAY_PAGE
|
| 10 |
PAGE_NUM_THRU |
Number(5,0) |
INTEGER NOT NULL |
Thru Page Number
Prompt Table:
PAY_PAGE
|
| 11 |
PRENOTE_DT |
Date(10) |
DATE |
Prenote Date
|
| 12 |
TEXT15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Text (15 Characters)
|
| 13 |
TEXT20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Text (20 Characters)
|
| 14 |
CHKADV_NO_START |
Number(15,0) |
DECIMAL(15) NOT NULL |
Starting Check/Advice Number
|
| 15 |
CHKADV_NO_THRU |
Number(15,0) |
DECIMAL(15) NOT NULL |
Thru Check/Advice Number
|
| 16 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 17 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Definition Name
|
| 18 |
DEL_RUNCTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Run Control
Default Value: N
|
| 19 |
RENEWAL_DAYS_OUT |
Number(3,0) |
SMALLINT NOT NULL |
Public Sector Extension
This is a run control field. It is used to indicate the number of days forward from the current date within which the batch process (CNTPAY02.SQR) will search for expiring contracts to be renewed.
|
| 20 |
SEPCHK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit
Default Value: N
|
| 21 |
RPT_DETAIL_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level of Report Detail
C=Claim-Level Detail
D=Line-Item Detail Level
R=Summary by Selection
S=Detail Report
Default Value: R
|
| 22 |
DIST_PRORATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Prorate Option
C=Calendar Days
I=For Internal System Use Only
N=Not Applicable
W=Work Days
Default Value: C
|
| 23 |
HP_USE_HOL_SCHD |
Character(1) |
VARCHAR2(1) NOT NULL |
To specify if Holiday Schedule is referenced
Y/N Table Edit
Default Value: N
|
| 24 |
REVIEW_DIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Distribution before GL indicator.
Y/N Table Edit
Default Value: N
|
| 25 |
PY_SSP_BGNSSDFLT |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Days After Payment Date Payslip becomes Available Online.
ePay View Payslip page will read this value prior to displaying which payslips are available for viewing and only show payslips that meet the criteria entered here (in days).
Default Value: 0
|
| 26 |
PY_SSP_MAN_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manual Chk
Default Value: N
|
| 27 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 28 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
Empl ID To
|
| 29 |
PY_BATCH_SIZE |
Number(7,0) |
INTEGER NOT NULL |
Number of rows that will be process per batch.
Default Value: 0
|
| 30 |
SELECT_EMPLOYEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Employee
Y/N Table Edit
Default Value: N
|
| 31 |
PY_DDP_SEP_FILES |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether a user would like to create separate files for IAT vs DDP transactions when running the DDP001.sqr to create the US Direct deposit file.
Y/N Table Edit
Default Value: N
|
| 32 |
PY_DDP_EXCL_OFFS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate whether a user would like to exclude the offset records from the US Direct deposit file when running DDP001.sqr
Y/N Table Edit
Default Value: N
|
| 33 |
PY_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action code.
R=Report Only
U=Update
Default Value: R
|
| 34 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 35 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 36 |
FILE_DIRECTORY |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|