| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
GPDE_EL_FROM_DT |
Date(10) |
DATE |
ELENA - Used to store 01.01.2010. Only ELENA data starting 2010 are reported
|
| 5 |
IF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If flag
|
| 6 |
GPDE_IC_CONTINUE_R |
Character(1) |
VARCHAR2(1) NOT NULL |
Continue Program Run
|
| 7 |
GPDE_EL_RUN |
Number(5,0) |
INTEGER NOT NULL |
Current ELENA Run
|
| 8 |
GPDE_EL_ELIG_NBR |
Number(8,0) |
INTEGER NOT NULL |
ELENA Nbr of eligible employees
|
| 9 |
GPDE_BS_CHILD_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Block Baustein - Child
|
| 10 |
GPDE_EL_RECNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
ELENA Recname
|
| 11 |
GPDE_EL_SENDER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider Nbr of ELENA Sender
|
| 12 |
GPDE_EL_RCVER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider Nbr of ELENA Receiver
|
| 13 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 14 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 15 |
GPDE_EL_EVENT_DT |
Date(10) |
DATE |
ELENA Event Date
|
| 16 |
GPDE_EL_SEG_DT |
Date(10) |
DATE |
ELENA Event Date
|
| 17 |
GPDE_EL_REP_RSN |
Character(2) |
VARCHAR2(2) NOT NULL |
ELENA Reporting Reason
00=Regular Registration
10=Start of Employment
30=End of Employment
40=Start/End Emplymnt in month
41=Start/End Emplymnt in month-UI
48=Retirement
49=Death
54=Payment after Termination
|
| 18 |
GPDE_EL_CANCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA Reporting cancellation
Y/N Table Edit
Default Value: N
|
| 19 |
GPDE_SI_BTNR |
Character(8) |
VARCHAR2(8) NOT NULL |
Employer SI Number
|
| 20 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
|
| 21 |
GPDE_EL_REPORT_DT |
Date(10) |
DATE |
ELENA Reporting Date
|
| 22 |
GPDE_EL_WORKED |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Status, value Y or N
D=In Progress Chip
E=Error
N=Not Worked
R=Reported
S=Cancel
Y=In Progress
Y/N Table Edit
Default Value: Y
|
| 23 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 24 |
GPDE_EL_ANFZ |
Number(2,0) |
SMALLINT NOT NULL |
ELENA - DBFZ - Nbr of absences
|
| 25 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 26 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 27 |
GPDE_EL_DBSB_SEQ |
Number(6,0) |
INTEGER NOT NULL |
ELENA - DBSB - Taxfree Payments Sequence Nbr
|
| 28 |
GPDE_EL_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname, used in ELENA
|
| 29 |
GPDE_EL_RECNAME_SO |
Character(18) |
VARCHAR2(18) NOT NULL |
ELENA Recname
|
| 30 |
GPDE_EL_RECNAME_SB |
Character(18) |
VARCHAR2(18) NOT NULL |
ELENA Subrecord name
|
| 31 |
GPDE_EL_STMT_TEXT1 |
Character(200) |
VARCHAR2(200) NOT NULL |
ELENA - SQL Statement Text
|
| 32 |
GPDE_EL_FIELD_SQL |
Character(100) |
VARCHAR2(100) NOT NULL |
ELENA Subrecord name
|
| 33 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 34 |
GPDE_DESCR1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description
|
| 35 |
GPDE_EL_DBSE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
ELENA - DBSE - Sequence Nbr
|
| 36 |
GPDE_RC_FILE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
File Number
|
| 37 |
GPDE_EL_FILENAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Name of the ELENA file
|
| 38 |
GPDE_EL_DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 39 |
GPDE_DV_PRODID |
Character(8) |
VARCHAR2(8) NOT NULL |
Employer SI Number
|
| 40 |
GPDE_DV_MODID |
Character(8) |
VARCHAR2(8) NOT NULL |
DEUEV MOD ID
|
| 41 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 42 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 43 |
GPDE_EL_DBEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBEN
Default Value: N
|
| 44 |
GPDE_EL_DBNA |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBNA
Default Value: N
|
| 45 |
GPDE_EL_DBGB |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBGB
Default Value: N
|
| 46 |
GPDE_EL_DBAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBAN
Default Value: N
|
| 47 |
GPDE_EL_DBAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBAG
Default Value: N
|
| 48 |
GPDE_EL_DBAB |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBAB
Default Value: N
|
| 49 |
GPDE_EL_DBFZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBFZ
Default Value: N
|
| 50 |
GPDE_EL_DBSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBSE
Default Value: N
|
| 51 |
GPDE_EL_DBSB |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBSB
Default Value: N
|
| 52 |
GPDE_EL_DBAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBAS
Default Value: N
|
| 53 |
GPDE_EL_DBZD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBZD
Default Value: N
|
| 54 |
GPDE_EL_DBNB |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBNB
Default Value: N
|
| 55 |
GPDE_EL_DBHA |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBHA
Default Value: N
|
| 56 |
GPDE_EL_DBKE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBKE
Default Value: N
|
| 57 |
GPDE_EL_DBFE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DBFE
|
| 58 |
NATIONALITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality Code
|
| 59 |
GPDE_EL_VSNR |
Character(12) |
VARCHAR2(12) NOT NULL |
Employee National ID
|
| 60 |
GPDE_SI_PROV_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider ID
|
| 61 |
GPDE_EL_EMPL_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Category
|
| 62 |
GPDE_EL_VOSZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip VOSZ
|
| 63 |
GPDE_EL_DSKO |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Chip DSKO
|
| 64 |
GPDE_EL_FILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
ELENA File Sequence Number
|
| 65 |
GPDE_EL_MAX_ROW |
Number(6,0) |
INTEGER NOT NULL |
ELENA - DBFZ - Nbr of absences
|
| 66 |
GPDE_EL_NBR_ROW |
Number(4,0) |
SMALLINT NOT NULL |
ELENA - DBFZ - Nbr of absences
|
| 67 |
GPDE_EL_FILE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If Flag
|
| 68 |
GPDE_EL_FILE_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
If Flag
|
| 69 |
GPDE_EL_NCSZ |
Character(1) |
VARCHAR2(1) NOT NULL |
If Flag
|
| 70 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 71 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 72 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 73 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
|
| 74 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Title
|
| 75 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 76 |
GPDE_TX_INC_TX_CLS |
Character(2) |
VARCHAR2(2) NOT NULL |
Tax Class
0=None
1=Tax Class I
2=Tax Class II
3=Tax Class III
4=Tax Class IV
5=Tax Class V
6=Tax Class VI
|
| 77 |
GPDE_TX_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Number of Children
|
| 78 |
GPDE_TX_NUM_CHILD |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Number of Children
|
| 79 |
GPDE_SI_POS_IN_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Position
0=0 Apprentice
1=1 Blue Collar, non prof
2=2 Blue Collar Prof
3=3 BC Foreman
4=4 White Collar
5=5 Disabled
6=6 Rehabilitation
7=7 Homeworker;domestic business
8=8 Part Time < 18 Hrs.
9=9 Part Time >= 18 Hrs.
|
| 80 |
BA_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
BA Code
|
| 81 |
GPDE_SI_EDUCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Education
0=0 unknown
1=1General Secondary w/o Prof
2=2 General Secondary with Prof
3=3 Gen Univ Entr no Prof Train
4=4 Gen Univ Entr w/Prof Train
5=5 Technical College Degree
6=6 University Degree
7=7 unknown degree
|
| 82 |
GPDE_SIP_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Insurance Region
|
| 83 |
GPDE_DV_SV_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
DEUEV Contribution Group Code
|
| 84 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 85 |
GPDE_RP_TXGRS_ANLZ |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 86 |
GPDE_RP_TXGRS_BON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 87 |
GPDE_RP_SIGRS_ANLZ |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 88 |
GPDE_RP_SIGRS_BON |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 89 |
GPDE_RP_TOTGRSS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total of Gross
|
| 90 |
GPDE_RP_KVLFD_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 91 |
GPDE_RP_KVBON_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 92 |
GPDE_RP_RVLFD_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 93 |
GPDE_RP_RVBON_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 94 |
GPDE_RP_AVLFD_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 95 |
GPDE_RP_AVBON_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 96 |
GPDE_RP_PVLFD_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 97 |
GPDE_RP_PVBON_AN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 98 |
GPDE_RP_TAX_LFD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 99 |
GPDE_RP_TAX_BON |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 100 |
GPDE_RP_SLDTY_LFD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 101 |
GPDE_RP_SLDTY_BON |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 102 |
GPDE_RP_CHRCHT_LFD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 103 |
GPDE_RP_CHRCHT_BON |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 104 |
GPDE_AL_OPRNAME |
Character(11) |
VARCHAR2(11) NOT NULL |
Executing Clerk
Prompt Table:
PERS_SRCH_GBL
|
| 105 |
GPDE_AL_GENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
gender of an EE
M=Mr
W=Mrs
|
| 106 |
GPDE_AL_CONTACT_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
executing clerk
|
| 107 |
GPDE_AL_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
phone number of an employee
Prompt Table:
GPDE_AL_PH_SRCH
|
| 108 |
GPDE_AL_FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax number of an employee
Prompt Table:
GPDE_AL_PH_SRCH
|
| 109 |
GPDE_AL_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
email address of an employee
Prompt Table:
GPDE_AL_EM_SRCH
|
| 110 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 111 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 112 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 113 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 114 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 115 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 116 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 117 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 118 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 119 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 120 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 121 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 122 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 123 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 124 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 125 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 126 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 127 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 128 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 129 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 130 |
GPDE_EL_NAME1AG |
Character(30) |
VARCHAR2(30) NOT NULL |
DBAG - field NAME1AG
|
| 131 |
GPDE_EL_NAME2AG |
Character(30) |
VARCHAR2(30) NOT NULL |
DBAG - field NAME2AG
|
| 132 |
GPDE_EL_NAME3AG |
Character(30) |
VARCHAR2(30) NOT NULL |
DBAG - field NAME3AG
|
| 133 |
GPDE_EL_DBFZ_SEQ |
Number(6,0) |
INTEGER NOT NULL |
ELENA - DBFZ - Absence Sequence Nbr
|
| 134 |
GPDE_EL_FEHLART |
Character(2) |
VARCHAR2(2) NOT NULL |
ELENA - Absence Begin Date
|
| 135 |
GPDE_EL_FEHLBEG |
Date(10) |
DATE |
ELENA - Absence Begin Date
|
| 136 |
GPDE_EL_FEHLEND |
Date(10) |
DATE |
ELENA - Absence Begin Date
|
| 137 |
GPDE_EL_STSOBART |
Character(2) |
VARCHAR2(2) NOT NULL |
ELENA - DBSE - Field STSOBART
|
| 138 |
GPDE_EL_ANSTSOB |
Number(3,0) |
SMALLINT NOT NULL |
ELENA - DBSE - ANSTSOB - Nbr of Taxable Payments
|
| 139 |
GPDE_EL_VSTSOB |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBSE - Field VSTSOB
|
| 140 |
GPDE_EL_STSOB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ELENA - DBSE - Field STSOB
|
| 141 |
GPDE_EL_SBART |
Character(2) |
VARCHAR2(2) NOT NULL |
ELENA - DBSB - Field SBART
|
| 142 |
GPDE_EL_ANSB |
Number(3,0) |
SMALLINT NOT NULL |
ELENA - DBSB - ANSB - Nbr of Taxfree Payments
|
| 143 |
GPDE_EL_SB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ELENA - DBSE - Field SB
|
| 144 |
GPDE_EL_ASBEG |
Date(10) |
DATE |
ELENA - Education Begin Date - ASBEG
|
| 145 |
GPDE_EL_MMARTAS |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBAS- Field MMARTAS
1=Apprenticeship
2=End Apprentice
|
| 146 |
GPDE_EL_ASVOREND |
Date(10) |
DATE |
ELENA - Education Planned End Date - ASVOREND
|
| 147 |
GPDE_EL_TATASEND |
Date(10) |
DATE |
ELENA - Education Actual End Date - TATASEND
|
| 148 |
GPDE_EL_ZD_FIKTGRS |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 149 |
GPDE_EL_ZD_LMPG37B |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 150 |
GPDE_EL_ZD_LMPG40A |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 151 |
GPDE_EL_ZD_LMPG40B |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 152 |
GPDE_EL_ZD_FRWKVAG |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 153 |
GPDE_EL_ZD_FRWPVAG |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 154 |
GPDE_EL_ZD_FRWKV |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 155 |
GPDE_EL_ZD_FRWPV |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 156 |
GPDE_EL_ZD_CONTRPF |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 157 |
GPDE_EL_ZD_LMPTXEE |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 158 |
GPDE_EL_ZD_LMPSLEE |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 159 |
GPDE_EL_ZD_LMPCTEE |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Calculation Numeric Result
|
| 160 |
GPDE_EL_ZD_RSNAZCH |
Number(1,0) |
SMALLINT NOT NULL |
Calculation Numeric Result
|
| 161 |
GPDE_EL_ZD_REGAZ |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Calculation Numeric Result
|
| 162 |
GPDE_EL_CRT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create ELENA File
|
| 163 |
GPDE_EL_CRT_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Create ELENA data
|
| 164 |
GPDE_EL_SEND_BTN |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA Send File Pushbutton
|
| 165 |
GPDE_EL_PRCS_CONF |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBSB - ANSB - Nbr of Taxfree Payments
|
| 166 |
GPDE_EL_PROTOKOLL |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBSB - ANSB - Nbr of Taxfree Payments
|
| 167 |
GPDE_EL_TEST_ENV |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBSB - ANSB - Nbr of Taxfree Payments
|
| 168 |
GPDE_AL_PROP_VAL |
Character(100) |
VARCHAR2(100) NOT NULL |
A Property Value in the GPDE setup Name/Value Pair Table.
|
| 169 |
GPDE_EL_EMPLID_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA Label Field (used for Group Box labels)
Y/N Table Edit
Default Value: N
|
| 170 |
GPDE_EL_FILE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
ELENA File Number
|
| 171 |
GPDE_EL_FIL_U_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
If Flag
|
| 172 |
GPDE_EL_RID_FINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
ELENA - DBSB - ANSB - Nbr of Taxfree Payments
|
| 173 |
GPDE_AD_TGD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Fieldname for GPDE Address mapping.
|
| 174 |
GPDE_BS_CHIP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Block Sequence
|
| 175 |
GPDE_EL_FLAG_DT |
Date(10) |
DATE |
ELENA - Used to store 01.01.2010. Only ELENA data starting 2010 are reported
|
| 176 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 177 |
GPDE_EL_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 178 |
GPDE_EL_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 179 |
GPDE_EL_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 180 |
GPDE_EL_STMT_TEXT2 |
Long Character(8192) |
CLOB |
ELENA - SQL Statement Text
|
| 181 |
GPDE_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 182 |
GPDE_EL_RUN2 |
Number(5,0) |
INTEGER NOT NULL |
ELENA Run
|