| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
END_EFFDT |
Date(10) |
DATE |
End Effdt
|
| 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
8=Disabled Trainee in facility
9=Disabled Workshop employee
N=Not Disabled
Default Value: N
|
| 7 |
HANDICAP_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Handicap Percent
|
| 8 |
DISABLED_PERM_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanent Disability
Y/N Table Edit
|
| 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=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
|
| 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 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 18 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 19 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 20 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|