GPFR_ILL_LONG

(SQL Table)
Index Back

LT: Main data.

L: Main Data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ORIG_BEGIN_DT Date(10) DATE original begin date
4 GPFR_ILL_LONG_TERM Character(1) VARCHAR2(1) NOT NULL GPFR: Long-Term Illness

Y/N Table Edit

Default Value: N

5 LAST_DATE_WORKED Date(10) DATE Last Date Worked
6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
7 GPFR_ILL_COT_AMT12 Number(12,2) DECIMAL(11,2) NOT NULL GPFR: Ded Amount for Past 12 Months
8 GPFR_ILL_COT_AMT6 Number(12,2) DECIMAL(11,2) NOT NULL GPFR: Ded Amount for Past 6 Months
9 GPFR_ILL_HRS_12 Number(7,2) DECIMAL(6,2) NOT NULL GPFR: Nbr Worked Hours Past 12 Month
10 GPFR_ILL_HRS_3 Number(7,2) DECIMAL(6,2) NOT NULL GPFR: Nbr of Worked Hours 3 Months
11 GPFR_ILL_EURO_1 Character(1) VARCHAR2(1) NOT NULL GPFR: Payment in Euro

Y/N Table Edit

Default Value: N

12 GPFR_ILL_EURO_2 Character(1) VARCHAR2(1) NOT NULL GPFR: Payment in Euro

Y/N Table Edit

Default Value: N

13 GPFR_AT_ID_PRINTED Character(1) VARCHAR2(1) NOT NULL GPFR: Printing Already Requested.

Y/N Table Edit

Default Value: N