DEP_ASOF

#	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
3	EFFDT	Date(10)	DATE	Effective Date
4	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
5	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
6	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
7	DEP_BENEF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Dependent Beneficiary Type B=Beneficiary C=COBRA Dependent Only D=Dependent E=QDRO Estate N=None O=Both Q=QDRO Representative - Employee R=QDRO Representative -Recipient
8	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed Default Value: S
9	MAR_STATUS_DT	Date(10)	DATE	This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
10	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Default Value: M
11	BIRTHDATE	Date(10)	DATE	Date of Birth
12	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
13	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
14	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
15	OCCUPATION	Character(40)	VARCHAR2(40) NOT NULL	Occup
16	DT_OF_DEATH	Date(10)	DATE	Date of Death
17	STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Student N=No Y=Yes Y/N Table Edit Default Value: N
18	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled. Y/N Table Edit Default Value: N
19	MEDICARE_ENTLD_DT	Date(10)	DATE	Date Entitled to Medicare
20	COBRA_EVENT_DT	Date(10)	DATE	COBRA Event Date
21	CSB_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Eligible for CSB Y/N Table Edit Default Value: N
22	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.
23	COBRA_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	COBRA Generated Emplid
24	STUDENT_STATUS_DT	Date(10)	DATE	Student Status Date
25	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker Y/N Table Edit Default Value: N
26	DEPBEN_RIDER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Court Order Flag 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	SAME_PHONE_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Same Phone as Employee Y/N Table Edit Default Value: N
30	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 Prompt Table: PERSONAL_PHONE
31	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
32	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
33	DEP_ADOPTION_DT_UK	Date(10)	DATE	Date used in UK Parental Leave to indicate the adoption date for an adopted dependent.
34	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
35	FP_DEPEND_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID of the Dependent Prompt Table: PERSON_NAME
36	FP_STAT_FONC	Character(1)	VARCHAR2(1) NOT NULL	Civil Servant Status Y/N Table Edit Default Value: N
37	FP_EMPLOYER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Employer Name
38	FP_SAME_PUBL_SCE	Character(1)	VARCHAR2(1) NOT NULL	Same Public Service Y/N Table Edit Default Value: N
39	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update Default Value: %Date