| # |
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_SEQ_NUM |
Number(8,0) |
INTEGER NOT NULL |
Calendar Sequence Number
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_AT_PYGRP_VW
|
| 5 |
GP_CAL_GRP_PREFIX |
Character(16) |
VARCHAR2(16) NOT NULL |
Calendar Run Id
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 7 |
GP_CAL_FREQ_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar Type for auto calendar group creation
|
| 8 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 9 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 10 |
GP_CALGRP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Number of Calendar Groups
|
| 11 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 12 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 13 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
Prompt Table:
GP_CALENDAR6_VW
|
| 14 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table:
GP_RUN_TYPE_VW
|
| 15 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GP_FIRST_PRD_VW
|
| 16 |
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:
FREQUENCY_TBL
|
| 17 |
GP_CAL_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar exists
Y/N Table Edit
Default Value: N
|
| 18 |
GP_PERIOD_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar exists
Y/N Table Edit
Default Value: Y
|
| 19 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GP_ABS_CAL_VW1
|
| 20 |
TRGT_CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar to which retro deltas are targeted or forwarded
Prompt Table:
%GP_EDIT_FLD1
|
| 21 |
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
|
| 22 |
GP_CAL_ID_PREFIX |
Character(7) |
VARCHAR2(7) NOT NULL |
Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality
|
| 23 |
AUTO_CAL_UOM |
Character(2) |
VARCHAR2(2) NOT NULL |
Unit of measure used in automatic period generation
10=Number of Days
20=Number of Months
30=Semimonthly
|
| 24 |
REPEAT_FREQUENCY |
Number(2,0) |
SMALLINT NOT NULL |
Units in Period
|
| 25 |
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
|
| 26 |
DAYS_ADJUSTMENT |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Days Adjustment
|
| 27 |
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
|
| 28 |
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
|
| 29 |
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
|
| 30 |
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
|
| 31 |
PYE_SELECT_PI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Input Indicator
Y/N Table Edit
Default Value: N
|
| 32 |
PYE_SELECT_RTO_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Retro Option
Y/N Table Edit
Default Value: N
|
| 33 |
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
|
| 34 |
PRD_FREQ_SUFFIX |
Character(1) |
VARCHAR2(1) NOT NULL |
Use this field to store a period frequency suffix used in automatic period creation to build the complete suffix for Period ID. This field 'defaults' for the first letter of the Frequency selected, but it is editable
|
| 35 |
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
|
| 36 |
CAL_PRD_ID_OFF_CYL |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GP_OFFCY_PRD_VW
|
| 37 |
AUTO_OFF_CYCLE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments
|
| 38 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|