BN_DEPBEN_EFFDT (SQL Table)	Index Back
Depenedent effective dated Inf The record will be used to track effective dated dependent beneficiary data. In release 8.3, this record will will only be supported under a Federal HRMS liscense.

BN_DEPBEN_EFFDT

(SQL Table)

Depenedent effective dated Inf

The record will be used to track effective dated dependent beneficiary data. In release 8.3, this record will will only be supported under a Federal HRMS liscense.

Parent record: DEP_BEN

# 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
Default Value: %date

4 MEDICARE_A_IND Character(1) VARCHAR2(1) NOT NULL Medicare Type A indicator
Y/N Table Edit
Default Value: N

5 MEDICARE_B_IND Character(1) VARCHAR2(1) NOT NULL Medicare Type B Indicator
Y/N Table Edit
Default Value: N

6 MEDICARE_D_IND Character(1) VARCHAR2(1) NOT NULL Medicare Type D indicator
Y/N Table Edit
Default Value: N

7 MEDICARE_NUMBER Character(15) VARCHAR2(15) NOT NULL Medicare Number

8 ALT_MEDICARE_NBR Character(15) VARCHAR2(15) NOT NULL Alternate Medicare Number

9 MEDICARE_REASON_A Character(10) VARCHAR2(10) NOT NULL Medicare Reason A

10 MEDICARE_REASON_B Character(10) VARCHAR2(10) NOT NULL Medicare Reason B

11 MEDICARE_REASON_D Character(10) VARCHAR2(10) NOT NULL Medicare Reason D

12 MEDICARE_ELIG_RSN Character(1) VARCHAR2(1) NOT NULL Medicare Eligibility Reason. Used in the Loop 2000 INS of the HIPAA file.
0=Age
1=Disability
2=End Stage Renal Disease

#	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 Default Value: %date
4	MEDICARE_A_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type A indicator Y/N Table Edit Default Value: N
5	MEDICARE_B_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type B Indicator Y/N Table Edit Default Value: N
6	MEDICARE_D_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type D indicator Y/N Table Edit Default Value: N
7	MEDICARE_NUMBER	Character(15)	VARCHAR2(15) NOT NULL	Medicare Number
8	ALT_MEDICARE_NBR	Character(15)	VARCHAR2(15) NOT NULL	Alternate Medicare Number
9	MEDICARE_REASON_A	Character(10)	VARCHAR2(10) NOT NULL	Medicare Reason A
10	MEDICARE_REASON_B	Character(10)	VARCHAR2(10) NOT NULL	Medicare Reason B
11	MEDICARE_REASON_D	Character(10)	VARCHAR2(10) NOT NULL	Medicare Reason D
12	MEDICARE_ELIG_RSN	Character(1)	VARCHAR2(1) NOT NULL	Medicare Eligibility Reason. Used in the Loop 2000 INS of the HIPAA file. 0=Age 1=Disability 2=End Stage Renal Disease