| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
GPFR_PAR3_CONT_FAM |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Family
Prompt Table:
GPFR_DUCS_P3_VW
|
| 3 |
GPFR_DUCS_CON_TYP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
|
| 4 |
GPFR_DUCS_CON_TYP2 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD1
|
| 5 |
GPFR_DUCS_CON_T11 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 1
Prompt Table:
GPFR_DUCS_PAR4
|
| 6 |
GPFR_DUCS_CON_T12 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Negative Contribution Type 1
Prompt Table:
GPFR_DUCS_PAR4
|
| 7 |
GPFR_DUCS_CON_T21 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 2
Prompt Table:
GPFR_DUCS_PAR4
|
| 8 |
GPFR_DUCS_CON_T22 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Negative Contribution Type 2
Prompt Table:
GPFR_DUCS_PAR4
|
| 9 |
GPFR_DUCS_ORDER |
Number(2,0) |
SMALLINT NOT NULL |
Order number in the contribution setup
|
| 10 |
GPFR_DUCS_CON_ET1 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_PINVW
|
| 11 |
GPFR_DUCS_CON_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
GPFR: Description
|
| 12 |
GPFR_DUCS_CON_ET2 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Base
Prompt Table:
GPFR_DUCS_PINVW
|
| 13 |
GPFR_DUCS_CON_BASE |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin for Base
Prompt Table:
%GP_EDIT_FLD2
|
| 14 |
GPFR_DUCS_CON_ET3 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Employee
Prompt Table:
GPFR_DUCS_PINVW
|
| 15 |
GPFR_DUCS_CON_RAT1 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin for Employee's Rate
Prompt Table:
%GP_EDIT_FLD3
|
| 16 |
GPFR_DUCS_CON_ET4 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Employer
Prompt Table:
GPFR_DUCS_PINVW
|
| 17 |
GPFR_DUCS_CON_RAT2 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin for Employer's Rate
Prompt Table:
%GP_EDIT_FLD4
|
| 18 |
GPFR_DUCS_CON_ET5 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: AT
Prompt Table:
GPFR_DUCS_PINVW
|
| 19 |
GPFR_DUCS_CON_RAT3 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin for AT Rate
Prompt Table:
%GP_EDIT_FLD5
|
| 20 |
GPFR_DUCS_CON_ET6 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Employee
Prompt Table:
GPFR_DUCS_PINVW
|
| 21 |
GPFR_DUCS_CON_AMT1 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin Employee Amount
Prompt Table:
%GP_EDIT_FLD6
|
| 22 |
GPFR_DUCS_CON_ET7 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Employer
Prompt Table:
GPFR_DUCS_PINVW
|
| 23 |
GPFR_DUCS_CON_AMT2 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Pin Employer Amount
Prompt Table:
%GP_EDIT_FLD7
|
| 24 |
GPFR_DUCS_CON_ET8 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Payee FTE
Prompt Table:
GPFR_DUCS_PINVW
|
| 25 |
GPFR_DUCS_CON_FTE1 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Payee FTE with no lump
Prompt Table:
%GP_EDIT_FLD8
|
| 26 |
GPFR_DUCS_CON_ET9 |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Payee FTE, lump sum cont
Prompt Table:
GPFR_DUCS_PINVW
|
| 27 |
GPFR_DUCS_CON_FTE2 |
Number(8,0) |
INTEGER NOT NULL |
GPFR: payee FTE with lump
Prompt Table:
%GP_EDIT_FLD9
|
| 28 |
GPFR_DUCS_CON_TRS |
Character(1) |
VARCHAR2(1) NOT NULL |
GPFR: Transportation Contribution
Y/N Table Edit
Default Value: N
|
| 29 |
GPFR_DUCS_CON_TAT |
Character(1) |
VARCHAR2(1) NOT NULL |
DUCS Additional Transportation
Y/N Table Edit
Default Value: N
|