| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GPFR_DA_SIGN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add
S=Subtract
|
| 3 |
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
|
| 4 |
GP_RPT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Extraction Process Name
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 8 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 9 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 10 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 11 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 12 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 13 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 14 |
GPFR_DA_SNDREF |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table:
GPFR_DA_SNDREF
|
| 15 |
GPFR_DA_RECIP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 16 |
GPFR_DA_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field
Prompt Table:
COMPANY_TBL
|
| 17 |
GPFR_DA_EMPLID |
Character(16) |
VARCHAR2(16) NOT NULL |
DADS related field
|
| 18 |
GPFR_DA_BGNDT |
Date(10) |
DATE |
DADS related field
|
| 19 |
GPFR_DA_ENDDT |
Date(10) |
DATE |
DADSD related field
|
| 20 |
GPFR_DA_FEEREF |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS related field
|
| 21 |
GPFR_DA_ESTAB |
Character(12) |
VARCHAR2(12) NOT NULL |
DADS related field
Prompt Table:
ESTAB_TBL
|
| 22 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 23 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 24 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 25 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 26 |
GPFR_DA_ACT_BGN |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field
|
| 27 |
GPFR_DA_REA_BGN |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 28 |
GPFR_DA_DT_BGN |
Date(10) |
DATE |
DADS related field.
|
| 29 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 30 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 31 |
ACTION_DT |
Date(10) |
DATE |
Action Date
|
| 32 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 33 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 34 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 35 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 36 |
CLNG_CALPRCT_GPFRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
|
| 37 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 38 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 39 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 40 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 41 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 42 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 43 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
|
| 44 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 1
|
| 45 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 2
|
| 46 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 3
|
| 47 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 4
|
| 48 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 5
|
| 49 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
|
| 50 |
GPFR_DA_PROFST |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 51 |
GPFR_DA_CTGST |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 52 |
SS_REGIM_CD_GPFRA |
Number(3,0) |
SMALLINT NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
|
| 53 |
GPFR_DA_AG_PEN_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
DADS related field
|
| 54 |
GPFR_DA_AG_PEN_NUM |
Character(4) |
VARCHAR2(4) NOT NULL |
DADS related
|
| 55 |
GPFR_DA_AG_MEM_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS related field
|
| 56 |
GPFR_DA_AG_POP_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field
|
| 57 |
GPFR_DA_AG_CON_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 58 |
GPFR_DA_AR_PEN_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
DADS related field
|
| 59 |
GPFR_DA_AR_PEN_NUM |
Character(4) |
VARCHAR2(4) NOT NULL |
DADS related field
|
| 60 |
GPFR_DA_AR_MEM_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS related field
|
| 61 |
GPFR_DA_AR_POP_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field
|
| 62 |
GPFR_DA_AR_CON_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 63 |
AT_SECTION |
Character(2) |
VARCHAR2(2) NOT NULL |
AT SECTION
|
| 64 |
RISKCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Risk Code
|
| 65 |
GPFR_DA_ATCODE |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 66 |
STANDARD_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Standard Rate
|
| 67 |
GPFR_DA_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Mandatory Base Scheme used for DADS
|
| 68 |
GPFR_DA_MIN_B_SIT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 69 |
GPFR_DA_OVR_B_SIT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 70 |
GPFR_DA_MIN_E_SIT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 71 |
GPFR_DA_OVR_E_SIT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 72 |
GPFR_DA_OVR_ES_SIT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 73 |
GPFR_DA_CHSERV |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 74 |
GPFR_DA_TESTIND |
Character(10) |
VARCHAR2(10) NOT NULL |
DADs related field
|
| 75 |
GPFR_DA_PURGE |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Keep Added Data
2=Delete Added Data
|
| 76 |
GPFR_DA_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
DADS related field
|
| 77 |
GPFR_DA_USEDDT |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
E=End Dates
P=Payment Dates
|
| 78 |
GPFR_DA_DECLTYP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 79 |
GPFR_DA_DECLNAT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 80 |
GPFR_DA_DECLPRT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 81 |
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
|
| 82 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
|
| 83 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 84 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 85 |
REPEAT_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Repeat Number
|
| 86 |
PAYROLL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use by the Employee Survey application engine to determine to determine whether an indicator is related to payroll or not.
|
| 87 |
GPFR_DA_STRUCT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 88 |
GPFR_DA_RECORD |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related record
|
| 89 |
GPFR_DA_ST_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
DADS related field
|
| 90 |
GPFR_DA_REC_NUM |
Number(5,0) |
INTEGER NOT NULL |
DADS related field
|
| 91 |
GPFR_DA_PR_NUM |
Number(3,0) |
SMALLINT NOT NULL |
DADS related field.
|
| 92 |
GPFR_DA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
F=Fixed
M=Monetary
N=Numeric
T=Text
|
| 93 |
GPFR_DA_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
DADS related field
|
| 94 |
GPFR_DA_DECIMAL |
Number(2,0) |
SMALLINT NOT NULL |
DADS related field
|
| 95 |
GPFR_DA_LBLSRC |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Data Type
2=Record
3=Translate Value
|
| 96 |
GPFR_DA_DATSRC |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
0=System-Computed
1=Accumulator User Key 1
10=Base
11=Percent
12=Rate
13=Unit
14=Customer Field1
15=Customer Field2
16=Customer Field3
17=Customer Field4
18=Customer Field5
2=Accumulator User Key 2
3=Accumulator User Key 3
4=Accumulator User Key 4
5=Payroll Result Value
6=Fixed Text
7=Not Computed
8=Accumulator User Key 5
9=Accumulator User Key 6
|
| 97 |
GPFR_DA_SUMOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Sum
2=First
3=Last
|
| 98 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 99 |
GPFR_DA_BGN_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 100 |
GPFR_DA_BGN_RSN2 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 101 |
GPFR_DA_BGN_RSN3 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 102 |
GPFR_DA_BGN_RSN4 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 103 |
GPFR_DA_BGN_RSN5 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 104 |
END_DT |
Date(10) |
DATE |
end date
|
| 105 |
GPFR_DA_END_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 106 |
GPFR_DA_END_RSN2 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 107 |
GPFR_DA_END_RSN3 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 108 |
GPFR_DA_END_RSN4 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 109 |
GPFR_DA_END_RSN5 |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field.
|
| 110 |
GPFR_DA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 111 |
GPFR_DA_NUM_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
DADS related field
|
| 112 |
GPFR_DA_NUM_NROUND |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Not Rounded Value
|
| 113 |
GPFR_DA_CHR_VALUE |
Character(120) |
VARCHAR2(120) NOT NULL |
DADS related field
|
| 114 |
GPFR_MEMBERSHIP |
Character(35) |
VARCHAR2(35) NOT NULL |
Membership number for AGIRC, ARRCO and others
|
| 115 |
PERIOD_BEGIN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 116 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
|
| 117 |
USER_KEY1 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 1
|
| 118 |
USER_KEY2 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 2
|
| 119 |
USER_KEY3 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 3
|
| 120 |
USER_KEY4 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 4
|
| 121 |
USER_KEY5 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 5
|
| 122 |
USER_KEY6 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 6
|
| 123 |
GPFR_DA_ESTREP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field.
|
| 124 |
GPFR_DA_CONNUM |
Number(5,0) |
INTEGER NOT NULL |
DADS related field
|
| 125 |
CHR_PIN_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Calculation Character Result
|
| 126 |
GPFR_DA_OT_CON_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
|
| 127 |
GPFR_DA_OT_PEN_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
DADS related field
|
| 128 |
GPFR_DA_OT_MEM_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
DADs related field
|
| 129 |
GPFR_DA_BASTYP |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field.
|
| 130 |
GPFR_DA_CONTBAS |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
DADS related field.
|
| 131 |
GPFR_DA_OT_POP_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
DADS related field
|
| 132 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 133 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 134 |
ABSENCE_DATE |
Date(10) |
DATE |
Absence Date
|
| 135 |
GPFR_DA_ABS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
01=Illness
02=Maternity
03=Half Treatment Illness
04=Work Accident
05=Disability
07=Unemployment
08=Occ. Disease
09=Illness
10=Therap. PT
11=Journey Acc
12=Vacation NP
|
| 136 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
|
| 137 |
ABS_BGN_DT |
Date(10) |
DATE |
Absence Begin Date
|
| 138 |
ABS_END_DT |
Date(10) |
DATE |
Absence End Date
|
| 139 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 140 |
HEADCOUNT |
Number(6,0) |
INTEGER NOT NULL |
Headcount
|
| 141 |
GPFR_DA_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
A=Auto
C=Activated
I=Ignored
M=Manual
Default Value: M
|
| 142 |
GPFR_DA_AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
DADS Application Engine Section
|
| 143 |
GPFR_DA_CUSTOM |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS Customization Flag
C=Customization
P=PeopleSoft Maintained
|
| 144 |
GPFR_DA_FIXED |
Character(20) |
VARCHAR2(20) NOT NULL |
Fixed Text
|
| 145 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 146 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|
| 147 |
GPFR_DA_INSEE_DT |
Date(10) |
DATE |
INSEE Date
|
| 148 |
GPFR_DA_VALIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether to Validate the DADS Extraction in the DADS Extraction page or not.
|
| 149 |
GPFR_DA_REPDFN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS Report Definition Flag
|
| 150 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 151 |
PIN_CUSTOM1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Customer FIelds
|
| 152 |
PIN_CUSTOM2 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM2
|
| 153 |
PIN_CUSTOM3 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM3 fields
|
| 154 |
PIN_CUSTOM4 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM4
|
| 155 |
PIN_CUSTOM5 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM5
|
| 156 |
BASE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculated Base Value
|
| 157 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 158 |
RATE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 159 |
PCT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Percent Result Value
|
| 160 |
UNIT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Number of units used in result calculation
|
| 161 |
GPFR_DA_SEQ_NUM1 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 1
|
| 162 |
GPFR_DA_SEQ_NUM2 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 2
|
| 163 |
GPFR_DA_SEQ_NUM3 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 3
|
| 164 |
GPFR_DA_SEQ_NUM4 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 4
|
| 165 |
GPFR_DA_SEQ_NUM5 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 5
|
| 166 |
GPFR_DA_SEQ_NUM6 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 6
|
| 167 |
GPFR_DA_SEQ_NUM7 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 7
|
| 168 |
GPFR_DA_SEQ_NUM8 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 8
|
| 169 |
GPFR_DA_SEQ_NUM9 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 9
|
| 170 |
GPFR_DA_SEQ_NUM10 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 10
|
| 171 |
GPFR_DA_SRC_VAL1 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 1
|
| 172 |
GPFR_DA_SRC_VAL2 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 2
|
| 173 |
GPFR_DA_SRC_VAL10 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 10
|
| 174 |
GPFR_DA_SRC_VAL3 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 3
|
| 175 |
GPFR_DA_SRC_VAL4 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 4
|
| 176 |
GPFR_DA_SRC_VAL5 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 5
|
| 177 |
GPFR_DA_SRC_VAL6 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 6
|
| 178 |
GPFR_DA_SRC_VAL7 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 7
|
| 179 |
GPFR_DA_SRC_VAL8 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 8
|
| 180 |
GPFR_DA_SRC_VAL9 |
Character(20) |
VARCHAR2(20) NOT NULL |
DADS: Source Value 9
|
| 181 |
GPFR_DA_SRC_DFN1 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 1
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 182 |
GPFR_DA_SRC_DFN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 2
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 183 |
GPFR_DA_SRC_DFN10 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 10
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 184 |
GPFR_DA_SRC_DFN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 3
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 185 |
GPFR_DA_SRC_DFN4 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 4
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 186 |
GPFR_DA_SRC_DFN5 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 5
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 187 |
GPFR_DA_SRC_DFN6 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 6
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 188 |
GPFR_DA_SRC_DFN7 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 7
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 189 |
GPFR_DA_SRC_DFN8 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 8
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 190 |
GPFR_DA_SRC_DFN9 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 9
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|