42.1.1.2 PDM Physical View Mode Naming Conventions
In the physical view model, OFSDF PDM tables and columns may have abbreviated words joined by underscore character to form more meaningful and descriptive names. Table names in the physical view are capitalized.
Table 42-2 Prefixes and Suffixes for tables in the Physical View Mode of the Physical Data Model
| PDM Area | Table Type | Prefix | Suffix | Example |
|---|---|---|---|---|
| Staging (Data Sourcing) | All Tables | STG_ | STG_LOAN_CO NTRACTS | |
| Interface tables for data from MDM and core banking systems | _INTF | STG_ORG_UNI T_ATTR_INTF | ||
| Transaction Tables | _TXNS |
STG_CARDS_SE TTLEMENT_TX NS |
||
| Master Tables | _MASTER | STG_CUSTOME R_MASTER | ||
| Results (Datamart) | All Fact Tables | FCT_ |
FCT_ACCOUNT _SUMMARY |
|
| All Dimension Tables | DIM_ | DIM_ DIM_PRODUCT |
The table below lists the prefix and/or suffix used for columns names in the physical view of the OFSDF PDM. The prefix or suffix depends on the class and data type of the column.
Table 42-3 Column Name Prefix to indicate the Column Datatype
| Column Data Type | Prefix |
|---|---|
| Varchar | V_ |
| Number | N_ |
| Date | D_ |
| Flag | F_ |
Column name suffix for common classes of columns is in the following table.
Table 42-4 Column Name Suffix to indicate the Column Class
| Column Class | Suffix |
|---|---|
| Method | _METHOD |
| Percentage | _PCT |
| Rate | _RATE |
| Balance | _BAL or _BALANCE |
| Amount | _AMT or _AMOUNT |
| Term | _TERM |
| Type | _TYPE |
| Frequency | _FREQ |
In addition, frequently occurring keywords in column names may be abbreviated as shown in the following table.
Table 42-5 Abbreviated the frequently occurring keywords in the column names
| Name | Abbreviated Form |
|---|---|
| Accrual | accr |
| Account | acct |
| Accounting Currency | acy |
| Address | addr |
| Adjustment | adj |
| Advance | adv |
| Amount | amt |
| Application | app |
| Average | avg |
| Balance | bal |
| Business | bus |
| Currency | ccy |
| Consolidation | cons |
| Customer | cust |
| Description | desc |
| Dimension | dim |
| Detail | dtl |
| Earnings at Risk | ear |
| End Of Period | eop |
| Error | err |
| Flag | flg |
| Frequency | freq |
| Future | fut |
| Forex | fx |
| Generation | gen |
| General Ledger | gl |
| Hierarchy | hier |
| History | hist |
| Local Currency | lcy |
| Line Of Business | lob |
| Maximum | max |
| Minimum | min |
| Mortgage | mort |
| Message | msg |
| Multiplier | mult |
| Number | num |
| Over Draft | od |
| Option | opt |
| Origination | org |
| Percent | pct |
| Payment | pmt |
| Prepayment | Ppmt |
| Product | prod |
| Source | src |
| Status | stat |
| Statistics | stats |
| Temporary | temp |
| Total | tot |
| Transaction | txn |
| Value at Risk | var |
| Value | val |