| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Default Value: 999999
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ENTRY_TYPE_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Date From Element
Default Value: 003
Prompt Table:
GP_ENT_DATE_VW
|
| 5 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 6 |
PIN_DATE_FROM_NUM |
Number(8,0) |
INTEGER NOT NULL |
Previous Period Date From Element
Prompt Table:
%GP_EDIT_FLD1
|
| 7 |
ENTRY_TYPE_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Date To Element
Default Value: 003
Prompt Table:
GP_ENT_DATE_VW
|
| 8 |
DATE_TO |
Date(10) |
DATE |
Previous Period Date To
|
| 9 |
PIN_DATE_TO_NUM |
Number(8,0) |
INTEGER NOT NULL |
Previous Period To Date Element
Prompt Table:
%GP_EDIT_FLD2
|
| 10 |
RETURN_DECIMALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Duration With Decimals
Y/N Table Edit
Default Value: N
|
| 11 |
PERIOD_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Option
D=Days
M=Months
Y=Years
Default Value: Y
|
| 12 |
ROUND_MONTH_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Add 1 Year if >=
Y/N Table Edit
Default Value: N
|
| 13 |
ROUND_MONTH_VAL |
Number(2,0) |
SMALLINT NOT NULL |
Round Months Number
|
| 14 |
ROUND_DAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Add 1 Month if >=
Y/N Table Edit
Default Value: N
|
| 15 |
ROUND_DAY_VAL |
Number(2,0) |
SMALLINT NOT NULL |
Round Day Number
|
| 16 |
GNRN_STAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicates whether or not periods of time is included in the resolution of a duration element considers the payees employee status or not
Y/N Table Edit
Default Value: N
|
| 17 |
DUR_EMPLSTAT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Used with Duration elements. Indicates whether to include or exclude days based on the payees HR status on the day. You can further indicate whether days should be included or excluded based on the time the payee was in that status. For example:
- Always include days when payee was Active.
- Include days when payee was suspended if he was in that status for less than a month.
E=Excluded
I=Included
Default Value: I
|
| 18 |
INCL_DUR_LIMIT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to count Days 'Inclusive' or 'Exclusive' of the From and To Dates.
Y/N Table Edit
Default Value: N
|
| 19 |
INCL_ABS_HIST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Absence Days
Y/N Table Edit
Default Value: N
|
| 20 |
PIN_FRML_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_FM2_VW
|
| 21 |
GP_VERSION |
Character(18) |
VARCHAR2(18) NOT NULL |
Stores element version.
|