TO DO Generation

This function can be used to generate TO DO for failure or success of each individual record execution status or a single TO DO after completion of batch to get the summary of all the failures or multiple TODO’s for each of the selected failures in this particular execution.

TODO functions can be used in all three sections of DATA TRANSFORMATION i.e. HEADER, FOOTER or FIELD.

TODO(TODO_TYPE,TODO_ROLE,ASSIGN_USER,STATUS,SINGLE_TODO,SORT_KEY[KEY_LIST],
DRILL_KEY[KEY_LIST],CHAR[TYPE=VALUE],MSG[MSG_CAT,MSG_NUM,parm1,param2..])

TO DO generation is allowed at two levels,

• RECORD LEVEL: Parameter value of ‘STATUS’ should not be NULL. It must be either TRUE or FALSE.

  • TODO for FAILURE: Parameter value of ‘STATUS’ should be FALSE

  • TODO for SUCCESS: Parameter value of ‘STATUS’ should be TRUE

• BATCH LEVEL: Parameter value of ‘STATUS’ should be NULL.

INPUT Parameters:

• TODO_​TYPE – TODO Type for which TODO is to be created

• TODO_​ROLE – TODO Role will be responsible to work on this TODO

• ASSIGN_​USER – Created TODO will be assigned to this USER

• STATUS – Possible values are TRUE, FALSE or NULL.

  • If TRUE – TODO will be created after successful execution of each record.

  • If FALSE – TODO will be created after failed execution of each record.

  • If NULL – TODO will be created after success or failed execution of this batch.

• SINGLE_​TODO – This parameter will be used to decide if this TODO is applicable for all the defined SERVICES in this FRT. Possible values are TRUE or FALSE. Parameter in use if FRT has multiple SERVICES configured.

  • If TRUE – This TODO function will be applicable for TODO generation of all the SERVICES in this FRT

  • If FALSE – This TODO function will be applicable for TODO generation in only that SERVICE mentioned in MAP FILED XPATH value against which this function is configured.

• SORT_​KEY[KEY_​LIST] – Sort Key required for the TODO TYPE. Multiple keys i.e. COMMA-SEPARATED can be passed. This is optional parameter block.

Example:

TODO('C1FUDFLT','F1-DFLT',null,NULL,TRUE,SORT_KEY[:FILE_ID],
DRILL_KEY[:FILE_ID,:FILENAME],CHAR['ZZACCT-E'='9901765140'],
MSG[90003,302,:FILE_ID,:FILENAME,:BATCH_CD,:BATCH_NUM])

• DRILL_​KEY[KEY_​LIST] – Drill Key required for the TODO TYPE. Multiple keys i.e. COMMA-SEPARATED can be passed. This is optional parameter block.

Example:

TODO('C1FUDFLT','F1-DFLT',null,NULL,TRUE,SORT_KEY[:FILE_ID],
DRILL_KEY[:FILE_ID,:FILENAME],CHAR['ZZACCT-E'='9901765140'],
MSG[90003,302,:FILE_ID,:FILENAME,:BATCH_CD,:BATCH_NUM])

• MSG[MSG_​CAT,MSG_​NUM,PARAM_​LIST]– Message for which the TODO generation should be done. Multiple keys i.e. COMMA-SEPARATED can be passed. This is optional parameter block.

INPUT parameters – These are the MESSAGE meta-data defined in ORMB.

MSG_​CAT – Message Category

MSG_​NUM – Message Number

PARAM_​LIST – Input parameter list (COMMA-SEPARATED) for this message

Example:

TODO('C1FUDFLT','F1-DFLT',null,NULL,TRUE,SORT_KEY[:FILE_ID],
DRILL_KEY[:FILE_ID,:FILENAME],CHAR['ZZACCT-E'='9901765140'],
MSG[90003,302,:FILE_ID,:FILENAME,:BATCH_CD,:BATCH_NUM])

TODO generation has two behaviors for MSG block in record failures,

• TODO function without MSG Block
  • Record Level - TODO will be created after every failed execution of each record.

  • Batch Level - Single TODO will be created after completion of batch with the summary of all the failure details.

• TODO function with MSG Block

  • Record Level - TODO will be created after failure for the mentioned Category and Number execution of each record.

  • Batch Level - Single TODO will be created after completion of batch only for the mentioned Category and Number.