BE010130 - HR_Benefit_MSTR | Prospr - Dynamics GP Table Reference

BE010130 - HR_Benefit_MSTR

Query Builder

Select * from BE010130

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
BENEFIT	Benefit	String	8	View
BENEFITTYPE_I	Benefit Type	String	8	View
IINDEX_I	IIndex	Integer	2	View
BENEFITKIND_I	Benefit Kind	Integer	2	View
COMPLETIONSTATUS_I	Completion Status	Integer	2	View
POLICYNUMBER_I	Policy Number	String	32	View
BENEFITSTATUS_I	Benefit Status	Integer	2	View
INACTIVE	Inactive	Boolean	2	View
OVERRIDE_I	Override	Boolean	2	View
CHECK1_I	Check1	Boolean	2	View
CHECK2_I	Check2	Boolean	2	View
CHECK3_I	Check3	Boolean	2	View
CHECK4_I	Check4	Boolean	2	View
CHECK5_I	Check5	Boolean	2	View
DATEDUE_I	Date Due	Date	4	View
DSCRIPTN	Description	String	32	View
COMMENTSTR10_I	CommentStr10	String	12	View
IBENEFITAMOUNT_I	IBenefit Amount	Currency	10	View
LIFEAMTEMPL_I	Life Amt Empl	Currency	10	View
LIFEAMTSPOUSE_I	Life Amt Spouse	Currency	10	View
LIFEAMTCHILDREN_I	Life Amt Child(ren)	Currency	10	View
BENELIGIBILEDATE_I	Benefit Eligibility Date	Date	4	View
BNFBEGDT	Benefit Beg Date	Date	4	View
BNFENDDT	Benefit End Date	Date	4	View
VARBENFT	Variable Benefit	Boolean	2	View
BNFTFREQ	Benefit Frequency	Integer	2	View
COSTEMPLOYEE_I	Cost Employee	Currency	10	View
COSTEMPLOYER_I	Cost Employer	Currency	10	View
COSTOTHER1_I	Cost Other 1	Currency	10	View
COSTOTHER2_I	Cost Other 2	Currency	10	View
I1_I	i1	Integer	2	View
I2_I	i2	Integer	2	View
I3_I	i3	Integer	2	View
I4_I	i4	Integer	2	View
NUMBEROFCHILDREN_I	Number of children	Integer	2	View
COSTTOTAL_I	Cost Total	Currency	10	View
COSTCOBRA_I	Cost COBRA	Currency	10	View
BENEFITDEDUCTIBLE_I	Benefit Deductible	Currency	10	View
BNPAYPMX	Benefit Pay Period Max	Currency	10	View
BNFYRMAX	Benefit Year Max	Currency	10	View
BNFLFMAX	Benefit Lifetime Max	Currency	10	View
BENEFICIARYINDEX_I	Beneficiary Index	Long Integer	4	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTESINDEX_I	Notes Index	Currency	10	View
CONTRIBPRETAX_I	Contrib Pre Tax	Currency	10	View
CONTPRETAXDLR_I	Contrib Pre Tax Dollar	Currency	10	View
CONTRIBAFTERTAX_I	Contrib After Tax	Currency	10	View
CONTAFTERTAXDLR_I	Contrib After Tax Dollar	Currency	10	View
CONTRIBBONUS_I	Contrib Bonus	Currency	10	View
CONTRIBBONUSDOLLAR_I	Contrib Bonus Dollar	Currency	10	View
HIGHLYCOMPENSATED_I	Highly Compensated	Boolean	2	View
LOANACTIVE_I	Loan Active	Boolean	2	View
TYPEOFCODE_I	Type of Code	Integer	2	View
TIERSUSED_I	Tiers Used	Boolean	2	View
MAJMEDCOVERAGE_I	Major Medical Coverage	Integer	2	View
MAXOUTOFPOCKET_I	Max Out-Of-Pocket	Currency	10	View
ELIGIBILITYDATE_I	Eligibility Date	Date	4	View
PRIMARYBENEFICIARY_I	Primary Beneficiary	String	32	View
SECBENEFICIARY_I	Secondary Beneficiary	String	32	View
BNFTMTHD	Benefit Method	Integer	2	View
BNFFRMLA	Benefit Formula	Integer	2	View
BNFPRCNT_1	Benefit Percent[1]	Currency	10	View
BNFPRCNT_2	Benefit Percent[2]	Currency	10	View
BNFPRCNT_3	Benefit Percent[3]	Currency	10	View
BNFPRCNT_4	Benefit Percent[4]	Currency	10	View
BNFPRCNT_5	Benefit Percent[5]	Currency	10	View
DEDNMTHD	Deduction Method	Integer	2	View
DEDFRMLA	Deduction Formula	Integer	2	View
DEDNPRCT_1	Deduction Percent[1]	Currency	10	View
DEDNPRCT_2	Deduction Percent[2]	Currency	10	View
DEDNPRCT_3	Deduction Percent[3]	Currency	10	View
DEDNPRCT_4	Deduction Percent[4]	Currency	10	View
DEDNPRCT_5	Deduction Percent[5]	Currency	10	View
DEPYPRMX	Deduction Pay Period Max	Currency	10	View
DEDYRMAX	Deduction Year Max	Currency	10	View
DEDLTMAX	Deduction Lifetime Max	Currency	10	View
DEDINITBAL	Deduction Initial Balance	Currency	10	View
INACTBENEMPLOYEE	Inactive Benefit Employee	Boolean	2	View
INACTBENEMPLR	Inactive Benefit Employer	Boolean	2	View
Benefit_Fiscal_Max	Benefit Fiscal Max	Currency	10	View
Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	10	View
LIFEINSURTYPE	Life Insurance Type	Integer	2	View

BE010130 - HR_Benefit_MSTR

Query Builder

Customer Service

Information

My Account

Contact Us