TLM – Some important tables

lvque: reflects details of all files being currently loaded in TLM database

lfils: logs entry of each file loaded in TLM

lworkflow_queue: reflects details of all initiations being currently running in TLM database

lworkflow_queue_log: logs entry of all initiations completed in TLM

lbank: stores details of a reconciliation account (set)

linitiation: details of all initiations and associated pass_list

litem: A ledger or statement entry which requires reconciliation.

lload_trig: Specifies the files which stlfetch processes.

lmessage_feed: details about all message types created in TLM

lmessage_header: header records of incoming feed

lpash: list of all passes

lpass_list_header: list of all pass lists

lpass_list_detail: list of all pass lists and their associated passes

lqueue_header: lists all available queues

lqueue_detail: details of all items linked to that queue

lqueue_summary: Summary statistics of entries in the queue.