| # |
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.
Y/N Table Edit
Default Value: N
|
| 3 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
Y/N Table Edit
Default Value: N
|
| 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.
Y/N Table Edit
Default Value: N
|
| 13 |
COMMENTS |
Long Character |
CLOB |
Comment
|