ABS_PARAMETERS(SQL Table) |
Index Back |
|---|---|
Absence ParametersHolds parameters that are used during processing in the Monitor Absence module. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MULTI_ABSENCE_IND | Character(1) | VARCHAR2(1) NOT NULL | Multiple Absence Indicator |
| 2 | CONT_ABSENCE_IND | Character(1) | VARCHAR2(1) NOT NULL | Continuing Absence Indicator |
| 3 | MIN_NOTIFY_DAYS | Number(3,0) | SMALLINT NOT NULL | Minimum Notification Days |
| 4 | QW_BEFORE_WEEKS | Number(2,0) | SMALLINT NOT NULL | Qualifying Week Before EWC |
| 5 | CONT_EMPL_WEEKS | Number(2,0) | SMALLINT NOT NULL | Continuous Employment Weeks |
| 6 | MPP_BEFORE_WEEKS | Number(2,0) | SMALLINT NOT NULL | MPP Before Weeks |
| 7 | SMP_PAYABLE_WEEKS | Number(2,0) | SMALLINT NOT NULL | SMP Payable Weeks |
| 8 | BASIC_LEAVE_PERIOD | Number(2,0) | SMALLINT NOT NULL | Maternity Leave Period (Weeks) |
| 9 | EXT_ELIG_TIME | Number(2,0) | SMALLINT NOT NULL | Yrs Service for Add Leave |
| 10 | EXTENDED_LEAVE_WKS | Number(3,0) | SMALLINT NOT NULL | Additional Leave Period |
| 11 | ABS_PRIOR_NOTIF_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates prior notification period before leave. |
| 12 | ABS_QUALIF_RULE_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates qualifying rule for leave. |
| 13 | ABS_STD_AGE_LIM_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates the age limit of dependent. |
| 14 | ABS_PAR_ENTITLE_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates the total leave entitlement per dependent. |
| 15 | ABS_MAX_PER_YR_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates maximum leave entitlement per year per dependent. |
| 16 | ABS_MIN_TAKE_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates minimum leave taken for dependent. |
| 17 | ABS_DIS_AGE_LIM_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates age limit for a disabled dependent. |
| 18 | ABS_ADP_ELIG_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates eligibility period from adoption. |
| 19 | ABS_ADP_AGE_LIM_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates age limit for an adopted dependent. |
| 20 | ABS_DIS_MINTAKE_UK | Number(3,0) | SMALLINT NOT NULL | Used in the Absence Parameters page for UK Parental Leave. Indicates minimum leave taken for a disabled dependent. |
| 21 | EXT_ELIG_START | Character(1) | VARCHAR2(1) NOT NULL |
Extended Eligibility Start Def
H=Orig Hire/Rehire Date S=Service Date Default Value: H |
| 22 | ILL_LENG_CAT1_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 1 |
| 23 | ILL_LENG_CAT2_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 2 |
| 24 | ILL_LENG_CAT3_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 3 |
| 25 | ILL_LENG_CAT4_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 4 |
| 26 | ILL_LENG_CAT5_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 5 |
| 27 | ILL_LENG_CAT6_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 6 |
| 28 | ILL_LENG_CAT7_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 7 |
| 29 | ILL_LENG_CAT8_NLD | Number(3,0) | SMALLINT NOT NULL | Illness Length Category 8 |
| 30 | ILL_LENG_TYP1_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 1
1=Short 2=Medium 3=Long |
| 31 | ILL_LENG_TYP2_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 2
1=Short 2=Medium 3=Long |
| 32 | ILL_LENG_TYP3_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 3
1=Short 2=Medium 3=Long |
| 33 | ILL_LENG_TYP4_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 4
1=Short 2=Medium 3=Long |
| 34 | ILL_LENG_TYP5_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 5
1=Short 2=Medium 3=Long |
| 35 | ILL_LENG_TYP6_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 6
1=Short 2=Medium 3=Long |
| 36 | ILL_LENG_TYP7_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 7
1=Short 2=Medium 3=Long |
| 37 | ILL_LENG_TYP8_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Length Type 8
1=Short 2=Medium 3=Long |
| 38 | AGE_CAT1_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 1 |
| 39 | AGE_CAT2_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 2 |
| 40 | AGE_CAT3_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 3 |
| 41 | AGE_CAT4_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 4 |
| 42 | AGE_CAT5_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 5 |
| 43 | AGE_CAT6_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 6 |
| 44 | AGE_CAT7_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 7 |
| 45 | AGE_CAT8_NLD | Number(2,0) | SMALLINT NOT NULL | Age Category 8 |
| 46 | IND_LV_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Long-term Illness
E=Excluded I=Included Default Value: I |
| 47 | IND_PV_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Partial Illness
E=Excluded I=Included Default Value: I |
| 48 | IND_ZV_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Maternity Illness
E=Excluded I=Included Default Value: I |