| # |
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 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GP_FREQ_PRD_VW
|
| 4 |
AUTO_CAL_PERIOD_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 6 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table:
GP_RUN_TYPE_VW
|
| 7 |
FREQUENCY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table:
GP_FREQ_PRD_VW2
|
| 8 |
GP_CAL_ID_SUFFIX |
Character(8) |
VARCHAR2(8) NOT NULL |
Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality
|
| 9 |
TRGT_CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar to which retro deltas are targeted or forwarded
Prompt Table:
GP_CALENDAR4_VW
|
| 10 |
DAYS_ADJUSTMENT |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Days Adjustment
|
| 11 |
DAY_OF_WK |
Character(1) |
VARCHAR2(1) NOT NULL |
Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 6
|
| 12 |
PAY_ADJ_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Type - This field is used in GP Automatic Calendar Creation to specify the type of adjustment of payment date
1=Days From Period End Date
2=Specific Day of the Week
Default Value: 1
|
| 13 |
PRD_END_DT_PAY_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used in case that we are paying on an specific day and the day doesn't matches with the Calendar End Date, so we adjust the date one day before or after Period End Dt.
1=On Or Before Period End Date
2=On Or After Period End Date
Default Value: 1
|
| 14 |
HOLIDAY_PAY_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field refers to how are we going to adjust the Payment Date if it's a Holiday.
1=Payment Date does not change
2=Payment Date is the day before
3=Payment Date is the day after
Default Value: 2
|
| 15 |
PYE_SELECT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee Select Option
A=Active Payees Only
B=Active Payees with...
C=Active PLUS Payees with...
D=All Payees with...
L=Listed Payees Only
Default Value: A
|
| 16 |
PYE_SELECT_PI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Input Indicator
Y/N Table Edit
Default Value: N
|
| 17 |
PYE_SELECT_RTO_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Retro Option
Y/N Table Edit
Default Value: N
|
| 18 |
SEL_CRIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Criteria Option
0=Payee List
1=All Active
2=Active with PI
3=Active with Retro Trigger
4=Active with PI or Rto Trigger
5=Active or has PI
6=Active or has Retro Trigger
7=Active or has PI or Rto Trgr
8=All payees with PI
9=All payees with Retro Changes
A=All with PI or Retro Trigger
|