Payroll Personnel Data Warehouse

Payroll Personnel Data Warehouse


Table and Fields Description


Table Description --- COASAC






Fields Definition


Field Name Business Name Data Type Description
ACCOUNT_NBR ACCOUNT NUMBER VARCHAR2(7) 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.
SUB_ACCT_NBR SUB ACCOUNT NUMBER VARCHAR2(5) Allows an account to be broken down in more detail(Cost Center) in order to better track detail transactions. The sub account takes on the attributes of the account it reports to, including account manager, fund group and function code. Assigned by account manager.
SUB_ACCT_NM SUB ACCOUNT NAME VARCHAR2(40) The descriptive name of the sub account.


Top of this page Table Description Data Dictionary PPS Main Menu


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