	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

21 COLUMNS | 3 INDEXES | 812 | 08 | F085537W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	812	F085537W	XB	21	3	Current Dep/Ben X-Reference Work Table	Files	08: Human Resources

TOP 812 | 08 | F085537W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	XBAN8	Address Number	Numeric	UDC	8	Allow NULL?
2	XBPAN8	Participant Address Number	Numeric	Generic Edit	8	Allow NULL?
3	XBMLNM	Name - Mailing	String	Generic Edit	40	Allow NULL?
4	XBDBEN	Dependent/Beneficiary	Character	UDC (08 DC)	1	Allow NULL?
5	XBRELA	Dependent/Beneficiary Relationship	Character	UDC (08 RL)	1	Allow NULL?
6	XBPLAN	Plan ID	String	Generic Edit	8	Allow NULL?
7	XBAOPT	Plan Additional Option	String	Generic Edit	3	Allow NULL?
8	XBEFT	Date - Effective	Date	Generic Edit	6
9	XBEFTE	Date - Ending Effective	Date	Generic Edit	6
10	XBPCP#	Primary Care Physician Number	String	Generic Edit	20	Allow NULL?
11	XBPERC	Percentage - Beneficiary	Numeric	Generic Edit	5	Allow NULL?
12	XBSECPERC	Percentage - Secondary Beneficiary	Numeric	Generic Edit	5	Allow NULL?
13	XBNEWPERC	New Percentage - Beneficiary	Numeric	Generic Edit	5	Allow NULL?
14	XBNSECPERC	New Percentage - Secondary Beneficiary	Numeric	Generic Edit	5	Allow NULL?
15	XBPCPVST	PCP Visited Previously	Character	UDC (00 ZO)	1	Allow NULL?
16	XBUSER	User ID	String	Generic Edit	10	Allow NULL?
17	XBPID	Program ID	String	Generic Edit	10	Allow NULL?
18	XBJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	XBUPMJ	Date - Updated	Date	Generic Edit	6
20	XBUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
21	XBCCAI	Active/Inactive Flag	Character	UDC (11 AI)	1	Allow NULL?

Number

Description

Emp Deb Plan Option + (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PAN8	Participant Address Number	Ascending
3	DBEN	Dependent/Beneficiary	Ascending
4	PLAN	Plan ID	Ascending
5	AOPT	Plan Additional Option	Ascending

AN8 PLAN AOPT

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PLAN	Plan ID	Ascending
3	AOPT	Plan Additional Option	Ascending

Employee Dependent

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PAN8	Participant Address Number	Ascending