| # |
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
Default Value: 01
|
| 3 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 4 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 5 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 6 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
BIRTHSTATE_VW
|
| 7 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 8 |
DEPBEN_RIDER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Court Order Flag
Y/N Table Edit
|
| 9 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 10 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 11 |
SAME_PHONE_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Same Phone as Employee
Y/N Table Edit
|
| 12 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 13 |
CSB_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible for CSB
Y/N Table Edit
|
| 14 |
COBRA_EVENT_DT |
Date(10) |
DATE |
COBRA Event Date
|
| 15 |
COBRA_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
|
| 16 |
COBRA_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
COBRA Generated Emplid
|
| 17 |
MEDICARE_ENTLD_DT |
Date(10) |
DATE |
Date Entitled to Medicare
|
| 18 |
FP_DEPEND_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID of the Dependent
Prompt Table:
PERSON_NAME
|
| 19 |
FP_STAT_FONC |
Character(1) |
VARCHAR2(1) NOT NULL |
Civil Servant Status
Y/N Table Edit
Default Value: N
|
| 20 |
FP_EMPLOYER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer Name
|
| 21 |
FP_SAME_PUBL_SCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Same Public Service
Y/N Table Edit
Default Value: N
|
| 22 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
Default Value: %Date
|
| 23 |
DEP_ELIGIBLE_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox to indicate if dependent is eligible for UK Parental Leave.
Y/N Table Edit
Default Value: N
|
| 24 |
DEP_ADOPTED_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox used in UK Parental Leave to indicate if dependent is adopted.
Y/N Table Edit
Default Value: N
|
| 25 |
DEP_ADOPTION_DT_UK |
Date(10) |
DATE |
Date used in UK Parental Leave to indicate the adoption date for an adopted dependent.
|
| 26 |
DEP_CERTIFICATE_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox used in UK Parental Leave to indicate if dependent's certificate(s) have been verified. The certificates can be: Birth Certificate, adoption papers or award of a disability allowance.
Y/N Table Edit
Default Value: N
|
| 27 |
GVT_FEHB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
FEHB Participant
Y/N Table Edit
Default Value: N
|
| 28 |
GVT_DEP_BENEF_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Dependent's Fed Plan Type
CHA=CHAMPUS
FEH=FEHB
MCA=Medicare Plan A
MCB=Medicare Plan B
OTH=Other Federal Health Plan
|
| 29 |
BENEF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Beneficiary Indicator for Individual or Entity
E=Entity
I=Individual
Default Value: I
|
| 30 |
BEN_DEP_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Beneficiary Update pb
N=No
Y=Yes
Default Value: Y
|
| 31 |
BEN_APPR_DT |
Date(10) |
DATE |
approval updated date
|