| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
DEPENDENT_BENEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 0
|
| 5 |
GPS_FAM_ALLOW_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a person is eligible for family allowance.
Y/N Table Edit
Default Value: N
|
| 6 |
GPS_EXTRA_PAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a person is eligible for Extra Social Payment (Sozialzuschlag).
Y/N Table Edit
Default Value: N
|
| 7 |
GPS_EXTRA_PAY2_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a person is eligible for Extra Additional Location Payment (Orts-zuschlag).
Location Allowance:
A payment made in recognition of different conditions prevailing at the host location. Locations are assessed for their degree of hardship and the criteria may include isolation, special health risks, extremes of climate and political instability, for example. The allowance is usually expressed as percentage of base pay.
Y/N Table Edit
|
| 8 |
GPS_COUNTING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a person is counting for Extra Social Payment (Sozialzuschlag). Familly Allowance related flag.
Y/N Table Edit
Default Value: N
|
| 9 |
GPS_ENTITLMT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
German Public Sector: Family Allowance Entitlement Type
EDUC=School Education
NOEN=Under 18 years
NOET=No Entitlement
NWRK=Unemployed
SRCH=Search for Education
TPRD=Transition Period
TRNE=Trainee
VECO=Voluntary Ecological Year
VEDU=Vocational Education
|
| 10 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 11 |
GPDE_DV_TIME |
Time(15) |
TIMESTAMP |
Timestamp for DateTime Comparisons.
|
| 12 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 13 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 14 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 15 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 16 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 17 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 18 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 19 |
GPDE_AL_SEQCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence
|
| 20 |
GPS_EMPLID_PAYEE |
Character(11) |
VARCHAR2(11) NOT NULL |
Germanin Public Sector Employee.
Prompt Table:
PERSON_NAME
|
| 21 |
GPS_EMPL_RCD_PAYEE |
Number(3,0) |
SMALLINT NOT NULL |
Employee Record: Employment to be paid out.
Default Value: 0
Prompt Table:
GPS_JOB_CURR_VW
|
| 22 |
DISABLED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Type
1=GT 50% Disabled. Not blind.
2=Blind
3=LT 50%, But GT 20% Disabled
4=Equalized Disability
5=25 - 49% Disabled (Saarland)
6=Widow/Wife
7=Miner Pension
8=Disabled Trainee in facility
9=Disabled Workshop employee
N=Not Disabled
Default Value: N
|
| 23 |
HANDICAP_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Handicap Percent
|