| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PYRE_TMPLT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets Template Type
A=Amount
B=Hours or Amounts
H=Hours
|
| 2 |
PYRE_TMPLT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Template ID for Rapid Entry Paysheets
Prompt Table:
PYRE_TEMPLATE
|
| 3 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
PAY_RUN_TBL
|
| 4 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PYRE_HEADER.OPRID
|
| 6 |
EARNS_BEGIN_DT |
Date(10) |
DATE NOT NULL |
Earnings Begin Date
|
| 7 |
EARNS_END_DT |
Date(10) |
DATE NOT NULL |
Earnings End Date
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 9 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 0
|
| 10 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 12 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 13 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
Default Value: PYRE_TEMPLATE.ERNCD
|
| 14 |
PYRE_ERNTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets: Defines the type of earning.
A=Amount
H=Hours
Default Value: PYRE_TEMPLATE.PYRE_ERNTYP
|
| 15 |
EARNS_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Earnings Amount
|
| 16 |
EARNS_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Earnings Hours
|
| 17 |
ERNCD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Rapid Paysheets Earning Code
Default Value: PYRE_TEMPLATE.ERNCD2
|
| 18 |
PYRE_ERNTYP2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets: Defines the type of earning.
A=Amount
H=Hours
Default Value: PYRE_TEMPLATE.PYRE_ERNTYP2
|
| 19 |
EARNS_AMT2 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Pay period earnings amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 20 |
EARNS_HRS2 |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 21 |
ERNCD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Rapid Paysheets Earning Code
Default Value: PYRE_TEMPLATE.ERNCD3
Prompt Table:
%RECNAME_EDIT
|
| 22 |
PYRE_ERNTYP3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets: Defines the type of earning.
A=Amount
H=Hours
Default Value: PYRE_TEMPLATE.PYRE_ERNTYP3
|
| 23 |
EARNS_AMT3 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Pay period earnings amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 24 |
EARNS_HRS3 |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 25 |
ERNCD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Rapid Paysheets Earning Code
Prompt Table:
%RECNAME_EDIT
|
| 26 |
PYRE_ERNTYP4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets: Defines the type of earning
A=Amount
H=Hours
|
| 27 |
EARNS_AMT4 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Pay period earnings amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 28 |
EARNS_HRS4 |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Pay period hours amount. Used for public assistance data on Employment and Salary Verification integration file extract process.
|
| 29 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
Default Value: 0
|
| 30 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit
Default Value: N
|
| 31 |
PYRE_PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Rapid Paysheets: Detail record has been successfully validated.
Default Value: Y
|
| 32 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Default Value: PYRE_RUNID_HDR.GB_GROUP_ID
|