| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPERATOR_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GPFR_DA_SNDREF |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table:
GPFR_DA_SNDREF
|
| 4 |
GPFR_DA_RECIP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Default Value: COMPLETE
Prompt Table:
GPFR_DA_RECIP
|
| 5 |
GPFR_DA_CHSERV |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Default Value: 40
Prompt Table:
GPFR_DA_COD1_VW
|
| 6 |
GPFR_DA_PURGE |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Keep Added Data
2=Delete Added Data
Default Value: 1
|
| 7 |
GPFR_DA_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
DADS related field
|
| 8 |
GPFR_DUCS_GEN_FMT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
This field indicates the period type (year, quater, month) to be processed. It is written on the GEN record. For the Urssaf Ducs, the period type is always set to 'Period' in the file. On the DUCS extraction page, the 'Period' value is not relevant.
602=Yearly Declaration
608=Quarterly Declaration
610=Monthly Declaration
900=Period Declaration
Default Value: 602
|
| 9 |
PERIOD_BEGIN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 10 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
|
| 11 |
GPFR_DA_USEDDT |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
E=End Dates
P=Payment Dates
Default Value: E
|
| 12 |
GPFR_DA_DECLTYP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Default Value: 51
Prompt Table:
GPFR_DA_COD3_VW
|
| 13 |
GPFR_DA_DECLPRT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Default Value: 11
Prompt Table:
GPFR_DA_COD4_VW
|
| 14 |
GPFR_DA_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option for DADS Extraction Process
1=All Structures
2=Non-Payee Structures
3=Payee Structures
4=Payee Structures by Stream
5=Situation Override Only
Default Value: 1
|
| 15 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
Prompt Table:
GP_STRM
|
| 16 |
GPFR_DA_VALIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether to Validate the DADS Extraction in the DADS Extraction page or not.
Y/N Table Edit
|
| 17 |
GPFR_DA_REP_DFN |
Character(10) |
VARCHAR2(10) NOT NULL |
Report Definition for Summarized data
Prompt Table:
GPFR_DA_SUM_VW
Set Control Field: GPFR_DA_REP_DFN
|
| 18 |
GPFR_DA_REPDFN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS Report Definition Flag
Y/N Table Edit
|