BN_PERSON_EFFDT (SQL Table)	Index Back
Benefits Person Effective date This record will used to store employee level personal benefits data that needs to be effective dated. In release 8.3, this record will only be supported with a Federal Liscense.

BN_PERSON_EFFDT

(SQL Table)

Benefits Person Effective date

This record will used to store employee level personal benefits data that needs to be effective dated. In release 8.3, this record will only be supported with a Federal Liscense.

Parent record: BN_PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

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

6 GVT_CHAMPUS_IND Character(1) VARCHAR2(1) NOT NULL This is a flag to indicate the Employee is Eligible for CHAMPUS benfit due to prior military service.
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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	MEDICARE_A_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type A indicator Y/N Table Edit Default Value: N
4	MEDICARE_B_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type B Indicator Y/N Table Edit Default Value: N
5	MEDICARE_D_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type D indicator Y/N Table Edit Default Value: N
6	GVT_CHAMPUS_IND	Character(1)	VARCHAR2(1) NOT NULL	This is a flag to indicate the Employee is Eligible for CHAMPUS benfit due to prior military service. 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