| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
DISABLE_TYPE_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability Type
AAH=Disabled Person Allowance
COT=Known as COTOREP
COT=Known as COTOREP
DIS=Disability Card
FEM=Spouse of mentally disabled
ORP=War Orphan
PEN=Pensioned, Volunteer Fire Man
RQT=Disabled Worker Recognition
TPI=Disability Pension Owner
TPM=Disability Milit Pension Owner
VAM=Work Accident or Disease
VGN=Re-Married War Widow
VGR=Not-Married War Widow
Default Value: RQT
|
| 3 |
DIS_BEGIN_DT_FRA |
Date(10) |
DATE NOT NULL |
Disability Begin Date
|
| 4 |
DIS_END_DT_FRA |
Date(10) |
DATE |
Disability End Date
|
| 5 |
DIS_COTOREP_RT_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
COTOREP Category
A=COTOREP A - Category
B=COTOREP B Category
C=COTOREP C Category
|
| 6 |
DIS_IPP_RT_FRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Disability Rate
|
| 7 |
DIS_PRIOR_PLC_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Placement
Y/N Table Edit
Default Value: N
|
| 8 |
PLACEMENT_TYPE_FRA |
Character(4) |
VARCHAR2(4) NOT NULL |
Previous Placement Type
AP=Protected WorkShop
CAT=Helped by a Work Center
CDTD=Home Work Center
CFP=Professional Training Center
IMPR=Professional/Medical Center
|
| 9 |
WRK_ACCDNT_DIS_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability Due to WorkAccident
Y/N Table Edit
Default Value: N
|
| 10 |
TITLE_NBR_FRA |
Character(12) |
VARCHAR2(12) NOT NULL |
Title Number
|
| 11 |
NOTIF_DT_FRA |
Date(10) |
DATE |
Notification Date
|
| 12 |
ACCDNT_ILLNESS_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Accident Cause.
A=Work Accident
M=Disease
|
| 13 |
OCC_ILLNESS_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Professional Disease
Prompt Table:
OCC_ILLNESS_FRA
|
| 14 |
COMMENTS |
Long Character |
CLOB |
Comment
|