| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
PAY_RUN_TBL
|
| 5 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 6 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 7 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
Prompt Table:
PAY_CALENDAR
|
| 8 |
CYCLE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle
Default Value: B
|
| 9 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 10 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
Prompt Table:
PAY_PAGE
|
| 11 |
PAGE_NUM_THRU |
Number(5,0) |
INTEGER NOT NULL |
Thru Page Number
Prompt Table:
PAY_PAGE
|
| 12 |
PRENOTE_DT |
Date(10) |
DATE |
Prenote Date
|
| 13 |
TEXT15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Text (15 Characters)
|
| 14 |
TEXT20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Text (20 Characters)
|
| 15 |
CHKADV_NO_START |
Number(15,0) |
DECIMAL(15) NOT NULL |
Starting Check/Advice Number
|
| 16 |
CHKADV_NO_THRU |
Number(15,0) |
DECIMAL(15) NOT NULL |
Thru Check/Advice Number
|
| 17 |
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.
|
| 18 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Definition Name
|
| 19 |
DEL_RUNCTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Run Control
Default Value: N
|
| 20 |
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.
Default Value: 1
|
| 21 |
SEPCHK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit
Default Value: N
|
| 22 |
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
|
| 23 |
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
|
| 24 |
HP_USE_HOL_SCHD |
Character(1) |
VARCHAR2(1) NOT NULL |
To specify if Holiday Schedule is referenced
Y/N Table Edit
Default Value: N
|
| 25 |
OVERRIDE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit
Default Value: N
|
| 26 |
HPIP_CONSOLIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Accounting Lines
Y/N Table Edit
Default Value: N
|
| 27 |
HPIP_BALANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance Accounting Lines
Y/N Table Edit
Default Value: N
|
| 28 |
HPIP_BK_SUSP |
Character(1) |
VARCHAR2(1) NOT NULL |
Book to Suspense Account
|
| 29 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
|
| 30 |
LAST_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 31 |
HPIP_VALID_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Validation status
|
| 32 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 33 |
GL_RUN_NUM |
Number(3,0) |
SMALLINT NOT NULL |
GL Run Control Number
|