aurora_standard.jkyemppd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
accr_code varchar(6) YES
accr_ctr smallint(6) YES
lapse_date date YES
accr_inc_code varchar(6) YES
accr_allowed decimal(12,0) YES
accr_used decimal(12,0) YES
accr_ytd decimal(12,0) YES
print_flag varchar(1) YES
accr_lost decimal(12,0) YES
line_no bigint(20) unsigned NO PRI auto_increment
active_flag varchar(1) YES

References

Local Column References
line_no
TableColumn
aurora_standard.chmmbc41service_line_no
aurora_standard.sticstvrrec_line_no
aurora_standard.stmnotednote_line_no
aurora_standard.stmwarrdwarr_line_no
aurora_standard.stoordrdkit_line_no
aurora_standard.stuinvcdinv_line_no
aurora_standard.stuinvcdpo_line_no
aurora_standard.stuordrdorder_line_no
aurora_standard.stuprcheinv_line_no
aurora_standard.sturectdrec_line_no
aurora_standard.sturectdpo_line_no
aurora_standard.sturqstdpo_line_no
aurora_standard.sturqstdref_line_no
aurora_standard.sturtrndret_line_no
aurora_standard.sturtrndpo_line_no
aurora_standard.sturtrndrec_line_no
aurora_standard.sturtrndinv_line_no
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code
accr_code
TableColumn
aurora_standard.styemplrsick_accr_code
aurora_standard.styemplrvac_accr_code
aurora_standard.stytypersick_accr_code
aurora_standard.stytypervac_accr_code
accr_ctr
TableColumn
aurora_standard.styemplrsick_accr_ctr
aurora_standard.styemplrvac_accr_ctr
lapse_date
TableColumn
aurora_standard.styemplrsick_lapse_date
aurora_standard.styemplrvac_lapse_date
aurora_standard.styptoadnew_lapse_date
aurora_standard.styptodvnew_lapse_date