GP_ABS_FMLA_ELG(SQL Table) |
Index Back |
|---|---|
FMLA Eligibility CSTransaction data for Absence Management FMLA eligibility configurable section |
| # | 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 | TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 1 |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 7 | GP_ABS_SEC_VAL_FLG | Date(10) | DATE | Section Validation Flag |
| 8 | GP_ABS_FMLA_ELIG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if employee is eligible for FMLA
Y/N Table Edit Default Value: N |
| 9 | GP_ABS_FMLA_OVRRD | Character(1) | VARCHAR2(1) NOT NULL |
Override eligibility
Y/N Table Edit Default Value: N |
| 10 | GP_ABS_FMLA_SPOUSE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if spouse works for the same company
Y/N Table Edit Default Value: N |
| 11 | GP_ABS_FMLA_SPS_ID | Character(11) | VARCHAR2(11) NOT NULL |
Spouse's employee ID
Prompt Table: PERSON_NAME |
| 12 | GP_ABS_FMLA_FD_ELG | Character(3) | VARCHAR2(3) NOT NULL | Federal eligibility |
| 13 | GP_ABS_FMLA_FD_SVC | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if federal service weeks eligibility requirement is met
Y/N Table Edit Default Value: N |
| 14 | GP_ABS_FMLA_SVC_FD | Number(4,0) | SMALLINT NOT NULL | FMLA service weeks (Federal) |
| 15 | GP_ABS_FMLA_FD_HRS | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if federal earned hours eligibility requirement is met
Y/N Table Edit Default Value: N |
| 16 | GP_ABS_FMLA_HRS_FD | Number(4,0) | SMALLINT NOT NULL | FMLA earned hours (Federal) |
| 17 | GP_ABS_FMLA_FD_EES | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if federal minimum number of employees eligibility requirement is met
Y/N Table Edit Default Value: N |
| 18 | GP_ABS_FMLA_ST_ELG | Character(3) | VARCHAR2(3) NOT NULL | State eligibility |
| 19 | GP_ABS_FMLA_ST_SVC | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if state service weeks eligibility requirement is met
Y/N Table Edit Default Value: N |
| 20 | GP_ABS_FMLA_SVC_ST | Number(4,0) | SMALLINT NOT NULL | FMLA service weeks (State) |
| 21 | GP_ABS_FMLA_ST_HRS | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if state earned hours eligibility requirement is met
Y/N Table Edit Default Value: N |
| 22 | GP_ABS_FMLA_HRS_ST | Number(4,0) | SMALLINT NOT NULL | FMLA earned hours (State) |
| 23 | GP_ABS_FMLA_ST_EES | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if state minimum number of employees eligibility requirement is met
Y/N Table Edit Default Value: N |
| 24 | GP_ABS_FMLA_YR_BGN | Date(10) | DATE NOT NULL |
FMLA year begin date
Default Value: %date |
| 25 | GP_ABS_FMLA_YR_END | Date(10) | DATE NOT NULL |
FMLA year end date
Default Value: %date |
| 26 | GP_ABS_FMLA_BAL | Character(3) | VARCHAR2(3) NOT NULL | FMLA balances |
| 27 | GP_ABS_FMLA_LV_RQT | Number(3,0) | SMALLINT NOT NULL | FMLA leave requested |
| 28 | GP_ABS_FMLA_LV_TKN | Number(3,0) | SMALLINT NOT NULL | FMLA leave taken |
| 29 | GP_ABS_FMLA_LV_AVL | Number(3,0) | SMALLINT NOT NULL | FMLA leave available |
| 30 | GP_ABS_FMLA_ENTITL | Number(3,0) | SMALLINT NOT NULL | FMLA entitlement |