HRS_APP_DIS_GER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	END_EFFDT	Date(10)	DATE	End Effdt
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 N=Not Disabled Default Value: N
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=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
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
12	DISABILITY_CARD_NO	Character(25)	VARCHAR2(25) NOT NULL	Disability Card Number
13	CARD_ISSUE_DT	Date(10)	DATE	Card Issue Date
14	CARD_EXP_DT	Date(10)	DATE	Card Expiration Date
15	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
16	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
17	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
18	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id