| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 3 |
PAY_END_DT |
Date(10) |
DATE NOT NULL |
Pay Period End Date
Prompt Table:
PAY_CALENDAR
|
| 4 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 5 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
Prompt Table:
PAY_PAGE
|
| 6 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 8 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table:
PER_ORG_ASGN_VW
|
| 9 |
BENEFIT_RCD_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
Prompt Table:
PER_ORG_ASGN_VW
|
| 10 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 11 |
JOB_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Pay Data Change
N=No
R=Calculation Required
Y=Yes
Default Value: N
|
| 12 |
PARTIAL_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Pay Period
Y/N Table Edit
Default Value: N
|
| 13 |
CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
Y/N Table Edit
Default Value: N
|
| 14 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 15 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 16 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 17 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 18 |
MANUAL_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Check
N=No
R=Reversal
Y=Yes
Default Value: N
|
| 19 |
FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
Prompt Table:
PAY_FORM_TBL
|
| 20 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 21 |
CHECK_DT |
Date(10) |
DATE |
Check date.
|
| 22 |
TOTAL_GROSS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Gross
|
| 23 |
NET_PAY |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Net Pay
|
| 24 |
PAYCHECK_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Paycheck Adjustment Entry
N=Reversal
Y=Reversal/Adjustment
Y/N Table Edit
Default Value: N
|
| 25 |
SINGLE_CHECK_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
How is Single Check Used
C=Check Only
N=Not Applicable
P=Paysheet Only
Default Value: N
|
| 26 |
TL_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Time && Labor Source Flag
T=Time and Labor Record
U=User Updated/Created Record
|
| 27 |
PAY_SHEET_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Paysheet
F=FLSA Paysheet
K=Batch Final Check
L=Online Final Check
O=On-line Paysheet
P=Paysheet Load
S=Regular Paysheet
Default Value: S
|
| 28 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: JOB.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|
| 29 |
LOCKED_FOR_CONF |
Character(1) |
VARCHAR2(1) NOT NULL |
Locked for Confirm
Y/N Table Edit
Default Value: N
|