| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 3 |
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
|
| 4 |
HANDICAP_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Handicap Percent
|
| 5 |
DISABLED_PERM_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanent Disability
Y/N Table Edit
|
| 6 |
DISABILITY_EVAL_DT |
Date(10) |
DATE |
Disability Evaluation Dt
|
| 7 |
DIS_STATUS_OFFICE |
Character(4) |
VARCHAR2(4) NOT NULL |
Disability Status Office Type
AA=Employment Office
AFS=Family & Social welfare Office
BG=Other/Par. 152 Abs. 2 SGB IX
BG=Employer's Liability Ins Assoc
EIN=Establishment Par. 51 SGB IX
FST=Social Security Office
FST=Social Security Office
HFST=Main Social Security Office
IA=Integration Office
IA=Integration Office
LAA=Regional Employment Office
LAA=Regional Employment Office
LRA=District Admin of a Land
REGP=Chief Officer - District Admin
REGP=Chief Officer - District Admin
VA=Pension Office
WFBM=Sheltered Workshop
ZST=Central office- Miner benefits
|
| 8 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 9 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 10 |
DISABLED_POSN_CNT |
Number(1,0) |
SMALLINT NOT NULL |
Disabled Position Count
|
| 11 |
DISABILITY_CARD_NO |
Character(25) |
VARCHAR2(25) NOT NULL |
Disability Card Number
|
| 12 |
CARD_ISSUE_DT |
Date(10) |
DATE NOT NULL |
Card Issue Date
|
| 13 |
CARD_EXP_DT |
Date(10) |
DATE |
Card Expiration Date
|
| 14 |
APPRENTICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Apprentice-level Employee
N=None
Y=Apprentice
Y/N Table Edit
Default Value: N
|
| 15 |
APP_BGN_DT |
Date(10) |
DATE |
Apprenticeship Begin date
|
| 16 |
APP_END_DT |
Date(10) |
DATE |
Apprenticeship End date
|
| 17 |
DSB_PART_TIME_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field stores translate values pertaining to part-time disabled workers.
A part-time disabled worker can be further classified by wehter they are old-age parttime or have been hired through a special agency.
A=Agency Contract
N=None or Other
O=Old Age/Part Time
R=Request Approval
Default Value: N
|