DEP_BENEF_FRA(SQL Table) |
Index Back |
|---|---|
Dependent/Benef French DataDEP_BENEF_FRA is a child record of DEPENDENT_BENEF and holds dependent personal information specific to France. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | FAMILY_SUP_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Family Supplement
Y/N Table Edit Default Value: N |
| 5 | GARNISH_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Garnishment
Y/N Table Edit Default Value: N |
| 6 | AFB_ALLOW_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
AFB Allowance
Y/N Table Edit Default Value: N |
| 7 | CHIC_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
CHIC Status
Y/N Table Edit Default Value: N |
| 8 | SCHOOL_PR_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Schooling Premium Status
Y/N Table Edit Default Value: N |
| 9 | HOLIDAY_PR_STS_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Premium
Y/N Table Edit Default Value: N |
| 10 | DEP_BEN_STS_7_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Alsace-Moselle
Y/N Table Edit Default Value: N |
| 11 | DEP_BEN_STS_8_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Dependent/Beneficiary Status 8
Y/N Table Edit Default Value: N |
| 12 | DEP_BEN_STS_9_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Dependent/Beneficiary Status 9
Y/N Table Edit Default Value: N |
| 13 | DEP_BEN_STS_10_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Dependent/Beneficiary Status10
Y/N Table Edit Default Value: N |