Diffierent types Apps Tables

_ALL Conatains multi org data before using this table you need to set client_into to specific org , Org_id is common column.

_V view created on base table

_VL view created on multi language tables.

always use the condition LANGUAGE = USERENV(’LANG’).

_TL Tables support multi language.

_B These Main base tables

_F these date tracked tables for only in HRMS and these table contain 2 common columns effective_start_date and effective_end_date

_S sequence related tables

_AVN Audit view shadow tables contains data track information