| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCC_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence ID
|
| 3 |
SCC_SEQ_ID3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
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
|
| 6 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
Y/N Table Edit
Default Value: N
|
| 7 |
DISABILITY_STS_USA |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled
X=Not Indicated
Y=Disabled
|
| 8 |
HR_EE_SIGNATURE |
Character(75) |
VARCHAR2(75) NOT NULL |
Employee Signature
|
| 9 |
HR_DISCLOSURE_DT |
Date(10) |
DATE |
Disclosure Date
|
| 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_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
|
| 13 |
DISABILITY_PERCTG |
Number(3,0) |
SMALLINT NOT NULL |
Disability Percentage
|
| 14 |
DISABL_STARTDT_ITA |
Date(10) |
DATE |
Disability Start Date
|
| 15 |
DISABL_ENDDT_ITA |
Date(10) |
DATE |
Disability End Date
|
| 16 |
DISABILITY_CD_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability Code
DSB=Disabled
HDS=Heavily Disabled
HMD=Heavy Mental Disorder
MDR=Mental Disorder
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|
| 20 |
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
|
| 21 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 22 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|