SAD_CRM_FLT_DIS (SQL View)	Index Back
Mapping for DISABILITY Mapping for DISABILITY

SAD_CRM_FLT_DIS

(SQL View)

Mapping for DISABILITY

SELECT EMPLID , DISABLED , DISABLED_VET , REG_DISABLED_NBR , DISABILITY_CD_UK , DISABILITY_ITA , DISABILITY_PERCTG , DISABILITY_CD_JPN , DISABILITY_GR_JPN , WKRCOMP_DISGRD_JPN , WKRCOMP_ISGRD_JPN , APS_DSB_NDS_AUS , COMMENTS FROM PS_DISABILITY WHERE EMPLID IN ( SELECT EMPLID FROM PS_SAD_CRM_EMPLIDS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

3 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran

4 REG_DISABLED_NBR Character(10) VARCHAR2(10) NOT NULL Registered Disabled Number

5 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

6 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

7 DISABILITY_PERCTG Number(3,0) SMALLINT NOT NULL Disability Percentage

8 DISABILITY_CD_JPN Character(3) VARCHAR2(3) NOT NULL Disability Code
DSB=Disabled
HDS=Heavily Disabled
HMD=Heavy Mental Disorder
MDR=Mental Disorder

9 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

10 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

11 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

12 APS_DSB_NDS_AUS Character(1) VARCHAR2(1) NOT NULL Employees have the option of not wanting to provide disability information. This field is required for the purpose of APS reporting only.

13 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.
3	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran
4	REG_DISABLED_NBR	Character(10)	VARCHAR2(10) NOT NULL	Registered Disabled Number
5	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
6	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
7	DISABILITY_PERCTG	Number(3,0)	SMALLINT NOT NULL	Disability Percentage
8	DISABILITY_CD_JPN	Character(3)	VARCHAR2(3) NOT NULL	Disability Code DSB=Disabled HDS=Heavily Disabled HMD=Heavy Mental Disorder MDR=Mental Disorder
9	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
10	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
11	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
12	APS_DSB_NDS_AUS	Character(1)	VARCHAR2(1) NOT NULL	Employees have the option of not wanting to provide disability information. This field is required for the purpose of APS reporting only.
13	COMMENTS	Long Character	CLOB	Comment