Payroll Personnel Data Warehouse

Payroll Personnel Data Warehouse


Table and Fields Description


Table Description --- COASOB






Fields Definition


Field Name Business Name Data Type Description
ACCOUNT_NBR ACCOUNT NUMBER VARCHAR2(5) Organization chosen identifier used to classify financial resources for accounting and reporting purposes.
FIN_COA_CD CHART OF ACCOUNTS NUMBER VARCHAR2(2) Identifier of a Chart of Accounts.
FIN_OBJECT_CD OBJECT NUMBER VARCHAR2(4) Identifier used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income.
FIN_SUB_OBJ_CD SUB OBJECT NUMBER VARCHAR2(3) Provides for an object code to be broken down into greater detail. Assigned by account manager.
FIN_SUB_OBJ_NM SUB OBJECT NAME VARCHAR2(40) The descriptive name of the sub object.


Top of this page Table Description Data Dictionary PPS Main Menu


Sent Comment to: PPS Data Warehouse Support
Last Updated: July 16, 1997