HRS_HIRE_DGER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	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
5	HANDICAP_PERCENT	Number(3,0)	SMALLINT NOT NULL	Handicap Percent
6	DISABLED_PERM_GER	Character(1)	VARCHAR2(1) NOT NULL	Permanent Disability Y/N Table Edit
7	DISABILITY_EVAL_DT	Date(10)	DATE	Disability Evaluation Dt
8	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
9	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
10	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
11	DISABLED_POSN_CNT	Number(1,0)	SMALLINT NOT NULL	Disabled Position Count Default Value: 0
12	DISABILITY_CARD_NO	Character(25)	VARCHAR2(25) NOT NULL	Disability Card Number
13	CARD_ISSUE_DT	Date(10)	DATE	Card Issue Date Default Value: %Date
14	CARD_EXP_DT	Date(10)	DATE	Card Expiration Date
15	HRS_HIRE_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Hire Sequence ID