HRS_HIRE_DIS

#	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	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled. Y/N Table Edit
4	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran Y/N Table Edit Default Value: N
5	DISABILITY_STS_USA	Character(1)	VARCHAR2(1) NOT NULL	Disability (Section 503) Status USA N=Not Disabled X=Not Indicated Y=Disabled
6	HR_EE_SIGNATURE	Character(75)	VARCHAR2(75) NOT NULL	Employee Signature
7	HR_DISCLOSURE_DT	Date(10)	DATE	Disclosure Date
8	HRS_DIS_SEEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Default Value: N
9	HRS_VET_SEEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Default Value: N
10	REG_DISABLED_NBR	Character(10)	VARCHAR2(10) NOT NULL	Registered Disabled Number
11	DISABILITY_CD_UK	Character(3)	VARCHAR2(3) NOT NULL	Disability DXT=Manual Dexterity HRN=Hearing LRN=Learning MBL=Mobility MNH=Mental Handicap MNI=Mental Illness OTH=Other RSP=Respiratory SPC=Speech UNS=Unspecified VSN=Vision
12	DISABILITY_CD_JPN	Character(3)	VARCHAR2(3) NOT NULL	Disability Code DSB=Disabled HDS=Heavily Disabled HMD=Heavy Mental Disorder MDR=Mental Disorder
13	DISABILITY_GR_JPN	Character(3)	VARCHAR2(3) NOT NULL	This field tracks the disability grade of a dependent. 001=Disability Grade 1 002=Disability Grade 2 003=Disability Grade 3 004=Disability Grade 4 005=Disability Grade 5 006=Disability Grade 6 007=Disability Grade 7
14	WKRCOMP_DISGRD_JPN	Character(3)	VARCHAR2(3) NOT NULL	This field tracks the worker's compensation disability grade of a dependent. 001=Disability Grade 1 002=Disability Grade 2 003=Disability Grade 3 004=Disability Grade 4 005=Disability Grade 5 006=Disability Grade 6 007=Disability Grade 7 008=Disability Grade 8 009=Disability Grade 9 010=Disability Grade 10 011=Disability Grade 11 012=Disability Grade 12 013=Disability Grade 13 014=Disability Grade 14
15	WKRCOMP_ISGRD_JPN	Character(3)	VARCHAR2(3) NOT NULL	This field tracks the Workers Comp Injury and Sickness grade for a dependent 001=Inj/Sick Grade 1 002=Inj/Sick Grade 2 003=Inj/Sick Grade 3
16	DISABILITY_ITA	Character(3)	VARCHAR2(3) NOT NULL	Disability BLN=Blind CIV=Civil due to war disability CNR=Civil Disabl.not Recognized CVL=Civil Disability DD=Deaf and Dumb EXP=Expelled LAB=Labor disability SER=Civil servants disability WAR=Due to war disability WID=War widows and orphans
17	DISABILITY_PERCTG	Number(3,0)	SMALLINT NOT NULL	Disability Percentage
18	INFO_RCVD_DT	Date(10)	DATE	Date Received
19	COMMENTS	Long Character	CLOB	Comment
20	HRS_HIRE_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Hire Sequence ID