BN_834_MEMBER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	BN_EDI_TRANS_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Number
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
8	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
9	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
13	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
14	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
15	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	BN_834_BIRTH_ORDER	Number(1,0)	SMALLINT NOT NULL	Stores the Birth Order for Twins / Triplets for the HIPAA 834 EDI File.
18	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
19	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
20	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. */
21	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
22	COBRA_EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	COBRA Event Classification
23	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
24	HIRE_DT	Date(10)	DATE	First Start Date
25	JOB_EFFDT	Date(10)	DATE	Job Effective Date
26	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
27	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
28	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
29	STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Student N=No Y=Yes
30	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.
31	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
32	DT_OF_DEATH	Date(10)	DATE	Date of Death
33	MEDICARE_A_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type A indicator
34	MEDICARE_B_IND	Character(1)	VARCHAR2(1) NOT NULL	Medicare Type B Indicator
35	MEDICARE_EFFDT	Date(10)	DATE	This is the Medicare Subscription Date for members in HIPAA EDI File.
36	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
37	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone #
38	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
39	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
40	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
41	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
42	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
43	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
44	ADDRESS1_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 1 Other
45	ADDRESS2_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 2 Other
46	CITY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	City Other
47	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other
48	POSTAL_OTHER	Character(12)	VARCHAR2(12) NOT NULL	Postal Other
49	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
50	ASOFDATE	Date(10)	DATE	As of Date
51	BN_834_MAINT_CD	Character(3)	VARCHAR2(3) NOT NULL	Stores the Maintenace Type Code used on the HIPAA 834 EDI file. Default Value: 030
52	BN_834_MAINT_RSNCD	Character(3)	VARCHAR2(3) NOT NULL	Stores the Maintenace Reason Code used on the HIPAA 834 EDI file.
53	BN_EDI_SUBSCBR_NBR	Character(30)	VARCHAR2(30) NOT NULL	This field will be updated with the EMPLID or SSN based on user choice on EDI Partners page. It will have EMPLID in case SSN field is empty.
54	BN_834_DEPEND_IND	Character(1)	VARCHAR2(1) NOT NULL	Stores the Dependent Indicator flag used on the HIPAA 834 EDI file. Default Value: N
55	BN_834_MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stores the Marital Status per the EDI Implementation guide. They are mapped to the Marital Status in PS using Transaction Map table.
56	BN_834_RELATION_CD	Character(2)	VARCHAR2(2) NOT NULL	Stores the mapped value of the Relationship Code used on the HIPAA 834 EDI file.
57	BN_834_BEN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stores the Benefit Status Code used on the HIPAA 834 EDI file. Default Value: A
58	BN_834_GRP_NBR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Group Number for Loop 2000 and 2300 in HIPAA EDI file
59	BN_834_MEDICARE_CD	Character(1)	VARCHAR2(1) NOT NULL	Stores the Medicare Codes for HIPAA EDI file Default Value: E
60	BN_834_MED_BGN_DT	Date(10)	DATE	Stores the Medicare Begin Date for HIPAA EDI File.
61	BN_834_MED_END_DT	Date(10)	DATE	Stores the Medicare End Date for HIPAA EDI File.
62	BN_834_COBRA_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Stores the mapped value of the COBRA Qualifying Event Code used on the HIPAA 834 EDI file.
63	BN_834_EMPL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Stores the Employment Status Code used on the HIPAA 834 EDI file.
64	BN_834_STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Stores the mapped value of the Student Status Code used on the HIPAA 834 EDI file.
65	BN_834_HEALTH_CD	Character(1)	VARCHAR2(1) NOT NULL	Stores the Health Related Code used on the HIPAA 834 EDI file. Default Value: U
66	BN_EDI_SEP_SEGMENT	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate segments on the Benefits EDI transactions.
67	BN_EDI_SEP_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate fields on the Benefits EDI transactions.
68	BN_834_MBR_SEG_INS	Character(30)	VARCHAR2(30) NOT NULL	Stores the concatenation of the INS05 to INS12 member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields. The Field Length was modified from 25 to accomodate 30 Characters to facilitate the accomodation of all 17 elements from INS01 to INS17.
69	BN_834_MBR_SEG_NM1	Character(122)	VARCHAR2(122) NOT NULL	Stores the concatenation of the NM103 to NM109 member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
70	BN_834_MBR_SEG_N3H	Character(111)	VARCHAR2(111) NOT NULL	Stores the concatenation of the N301 to N302 (home address) member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
71	BN_834_MBR_SEG_N4H	Character(60)	VARCHAR2(60) NOT NULL	Stores the concatenation of the N401 to N404 (home address) member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
72	BN_834_MBR_SEG_N3O	Character(111)	VARCHAR2(111) NOT NULL	Stores the concatenation of the N301 to N302 (mailing address) member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
73	BN_834_MBR_SEG_N4O	Character(60)	VARCHAR2(60) NOT NULL	Stores the concatenation of the N401 to N404 (mailing address) member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
74	BN_834_MBR_SEG_DMG	Character(15)	VARCHAR2(15) NOT NULL	Stores the concatenation of the DMG01 to DMG04 member segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
75	BN_834_MBR_EC01	Character(3)	VARCHAR2(3) NOT NULL	HIPAA Loop 2100A EC Employment Code