| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SET_VLD_HR_07
|
| 2 |
ABSENCE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Absence Type
|
| 3 |
ABSENCE_CLASS |
Character(4) |
VARCHAR2(4) NOT NULL |
Absence Class
Prompt Table:
ABS_CLASS_TBL
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
ABSENCE_IMAGE_REF |
Image Reference(30) |
VARCHAR2(30) |
Absence Type Image
|
| 7 |
CERT_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Certificate Required
Y/N Table Edit
Default Value: N
|
| 8 |
CERT_PERIOD |
Number(2,0) |
SMALLINT NOT NULL |
Certificate Period
|
| 9 |
CERT_PERIOD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Certificate Period Type
DAY=Days
MTS=Months
WKS=Weeks
Default Value: DAY
|
| 10 |
ABS_ENTRY_PANEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Data entry page for different kind of absence.
GEN=General Absence
UKM=UK Maternity Leave
UKP=UK Parental Leave
UKS=UK Shared Parental Leave
VAC=Vacation
Default Value: GEN
|
| 11 |
ABS_TRACK_MAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Maternity Dates
Y/N Table Edit
Default Value: N
|
| 12 |
ABS_TRACK_INCIDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Incident Number
Y/N Table Edit
Default Value: N
|
| 13 |
PAID_UNPAID_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Paid/Unpaid Indicator
AP=Always Paid
AU=Always Unpaid
DP=Default Paid
DU=Default Unpaid
NA=Not Applicable
|
| 14 |
IMAGE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
Prompt Table:
CONTIMAGE_VW
|
| 15 |
PROLONG_PROB_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Prolongation Probation
Y/N Table Edit
Default Value: N
|
| 16 |
PROLONG_NOTIF_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Prolongation Notification is used by Belgium to track the impact of absences on the notification period for employees
Y/N Table Edit
Default Value: N
|
| 17 |
PROLONG_PROT_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Prolongation Protection is used by Belgium for tracking the impact of absences on the Protection Period of employees.
Y/N Table Edit
Default Value: N
|
| 18 |
MANDAT_REPL_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Replacement
Y/N Table Edit
Default Value: N
|
| 19 |
MAND_R_PERIOD_BEL |
Number(3,0) |
SMALLINT NOT NULL |
Number of Months
|
| 20 |
HR_ACTION_LIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Action List
Prompt Table:
HR_ACTN_LST_NLD
|