SECTION 2.1- RECORDS FOR ALPHABETS A-F This section includes the record names, record descriptions, fields, and key of all records. The records that are used by the National Finance Center have an asterisk included. Records Description Fields Key AAP_ETHNIC_PMPT Affirmative Action Plan Ethnic DESCR Prompt ETHNIC_GROUP KEY(1) AAP_TBL Affirmative Action Plan Table AAP_RESPONSIBLE_ID DESCR ESTABID KEY(1) AAP_TBL_LNG Affirmative Action Plan Related DESCR Language Table ESTABID KEY(1) LANGUAGE_CD KEY(2) AAP_YEAR Affirmative Action Plan Year ESTABID KEY(1) FEMALE_GOAL START_DT KEY(2) AAP_YEAR_GOALS ESTABID KEY(1) ETHNIC_GROUP KEY(3) FEMALE_GOAL START_DT KEY(2) TOTAL_GOAL AAP_YEAR_JG_GLS Affirmative Action Plan Year Job EEO_JOB_GROUP KEY(3) Group Goals ESTABID KEY(1) ETHNIC_GROUP KEY(4) FEMALE_GOAL START_DT KEY(2) TOTAL_GOAL AAP_YEAR_JOBGRP Affirmative Action Plan Year Job EEO_JOB_GROUP KEY(3) Group ESTABID KEY(1) FEMALE_GOAL MINORITY_GOAL START_DT KEY(2) AA_COST_RT_JPN Cost Rate Japan Table COST_RATE_JPN EFFDT KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) EMPL_RCD_JPN KEY(4) AA_CR_EFFDT_JPN Additional Appt History View EFFDT KEY(3) EMPLID KEY(1) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 1 EMPL_RCD KEY(2) AA_JC_JPN_AET Japan Auto Insert Additional Appt BUSINESS_UNIT Jobcode DESCR DESCR2 ERROR_FLAG JOBCODE LANGUAGE_CD PROCESS_INSTANCE KEY(1) RUN_CNTL_ID SETID AA_SETUP_JPN Additional Appt Setup Table BUSINESS_UNIT COMPANY DEPTID JOBCODE LOCATION ABSENCE_CAL Absence Calendar Standing Data ABS_MONTH_END_DT ABS_MONTH_START_DT CALYEAR KEY(1) MONTHCD KEY(2) ABSENCE_HIST EE Absence ABSENCE_CODE ABSENCE_TYPE KEY(4) ABS_APPROVED_DT ABS_BEGIN_TM ABS_ENTRY_PANEL ABS_HIST_BELSBR ABS_HIST_GERSBR ABS_HIST_ITASBR ABS_HIST_NLDSBR ABS_HIST_UK_SBR ABS_RECURRENCE ABS_RETURN_TM BEGIN_DT KEY(3) BIRTH_DT COUNSELLING DISCIPLINARY DOC_CONSULTED DOC_CONSULT_DT DUE_DT DURATION_DAYS DURATION_HOURS EMPLID KEY(1) EMPLOYER_APPROVED EMPL_RCD KEY(2) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 2 INCIDENT_NBR INDUSTRIAL_INJURY NOTIFIED_BY NOTIFIED_DT NOTIFIED_TM PAID_UNPAID REASON REFER_TO_OHA RETURN_DT ABSHCOMUK_LNG Parental Leave Absence Comment ABSENCE_TYPE KEY(4) ABS_COMMENTS_UK BEGIN_DT KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) LANGUAGE_CD KEY(5) ABSV_ACCRUAL Vacation Accrual Record ABSV_ACCRUAL_DT KEY(5) ABSV_DYS_CARRYOVER ABSV_DYS_EARN_YTD ABSV_DYS_TAKE_YTD BENEFIT_PLAN COMPANY KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) PLAN_TYPE KEY(4) ABSV_ADDL_TBL Vacation Bonus Entitlement ABSV_BONUS_DAYS ABSV_SERVICE_INT KEY(3) BENEFIT_PLAN KEY(2) PLAN_TYPE KEY(1) ABSV_PERIOD Vacation Accrual Period ABSV_CURR_END_DT ABSV_FUTURE_END_DT BENEFIT_PLAN KEY(3) COMPANY KEY(1) PLAN_TYPE KEY(2) ABSV_PLAN_TBL Vacation Plan Table ABSV_ACCRUAL_FREQ ABSV_MAX_BALANCE ABSV_MAX_CARRYOVER ABSV_RATE_FLG BENEFIT_PLAN KEY(2) PLAN_TYPE KEY(1) ABSV_RATE_TBL Vacation Service Rate Values ABSV_DAYS_EARNED ABSV_SERVICE_INT KEY(3) BENEFIT_PLAN KEY(2) PLAN_TYPE KEY(1) ABSV_REQUEST Vacation Request ABSENCE_TYPE EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 3 ABSV_ACCRUAL_DT KEY(5) ABSV_APPROVED_BY ABSV_APPROVED_DT ABSV_APPROVED_FLG ABSV_REQUEST_DT BEGIN_DT KEY(6) COMPANY KEY(3) DURATION_DAYS EMPLID KEY(1) EMPL_RCD KEY(2) PLAN_TYPE KEY(4) RETURN_DT ABSV_RUNCTL Vacation Run Control Record ABSV_CURR_END_DT ABSV_FUTURE_END_DT ABSV_REVERSE_FLG BENEFIT_PLAN COMPANY GPGB_HIREDT_IND OPRID KEY(1) PLAN_TYPE RUN_CNTL_ID KEY(2) ABSW_SCHD_DET Work Schedule Details ABSW_SCHD_ID KEY(1) ABSW_SEQ_NO KEY(2) ABSW_TMPL_ID ABSW_SCHD_TBL Work Schedule Table ABSW_SCHD_ID KEY(1) BEGIN_DT DESCR50 ABSW_SCHEDULE EE Work/Holiday Schedule ABSW_SCHD_ID BEGIN_DT KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) END_DT HOLIDAY_SCHEDULE ABSW_S_TBL_LANG Work Schd Tbl - Related Lang ABSW_SCHD_ID KEY(1) DESCR50 LANGUAGE_CD KEY(2) ABSW_TMPL_DET Work Template Details ABSW_DAY_NO KEY(2) ABSW_TMPL_ID KEY(1) DESCR DURATION_HOURS END_TIME START_TIME KEY(3) ABSW_TMPL_TBL Work Template Table ABSW_TMPL_ID KEY(1) DESCR50 EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 4 ABSW_T_DET_LANG Work Tmpl Details - Related Lang ABSW_DAY_NO KEY(2) ABSW_TMPL_ID KEY(1) DESCR LANGUAGE_CD KEY(4) START_TIME KEY(3) ABSW_T_TBL_LANG Related lang Work Template Tbl ABSW_TMPL_ID KEY(1) DESCR50 LANGUAGE_CD KEY(2) ABS_CD_TBL_LANG Absense Code Table - Related Lang ABSENCE_CODE KEY(3) ABSENCE_TYPE KEY(2) DESCR DESCRSHORT LANGUAGE_CD KEY(4) SETID KEY(1) ABS_CLASS_TBL Absence Class Table ABSENCE_CLASS KEY(2) DESCR DESCRSHORT SETID KEY(1) ABS_CL_TBL_LANG Absence Class Tbl - Related Lang ABSENCE_CLASS KEY(2) DESCR DESCRSHORT LANGUAGE_CD KEY(3) SETID KEY(1) ABS_CODE_TBL Absence Code Table ABSENCE_CODE KEY(3) ABSENCE_TYPE KEY(2) DESCR DESCRSHORT SETID KEY(1) ABS_HIST_CERT EE Absence Certificates ABSENCE_TYPE KEY(4) BEGIN_DT KEY(3) CERT_TYPE CERT_VALID_FROM_DT KEY(5) CERT_VALID_TO_DT EMPLID KEY(1) EMPL_RCD KEY(2) RECEIVED_DT ABS_HIST_COM_UK Parental Leave Absence Comment ABSENCE_TYPE KEY(4) ABS_COMMENTS_UK BEGIN_DT KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) ABS_HIST_DET EE Absence Details ABSENCE_TYPE KEY(4) ABS_H_D_NLDSBR BEGIN_DT KEY(3) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 5 COMMENTS COMMENT_DT KEY(5) EMPLID KEY(1) EMPL_RCD KEY(2) ABS_HIST_LANG EE Absence - Related Lang ABSENCE_TYPE KEY(4) BEGIN_DT KEY(3) EMPLID KEY(1) EMPL_RCD KEY(2) LANGUAGE_CD KEY(5) NOTIFIED_BY REASON ABS_H_DET_LANG Rellang EE Absence Details ABSENCE_TYPE KEY(4) BEGIN_DT KEY(3) COMMENTS COMMENT_DT KEY(5) EMPLID KEY(1) EMPL_RCD KEY(2) LANGUAGE_CD KEY(6) ABS_PARAMETERS Absence Parameters ABS_PAR_NLDSBR ABS_PAR_UK_SBR CONT_ABSENCE_IND MULTI_ABSENCE_IND ABS_PARAMETERS2 Absence Parameters Child Rec. EMPL_CLASS KEY(1) ABS_STAT_NLD Absence History Statistics NLD ABSENCE_TYPE AGE_NLD BEGIN_DT KEY(8) COMPANY KEY(3) CREATION_DT DEPTID KEY(5) EMPLID KEY(1) EMPL_RCD KEY(2) EMPL_RCD_ELI_NLD EMPL_RCD_ILI_NLD FTE_ELI_NLD FTE_ILI_NLD ILL_AVDAYS_ELI_NLD ILL_AVDAYS_ILI_NLD ILL_DAYEPI_ELI_NLD ILL_DAYEPI_ILI_NLD ILL_DAYIPI_ELI_NLD ILL_DAYIPI_ILI_NLD ILL_ENDEPI_ELI_NLD ILL_ENDEPI_ILI_NLD ILL_ENDIPI_ELI_NLD EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 6 ILL_ENDIPI_ILI_NLD ILL_LENEPI_ELI_NLD ILL_LENEPI_ILI_NLD ILL_LENIPI_ELI_NLD ILL_LENIPI_ILI_NLD ILL_START_FULL_NLD ILL_START_PART_NLD NL_FROM_MONTH KEY(7) NL_FROM_YEAR KEY(6) SETID KEY(4) SEX ABS_TYPE_TBL Absence Type Table ABSENCE_CLASS ABSENCE_IMAGE_REF ABSENCE_TYPE KEY(2) ABS_ENTRY_PANEL ABS_TRACK_INCIDENT ABS_TRACK_MAT ABS_TYPE_BELSBR CERT_PERIOD CERT_PERIOD_TYPE CERT_REQUIRED DESCR DESCRSHORT IMAGE_NAME PAID_UNPAID_IND SETID KEY(1) ABS_TY_TBL_LANG Absence Type Table - Related Lang ABSENCE_TYPE KEY(2) DESCR DESCRSHORT LANGUAGE_CD KEY(3) SETID KEY(1) ACCDNT_TYPE_LNG Related Lang-Accident Type ACCIDENT_TYPE_CD KEY(2) DESCR100 DESCRSHORT EFFDT KEY(4) LANGUAGE_CD KEY(3) SETID KEY(1) ACCDNT_TYPE_TBL Accident Type Codes ACCIDENT_TYPE_CD KEY(2) DESCR100 DESCRSHORT EFFDT KEY(3) EFF_STATUS SETID KEY(1) ACCDT_INS_HAZ GER - Accident_Ins Hazard Tbl ACCDT_HAZ_CLS EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 7 ACCIDENT_INS KEY(1) DESCR100 EFFDT KEY(2) HAZARD KEY(3) ACCDT_INS_HAZ_L GER - Accident_Ins Hazard Lang ACCIDENT_INS KEY(1) DESCR100 EFFDT KEY(2) HAZARD KEY(3) LANGUAGE_CD KEY(4) ACCDT_INS_LANG GER - Accident Ins. Table Lang ACCIDENT_INS KEY(1) DESCR100 DESCRSHORT EFFDT KEY(3) LANGUAGE_CD KEY(2) *ACCDT_INS_TBL GER - Accident Insurance Table ACCIDENT_INS KEY(1) ADDRESS_SBR DESCR100 DESCRSHORT EFFDT KEY(2) EFF_STATUS ACCESS_GRP_LANG Related Language Table ACCESS_GROUP KEY(1) DESCR DESCRLONG LANGUAGE_CD KEY(2) ACCESS_GRP_TBL Tree Access Groups ACCESS_GROUP KEY(1) DESCR DESCRLONG *ACCOMPLISHMENTS Person Accomplishments ACCOMPLISHMENT KEY(2) DT_ISSUED KEY(3) EDUCATION_SBR EDUCATN_AUS_SBR EDUCATN_FED_SBR EDUCATN_FP_SBR EDUCATN_GER_SBR EDUCATN_JPN_SBR EMPLID KEY(1) HONOR_AWARD_SBR HONO_AW_FRA_SBR LANGUAGE_SBR LIC_CERT_SBR MAJOR_CODE KEY(4) MEMBERSHIP_SBR NVQ_PROG_SBR TESTS_SBR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 8 Z_LC_ACCOMP_SBR Z_SIMS_EDU_SBR ACCOMPLISH_LANG Accomplishments Related Lang ACCOMPLISHMENT KEY(2) DESCR DT_ISSUED KEY(3) EDUCATOR EMPLID KEY(1) GRANTOR ISSUED_BY LANGUAGE_CD KEY(5) MAJOR MAJOR_CODE KEY(4) MANDATE MANDATE_FUNCTION SCHOOL SUBFACULTY_NAME *ACCOMP_TBL Accomplishment Table ACCOMPLISHMENT KEY(1) ACCOMP_CATEGORY DEGREE_FP_SBR DEGREE_SBR DESCR DESCRSHORT HP_STATS_DEG_LVL LIC_CERTIF_SBR NVQ_ACCOMP_SBR ACCOMP_TBL_LANG Related Lang-Accomplishmnt Tbl ACCOMPLISHMENT KEY(1) ACCOMP_CATEGORY DESCR DESCRSHORT LANGUAGE_CD KEY(2) NVQ_TITLE ACCOM_DIAGNOSIS EE Accommodation Diagnosis ACCOMMODATION_ID KEY(3) DIAGNOSIS_CD KEY(4) EMPLID KEY(1) EMPL_RCD KEY(2) REG_REGION KEY(5) ACCOM_JOB_TASK EE Accommodation Job Tasks ACCOMMODATION_ID KEY(3) BUSINESS_UNIT EMPLID KEY(1) EMPL_RCD KEY(2) JOBCODE KEY(4) JOB_TASK KEY(6) LOCATION KEY(5) ACCOM_OPTION EE Accommodation Options ACCOMMODATION_ID KEY(3) EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 9 ACCOMMODATION_OPT KEY(4) ACCOMMODATION_TYPE ACCOM_COST ACCOM_STATUS CURRENCY_CD DESCRLONG EMPLID KEY(1) EMPLOYER_SUGGESTED EMPL_RCD KEY(2) STATUS_DT ACCOM_OP_LNG EE Accommodation Options ACCOMMODATION_ID KEY(3) ACCOMMODATION_OPT KEY(4) DESCRLONG EMPLID KEY(1) EMPL_RCD KEY(2) LANGUAGE_CD KEY(5) ACCOM_REQUEST EE Accommodation Requests ACCOMMODATION_ID KEY(3) COMMENTS DT_REQUESTED EMPLID KEY(1) EMPL_RCD KEY(2) REQUEST_STATUS RESPONSIBLE_ID STATUS_DT ACCOM_TYPE_LANG Related Lang-Accommodatn Type ACCOMMODATION_TYPE KEY(1) DESCR DESCRSHORT EFFDT KEY(3) LANGUAGE_CD KEY(2) ACCOM_TYPE_TBL Accommodation Type Codes ACCOMMODATION_TYPE KEY(1) DESCR DESCRSHORT EFFDT KEY(2) EFF_STATUS ACCRUAL_RUNCTL Leave Accrual Process Run Ctrl ACCRUAL_PROC_DT BENEFIT_PLAN COMPANY OPRID KEY(1) PLAN_TYPE RUN_CNTL_ID KEY(2) *ACCT_CD_TBL Account Codes ACCT_CD KEY(1) CHARTFLD_KY_SBR COMMIT_ACCTG_FLG DESCR EmpowHR Data Dictionary Prepared by Information Management Resources, Inc. on 8/5/2008 Section 2.1 Records Alphabets.doc P a ge | 10
Description: