| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 4 |
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
|
| 5 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
Y/N Table Edit
Default Value: N
|
| 6 |
DISABILITY_STS_USA |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled
X=Not Indicated
Y=Disabled
|
| 7 |
HR_EE_SIGNATURE |
Character(75) |
VARCHAR2(75) NOT NULL |
Employee Signature
|
| 8 |
HR_DISCLOSURE_DT |
Date(10) |
DATE |
Disclosure Date
|
| 9 |
HRS_DIS_SEEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Value: N
|
| 10 |
HRS_VET_SEEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Value: N
|
| 11 |
REG_DISABLED_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Registered Disabled Number
|
| 12 |
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
|
| 13 |
DISABILITY_CD_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability Code
DSB=Disabled
HDS=Heavily Disabled
HMD=Heavy Mental Disorder
MDR=Mental Disorder
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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
|
| 17 |
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
|
| 18 |
DISABILITY_PERCTG |
Number(3,0) |
SMALLINT NOT NULL |
Disability Percentage
|
| 19 |
INFO_RCVD_DT |
Date(10) |
DATE |
Date Received
|
| 20 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 21 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 22 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 23 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|
| 24 |
COMMENTS |
Long Character |
CLOB |
Comment
|