| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCC_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence ID
|
| 3 |
SCC_SEQ_ID3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
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
N=Not Disabled
|
| 7 |
HANDICAP_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Handicap Percent
|
| 8 |
DISABLED_PERM_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanent Disability
|
| 9 |
DISABILITY_EVAL_DT |
Date(10) |
DATE |
Disability Evaluation Dt
|
| 10 |
DIS_STATUS_OFFICE |
Character(4) |
VARCHAR2(4) NOT NULL |
Disability Status Office Type
AA=Employment Office
AFS=Social (and family) office
BG=Other or par. 69 pas. 2 SGB IX
BG=Employer's Liability Ins Assoc
EIN=Office par. 35 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=Document for Support of Mners
|
| 11 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 12 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 13 |
DISABLED_POSN_CNT |
Number(1,0) |
SMALLINT NOT NULL |
Disabled Position Count
|
| 14 |
DISABILITY_CARD_NO |
Character(25) |
VARCHAR2(25) NOT NULL |
Disability Card Number
|
| 15 |
CARD_ISSUE_DT |
Date(10) |
DATE |
Card Issue Date
|
| 16 |
CARD_EXP_DT |
Date(10) |
DATE |
Card Expiration Date
|
| 17 |
APPRENTICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Apprentice-level Employee
N=None
Y=Apprentice
|
| 18 |
APP_BGN_DT |
Date(10) |
DATE |
Apprenticeship Begin date
|
| 19 |
APP_END_DT |
Date(10) |
DATE |
Apprenticeship End date
|
| 20 |
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
|
| 21 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|