| # |
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 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 5 |
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
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 7 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
|
| 8 |
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.
|
| 9 |
TRGT_CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar to which retro deltas are targeted or forwarded
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 16 |
PYE_SELECT_PI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Input Indicator
|
| 17 |
PYE_SELECT_RTO_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Retro Option
|
| 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
|
| 19 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 20 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
|
| 21 |
GP_PRD_PREFIX |
Character(9) |
VARCHAR2(9) NOT NULL |
Period Prefix field
|
| 22 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 23 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 24 |
DUPLICATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Flag
|
| 25 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 26 |
SRC_CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Calendar ID
|
| 27 |
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
|