aurora_standard.styoempd

Field Type Null Default Key Extra Comment
empl_code char(6) YES
depend_name char(40) YES
depend_ssn char(11) YES
depend_dob date YES
covered_all char(1) YES
covered_jan char(1) YES
covered_feb char(1) YES
covered_mar char(1) YES
covered_apr char(1) YES
covered_may char(1) YES
covered_jun char(1) YES
covered_jul char(1) YES
covered_aug char(1) YES
covered_sep char(1) YES
covered_oct char(1) YES
covered_nov char(1) YES
covered_dec char(1) YES
fac_no char(3) YES
tax_year char(4) YES
depend_lname char(30) YES
depend_fname char(20) YES
depend_mname char(1) YES
depend_suffix char(4) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code
tax_year
TableColumn
aurora_standard.stycntrcw2_tax_year