DIF Statement Template Tags

Oracle HRMS enables you to print the DIF statement in the predefined layout or configure the statement to display your own details to meet business requirements. The application provides you with a predefined DIF statement template, DIF_stmt_tmpl.rtf. You can use this template as it is or create your template by adding, renaming, or removing the tags listed in the table. See: Additional Implementation Steps for French Legislations

The template tags appear as Label name or Label value in the statement. For example, use the tag <?EE_NAME?> to display the label Employee Name. If you want the label value for employee name to look like Tierry Henri in the statement, then use the tag <?emp_hdr_full_name?>.

The following table lists the tags that appear as labels in the statement, their meaning, and whether the tag displays as a Label name or Label value in the statement.

Tag Name Meaning Label Name/Label Value
<?DIF_STMT?> DIF Statement Label name
<?ER?> Employer Label name
<?EE?> Employee Label name
<?NAME?> Name: Label name
<?SIRET?> SIRET Number: Label name
<?ESTAB_NAME?> Establishment Name: Label name
<?ESTAB_ADD?> Establishment Address: Label name
<?COMP_NAME?> Company Name: Label name
<?COMP_ADD?> Company Address: Label name
<?EE_ADD?> Address: Label name
<?EE_NUM?> Employee Number: Label name
<?HIRE_DATE?> Hire Date: Label name
<?ADJ_DATE?> Adjusted Service Date: Label name
<?TERM_DATE?> Actual Termination Date: Label name
COLL_AGGR Collective Agreement: Label name
ASG_CATG Assignment Category: Label name
CTR_INFO Contract Information Label name
<?CTR_TYPE?> Contract Type: Label name
<?CTR_CATG?> Contract Category: Label name
<?CTR_WKG_HRS?> Contractual Working Hours: Label name
<?COLL_AGGR?> Start Date: Label name
<?ASG_CATG?> End Date: Label name
<?ACC_INFO?> Accrual Information Label name
<?ACC_PLAN?> Plan Name: Label name
<?EE_ENROL_ST?> Enrollment Start Date: Label name
<?EE_ENROL_END?> Enrollment End Date: Label name
<?STMT_PERIOD?> Statement Period Label name
<?FROM?> From: Label name
<?TO?> To: Label name
<?DIF_ACC?> DIF Accrual Label name
<?CO?> Carry Over Label name
<?ACC?> Accrual Label name
<?ACC_REPEAT?> Accruals Label name
<?TOTAL?> Total Label name
<?DT_FROM?> Date From Label name
<?DT_TO?> Date To Label name
<?WKG_HRS?> Working Hours Label name
<?DIF_TAKEN?> DIF Taken Label name
<?ST_DATE?> Start Date Label name
<?END_DATE?> End Date Label name
<?ABS_DUR?> Absence Duration Label name
<?TR_LV_CATG?> Training leave category Label name
<?CRS_NAME?> Course Name Label name
<?TRG_PROV?> Training Provider Label name
<?TRG_TYPE?> Type of training Label name
<?TRG_REF?> Training Reference Label name
<?LEG_CATG?> Legal Category Label name
<?HRS_OUT_WKG?> Hours outside working time Label name
<?PROJ_ABS?> Projected (Y/N) Label name
<?HRS?> Hours Label name
<?DIF_ADJ?> DIF Adjustments Label name
<?ADJUST?> Adjustments Label name
<?ELE_NAME?> Element Name Label name
<?IMP_BAL?> Impact on Balance (Add/Subtract) Label name
<?BAL?> Balance Label name
<?er_hdr_estab_name?> Establishment name Label value
<?er_hdr_estab_addr_compl?> Establishment address - complement Label value
<?er_hdr_estab_addr_nstreet?> Establishment address - number and street Label value
<?er_hdr_estab_addr_town?> Establishment address - small town Label value
<?er_hdr_estab_addr_zip?> Establishment address - zip code Label value
<?er_hdr_estab_addr_towncity?> Establishment address - town or city Label value
<?er_hdr_estab_country?> Establishment address - country Label value
<?er_hdr_comp_name?> Company name Label value
<?er_hdr_comp_addr_compl?> Company address - complement Label value
<?er_hdr_comp_addr_nstreet?> Company address - number and street Label value
<?er_hdr_comp_addr_town?> address - small town Label value
<?er_hdr_comp_addr_zip?> Company address - zip code Label value
<?er_hdr_comp_addr_towncity?> Company address - town or city Label value
<?er_hdr_comp_country?> Company address - country Label value
<?er_hdr_estab_siret?> SIRET number Label value
<?emp_hdr_full_name?> Employee full name Label value
<?emp_hdr_empnum?> Employee number Label value
<?emp_hdr_addr_compl?> Employee address - complement Label value
<?emp_hdr_addr_nstreet?> Employee address - number and street Label value
<?emp_hdr_addr_town?> Employee address - small town Label value
<?emp_hdr_addr_zip?> Employee address - zip code Label value
<?emp_hdr_addr_towncity?> Employee address - town or city Label value
<?emp_hdr_country?> Employee address - country Label value
<?emp_hdr_hiredate?> Date of hire Label value
<?emp_hdr_adj_svc_date?> Adjusted Service Date Label value
<?emp_hdr_term_date?> Actual Termination Date Label value
<?emp_hdr_coll_aggr?> Collective agreement Label value
<?emp_hdr_asg_catg?> Assignment category Label value
<?ctr_hdr_start?> Contract start date Label value
<?ctr_hdr_end?> Contract end date Label value
<?ctr_hdr_type?> Contract type Label value
<?ctr_hdr_category?> Contract category Label value
<?ctr_hdr_hours?> Contract working hours Label value
<?statement_start_date?> Statement start date Label value
<?statement_end_date?> Statement end date Label value
<?co_date_to?> Carryover to date Label value
<?co_hours?> Carryover hours Label value
<?acc_date_from?> Accrual date from Label value
<?acc_date_to?> Accrual date to Label value
<?acc_wkg_hrs?> Accrual working hours Label value
<?acc_hours?> Accrual hours Label value
<?total_dif_acc?> Total DIF accrual Label value
<?abs_start_date?> Absence start date Label value
<?abs_end_date?> Absence end date Label value
<?abs_duration?> Absence duration Label value
<?abs_trg_catg?> Training category Label value
<?abs_course_name?> Course name Label value
<?abs_trg_prov?> Training provider Label value
<?abs_trg_type?> Training type Label value
<?abs_trg_ref?> Training reference Label value
<?abs_leg_catg?> Legal category Label value
<?abs_out_wkg_hrs?> Hours outside working hours Label value
<?abs_proj_yn?> Projected absence (y/n) Label value
<?total_dif_abs?> Total absence hours Label value
<?adj_element?> Adjustment element Label value
<?adj_start?> Adjustment element entry start date Label value
<?adj_end?> Adjustment element entry end date Label value
<?adj_hours?> Adjustment hours Label value
<?adj_add_or_subtract?> Impact on Balance (Add/Subtract) Label value
<?dif_bal_hrs?> DIF balance hours Label value