| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
eligibility group
Prompt Table:
GP_ELIG_GRP
|
| 5 |
SCHEDULE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
Prompt Table:
SCH_DEFN_CMN_VW
|
| 6 |
ALT_WRK_SCHED_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
TR Alternate Schedule ID
Prompt Table:
SCH_DEFN_CMN_VW
Set Control Field: ALT_SCHEDULE_GRP
|
| 7 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_TBL
|
| 8 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 9 |
ASOF_DT_EXCHNG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
As of Date for Exchange Rate
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date
Default Value: E
|
| 10 |
PIN_PRO_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_PO0_VW
|
| 11 |
FREQ_ID_MONTHLY |
Character(5) |
VARCHAR2(5) NOT NULL |
Monthly Frequency
Default Value: M
Prompt Table:
GP_M_FRQ_TBL_VW
|
| 12 |
FREQ_ID_DAILY |
Character(5) |
VARCHAR2(5) NOT NULL |
Daily Frequency
Default Value: D
Prompt Table:
DAY_FREQ_TBL_VW
|
| 13 |
RND_OPTN_BASE_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
rounding option base
NR=No Rounding
SP=Use Specified Rounding
Default Value: NR
|
| 14 |
RND_OPTN_RATE_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
rounding option rate
NR=No Rounding
SP=Use Specified Rounding
Default Value: NR
|
| 15 |
RND_OPTN_UNIT_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
rounding option unit
NR=No Rounding
SP=Use Specified Rounding
Default Value: NR
|
| 16 |
RND_OPTN_PCT_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
rounding option percent
NR=No Rounding
SP=Use Specified Rounding
Default Value: NR
|
| 17 |
RND_OPTN_RSLV_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
rounding option resolved
NR=No Rounding
SP=Use Specified Rounding
Default Value: NR
|
| 18 |
PIN_RND_BASE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_RR0_VW
|
| 19 |
PIN_RND_RATE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_RR0_VW
|
| 20 |
PIN_RND_UNIT_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_RR0_VW
|
| 21 |
PIN_RND_PCT_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_RR0_VW
|
| 22 |
PIN_RND_RSLV_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_RR0_VW
|
| 23 |
PRORATION_OPTN_PG |
Character(2) |
VARCHAR2(2) NOT NULL |
Proration Option
NP=No Proration
SP=Use Specific Proration
Default Value: NP
|
| 24 |
SCHEDULE_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduling Organizational Group Code
Prompt Table:
SCH_GROUP_TBL
|
| 25 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 26 |
ROTATION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Rotation ID
Prompt Table:
SCH_DEFN_ROT_VW
|
| 27 |
ALT_SCHEDULE_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Schedule Group code
Prompt Table:
SCH_GROUP_TBL
|
| 28 |
SETID_SCHED |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID for Schedule ID
|
| 29 |
ROTATION_ID_ALT |
Character(10) |
VARCHAR2(10) NOT NULL |
Rotation ID of relating to the Alternate Schedule
Prompt Table:
SCH_DEFN_ROTAVW
Set Control Field: ALT_SCHEDULE_GRP
|